Every DBA, owner or CEO etc. have worries regarding their SQL Server. We face challenges everyday with constant evolving business and technology needs. We at Stedman Solutions are interested and concerned about your worries in regards to SQL Server work. What is your biggest SQL Server worry today? Tell us so that we can focus our attention on the issues …
When working on different client servers, we often times get asked, why all their memory is not being used, and often times we are hitting the memory limits for SQL Server Standard Edition. Keep in mind that this limit on memory is for the buffer pool and what is being used by databases. SQL Server can use more than this …
Backup Retention Part 1 Backup Retention Part 3 In part 1 I spoke about why you would want to restore from backups and some other reasons to have an older backup around. In part 2 I will dive more into the specific types of backup retention methods. Part 3 I will define more on methods but also cover combined methods …
We are pleased to announce a new feature for our Monthly Managed Services customers and Daily Monitoring customers! New feature: Email Notification for Blocking Queries. Picture this scenario: Your SQL Server runs into blocking but you don’t find out until it is too late. Your server eventually gets to the point where it is so backlogged on the blocking that …
New Feature for Stedman Solutions Monthly Services Read more »
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
Last Saturday Dave and I had a fun talk about SQL Server, developers, DBAs, ransomware and Database Health Monitor on his show Rockin’ the Code World. Below is the recording of our episode and hope you enjoy. And make sure check out some of his other chats with other professionals around the world.
Backup Retention Part 2 Backup Retention Part 3 With backup retention times there is always a balance between keeping enough backups and purging those backups quickly to free up space. Some clients I have worked with only keep 2 to 3 days of backups, and others keep multiple years of backups. I generally like to push for something longer term …
Tune in this Saturday as I will be a guest on the Rockin’ the Code World show with DotNetDave. Join Us – January 8th at 10:00am pacific time. SCHEDULE: Introduction The Interview: Steve and I will be discussing: SQL Server Performance Tuning and Monitoring Steve’s app called the Database Health Monitor If there is time we will also discuss why developers …
Microsoft has announced that the next version of SQL Server will be SQL Server 2022. This version is currently in the Early Adopters program. Typically after that will come the Community Technical Preview (CTP) Version, which there may be a couple of those. Then it comes to final release or the RTM (Release to Manufacturing) version. Since they have announced …
The moment of truth. Database Health Monitor Update is out! Time to put on the bullet proof underwear and big boy pants to find out if over 10 years working on Database Health Monitor will pay off, and if anyone actually gets enough value out of it to participate in this new licensing structure. The absolute cheapest way to get …