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: 2017
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.

« Previous 1 2