=Create windows accounts for replication = list of the agents for replication in server 1 (publisher server) <machine_name>\repl_snapshot <machine_name>\repl_logreader <machine_name>\repl_distribution ...

The content of this course is designed, explained and demonstrated with examples by SQL professionals who all have come together for a single purpose; to share their experience and to help you become ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

The Microsoft OLE DB Provider is an SQL tool that enables developers to write code that provides an application with ADO access to an SQL database. The OLE DB Provider is not installed by default when ...

We take pride in delivering innovation with each new version of Microsoft SQL Server. However, there comes a time when product lifecycles must conclude. On July 14, 2026, SQL Server 2016 will reach ...