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 I had a project where I needed to add a number of logins as SQL Server sysadmin users to several SQL Server instances. Rather than spending hours clicking through the SSMS dialogs …
Latest 100 PostsRead More »
Another Successful Corrupt Database RepairJune 4, 2020
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 type of corruption in the database. Every time …
Latest 100 PostsRead More »
Database Corruption ChallengeJune 3, 2020
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 repair corrupt databases and to provide options to …
Latest 100 PostsRead More »
SQL Server Mentoring – what we offerJune 2, 2020
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 smaller offerings that we have is for what …
Latest 100 PostsRead More »
Confusion with Database CorruptionJune 1, 2020
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 as: A full backup and restore of a …
Latest 100 PostsRead More »

Weekly Summary – June 5, 2020