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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …