Louis Davidson

PASS Week/Speaking/Doing Schedule

Well, we are finally here at what is the secular version of the holiday season for Microsoft SQL Server nerd...

10 October 2011 3 min read

Jonathan Medd

Adding a Graphical Front End to your PowerShell Scripts

Even if you know PowerShell inside and out, there will be those times where you won't be the end user...

10 October 2011 20 min read

Jaap Wesselius

Recover a Mailbox Server in A Database Availability Group (DAG)

When one mailbox server in a Database Availability Group (DAG) is accidentally deleted, then it is supposedly easy to fix...

10 October 2011 4 min read

Robert Sheldon

Implementing Checkpoints in an SSIS Package

Like any other application, an SSIS package can fail. Once the problem has been resolved, you'll usually restart the package,...

10 October 2011 12 min read

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

A Performance Troubleshooting Methodology for SQL Server

When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between...

28 September 2011 33 min read

Rebecca Amos

An interview with Jeff Moden – Exceptional DBA 2011

He may call himself an “Accidental DBA”, but the many SQL Server professionals who have benefited from Jeff Moden’s knowledge...

27 September 2011 2 min read

Patrick Barel

Bulk Processing in Oracle Part 2

The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray...

27 September 2011 4 min read

Louis Davidson

MVP Deep Dives 2: Coming Really Soon

You probably have noticed that I haven’t blogged all that much these days. Part of the reason has been taking...

27 September 2011 3 min read

Learn SQL Server

Robert Young in Learn SQL Server

Going Beyond the Relational Model with Data

SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw...

27 September 2011 28 min read

Register for Simple Talk

Articles

PASS Week/Speaking/Doing Schedule

Adding a Graphical Front End to your PowerShell Scripts

Recover a Mailbox Server in A Database Availability Group (DAG)

Implementing Checkpoints in an SSIS Package

Complete Showplan Operators

SortedDictionary and SortedList

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

Introduction to Virtual Private Databases

Signal to Noise

Time for a rethink on SQL CLR?

Presentations: On snatching victory from the jaws of defeat.

Troubleshooting SQL Server: A Guide for the Accidental DBA

Chapters 9, 10, 11, and 12

Jez Humble: Geek of the Week

TLS/SSL and .NET Framework 4.0

A Performance Troubleshooting Methodology for SQL Server

An interview with Jeff Moden – Exceptional DBA 2011

Bulk Processing in Oracle Part 2

MVP Deep Dives 2: Coming Really Soon

Going Beyond the Relational Model with Data