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 …
In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have been able to get everything. Some have paid the ransom, and some have not. Even some who have paid the ransom did not got their data back. …
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
This is an interesting question. Some employers that I have worked for have encouraged continuing education, and becoming more skilled in certain areas, and other companies almost discourage that because that would get in the way of work. That would be the short sighted versus long sighted approach. Some environments want brilliant, experienced people and others want a warm body …
Will learning more about SQL Server help in your career? Read more »