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 …
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 …
Steve and his team quickly assessed our MS SQL corruption situation, advised on the best course of action and expertly effected fixes with no data loss or downtime. Highly recommended – speak to the people who have been there done that. Alex Victoratos | I.T Director
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 …
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 …
With so many recent contacts from possible clients who have been hit by ransomware, I have seen too many companies lose their entire SQL Server databases, their backups, and any hope of recovery. I have even seen a few where the ransomware failed and did not fully encrypt or fully decrypt the database making it impossible to get their data …
Here listed is the current percentages of SQL server versions running our Daily Check up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages
I was recently remembered of a time I was working more with performance tuning on Oracle. The following is something that I had discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to the question of how much procedure cache memory does one SQL …
How much Procedure Cache memory does one SQL Statement take up? Read more »