Louis Davidson

What Counts For a DBA: Fitness

If you know me, you can probably guess that physical exercise is not really my thing. There was a time...

09 November 2012 5 min read

Chris George

“It’s only test code…”

“Let me hack this in, it’s only test code”, “Don’t worry about getting it reviewed, it’s only test code”, “It...

09 November 2012 5 min read

Phil Factor

When things go awry

The moment the Entrepreneur opened his mouth on prime-time national TV, spelled out the URL and waxed big on how...

09 November 2012 3 min read

Michael Williamson

Red Gate Coder interviews: Robin Hellen

Robin Hellen is a test engineer here at Red Gate, and is also the latest coder I’ve interviewed. We chatted...

08 November 2012 18 min read

Louis Davidson

PASS Precon Countdown… See some of you Monday, and others on Tuesday Night

As I finish up the plans for Monday’s database design precon, I am getting pretty excited for the day. This...

02 November 2012 3 min read

Tony Davis

So it comes to PASS…

How does your company gauge the benefit of attending a technical conference? What’s the best change you made as a...

02 November 2012 2 min read

Joe Sack

Fixing Gatekeeper Row Cardinality Estimate Issues

The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator...

01 November 2012 18 min read

William Brewer

Database Deployment Cribsheet

As part of our long-running Cribsheet series, we asked William to write a guide to deployment that described in general...

29 October 2012 14 min read

Tom Fischer

View-Models with Flags in WPF

Enums in .NET are strongly-typed constants that allow you to share a multi-valued property across applications. When used in a...

29 October 2012 9 min read

Grant Fritchey

Hosted Monitoring

The concept of using services to take the place of writing a lot of your own code goes way, way...

25 October 2012 3 min read

Patrick Barel

Edition Based Redefinition – Part 1

One of the ‘killer’ features of the Oracle Database version 11g Release 2 is probably Edition Based Redefinition. This functionality...

25 October 2012 7 min read

Michael Williamson

Lightning talk: Michael Williamson – Simple isn’t easy, or how to design the electrical mains in your house

If you’ve ever wanted to see me take an excellent article on why electrical plugs should have three prongs and...

24 October 2012 1 min read

Edward Charbeneau

Writing Custom HTML Helpers for ASP.NET MVC

Switching from developing ASP.NET WebForms to MVC might seem awkward at first, but Ed demonstrates why the change needn't be...

24 October 2012 17 min read

Red and the Community

That's a wrap! Almost, there's still one last chance to attend a SQL in the City event in 2012

The communities team are back from the SQL in the City multi-city US Tour and we are delighted to have...

23 October 2012 2 min read

Richard Morris

Jeffrey Snover: Geek of the Week

PowerShell has radically improved the ease of monitoring and adminstering Windows-based servers, and automating routine processes. The visionary leader of...

23 October 2012 10 min read

Seth Delconte

Manipulating XML Data in SQL Server

When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from...

23 October 2012 14 min read

Annette Allen

SSIS Basics: Using the Execute SQL Task to Generate Result Sets

The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning...

23 October 2012 14 min read

Dmitri Korotkevitch

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable,...

23 October 2012 20 min read

Roger Hart

Another Marketing Conference, part two – the afternoon

In my previous post, I’ve covered the morning sessions at AMC2012. Here’s the rest of the write-up. I’ve skipped Charles...

22 October 2012 7 min read

Book Discussion

Brad McGehee in Book Discussion

Book Review: Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and Ted Kreuger

Experienced DBAs have a wealth of experience to rely on when it's time to troubleshoot a problem, but it can...

22 October 2012 11 min read

Register for Simple Talk

Articles