Follow the link below There are 2 coupons, one for the annual subscription, and one for lifetime access subscription. They are both 75% off the full price fee. Database Health Monitor Annual 75% offCOUPON CODE: BLACKFRIDAYSALE-ANNUAL Database Health Monitor Lifetime Access 75% offCOUPON CODE: BLACKFRIDAYSALE

Our SQL Server Backup and Recovery Course is ready for students! Priced at $99/year or $179/lifetime access (scroll down for sale details) Our main goal for this course is to determine if you have the right backup and recovery strategy and if you don’t, we’ll cover topics to get you set up with one and to be confident in the …

Now’s Your Chance – Course Open For Enrollment Read more »

If you are noticing a number of waits showing up on your SQL Server of type PREEMPTIVE_OS_GETPROCADDRESS and it is linked to the system procedure xp_delete_file the you may want to look at your backup cleanup jobs. Lets take a look at what you may actually be seeing – see image above What is shown in the image above is …

Xp_delete_file and Preemptive_Os_GetProcAddress waits Read more »

Stedman Solutions will be having a 3 Day SQL Server Course Thanksgiving Sale! Each day there will be a different course On Sale! Thanksgiving Day >>> 50% off Microsoft TSQL JOIN Types Course Friday Nov, 26th >>> 75% off Using Database Health Monitor Course Saturday Nov. 27th >>> 50% off NEW Backup and Recovery Course >>> COUPON CODES for each …

3-Day Thanksgiving Sale Schedule Read more »

Over the last 30+ years of working with SQL Server, I have seen a lot of interview questions relating to SQL Server. I have been on both sides of the interview table, sometimes wondering what the person on the other side of the table was asking. There are 3 questions that I really like when interviewing people for SQL Server …

What is your favorite SQL Server DBA Interview question? Read more »

I am working on a big update to Database Health Monitor that I expect to release near the end of the year. So far I am sharing the beta with a few people to try it out before it is ready to release. Here is a list of some of the changes. Licensing Changes There are some licensing changes in …

Database Health Monitor Preview Read more »

There are a few versions of SQL Server 2012 and SQL Server 2014 that are known to cause corruption in certain situations. These versions are: 2012 versions between 11.0.2100 and 11.0.3436 2012 versions between 11.0.5058 and 11.0.5521 2014 versions between 12.0.2000 and 12.0.2369 The recommendation if you are running one of these versions that you check the release notes and …

Dangerous Versions of SQL Server Read more »

Now that we have 5 training classes done (or almost done), I am starting to think about what training class I want to create next.  The original 5 are: SQL JOIN Types Getting Started with SQL Server The Database Health Monitor Class FREE Ransomware Awareness and how it relates to SQL Server Backup and Recovery class I have lots of …

What Training Class Do You Want to See? Read more »