Just over 3 years since Microsoft released SQL Server 2016 SP2, today Microsoft released SP3. There was a total of 17 Cumulative Updates in that time period for SQL Server SP2. SQL Server 2016 SP3 (KB 5003279) 2021-09-16 Here are …
Working on a recent SQL Server merge replication project we needed to update some of the servers in a merge replication scenario without upgrading all of them. Consider a merge replication setup with a publisher, a distributor and 2 or …
One of the more challenging components to configure on SQL Server is SQL Mail. I don’t know how many times I have had to try it multiple times before getting it right. Here is an article written by Derrick, one …
For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. Cursors are a feature of SQL Server that allow users to iterate through a result set one row at a time. This …