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… Read More »Transparent Data Encryption (TDE) on SQL Server 2019 Standard Edition
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… Read More »SQL Server 2000 to SQL Server 2019 – What’s the difference?
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… Read More »Cumulative Update 15 for SQL Server 2019 Just Released by Microsoft
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… Read More »SQL Server 2019 CU #13 Just Released By Microsoft Today
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… Read More »Are You Using All Your CPU Cores
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… Read More »Get a List of Tables That Are Compressed
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… Read More »Switching Compatibility Levels on Multiple Databases
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… Read More »Configuring Merge Replication
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… Read More »For merge publications, the version of the Subscriber must not exceed the version of the Publisher
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… Read More »SQL Server 2019 community technology preview 2.3