Posts by Kendra Little

An Introduction to SQL Server Clusters

Clustering
340 Comments
The options for high availability can get confusing. I was lucky enough to begin working with SQL Server clusters early in my career, but many people have a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster. Today, I’ll tell you what clusters are, what they’re…
Read More

Three Consulting Tools to Make You a Better DBA

21 Comments
As a consultant, I solve hard problems, and I use cool tools. These tools could help you, too– and in ways that may surprise you. Problem 1: The DBA’s Time is Money, and It’s Limited You know what, DBAs? You’re expensive. DBAs are frequently involved in every task that touches a database. This includes Windows…
Read More

SQL Server First Responders Kit Video

7 Comments
When your SQL Server is critically injured you need a first responder kit to help you diagnose the problem and apply emergency aid. In this session, Kendra Little introduces you to invaluable tools and techniques for triaging an emergency. If you have one year’s experience with database administration, this half-hour session will set you up…
Read More

Three Things That Rock About SQL Server

3 Comments
When something remarkable is around for a while, it becomes easy to take it for granted. Today, I’ll share three awesome things about SQL Server with tips to give you an edge when using each one. #1. The Free Online Documentation is Mind Blowing SQL Server is a huge product. We’ve got the database engine,…
Read More

The Dedicated Admin Connection: Why You Want It, When You Need It, and How To Tell Who’s Using It

SQL Server
44 Comments
There’s a DAC in SQL Server that you should know and love. Sadly, you probably either haven’t met or you’ve forgotten to turn it on. DAC? What’s That? First, a little disambiguation. The acronym ‘DAC’ is too popular. For the context of this article, our DAC is the ‘Dedicated Admin Connection’. SQL Server implements a…
Read More

You’ll be Reunited with an Old Friend in 2012

6 Comments
I may love a challenge, but I also like things that are quick and easy. There’s one particular quick and easy feature from SQL Server 2005 which I thought was gone for good. But there are signs it’s going to return. Any guesses what I’m talking about? Nope, it’s not Notification Services. (But that would…
Read More