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 right away without spending much time then I will suggest the solution. Frequently it turns out that people who are asking for help with a query have some really complex queries, where it is going …
Here is a list of my blog posts from the last week. SQL Server Text Data – Reclaiming spaceJune 18, 2020Earlier in the week I answered a question about reclaiming space, and after that post, I decided to put it into a video. Take a look at the video below from YouTube. Take …Read More » Worst Day as a DBAJune …
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 look at the video below from YouTube. Take a look at the video and let me know what you think.
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 SQL Server 2017. However most of what is included here will work on SQL Server 2005 or newer. Transcription: Steve Stedman 0:02Hi, I’m Steve Stedman, and welcome to this quick demo on merge replication. Merge …
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 are 3 SQL Server Recovery Models to choose from, Simple, Full and Bulk Logged. Simple: The transaction log is written to as a transaction runs and once the transaction completes what is in the transaction …
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 a shutdown. For instance, if the power was unplugged from the SQL Server while shutting down with open transactions that are currently being written to disk. Causes: The most important thing to do is to …
What does it mean when a SQL Database is SUSPECT? Read more »
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 context this could mean a few different things. Are you trying to find out where master.mdf is located, or are you trying to move it? The answer is its not saved in a config file, …
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 …
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 we call our mentoring packages. The mentoring works like this. Client prepays for a block of hours, usually 4 to 6 hours up front. Client sends requests …
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 help track down recent backups. Normally I would use Database Health Monitor and the cool backup reports, but I didn’t have that installed on the server needing help. The output looks something like this, although …