For years we have been able to use Transparent Data Encryption or TDE to encrypt our database files on SQL Server Enterprise Edition. This ability was the only reason many clients needed to upgrade from Standard Edition to Enterprise Edition. SQL Server 2019 includes TDE as a Standard Edition feature. No longer do you need to shell out the extra …

Transparent Data Encryption (TDE) on SQL Server 2019 Standard Edition Read more »

I was working with a client just the other day that has several SQL Server 2000 servers still in mission critical production environments, and a couple of newer versions of SQL Server 2005, 2016, 2019. Not often do I admit that I do still occasionally work on SQL Server 2000, and given that we are now in 2022, that makes …

SQL Server 2000 to SQL Server 2019 – What’s the difference? Read more »

Today Microsoft released SQL Server 2019 CU 15 (KB 5008996) If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions can help. With the amount of ransomware we are seeing, it is becoming more important than ever to apply any updates that contain security patches. Here are the latest …

Cumulative Update 15 for SQL Server 2019 Just Released by Microsoft Read more »

Today Microsoft release the following SQL Server update. SQL Server 2019 CU 13 (KB 5005679) 10/05/2021 At Stedman Solutions, LLC we do help with SQL maintenance and administration. If you need any help with your SQL Server cumulative updates, service packs or version upgrades, get in touch with us. Here are the latest updates for each version of SQL Server. …

SQL Server 2019 CU #13 Just Released By Microsoft Today Read more »

We recently worked on a SQL Server Performance Assessment for a client and during that we assisted with the upgrade from SQL Server standard edition to SQL Server enterprise edition. Part of the upgrade was an attempt to make use of more cores on the server. They were using Standard Edition of SQL Server which was fully utilizing 48 cores …

Are You Using All Your CPU Cores Read more »

Recently as part of an upgrade to SQL Server 2019, I needed to set the compatibility levels for a database to 150 (for 2019). You could certainly do this by clicking through the configuration dialogs for each database as shown here, but for a server with many databases that could take some time. Here are some of the compatibility levels …

Switching Compatibility Levels on Multiple Databases Read more »

This video is a 12 minute demo of how to quickly configure merge replication and to see it in action between SQL Server 2019 and SQL Server 2017. However most of what is included here will work on SQL Server 2005 or newer. Transcription: Steve Stedman 0:02Hi, I’m Steve Stedman, and welcome to this quick demo on merge replication. Merge …

Configuring Merge Replication Read more »

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 …

For merge publications, the version of the Subscriber must not exceed the version of the Publisher Read more »