Disaster recovery 101: fixing a broken system table page

This post is about a disaster-recovery scenario I described in our bi-weekly newsletter a couple of weeks ago, and wanted to make sure it’s out on the web too for people to find and use. I was helping someone try to recover data from a corrupt database, from an online forum question. They did not have any up-to-date backups […]

Summer 2018 classes in London open for registration

Due to popular demand, we’re coming back to London in 2018 and I’ve just released our classes for registration! All classes have discounts for registering before the end of 2017! (details on the individual class web pages…) Our classes in September in London will be: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 September […]

TSQL Tuesday #96: Folks Who Have Made a Difference

It’s been almost three years since I wrote a T-SQL Tuesday post (shame on me!), but this is one I definitely want to contribute to. It’s hosted by Ewald Cress and is about “the opportunity to give a shout-out to people (well-known or otherwise) who have made a meaningful contribution to your life in the world […]

New Pluralsight course: Understanding and Performing Backups

My latest Pluralsight course has been published – SQL Server: Understanding and Performing Backups. It’s 2.5 hours long, and from the course description: It’s really impossible to escape the need for backups even if you have some sort of synchronous replica of your databases, disasters can still happen that require restoring from backups. This means it’s critical that […]

Calling all user group leaders! We want to present for you in 2018!

By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more than 100 user groups and PASS virtual chapters around the world in 2017! We’d love to present remotely for your user group in 2018, anywhere in the world. It’s not feasible for us to travel to user groups or SQL […]

New Pluralsight course: Understanding, Configuring, and Troubleshooting Log Shipping

Glenn’s latest Pluralsight course has been published – SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping. It’s 90-minutes long, and from the course description: SQL Server log shipping is a very useful technology for high availability and disaster recovery, as well for general purpose database movement, migration, and upgrades. In this course, SQL Server: Understanding, Configuring, and […]