Info

Dear SQL DBA

Kendra Little of SQLWorkbooks.com answers burning questions from SQL Server Database Administrators and talks about her experiences as a DBA, consultant, and trainer.
RSS Feed
Dear SQL DBA
2018
June
May
April


2017
December
November
October
September
August
May
April
March
February
January


2016
December
November
October
September
August
July
June
May


Categories

All Episodes
Archives
Categories
Now displaying: March, 2017
Mar 30, 2017

A database transaction log is expanding, even though the DBA is running log backups and doesn't see an open transaction? What's going on with this Availability Group?

Timestamps in this episode if you want to skip ahead:

00:49 What's new @ SQL Workbooks
03:22 Info on SQLPASS Summit Content Survey & a heads-up for aspiring precon speakers
05:35 This week's question about t-log growth

Mar 23, 2017

A few episodes ago, I talked about how learning about Write Ahead Logging was a light bulb moment for me, and helped me learn tons of concepts about backups and recovery. This week, we talk about when SQL Server turns things upside down and doesn't use write ahead logging: and what it has to do for recovery in these special cases.

Mar 16, 2017

When you migrate a database, it can be useful to prove that you moved all the data and didn't miss any transactions. Learn how to use a tail log backup in a migration scenario.

Mar 9, 2017

Learn what a Stack Dump is in SQL Server. Hear what happens when Kendra causes a stack dump against a test SQL Server instance under load. Learn how to find information about stack dumps on your SQL Server, and how to escalate them when required.

Mar 2, 2017

When you're a Junior DBA, it's really hard to take in all the information out there. Learn about write ahead logging: the concept that can help you make sense of recovery models and backup strategies in SQL Server. Kendra tells the story of the "Wow!" moment when she learned about write ahead logging from Kimberly Tripp of SQLSkills.com, and explains how this all works in SQL Server.

1