At the beginning of June I realized that I was slightly behind on my blogging, so today, June 30th marks 30 days of 30 blog posts in the month of June. Some other big blogging months were March 2015 and April 2015, around the Database Corruption Challenge, and June 2013 with 27 posts, and May 2013 with 27 posts.
I hope that you have found something interesting in my posts for this month.
Now on to July.
Here is a summary of my posts from June.
SQL Server Express File Size Limitation
Recently while working on a project I ran into the SQL Server Express File Size Limitation. After tracking it down I thought it would be worth documenting here for the next time someone …Switching Compatibility Levels on Multiple Databases
Recently as part of an upgrade to SQL Server 2019, I needed to set the compatibility levels for a database to 150 (for 2019). You could certainly do this by clicking through the …- As a DBA, what is the biggest problem or mess you have had to clean up in a SQL Server. If you have been a DBA for long enough, at some point you …
- Question submitted at SteveStedman.com: Is there any formula to calculate size of TempDB? There are some great formula’s out there for instance to calculate the max server memory setting (https://bornsql.ca/s/memory/), however calculating the …
- A query walks into a bar and sees two tables. He walks up to them and says ‘Can I join you?‘ One table responds… Only if you are willing to commit. Getting Help …
What Version of SQL Server Are You Using?
For me, I support SQL Server version from SQL Server 2000 all the way to SQL Server 2019 and Azure SQL. In a typical week I work on everything in between SQL Server …
How Much Backup History is Too Much?
How much is too much when it comes to backup history. What we are talking about here is how much backup history do you want to keep, backup sizes, what file was written, …- 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 …
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 …SQL Server Text Data – Reclaiming space
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 …- 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 …
Setting text field to empty or null does not release the space used
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 …- 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 …
SQL Server Recovery Models Explained
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 …- 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 …
Weekly Summary – June 12, 2020
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 …Does a corrupt database really need to be repaired?
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 …What does it mean when a SQL Database is SUSPECT?
First rules about a database being in suspect mode: Do not trust anyone who just says follow these steps and it will always fix a SQL database that is SUSPECT. Do not listen …repair_rebuild vs repair_allow_data_loss
Yesterday I posted about how repair_allow_data_loss should never be used with CHECKDB or CHECKTABLE. Today I want to share the difference between repair_rebuild vs repair_allow_data_loss. First off, after reading the post about never …Do Not Run REPAIR_ALLOW_DATA_LOSS
So often I get the call from someone needing help with repairing a corrupt database, and then they tell me that they ran CHECKDB with REPAIR_ALLOW_DATA_LOSS and at that point I realize it …- 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. …
- When running DBCC CHECKDB, you will often times get screens of information back stating that the database is all okay, and that it checked every table. This can be quite tedious when you …
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 than spending hours clicking through the SSMS dialogs …- 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 …
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 type of corruption in the database. Every time …- Database Corruption ChallengeIn 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 …
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 smaller offerings that we have is for what …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 as: A full backup and restore of a …
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!