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 answered a question about reclaiming space, and after that post, I decided to put it …
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 …
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 …
What was your worst day as a DBA? We all have ups and downs in our life, perhaps some of those bad days are the days that make us realize how good we have it on a good day. There …
Here is a quest that was submitted on the blog today. HelloJust have a question about a table of mineone of the columns is of type text and its of estimated size of 128gb (99%)Now I do not have permissions …
Setting text field to empty or null does not release the space used Read more »
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 …
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: …
What does ransomware do to a SQL Server? Ransomware The way that ransomware generally does their thing it encrypts files and then leaves some clues around telling you that you need to pay the ransom, which often times is to …
It was a busy week this week, but I was able to create several blog posts relating to corruption. Does a corrupt database really need to be repaired?June 11, 2020 At Stedman Solutions, LLC the team and I do many database …
At Stedman Solutions, LLC the team and I do many database repairs from simple things that take just a few minutes to larger repairs that take many days to repair. Since 2015 we have been doing database corruption repair and …
Does a corrupt database really need to be repaired? Read more »
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 …
What does it mean when a SQL Database is SUSPECT? Read more »