Disaster recovery 101: fixing a broken boot page

One of the corruptions that can stymie all efforts at disaster recovery is broken boot page. If the boot page can’t be processed, the database can’t be brought online or even put into emergency mode. I first demonstrated how to work around this in my session on Advanced Data Recovery Techniques at PASS in 2014 […]

T-SQL Tuesday #67 – monitoring log activity with Extended Events

On the second Tuesday of each month, many people in the SQL Server community join together to all blog on the same topic – a cool idea from Adam Machanic many years ago. This month’s topic is Extended Events, hosted by Jes Borland (b | t) – you can see her original post here. Yesterday […]

November classes in Chicago

We’ve released our Fall lineup of classes for registration! Our November classes in Chicago, IL will be: IE0: Immersion Event for Junior/Accidental DBAs November 16 – 18 IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 November 16 – 20 IEPDS: Immersion Event on Practical Data Science November 16 – 19 You can get […]

New course: Index Fragmentation Internals, Analysis, and Solutions

My latest Pluralsight course has been published! It’s called SQL Server: Index Fragmentation Internals, Analysis, and Solutions and is just over 2.5 hours long. The modules are: Introduction Index Structure and Index Uses Types of Index Fragmentation Causes of Index Fragmentation Detecting Index Fragmentation Avoiding Index Fragmentation Removing Index Fragmentation Check it out here. We now […]

Finding a transaction in the log for a particular user

In the last IEHADR class we just had in Chicago, I was doing a demo of looking in the transaction log to find the point at which a table was dropped so a restore could be performed (as described in this blog post). One of the students asked how to find a transaction for a […]