Disk partition alignment is an often overlooked way to improve SQL Server I/O performance. A pointer to Microsoft’s paper on aligned and nonaligned storage.
SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
My review of Greg Low’s guide to building technical user communities, a one-of-its-kind book for anyone who wants to start and grow a user group.
SQLAuthority News – MVP Award Renewed
Microsoft has renewed my SQL Server MVP award for another year. A short note of thanks to everyone who helped make this proud moment possible.
SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
What is the difference between Line Feed (\n) and Carriage Return (\r)? Why Windows, Mac and Unix read a new line differently, and what it means in T-SQL.
SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
An introduction to Policy-Based Management in SQL Server 2008: facets, conditions, policies, and how to create, evaluate and fix non-complying policies.
SQL SERVER – Maximum Number of Index per Table
My TechEd on Road Ahmedabad recap, with 200+ attendees and a quiz, along with a look at the maximum number of index per table in SQL Server.
SQL SERVER – SQL Server Management Studio New Features
The top 5 new features of SQL Server Management Studio 2008, the tool that replaced Enterprise Manager and Query Analyzer, with upgrades DBAs asked for.