Simon Peyton Jones: Geek of the Week

Simon Peyton Jones is a Principal Researcher at Microsoft Research's lab in Cambridge. Although he is best known as the...

13 November 2009 11 min read

Roger Hart

Throwing a Windows 7 launch party – stealth user assistance?

Ironic or unironic, the Windows 7 launch party video has been roundly mocked, for smugness, sentimentality, pageant diversity, and the...

12 November 2009 4 min read

Robert Sheldon

Managing Transaction Logs in SQL Server

The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed...

12 November 2009 17 min read

Phil Factor

Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block

In which Phil is asked to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do...

12 November 2009 17 min read

Grant Fritchey

Controlling Execution Plans with Hints

The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best...

12 November 2009 38 min read

Bob Cramblitt

Exceptional DBA Josef Richberg: fighting cancer, but still sharing

Josef Richberg is an exceptional person: The Judges of the Exceptional DBA Award were quickly proved right in their decision...

10 November 2009 6 min read

Louis Davidson

Quest DMV Breakfast Code – Disk IO

For any of you who attended the Quest breakfast at PASS (and anyone else really) I wanted to go ahead...

04 November 2009 6 min read

Paul Glavich

Understanding Performance Profiling Targets

In this sample chapter from his upcoming book, Paul Glavich explains performance metrics and walks us through the steps needed...

04 November 2009 21 min read

red@work

Something Spooky at Red Gate

It’s not unusual to be sitting at your desk at Red Gate and hear a cheer erupt from a post-lunch...

30 October 2009 2 min read

Richard Morris

Interview with the Scary DBA – Grant Fritchey

For our first feature on working DBAs and their lives, we chose Grant Fritchey, the self-styled Scary DBA, who has been...

30 October 2009 12 min read

Louis Davidson

Prepping for PASS (apparently it is next week)

Mercy, PASS is going to be a busy week for me. My basic schedule is: Sunday: Arrive just after 4...

29 October 2009 3 min read

Tony Davis

SQL Server Sheep Ticks

The doggedness with which certain SQL Server “myths” cling to the coat of the SQL Server community is really quite...

28 October 2009 3 min read

Richard Morris

Tucker Taft: Geek of the Week

What do military networks and a 19th Century Difference Engine have in common? Tucker Taft; industry leader in compiler construction...

28 October 2009 15 min read

Louis Davidson

Seventh pillar – Encapsulated

The final numbered post in this version of my “pillar” series of posts ends in the most contestable part of...

23 October 2009 6 min read

Michael Sorens

How to build a Query Template Explorer

Having introduced his cross-platform Query Template solution, Michael now gives us the technical details on how to integrate his .NET...

23 October 2009 15 min read

Michael Francis

Virtual disks for the flop-buster

Vista Service Pack 3, as we like to call Windows 7, is worth getting if you are stuck with Vista. ...

22 October 2009 3 min read

red@work

Marketing Day Out

Imagine waking up with the knowledge that the day ahead will be one to remember, but not being entirely sure...

22 October 2009 6 min read

Matt Simmons

The Ego and the System Administrator

Because the Sys Admins and DBAs who are efficient end up wielding a great deal of power, there is always...

22 October 2009 5 min read

Jaap Wesselius

Introduction to Exchange Server 2010

What's new in Exchange Server 2010 and what features from Exchange Server 2007 have been deprecated? What has been done...

22 October 2009 32 min read

Nirmal Sharma

Increasing the Availability of Virtualised Applications and Services

By using a virtualized clustering computing environment with failover, you can improve server availability without using as many physical computers....

22 October 2009 23 min read

Register for Simple Talk

Articles

Simon Peyton Jones: Geek of the Week

Throwing a Windows 7 launch party – stealth user assistance?

Managing Transaction Logs in SQL Server

Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block

Controlling Execution Plans with Hints

Exceptional DBA Josef Richberg: fighting cancer, but still sharing

Quest DMV Breakfast Code – Disk IO

Understanding Performance Profiling Targets

Something Spooky at Red Gate

Interview with the Scary DBA – Grant Fritchey

Prepping for PASS (apparently it is next week)

SQL Server Sheep Ticks

Tucker Taft: Geek of the Week

Seventh pillar – Encapsulated

How to build a Query Template Explorer

Virtual disks for the flop-buster

Marketing Day Out

The Ego and the System Administrator

Introduction to Exchange Server 2010

Increasing the Availability of Virtualised Applications and Services