Help With SQL Queries
A few times each week I get questions from people wanting help with a query. If the solution is something simple that I can see… Read More »Help With SQL Queries
SQL Server
Weekly Summary – June 19, 2020
Here is a list of my blog posts from the last week. SQL Server Text Data – Reclaiming spaceJune 18, 2020Earlier in the week I… Read More »Weekly Summary – June 19, 2020
SQL Server Text Data – Reclaiming space
Earlier in the week I answered a question about reclaiming space, and after that post, I decided to put it into a video. Take a… Read More »SQL Server Text Data – Reclaiming space
Configuring Merge Replication
This video is a 12 minute demo of how to quickly configure merge replication and to see it in action between SQL Server 2019 and… Read More »Configuring Merge Replication
SQL Server Recovery Models Explained
SQL Server recovery models often incorrectly referred to as (MS SQL Recovery Mode) define how your SQL Server database will treat your transaction logs. There… Read More »SQL Server Recovery Models Explained
What does it mean when a SQL Database is SUSPECT?
First rules about a database being in suspect mode: A SQL database that is SUSPECT implies that it was unable to completely start up after… Read More »What does it mean when a SQL Database is SUSPECT?
Location of Master MDF files
The following question was asked on my website: What file does SQL Server use to find the location of the master.mdf file? website question Without… Read More »Location of Master MDF files
Weekly Summary – June 5, 2020
Here is my weekly summary of recent blog posts for the last 7 days. Script to bulk add SysAdmins to SQL ServerJune 5, 2020 Recently… Read More »Weekly Summary – June 5, 2020
SQL Server Mentoring – what we offer
At Stedman Solutions we work with our clients a variety of different consulting agreements from fixed price projects to ongoing hourly work. One of the… Read More »SQL Server Mentoring – what we offer
TSQL To List Recent Backups
Doing some recent investigation to find out why backups where not showing up where they were expected to be I put together this script to… Read More »TSQL To List Recent Backups