Here you have all of Steve Stedman’s SQL Server tips, announcements and news posts of December. Hot Topics: Rockin’ the Code World – January 8th – LIVE! I am happy to announce that on January 8th, I have the privilege of a being a guest on the Rockin’ the Code World show with DotNetDave. Please join the show on January …
I am happy to announce that on January 8th, I have the privilege of a being a guest on the Rockin’ the Code World show with DotNetDave. Please join the show on January 8th at 10:00am pacific time. I first met David at SQL Saturday in Las Vegas in 2015, and certainly enjoy his show. He’s been the host of …
On the day after Christmas this 2021, also know as Boxing Day to some, I received a call from someone looking for help to recover from ransomware. This was very similar to many other sad ransomware calls that I have received and tried to help with. This the most important database out of all of the databases they have on …
As a DBA are you ready if you get hit with ransomware? Read more »
If you currently use DBH and haven’t heard, you may want to keep reading. Starting January 5th 2022 Database Health Monitor will have what will be called “Connection Points” (meaning SQL Server Connections). There are several ways in which to increase your Connection Points (listed below). You may choose multiple ways to increase your Connection Points. For example you may …
This can be a rough time a year for many especially when it comes to $$$. For that reason Stedman Solutions likes to give back when we can. This year we hope our $500 donation of games and toys will make some children a little more merry. Surrounding areas were hit with massive flooding these last two months resulting in …
The following query will show the last time your SQL Server instance was started. I used this just today for planning purposes for doing SQL Server updates on a server that I had not ever restarted. I wanted to get an idea of how long it had been running before doing any work. This sample has been tested on SQL …
Determining the last time your SQL Server instance was restarted Read more »
There are very important changes happening to Database Health Monitor and we want this process to be easy and understandable for YOU! Please read carefully and email us at the address at the bottom for any questions. Starting January 5th 2022 Database Health Monitor will have what will be called “Connection Points” (meaning SQL Server Connections). There are several ways …
NEW Database Health Monitor Server Connection Points Read more »
60% Off SQL Server Backup & Restore Course Coupon Code: JOY60 Expires: Jan 2nd at 11:59pm This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch. 40% Off Database Health Monitor Course Coupon Code: JOY40 Expires: Jan 2nd at 11:59pm Learn how to monitor your …
Starting December 11, 2021 the Stedman’s SQL School will now sent out Certificates upon course completion. When you are going through the class, be sure to hit the “Complete and Continue” button when you finish each lesson that that lesson is marked as complete and it will trigger our system to send you your certificate. The certificates are great for …
Our Classes Now Have a Certificate On Completion Read more »
Here is a quick CTE that can be used to generate all the dates in a range. This is handy to use when trying to find dates missing from a set, you can outer join to it, or union with it to fill in the blanks. Download my book for FREE when you sign up for my mailing list. Receive …