Seven Years at Stedman Solutions
This week marks my 7th anniversary of Stedman Solutions, LLC being my full time job and my primary source of income. It also happens to be the 7th anniversary of the last time I got fired. Read more…
High Alert – Preparing for a Cyber Attack
Recent Cyber attack announced issued by the US Government and the Office of the White House. The announcement states: If you have not already done so, I urge our private sector partners to harden your cyber defenses immediately. <<Read Full Statemen Read more…
Table Variable Vs. Temp Table
Every time I do a performance training class I share some stories about those long running reports that I was able to speed up by simply switching a Table Variable (declared with the @ sign) to a Temp Table (declare Read more…
Raving Fan of March 2022 – “Best tool out there”
The goal at Stedman Solutions, is to create raving fans out of each client. “Just satisfied” is not enough for us. This raving fans page is where we share details on raves from our happy customers. >>> Read what other Fan Read more…
Transparent Data Encryption (TDE) on SQL Server 2019 Standard Edition
For years we have been able to use Transparent Data Encryption or TDE to encrypt our database files on SQL Server Enterprise Edition. This ability was the only reason many clients needed to upgrade from Standard Edition to Enterprise Edition Read more…
Current Coupon Codes
50% OFF Our Newest Course! Coupon Code: FEB-RELEASE50 Using our instruction and scripts included in this course you will successfully configure email notifications when blocking occurs. Address blocking BEFORE it takes down your system. Read more…
Do you have the right backup and recovery strategy?
There is an old DBA joke, that goes something like this: You either need to have a good backup strategy, or a really good resume. But all joking aside, many people responsible for a SQL Server database find out to Read more…
10 Day of Database Health Reports Recap
We hope you enjoyed our 10 days of Database Health Monitor Reports. We enjoy making your job easier! To it even easier we’ve created this blog post with all 10 days listed.
Day 10 – Server Overview
With the server overview page you can keep close tabs on some of the key performance indicators for a SQL Server. The details on this page apply not to a single database, but instead to the entire SQL Server instance Read more…
Day 9 – I/O By Drive
The I/0 By drive report gives you an overview of how much I/O each drive holding database or log files is using. Here is an example showing the IO by drive for a SQL server with no databases on th Read more…
SQL Daily Monitoring – SQL Server Versions for February
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 What does this post mean?? Read more…
Day 8 – I/O By Database
The I/O By Database report is one of the instance level reports available in Database Health Monitor. The I/O by database page shows the databases with the most IO on your system. This can be used to track down performance Read more…
Day 7 – Waits by Type for Instance
The waits by type for instance page shows you the most commonly occurring waits on your SQL Server. Grid Columns Row: Just the row number in the grid. Type: The name of this wait type. Wait Seconds: The total amount Read more…
Day 6 – Inventory All Instances
This report originally came from a customer request. They wanted to be able to export a list of all SQL Servers to another tool for managing all their SQL Server licenses. You can get to this report by going to Read more…
Day 5 – Blocking by Hour of Day
The Blocking by Hour of the Day report is one of the instance level reports available in Database Health Monitor. Important Note: The blocking percentages are relative for the date range shown. We find the hour that has the most Read more…
Day 4 – CPU By Hour of Day
The SQL CPU by Hour of Day report lets you see what the average CPU load was per hour for the last week and beyond. I have used this report countless times to explain to customers what is going on Read more…
Day 3 – File Utilization
This report is commonly used to check in on the status of data files and log files for SQL Server. It is much quicker than right clicking on each database in SSMS and browsing to view the files. Some of Read more »
