Here’s a quick and easy link to review all blog posts written 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 a bit overwhelming and confusing. This is especially confusing wit Read more…
Introduction to Database Corruption Full Presentation
Fri, 26 Feb 2021
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 Read more…
New cumulative update for SQL Server 2017
https://stevestedman.com/2021/02/new-cumulative-update-for-sql-server-2017/Thu, 25 Feb 2021
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 get Read more…
Hierarchical Queries
Tue, 23 Feb 2021
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 lookin Read more…
NO DEK Update for File ID
https://stevestedman.com/2021/02/no-dek-update-for-file-id/Sat, 20 Feb 2021
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 Read more…
CTE Book Sample Code
Sat, 20 Feb 2021
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 SQ Read more…
Introduction to Corruption Slide Deck
Thu, 18 Feb 2021
The attached PDF is the slide deck for my Introduction to Corruption presentation from Feb 17th 2021. I hope you enjoyed the session.
The post Introduction to Corruption Slide Deck appeared first on Steve Stedman.
Introduction to Database Corruption
https://stevestedman.com/2021/02/introduction-to-database-corruption/Mon, 15 Feb 2021
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 database Read more…
Recursive CTEs
Mon, 15 Feb 2021
The following is chapter 4 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 availabl Read more…
Guidance on Query Optimization
Sun, 14 Feb 2021
I received this question from someone visiting the blog, and realized that rather than just replying to them, it might be good to put the options out there for everyone to see. Hello, I came across your website and it seem Read more…
OUTPUT Clause with an insert statement
Thu, 11 Feb 2021
So often I run into examples where someone is inserting a row and trying to get one of the values from that row that was just inserted. For instance an integer identity id value or just to be able t Read more…
Prize giveaway at the February webinar presentation
Mon, 08 Feb 2021
At our February webinar presentation on Database Corruption, Stedman Solutions will be giving away 3 daily checkup subscriptions one 3-month subscription, one 6-month subscription and one 9-month subscription. A value of $300, $600, and $900 each! If you are no Read more…