February 2021 Blog Posts Wrap Up

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 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

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

Mon, 15 Feb 2021https://stevestedman.com/2021/02/introduction-to-database-corruption/

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

https://stevestedman.com/2021/02/recursive-ctes-2/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
https://stevestedman.com/2021/02/output-clause-with-an-insert-statement/

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…