Louis Davidson

Some date math fun

Note: This concept presented is pretty simple and I am not claiming that I am the first to do this…...

09 February 2011 7 min read

Michael Sorens

Web Testing with Selenium Sushi: A Practical Guide and Toolset

How does one test the user-interface of a web application? Too often, the answer seems to be 'clumsily, slowly, and...

09 February 2011 35 min read

Jaap Wesselius

SMTP Routing Changed in an Exchange Database Availability Group

In Exchange Server 2010 it is possible to make the system more resilient by creating a Database Availability Group (DAG)...

03 February 2011 3 min read

Joe Celko

Look-up Tables in SQL

Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a...

01 February 2011 18 min read

Jeremy Jarrell

Hitting the Ground Running with Parallel Extensions in .NET 4.0

With the arrival of Parallel Extensions in .NET 4.0, the concurrent programming powers traditional reserved for the most elite of...

01 February 2011 13 min read

Nick Harrison

Database Refactoring

Although the methodology of refactoring code has been adopted enthusiastically, the same has not really been the case with databases....

01 February 2011 17 min read

Jonathan Allen

My wife has left me . . .

LiveJournal Tags: Leaving,Colleagues She announced it before Christmas, in a letter, giving the exact day she intended to leave and...

31 January 2011 2 min read

Robert Sheldon

Bulk Inserts via TSQL in SQL Server

The trouble with using BCP for reading data into SQL Server is that BCP is a command-line program. Fortunately, the...

31 January 2011 20 min read

Louis Davidson

Chapter One – Concepts/Requirements (The Fundamentals)

So here we are, the starting chapter with the obligatory introductory material that I hope people will read, digest, memorize...

28 January 2011 3 min read

Simon Cooper

Subterranean IL: Compiling C# exception handlers

An exception handler in C# combines the IL catch and finally exception handling clauses into a single try statement: How...

25 January 2011 4 min read

Louis Davidson

What Counts for a DBA: Passion

One of my first questions, when interviewing for a DBA/Programmer position, is always: “Why do you want this job?” The...

20 January 2011 3 min read

Feodor Georgiev

Collecting Performance Data into a SQL Server Table

Occasionally, when tracking down a performance problem, you have to have information over time on the values of particular sets...

20 January 2011 12 min read

Robbie Th'ng

What’s on Azure right now?

If you speak to Microsoft, they’ll give you a number of active accounts, but what are those accounts actually running?...

18 January 2011 2 min read

Damon Armstrong

Obscure SPUtility.SendMail Behavior When Manually Passing in Mail Headers

There are two ways to send mail in SharePoint: you can either use the mail components from the System.Net namespace,...

17 January 2011 2 min read

Laila Lotfi

Automated Error Reporting = More Robust Software

I would like to tell you how to revolutionize your software development process </marketing hyperbole> On a more serious note,...

17 January 2011 4 min read

Simon Cooper

Subterranean IL: Exception handling control flow

Control flow in and around exception handlers is tightly controlled, due to the various ways the handler blocks can be...

17 January 2011 3 min read

Jonathan Allen

Resolving IIS7 HTTP Error 500.19 – Internal Server Error

LiveJournal Tags: RedGate Tools,SQL Server,Tips and Tricks How To The requested page cannot be accessed because the related configuration data...

17 January 2011 2 min read

Richard Morris

Rob Pike: Geek of the Week

Rob Pike's contribution to Information Technology has been profound, both through the famous books he co-authored with Brian Kernighan, and...

17 January 2011 14 min read

Robert Chipperfield

Accessing SQL Server data from iOS apps

Almost all mobile apps need access to external data to be valuable. With a huge amount of existing business data...

14 January 2011 3 min read

Tools

Phil Factor in Tools

RegEx-Based Finding and Replacing of Text in SSMS

So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that would be much...

14 January 2011 19 min read

Register for Simple Talk

Articles

Some date math fun

Web Testing with Selenium Sushi: A Practical Guide and Toolset

SMTP Routing Changed in an Exchange Database Availability Group

Look-up Tables in SQL

Hitting the Ground Running with Parallel Extensions in .NET 4.0

Database Refactoring

My wife has left me . . .

Bulk Inserts via TSQL in SQL Server

Chapter One – Concepts/Requirements (The Fundamentals)

Subterranean IL: Compiling C# exception handlers

What Counts for a DBA: Passion

Collecting Performance Data into a SQL Server Table

What’s on Azure right now?

Obscure SPUtility.SendMail Behavior When Manually Passing in Mail Headers

Automated Error Reporting = More Robust Software

Subterranean IL: Exception handling control flow

Resolving IIS7 HTTP Error 500.19 – Internal Server Error

Rob Pike: Geek of the Week

Accessing SQL Server data from iOS apps

RegEx-Based Finding and Replacing of Text in SSMS