Thanks Paul.  I am planning an update for all these Stairway Levels.  Not sure when though, but it is on my list.

Yes, it will be SQL 2022. I have been waiting for a while for this. Happy Trails.

I am happy to update the article.  I will work with the publishers.

Most of the code will still work as it is, but the way you get the assemblies with...

No as illustrated above, instead of $Host.Name on the second one, it was supposed to be $Host.Version.

Good catch.

My understanding is that when you restore in standby, it will do the crash recovery for the database and execute the Redo phase and store the Undo phase in the...

Thanks.  I was really just illustrating that it is a permissions issue with the file.  The way I have done it in a demo is to allow permissions to Everyone...

When you back up a certificate the file that is created is locked down in permissions (ACL-Access Control List) to the SQL Server Service account only.  If you were to...

• This reply was modified 3 years, 7 months ago by  Ben Miller. Reason: missed adding something

Best Wishes Ken. Haven't seen you in a long time. Stay safe and hope to see you sometime in person. Best to your wife as well. Thanks for all you...

It is a feature of the Big Data Cluster part of the SQL 2019 Release. It did not make it into the Relational Engine this release. So no system dbs...

Yes, I know all of these things. Thanks for the posts.  These articles were written years ago.  I will see if I can get with Red-Gate and get these updated...

And you can certainly run RESTORE HEADERONLY from disk='disk file location' and RESTORE FILELISTONLY FROM disk='path to disk' to get some information about the database backup from the backup files...

I just migrated hundreds of databases to new servers and SQL 2016 SP1.  I used log shipping with PowerShell that I created to start the process of migration early and...

You are using terms that aren't really real. Between SQL and the disks. It is really about the Disks and Buffer Pool (reading from disks into memory) and there is...

As has been said it depends on whether your SQL Server services shutdown cleanly. If not there are ways to attach a single file as a database, but it will...

CUs will contain patches that are new and important for installation. Some could be contained in CUs, but they are also added to Windows Update and in the Security Bulletins. ...