By Posted on Posted in SQL Daily Checkup No Comments Tagged with , , ,

Here listed is the current percentages of SQL server versions running our Daily SQL monitoring service with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The pie chart above represents all of our current customers using our service and what SQL Server versions they are running. …

Daily SQL Monitoring – SQL Server Versions for April Read more »

By Posted on Posted in Classes No Comments Tagged with , , , ,

Current Stedman Solutions SQL Course Coupon Codes. Save Up to 65% Off our Popular Online SQL Server Courses, a Once a Year Type Savings! 65% Off for April JOINs Month Coupon Code: APRIL-JOINS Leave your JOIN confusion in the past and enroll in our SQL Server JOIN Types Course. Learn More Here 50% Off Our Newest Course! Coupon Code: FEB-RELEASE50 …

SQL Course Coupon Codes Read more »

By Posted on Posted in Corruption No Comments Tagged with , , , ,

So, you have discovered CheckDB is reporting errors on your SQL Server database or on a table in your database. What do you do? REPAIR_ALLOW_DATA_LOSS seems like and quick and easy fix right? But do you actually know what you’re doing? Well, if you read the error messages you might see that repair_allow_data_loss is the minimum repair level for the …

Beware – REPAIR_ALLOW_DATA_LOSS Vs REPAIR_REBUILD Read more »

By Posted on Posted in SQL 2017, Updates No Comments Tagged with , ,

If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions can help. With the amount of ransomware we are seeing, it is becoming more important than ever to apply any updates that contain security patches. Microsoft Just Released SQL Server 2017 CU 29 (KB 5010786) Here are the latest updates for each …

New SQL Update or SP from Microsoft Read more »

By Posted on Posted in Classes, JOIN Types, TSQL No Comments Tagged with , , , ,

Joining tables in SQL Server can be confusing and hinder your performance. I know because I have helped many confused people to understand their JOINs. That is why I created the JOIN Types cheat sheet several years ago, and the JOIN Types class last year. I have recently updated my poster to version 22. I have also made many blog …

Understanding JOINs Month Read more »

By Posted on Posted in Performance No Comments Tagged with , ,

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 …

March Blog Posts Wrap-up Read more »

By Posted on Posted in Steve No Comments Tagged with , , , ,

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

Seven Years at Stedman Solutions. Read more »

By Posted on Posted in Backup, Classes, Ransomware, Recovery No Comments Tagged with , , , , ,

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 …

High Alert – Preparing for a Cyber Attack Read more »

By Posted on Posted in Performance Tuning No Comments Tagged with , , , , ,

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 …

Table Variable Vs. Temp Table Read more »

By Posted on Posted in Database Health No Comments Tagged with , , ,

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 »