Kalen Delaney has been working with SQL Server for over 26 years and provides SQL Server training and consulting to clients around the world. Her most recent book is SQL Server 2012 Internals (Microsoft Press).
The January SQL Server 2008 Boooks Online (BOL) update revealed two stored procedures that previously weren't documented. Learn how you can use sp_clean_db_free_space and sp_clean_db_file_free_space to clean your database files.
Windows Server 2008 lets you configure the Distributed Transaction Coordinator (DTC) differently in clusters than in Windows Server 2003. Find out how these changes will affect your clustered SQL Server environment.
SQL Server Management Studio (SSMS) is a complex application that does a ton of wonderful things and, with SSMS 2014, there are still a couple of quirks or issues that I hope that Microsoft addresses or corrects someday....More
Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More