Managing Statistics in SQL Server for DBAs (videos)
Category:
query-performance
, database-administration
Want to learn more about managing statistics updates in SQL Server? Watch my 27 minute presentation on managing statistics.
Category: database-administration
Change Management Template for SQL Server DBAs and Developers
Category:
database-administration
, sql-server
I learned to do Change Management from some really smart people. When I first became a DBA, I worked at a small software company where changes were released with increasing frequency over the years. Our team was really great at planning and deploying changes, because we constantly worked at improving.
Training Plan for Junior DBAs Learning SQL Server
Category:
database-administration
You’re just getting started as a SQL Server Database Administrator – or you’re trying to get there.
Here’s a learning plan and links to free articles and scripts that will equip you to tackle the three most critical skills to for DBAs.
Faking Read and Writes in SQL Server Index DMVs (Trainer Resource)
Category:
database-administration
Trainers and speakers need the code they write to be predictable, re-runnable, and as fast as possible. Faking writes can be useful for speakers and teachers who want to be able to generate some statistics in SQL Server’s index dynamic management views or get some query execution plans into cache. The “faking” bit makes the code re-runnable, and usually a bit faster. For writes, it also reduces the risk of filling up your transaction log.
Three Inspiring Articles to Read This Week
Category:
database-administration
, career
It’s mid-February. New Year’s is gone, but it’s not springtime yet. Don’t get downtrodden – get inspired. Browse these articles and pick out one way you’re going to finish winter in rockstar style.
Warning Signs That You Have a SQL Server Backup Problem
Category:
database-administration
Your backups seem fine. They weren’t failing, the last time you checked. But trouble may be lurking.
Here’s the top 5 warning signs I’ve seen that backups haven’t been thought through.
3 Things I Wish I Learned Earlier as a SQL Server DBA
Category:
database-administration
, sql-server
Hindsight is everything. I was lucky to be trained by a great team of DBAs back when I first started with SQL Server. But it’s hard to know exactly what you really need to know, particularly as new tools are becoming available.