The REPAIR_ALLOW_DATA_LOSS option for DBCC CHECKDB and DBCC CHECKTABLE can be one of the most misleading and possibly catastrophic options. What the REPAIR_ALLOW_DATA_LOSS option does for DBCC CHECKDB and DBCC CHECKTABLE is to simply just throw away any pages (8k …
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 …
Today I had the opportunity to present on Database Corruption at the PASS Summit 2017 conference. You can download the presentation as a PDF here: Summit 2017 Corruption.pdf Here is the agenda from the corruption presentation. What is Database Corruption Causes …
Database Corruption Presentation at Pass Summit 2017 Read more »
Today at PASS Summit Microsoft announced a new SQL “Tool” for running queries against SQL Server, called the Microsoft SQL Operations Studio. So what is the Microsoft SQL Operations Studio This appears to be a new cross platform (Mac, Linux, …
With over 2000 downloads since the last updated to Database Health Monitor, I figured it was time to get another release of the product out. New Features in 2.6 Added a Job Schedule instance level report. Added an option on …
Database Health Monitor October 2017 Version Released Today Read more »
It is handy to have a SQL Restore script ready to go for every backup that you run. Here is a script that will help with that.
While doing a recent server move, I came across the need to script all agent jobs and save them to a file so that if we needed to reference what was there after the move we could get at the …
Script all Agent Jobs Using SQL Server Management Studio Read more »
Yesterday I had the opportunity to practice one of my sessions on Backup and Restore that I will be presenting at PASS Summit this year. I presented it at two different SQL Server Users Group meetings, one in Bellingham WA, …
A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script. The previously updated script added another column called “TextStatus” to the output to give …
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 …
Determining how much of your data file has been modified Read more »