Here’s a quick and easy link to review all blog posts written by Steve Stedman in February 2021. Enjoy! SQL Server – Backing up a database Sat, 27 Feb 2021 If you are a pro at SQL server I am sure you already know how to backup a database, but for someone who is new to it, things can be …
The following is chapter 6 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in this chapter. The script mentioned in this chapter is available at http://SteveStedman.com. Thinking of the proverb “two heads are better than one” makes me think, it really depends on the people. Two people working together are …
If you are a pro at SQL server I am sure you already know how to backup a database, but for someone who is new to it, things can be a bit overwhelming and confusing. This is especially confusing with the number of options that Microsoft has added into SQL Server Management Studio over time. We get called in quite …
Take a look at the video on our Youtube channel. After repairing dozens of corrupt databases over the last 6 years we are going to share our experiences. Some of the good, the bad, and the ugly of corrupt databases. What things people did to make it worse, and what people did to make things better. Related links:
Microsoft has just release an cumulative update for SQL Server 2017 CU 23. I am always interested in fixes to DBCC CHECKDB and DBCC CHECKTABLE. There was one fix related to CHECKTABLE that fixes an issue where the session gets killed when you run DBCC CHECKTABLE with PHYSICAL_ONLY due to disk full. The session remains in KILLED\ROLLBACK state and threads …
The following is chapter 5 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in this chapter. The script mentioned in this chapter is available at http://SteveStedman.com. Hierarchical CTEs When looking at the table of contents for a book it is generally represented as an outline of some kind utilizing indentation, …
Since installing SQL Server 2019 CU9, I have been getting lots of errors about NO DEK Update for almost every file. Here is an excerpt from the SQL Server log file. 182 2/20/2021 2:07:46 PM spid25s Refresh DEK for DBID: [5] File Id: [1] – Copying encryption state183 2/20/2021 2:07:46 PM spid25s DBID: [5] File Header for File Id: [1] …
As part of the CTE book there is a sample database that all the queries use. You can download the create script for that sample database here and run it in your local SQL Server, or on a test SQL Server: Due to the security settings of the web site, and many download checks, I was unable to anme the …
The attached PDF is the slide deck for my Introduction to Corruption presentation from Feb 17th 2021. I hope you enjoyed the session.
We are 2 days away from the Introduction to Database Corruption free presentation. On February 17, 2021 at 6:00pm Pacific time we will be presenting a free webcast training on SQL Server Database Corruption. After repairing dozens of corrupt databases over the last 6 years we are going to share our experiences. Some of the good, the bad, and the …