Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)
Category:
query-performance
Should you always index your foreign keys? What if you index them, and then the index never gets used?
Tag: dear-sql-dba
Finding Your Voice as a Speaker (Dear SQL DBA Episode 15)
Category:
database-administration
Learn what it’s like to find and develop your voice as a technical speaker in this week’s episode of Dear SQL DBA.
Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)
Category:
monitoring-troubleshooting
What are the best tools to collect and baseline wait statistics? Should you write your own? Watch the 18 minute video or read the episode transcript below.
Developer Seeks DBA Career (Dear SQL DBA, Episode 13)
Category:
career
A C# developer wants to be a DBA, but is having a hard time landing a job. Should they take a pay cut and go for a Junior level job? Or could there be another path?
Teach Yourself SQL Server Performance Tuning (Dear SQL DBA Episode 12)
Category:
query-performance
, sql-server
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.
Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)
Category:
database-administration
, sql-server
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.
Should I Automate my Windows Updates for SQL Server? (Dear SQL DBA Episode 10)
Category:
database-administration
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.