Alex Kuznetsov

Modifying Contiguous Time Periods in a History Table

Alex Kuznetsov is credited with a clever technique for creating a history table for SQL that is designed to store...

25 November 2010 7 min read

Brian Donahue

Updating the managed debugging API for .NET v4

In any successful investigation, the right tools play a big part in collecting evidence about the state of the “crime scene”...

24 November 2010 5 min read

Louis Davidson

Un-SQL–Thanksgiving

So here it is the night of Thanksgiving Eve here in the United states, and some time tomorrow I will...

24 November 2010 4 min read

Richard Mitchell

SQL Monitor and "The Cloud"

So, how can we demo this thing? In the beginning there was a product, and it was a good product...

23 November 2010 3 min read

Holger Schmeling

SQL Server Statistics

A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the...

23 November 2010 3 min read

Louis Davidson

Design Book– First Section (Skills)

One of the main things that I haven’t always loved about the previous books is that it wasn’t a perfect...

22 November 2010 5 min read

The .NET Team

Alan Turing Needs Your Help

Well. sort of. Clearly, you are using a computer. If you are on this site, you are probably quite familiar...

22 November 2010 2 min read

Phil Factor

Listing common SQL Code Smells.

Once you’ve done a number of SQL Code-reviews, you’ll know those signs in the code that all might not be...

22 November 2010 7 min read

Fabiano Amorim

ShowPlan Operator of the Week – Merge Join

Did you ever wonder how and why your indexes affect the performance of joins? Once you've read Fabiano's unforgettable explanation,...

22 November 2010 9 min read

Joe Celko

Contiguous Time Periods

It is always better, and more efficient, to maintain referential integrity by using constraints rather than triggers. Sometimes it is...

22 November 2010 13 min read

Louis Davidson

One Domain Table or Many?

Early in 2007, I wrote an article for Simple-Talk called Ten Common Database Design Mistakes, and it has been...

20 November 2010 6 min read

The .NET Team

A Bit Cloudy

“Systems Administrators, I come in peace. You have nothing to fear from me” – Office 365 Microsoft Business Productivity Online...

18 November 2010 3 min read

Dr. Masha Petrova

5 Steps to Making Your Boss Read Your Technical Reports

As an IT professional, you probably find it hard to communicate effectively with your less-than-technically-adept manager. Dr. Masha Petrova is...

18 November 2010 10 min read

Simon Cooper

Subterranean IL: Constructor constraints

The constructor generic constraint is a slightly wierd one. The ECMA specification simply states that it: constrains [the type] to...

17 November 2010 4 min read

Johan Veldhuis

Monitoring Mailbox Moves

Mailboxes moves happen all the time, and given how precious the data in mailboxes can be, you should know exactly...

17 November 2010 13 min read

Louis Davidson

Design Book–Top level outline

The more I teach sessions about database design, the more I realize that two things are true. First, most people...

16 November 2010 2 min read

Brien Posey

PST Horror Stories

Brien has been on the front line of Systems Administration for long enough to both respect and fear PST files....

16 November 2010 10 min read

Richard Mitchell

A weekend with the Samsung Galaxy Tab

This weekend I took one of the Samsung Galaxy Tabs we have lying around the office here home to see...

15 November 2010 5 min read

Phil Factor

Musings on the launch of SQL Monitor

For several years, I was responsible for the smooth running of a large number of enterprise database servers. We ran...

15 November 2010 4 min read

Phil Factor

Consuming JSON Strings in SQL Server

It has always seemed strange to Phil that SQL Server has such complete support for XML, yet is completely devoid...

15 November 2010 26 min read

Register for Simple Talk

Articles

Modifying Contiguous Time Periods in a History Table

Updating the managed debugging API for .NET v4

Un-SQL–Thanksgiving

SQL Monitor and "The Cloud"

SQL Server Statistics

Design Book– First Section (Skills)

Alan Turing Needs Your Help

Listing common SQL Code Smells.

ShowPlan Operator of the Week – Merge Join

Contiguous Time Periods

One Domain Table or Many?

A Bit Cloudy

5 Steps to Making Your Boss Read Your Technical Reports

Subterranean IL: Constructor constraints

Monitoring Mailbox Moves

Design Book–Top level outline

PST Horror Stories

A weekend with the Samsung Galaxy Tab

Musings on the launch of SQL Monitor

Consuming JSON Strings in SQL Server