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.
Do Clustered Index Columns Count Against Max Nonclustered Key Size?
Category:
indexing
, sql-server
SQL Server 2016 and Azure SQL Database have a lot of little perks. One little thing that changed is that the maximum key size allowed for nonclustered indexes was raised from 900 bytes to 1700 bytes.
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.
Free Poster: tempdb data files in SQL Server
Category:
database-administration
The tempdb database is a strange place in SQL Server.
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?
Does Adding NOINDEX Change DBCC CHECKDB with PHYSICAL_ONLY?
Category:
backup-recovery
The NOINDEX option does change the behavior of DBCC CHECKDB (even if you’re already using PHYSICAL_ONLY). Here’s how the two options compare to one another, and how to see the difference yourself in a simple example.
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.