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. Microsoft Just Released SQL Server 2017 CU 29 (KB 5010786) Here are the latest updates for each …
Today Microsoft released CU #26 for SQL Server 2017. Wow 26 CU’s for a SQL Server product. What is really amazing is that it is over 4 years since SQL Server 2017 was released and 26 CU’s in we are still having some pretty significant bugs fixed. I guess with the size and complexity of SQL Server that is to …
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 …
With SQL Server 2017, there was a new compatibility level introduced, level 140 the new SQL Server 2017 Compatibility Level. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server …
SQL Server 2017 introduces a new column in the sys.dm_db_file_space_usage system table. The column is modified_extent_page_count, which tells how many pages have been modified in your data file since the last full backup. What is really interesting about this is that with a little math you can calculate the percentage of your data file that has been modified. This would be useful …
Determining how much of your data file has been modified Read more »
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 …