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
SteveStedman
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
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
Another Happy Customer
After finishing a recent project we received this feedback from the customer. As a community health center with many competing priorities and limited resources, we… Read More »Another Happy Customer
Size of all databases on an instance
Occasionally I have the need to look up the size of all databases on an instance, based on the log file size and the data… Read More »Size of all databases on an instance