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.
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 are things with family and friends that can make things better or worse, but what I am interested in today …
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 to remove the column, but I was told that I can remove data from it (to save space).But of course, …
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 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 …
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 be paid by bitcoin. The amounts vary, but the times I have seen this the ransom has been between $50,000 …
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 repairs from simple things that take just a few minutes to larger repairs that take many days to repair. Since …
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 have seen many different decisions made by the business owners with the corrupt database. Often times when investigating a corrupt …
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 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 »