- Finding Serializable Queries
Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I needed to find queries that were being run against a SQL Server that …
- November 2019 Release of Database Health Monitor
Thanks to the successful funding campaign on Indiegogo I was able to fund the November 2019 release of Database Health Monitor. Here are the release notes. Version 2.9.4 Release Notes Version 2.9.4 is …
-
Funding the November release of Database Health Monitor
Can you help fund the next release of Database Health Monitor? I have started an Indiegogo funding campaign for the November release of Database Health monitor. Not asking for a lot here, just … - Upgrading SQL Server 2008 and R2
Should I upgrade from SQL Server 2008 and SQL Server 2008 R2 now that it is at end of life? On July 9, 2019 SQL Server 2008 and 2008 R2 reached their end …
- Database Health Monitor – September Release
Earlier today I had the opportunity to release the September update of Database Health Monitor. This is version 2.91. One of the updates is a new feature called aliasing, where you can add …
- Database Health Monitor Usage
Year over year we have had an increase in the number of people regularly using Database Health Monitor as shown in the chart below. I would like to see this grow at a …
- SQL Mail Configuration Errors
You may be configuring SQL Mail for the first time or the thousandth time and you come across the following cryptic message. Date 8/xxxxxx03 AM Log Database Mail (Database Mail Log) Log ID …
- August Discount on SQL Mentoring
Now through the end of August, at Stedman Solutions, we are offering a discount to the our Prepaid Mentoring package. 20% off the normal rates when you sign up and pay by August …
- Database Health Monitor – August 2019 Release
Today I released the August 2019 release of Database Health Monitor. This is version 2.9. My favorite new report is the Blocking By Hour of Day report which uses the existing data that …
- Corruption in TempDB
I received a contact message from the “Contact us” form, asking about how to go about repairing corruption in TempDB. The error message was something like this: SQL Server detected a logical consistency-based …
- TSQL To Start A SQL Agent Job
Most of us are familiar with the quick and easy right clicking on an agent job an select “Start job at Step…”, but what if you need to run a job on many …
- Another Successful Database Corruption Repair
At Stedman Solutions, LLC, we recently had the opportunity to help out another client with a corrupt database, to completely recover all their data and remove all the corruption. In this specific scenario …
-
Database Health Monitor 2.8.2 Released
Yesterday I released the first update to Database Health Monitor in a couple of months. There were some new features and some fixed saved up that were released yesterday. I did however run … - Largest tables on an instance
Here is a quick script that I find myself using frequently to find the largest tables on an entire SQL Server instance. Getting Help from Steve and the Stedman Solutions Team We are …
- TSQL Formatting and Wild Card Expansion
For years I have struggled to find a good way to do TSQL formatting. Here is a short video of how to simple TSQL cleanup and formatting using just SQL Server Management Studio …
- SQL 2016 Won’t Send Mail
One of the more challenging components to configure on SQL Server is SQL Mail. I don’t know how many times I have had to try it multiple times before getting it right. Here …
- Why is my log file not shrinking when I do regular backups?
I often times get the question similar to “Why is my log file not shrinking when I do regular backups”? It goes to show there the functionality of the SQL Server transaction log …
- SQL Server 2008 and 2008R2 End of Life – coming soon
Microsoft has announced that as of July 2019 SQL Server 2008 and SQL Server 2008R2 will be at the end of life support. What does this mean? No more updates, no more security …
- Database Health Monitor – Historic Wait Monitoring
What kind of load does the historic monitoring put on the SQL Server? It is my opinion that the historic wait monitoring is perhaps one of the most valuable features in Database Health …
- Basics of Database Corruption Repair
Please join me on Saturday March 16 in Victoria BC Canada for my SQL Saturday presentation on the Basics of Database Corruption Repair. Here is the session, the Basics of Database Corruption Repair. …
-
Database Health Monitor Version 2.7 Released Today
Today I am happy to release version 2.7 of the Database Health Monitor today. You can download the latest version here. Getting Help from Steve and the Stedman Solutions Team We are ready … - SQL Server 2019 community technology preview 2.3
As SQL Server 2019 approaches its release to manufacturing date, we get another update, Community Technology Preview 2.3. This puts it one step closer to release. More information from Microsoft. Getting Help from …
- SQL Backup Solutions – what do you use?
In the consulting world we come across many different backup and restore options for SQL Server with the different clients that we work with. Personally I am a big fan of the SQL …
- SQL Performance Tuning
Do you need help with a slow running SQL Server? Take a look at these SQL Server performance tuning options that we offer. Stedman Solutions Performance Tuning Getting Help from Steve and the …
- SQL Saturday – Spokane WA
On March 23rd I will be presenting at SQL Saturday in Spokane WA. There is still time to register for this event, so you can still sign up today. My presentation will be …
- SQL Saturday Victoria Canada
We will be visiting SQL Saturday in Victoria Canada on March 16th. After the last SQL Saturday that I tried to attend was snowed out in Redmond a few weeks ago, I am …
- Fixed Corruption in Thailand
Recently Derrick and I had a chance to help with a corruption repair in Thailand, just to clarify, the client was in Thailand, not us. This was our second corruption of the year …
- Bellingham SQL Server Users Group – Lunch Feb 20
On February 20th at Noon the Bellingham SQL Server Users Group, a PASS Chapter will be having its monthly networking lunch at Buffalo Wild Wings at the Bellis Fair Mall. Here is the …
- Stedman Solutions – on Facebook
I just added the Stedman Solutions, LLC company page on Facebook. It turns out I am connecting more and more with the SQL Server community on Facebook, so I figured I should add …
- No SQL Saturday Redmond
Well SQL Server in Redmond at the Microsoft Campus was a bust this year due to the snow storm. Seattle and the east side were hit pretty hard with snow, and Microsoft closed …
- SQL Saturday – Redmond 2019
On February 9, 2019, I have the privileged of presenting at SQL Saturday in Redmond Washington, at the Microsoft campus. SQL Saturday is a free SQL Server event, so if you want to …
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!