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
October
August
July
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: Category: technology
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 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.

Feb 23, 2017

Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? Kendra talks about the future of database administration and gives tips on strategizing your career.

Feb 16, 2017

Learn why the output from the built-in procedure sp_who2 can be so confusing, how to get more information, and free tools that can make it easier to figure out what you need to pay attention to in SQL Server.

Feb 9, 2017

Learn where full-text search shines, a common problem which full-text search does NOT solve, where full-text can run into performance problems.

Feb 2, 2017

Learn the difference between heaps, clustered and nonclustered indexes, primary keys, and columnstore indexes in SQL Server.

Jan 26, 2017

Learn how to approach the unexpected in a mysterious execution plan that contains way more operators than expected for a very simple SQL Server query.

Jan 19, 2017

Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help, surprisingly even on non-partitioned tables.

Nov 24, 2016

The first time you test a query it's slow, but when you run it again, it's much faster. Learn how SQL Server uses memory to make the second run much faster.

Nov 17, 2016

Learn why SQL Server 2016 SP1 is a game changer, and how to take best advantage of all the cool features now in Standard and Web Editions.

Nov 3, 2016

Learn about new features to speed up SQL Server queries. Kendra talks about automatic index tuning and speculates about Adaptive Query Processing.

Oct 20, 2016

As a database administrator or developer, you'll get into trouble fast if you try to force all your code and processes into a database shaped hole. You have to be creative when you problem solve  -- and when you communicate! So how do you cultivate creativity?

Oct 13, 2016

The bigger your indexes are, the harder your index maintenance falls. Is it better to rebuild big indexes? Or should you reorganize? Learn the pros and cons of each command and other options.

Oct 6, 2016

Should you look at automatically created statistics on  your tables in SQL Server to help you design better indexes?

Sep 29, 2016

What tools in SQL Server will notify you about blocking and help track the queries behind your toughest blocking and deadlocking problems?

Sep 22, 2016

Should you always index your foreign keys? What if you index them, and then the index never gets used?

Sep 1, 2016

Learn what it's like to find and develop your voice as a technical speaker in this week's episode.

Aug 25, 2016

What are the best tools to collect and baseline wait statistics? Should you write your own?

Aug 11, 2016

You'd love to have a job tuning SQL Servers, but you don't have an environment to practice in. Here's how to teach yourself performance tuning and prepare yourself to land and succeed in job interviews.

Aug 4, 2016

You need to change an INT column to a BIGINT in a large table. Learn why this schema change can make your transaction log explode, and how to avoid it.

Jul 28, 2016

Your boss wants you to automate patching for your SQL Servers. Is that a good idea? How far should you take it? Find out a DBAs perspective.

 

Jul 21, 2016

Learn what can cause performance regressions after migrating to a new SQL Server version, and how to troubleshoot it.

Jul 14, 2016

Learn how to configure the Max Degree of Parallelism and Cost Threshold for Parallelism settings in SQL Server - and about how SQL Server 2014 SP2 and SQL Server 2016 change the way that SQL Server automatically configures some SQL Servers with lots of cores.

« Previous 1 2 3 Next »