Fabiano Amorim

Complete Showplan Operators

Fabiano Amorim has taken the time to really drill into the behavior of a small set of execution plan operators...

10 October 2011 2 min read

Simon Cooper

SortedDictionary and SortedList

Apart from Dictionary<TKey, TValue>, there’s two other dictionaries in the BCL – SortedDictionary<TKey, TValue> and SortedList<TKey, TValue>. On the face...

05 October 2011 7 min read

Rebecca Amos

We're having an exceptionally good party – and you're invited!

Are you coming to the PASS Summit? Then join us to help Jeff Moden celebrate his Award of Exceptional DBA...

05 October 2011 1 min read

David Njoku

Introduction to Virtual Private Databases

You know the story. A group of blind men come across an elephant and each one feels a part...

04 October 2011 6 min read

Grant Fritchey

Signal to Noise

Out of the box SQL Monitor has a number of alerts configured for you. You can just install the software,...

03 October 2011 1 min read

Tony Davis

Time for a rethink on SQL CLR?

It is almost seven years since Microsoft announced the sensational news that, with their new SQL Server 2005, you could...

29 September 2011 4 min read

Phil Factor

Presentations: On snatching victory from the jaws of defeat.

Ah, SQL Pass is imminent; and all over the world, people are preparing their presentations. There is great satisfaction to...

29 September 2011 8 min read

Jonathan Kehayias

Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common...

29 September 2011 2 min read

Louis Davidson

Chapters 9, 10, 11, and 12

So I have been a bit remiss on my blogging the book duties. The fact is, the first 8 chapters...

28 September 2011 3 min read

Richard Morris

Jez Humble: Geek of the Week

Jez Humble and David Farley achieved fame through a book that tackled the least glamorous but most intricate part of...

28 September 2011 17 min read

Matteo Slaviero

TLS/SSL and .NET Framework 4.0

The Secure Socket Layer is now essential for the secure exchange of digital data, and is most generally used within...

28 September 2011 26 min read

Performance

Jonathan Kehayias in Performance

SQL Server Performance Troubleshooting: Wait Statistics, Virtual File Stats, Performance Counters, and Plan Cache

A systematic methodology for troubleshooting SQL Server performance issues using wait statistics (sys.dm_os_wait_stats), virtual file statistics (sys.dm_io_virtual_file_stats), Windows performance counters,...

28 September 2011 33 min read

Rebecca Amos