Do Not Run REPAIR_ALLOW_DATA_LOSS
So often I get the call from someone needing help with repairing a corrupt database, and then they tell me that they ran CHECKDB with… Read More »Do Not Run REPAIR_ALLOW_DATA_LOSS
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
CHECKDB WITH NO_INFOMSGS
When running DBCC CHECKDB, you will often times get screens of information back stating that the database is all okay, and that it checked every… Read More »CHECKDB WITH NO_INFOMSGS
Script to bulk add SysAdmins to SQL Server
Recently I had a project where I needed to add a number of logins as SQL Server sysadmin users to several SQL Server instances. Rather… Read More »Script to bulk add SysAdmins to SQL Server
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
Another Successful Corrupt Database Repair
Recently we had a new customer contact from someone with a corrupt database. They were getting corruption error #824, which usually indicates there is some… Read More »Another Successful Corrupt Database Repair
Database Corruption Challenge
In 2015, around the time I started Stedman Solutions LLC, I created the Database Corruption Challenge as a way to share knowledge of how to… Read More »Database Corruption Challenge
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
Confusion with Database Corruption
When working with clients on fixing their corrupt SQL Server databases we run into some common beliefs about corruption that are not quite true, such… Read More »Confusion with Database Corruption
For merge publications, the version of the Subscriber must not exceed the version of the Publisher
Working on a recent SQL Server merge replication project we needed to update some of the servers in a merge replication scenario without upgrading all… Read More »For merge publications, the version of the Subscriber must not exceed the version of the Publisher