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. What’s happened over 7 years? Grew the team from 0 to 1, and eventually to 5 and still growing. Database Corruption Challenge in 2015. …
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 Statement Here>> A frightening announcement for sure but don’t become a helpless victim! New customers are coming to us now regularly …
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 (declared with the # sign). Today I was working on a batch of TSQL code that took about 8 minutes to …
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 Fans had to say <<< I installed Database Health Monitor on many of my client’s SQL servers and believe it’s the …
Raving Fan of March 2022 – “Best tool out there” Read more »
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. SQL Server 2019 includes TDE as a Standard Edition feature. No longer do you need to shell out the extra …
Transparent Data Encryption (TDE) on SQL Server 2019 Standard Edition Read more »
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. >>> Link to Course <<<
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 too late that they did not have the right backup and recovery strategy. How would it feel to explain to your …
Do you have the right backup and recovery strategy? Read more »
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. Don’t have Database Health Monitor? Learn more about it. Day 1 – Database By Size The databases by size report is a quick and easy way to see …
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. The server overview page gives you a quick rundown of the following: Historic Waits Plan Cache CPU By Database Server …
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 the C Drive, and the load split between the E, F and G drives. The image below shows a SQL Server …