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 the latest updates for each version of SQL Server. SQL Server 2019 RTM CU 12Download links:CU 12 (KB 5004524) SQL …
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 more subscribers all on the same version of SQL Server, and you need to upgrade the SQL Server version on …
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 of the Stedman Solutions team on problems with SQL Server 2016 being able to send email. Written by Derrick Bovenkamp: …
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 can be useful in situations where a user needs to perform a set of operations on each row of a …