Nick Harrison

.NET Reflector meets the CodeDom

.NET Reflector was the first .NET tool to allow assemblies to be disassembled back into the high level language that...

02 October 2009 13 min read

Tony Davis

Index Fragmentation Anxiety: a Doctor Speaks

Do you suffer from Index Anxiety? Do you lie awake, worrying about whether you are neglecting to defrag your indexes?...

01 October 2009 3 min read

Robert Sheldon

Using Information Schema Views

Many seasoned database developers tuck away all the commonly-used INFORMATION_SCHEMA queries as templates. They're an indispensable supplement to sp_help and...

01 October 2009 13 min read

Richard Morris

Stephen Curtis Johnson: Geek of the Week

Stephen Johnson, one of the team that developed UNIX, can claim to be the man who originally wrote the software...

01 October 2009 11 min read

Fabiano Amorim

The Query Optimizer: Date Correlation Optimisation

In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to...

01 October 2009 10 min read

Richard Morris

Walter Bright: Geek of the Week

After developing the first native C++ compiler, the Zortech C++, and writing the Symantec Java compiler, Walter Bright created D...

01 October 2009 8 min read

Michael Sorens

A Unified Approach to Multi-DataBase Query Templates

While trying to get the information he needed out of various SQL, MySQL and Oracle environments, Michael finally got tired...

30 September 2009 22 min read

Louis Davidson

SQL Server Deep Dives

A project that I worked on a while back is finally coming to fruition, and it is one of the...

29 September 2009 3 min read

Rodney Landrum

Finding Data Corruption

In this article, taken from Chapter 8 of his new book, SQL Server Tacklebox, Rodney describes how a working DBA...

29 September 2009 29 min read

Damon Armstrong

TechFest Houston Slides and Source Code

TechFest Houston was a blast, and if you came out to my presentation on Simpliyfing Web Part Development or dropped...

28 September 2009 1 min read

Robert Chipperfield

Cloning objects the quick and dirty way

Working in .NET, a lot of the objects I use implement ISerializable – very handy when it comes to throwing...

25 September 2009 3 min read

Joe Celko

Celko’s SQL Stumper: The Data Warehouse Problem

Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems...

25 September 2009 5 min read

Matt Simmons

Hiring System Administrators

Hiring someone for a technical post is a task that should never be tackled half-heartedly. Matt Simmons provides some general...

24 September 2009 10 min read

Brien Posey

Implementing Cluster Replication – Part 1

Imagine that you're researching Continuous Cluster Replication, looking for a simple, direct guide to the basics of getting it set...

23 September 2009 14 min read

Neil Hobson

Exchange 2010 High Availability

In April 2009 Microsoft released a public beta of Exchange 2010, the latest and greatest version of a part of...

18 September 2009 14 min read

Simon Galbraith

Downloading Software: the SQL Prompt 4 Experiment

What is the best way for a Software vendor to get people to try out their tools? Is dialogue with...

18 September 2009 5 min read

Damon Armstrong

Access Denied for "User Profile and My Sites" Links in an SSP

SharePoint is great about hiding permissions. I was working on a Shared Service Provider (SSP) and was greeted with an...

17 September 2009 1 min read

Tony Davis

SQL Server Rootkits: Security Scare or Nightmare?

How many DBAs, I wonder, really know how to go about detecting potential rootkits in their SQL Servers? To install...

17 September 2009 3 min read

Joe Celko

Causation, Correlation and Crackpots

Joe Celko explores the dangers of muddling correlation and causation, emphasises the importance of determining how likely it is that...

15 September 2009 13 min read

Damon Armstrong

VSeWSS 1.3 – Getting around the "Unable to load one or more of the requested types" Error

I hate packaging SharePoint solutions by hand. Once you’ve got it working, it’s not a big deal, but it takes...

14 September 2009 3 min read

Register for Simple Talk

Articles

.NET Reflector meets the CodeDom

Index Fragmentation Anxiety: a Doctor Speaks

Using Information Schema Views

Stephen Curtis Johnson: Geek of the Week

The Query Optimizer: Date Correlation Optimisation

Walter Bright: Geek of the Week

A Unified Approach to Multi-DataBase Query Templates

SQL Server Deep Dives

Finding Data Corruption

TechFest Houston Slides and Source Code

Cloning objects the quick and dirty way

Celko’s SQL Stumper: The Data Warehouse Problem

Hiring System Administrators

Implementing Cluster Replication – Part 1

Exchange 2010 High Availability

Downloading Software: the SQL Prompt 4 Experiment

Access Denied for "User Profile and My Sites" Links in an SSP

SQL Server Rootkits: Security Scare or Nightmare?

Causation, Correlation and Crackpots

VSeWSS 1.3 – Getting around the "Unable to load one or more of the requested types" Error