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. …
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 …
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 …
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 …
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 …
Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression enabled: Tested on SQL Server 2019.
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 …
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 …
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 …
As SQL Server 2019 approaches its release to manufacturing date, we get another update, Community Technology Preview 2.3. This puts it one step closer to release. More information from Microsoft.