Robert Sheldon

Transact-SQL Formatting Standards (Coding Styles)

How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How...

25 August 2009 25 min read

Joe Celko

Getting rid of SQL Code

Joe becomes intrigued by the way that experts make errors in any area of technology, and suggests that the problem...

20 August 2009 13 min read

Roger Hart

Continuous Integration with SQL Toolbelt

Sometimes, you wish you had a tool to run a software development process exactly the way you need it to...

23 July 2009 17 min read

Richard Morris

Niklaus Wirth: Geek of the Week

It is difficult to begin to estimate the huge extent of the contribution that Niklaus Wirth has made to IT...

02 July 2009 11 min read

Phil Factor

The Book ‘Confessions of an IT Manager’

For three and a half years, the 'Confessions of an IT Manager', by Phil Factor, have been a distinctive part...

27 May 2009 7 min read

Gail Shaw

SQL Server Performance Investigation Part 2: Execution Plan Analysis, Index Design, and Post-Implementation Measurement

Part 2 of a SQL Server performance investigation: examining the execution plans of the worst-offending procedures identified in Part 1,...

03 April 2009 29 min read

Brien Posey

An Introduction to Unified Messaging

For many years, everyone involved in the administration of offices has wished that there was a way of combining the...

26 March 2009 15 min read

Richard Morris

Simon Sabin Says SQLBits

SQLBits is the largest SQL Server conference in Europe. Because it is held on a Saturday, and is free, it...

03 March 2009 9 min read

Bill Holmberg

Change Management- What It Is and Why You Need It

Bill Holmberg takes a practical look at Change Management, and list the steps you need to take. To make things...

02 March 2009 12 min read

Phil Factor

Phrenetic Phil and the SQL Shootout

Phil Factor turns to burlesque in order to reinforce his point that an ability to answer SQL Technical questions isn't...

03 February 2009 7 min read

Amirthalingam Prasanna

Some Data with your Application Take-away, Sir?

Prasanna is reminded of pizza in cardboard boxes when he explores the possibilities of Synchronization Services for ADO.NET. Data applications...

09 December 2008 9 min read

Joe Celko

Unique Experiences!

You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause...

18 November 2008 14 min read

Robert Sheldon

SQL Server Data Warehouse Cribsheet

It is time to shed light on Data Warehousing and to explain how SSAS, SSRS and Business Intelligence fit into...

03 November 2008 21 min read

Andrew Clarke

.NET Reflector: Soup to Nuts

.NET Reflector is almost an intrinsic part of the .NET Framework, a free tool for browsing the contents of a...

22 October 2008 15 min read

Ben Lye

Reporting on Mobile Device Activity Using Exchange 2007 ActiveSync Logs

In this new column giving practical advice on all things Sys Admin related, Ben Lye takes on the often difficult...

10 October 2008 6 min read

Vladimir Bodurov

Dynamically generating typed objects in .NET

When you are binding Data to DataGrid in .NET, this has to be done at design-time. That's fine if you...

14 July 2008 17 min read

Neil Hobson

High Availability in Exchange 2007

Neil Hobson writes about the ways that MS Exchange 2007 can ensure that your organisations messaging remains available. He looks...

10 June 2008 17 min read

John Papa

Data and Silverlight 2: Data Binding

Silverlight 2 is far more versatile than Silverlight 1. It can handle data-sources with some subtlety. John Papa tackles the...

05 June 2008 12 min read

Richard Morris

The Burning Men – The IT drug habit

It would seem bizzare that IT staff who depend on their quick wits for their living should ever think it...

29 April 2008 10 min read

Hugh Bin-Haad

The Concept of Cardinal Reciprocity- A Primer

Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a...

01 April 2008 12 min read

Register for Simple Talk

BI

Transact-SQL Formatting Standards (Coding Styles)

Getting rid of SQL Code

Continuous Integration with SQL Toolbelt

Niklaus Wirth: Geek of the Week

The Book ‘Confessions of an IT Manager’

SQL Server Performance Investigation Part 2: Execution Plan Analysis, Index Design, and Post-Implementation Measurement

An Introduction to Unified Messaging

Simon Sabin Says SQLBits

Change Management- What It Is and Why You Need It

Phrenetic Phil and the SQL Shootout

Some Data with your Application Take-away, Sir?

Unique Experiences!

SQL Server Data Warehouse Cribsheet

.NET Reflector: Soup to Nuts

Reporting on Mobile Device Activity Using Exchange 2007 ActiveSync Logs

Dynamically generating typed objects in .NET

High Availability in Exchange 2007

Data and Silverlight 2: Data Binding

The Burning Men – The IT drug habit

The Concept of Cardinal Reciprocity- A Primer