Joe Celko

The DIS-Information Principle: A Splitting Headache

You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue...

17 August 2010 10 min read

Louis Davidson

Tim Ford

DMVs for Query Plan Metadata

Before you can tackle any performance issues with a working database, you need to know which queries to work on...

17 August 2010 57 min read

Damon Armstrong

Handling Hot Keys in a Windows Application

I’m mostly a web developer, but there are occasions when I find myself developing WinForm or WPF applications. On those...

16 August 2010 2 min read

Nick Harrison

jQuery Goodness in a DotNet World

jQuery is one of the most popular JavaScript frameworks. It shields the programmer from the idiosyncrasies in the way that...

12 August 2010 12 min read

Michael Sorens

Mixing WPF and WinForms

You can embed WPF controls in a WinForms application or WinForms controls in a WPF application, using a simple adapter....

10 August 2010 32 min read

Richard Morris

Grady Booch: Geek of the Week

Grady Booch is probably best known for being one of the original developers of the Unified Modelling Language (UML). He...

09 August 2010 13 min read

Jaap Wesselius

Exchange 2010 Online Move-Mailbox – Mailboxes Offline for only a few Seconds

Exchange Server 2010 has an online Move-Mailbox functionality, invoked by calling the New-MoveRequest cmdlet. By using it, the time a...

09 August 2010 3 min read

Phil Factor

Sherry Time, the neglected break

For once, Shakespeare put it fair and square. It is just like that… ‘A good sherris-sack hath a twofold operation...

06 August 2010 8 min read

Tony Davis

Virtue in the Virtual

Everyone knows the difference between a live SQL Server database file and a backup file. However, it seems that this...

06 August 2010 3 min read

Kathi Kellenberger

SSN Matching Speed Phreakery

On Ask.SQLServerCentral.com, a group of people interested in experimenting with heavily optimised SQL techniques try them out on a problem,...

05 August 2010 18 min read

Brad McGehee

Brad’s Sure Guide to SQL Virtual Restore

In the first of a series of in-depth software reviews, Brad investigates a newcomer, SQL Virtual Restore. What does it...

05 August 2010 34 min read

Mike Mooney

When Database Source Control Goes Bad

It is a question every development manager dreads; "So how does your company handle database changes?". The reply usually masks...

05 August 2010 25 min read

Greg Larsen

Creative Solutions by Using a Number Table

One irritating thing for the occasional SQL Server Developer is that the experts assume that you are familiar with the...

03 August 2010 16 min read

Richard Morris

Roy Fielding: Geek of the Week

Almost certainly, you use the results of Roy Fielding's work every day. After all, he was one of the principal...

02 August 2010 14 min read

Jonathan Allen

Breaking news: New technology means you can now "re-charge" batteries

I know, it sounds crazy doesn’t it? Up until now you buy a battery and put it in your game...

29 July 2010 2 min read

Simon Cooper

Introduction to open instance delegates

Creating a delegate to a method is normally quite a cheap operation. However, there are some reflection-based situations where you...

27 July 2010 4 min read

red@work

Living the high life at Red Gate

I think it was the moment when, 1500 metres above the fields of South Cambridge, sitting in the front cockpit...

26 July 2010 5 min read

Jonathan Allen

Seven times world champion returns to previous job

I am a keen follower of Formula 1 racing, it could be the speed, the danger, the money, the politics,...

26 July 2010 3 min read

Krishna Kumar

Increasing Email Size Limits for your High Profile Users in Exchange 2010

If you ever need to set up fine-grained rules to control the maximum size of messages a subset of your...

26 July 2010 14 min read

Andrew Clarke

WebMatrix and SQL Server Compact Edition. Something for the rest of us?

WebMatrix, currently in beta, is Microsoft’s newest initiative aimed at those of us who take no pleasure in using the...

23 July 2010 3 min read

Register for Simple Talk

Articles