Buck Woody

Mission Critical: SQL Server 2008 Engine Post-Installation

Even an experienced DBA finds it safer to double-check that all the tasks have been done, and in the right...

03 March 2010 3 min read

Richard Morris

Rich Hickey: Geek of the Week

With Clojure soon to be ported to the .NET framework, as ClojureCLR, we felt that the time had come to...

02 March 2010 8 min read

Robert Sheldon

Adding a KPI to an SQL Server Analysis Services Cube

Key Performance Indicators, which vary according to the application, are widely used as a measure of the performance of parts...

02 March 2010 14 min read

Phil Factor

Exploring your database schema with SQL

In the second part of Phil's series of articles on finding stuff (such as objects, scripts, entities, metadata) in SQL...

02 March 2010 23 min read

Laila Lotfi

Back-sliding into Unmanaged Code

It is difficult to write about Microsoft’s ambivalence to .NET without mentioning clichés about dog food. In case you’ve been...

26 February 2010 3 min read

Nick Harrison

Reflector Pro Cometh

Reflector 6 is here. Nick Harrison is a long-time Reflector enthusiast, and has been responsible for writing an add-in. As...

25 February 2010 9 min read

Jonathan Lewis

Designing Efficient SQL: A Visual Approach

Sometimes, it is a great idea to push away the keyboard when tackling the problems of an ill-performing, complex, query,...

25 February 2010 16 min read

Bart Read

.NET Reflector & .NET Reflector Pro 6.1 have been released

.NET Reflector 6.1 and .NET Reflector Pro 6.1 have been released. You can download them from: http://www.red-gate.com/products/reflector/index.htm .NET Reflector is...

24 February 2010 2 min read

James Johnson

Hands-on Entity Framework

People keep saying that Entity Framework is simple to learn. Simple? Well, finally, we're going to be forced to agree,...

23 February 2010 11 min read

Alex Kuznetsov

Defensive Database Programming

Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL...

22 February 2010 3 min read

Louis Davidson

Rocky Mountain Tech Trifeca next Saturday, and I will be there with no bells on (I promise)

Is the world ready for a Louis Davidson keynote address? Luckily the entire world won’t have to find this out,...

19 February 2010 2 min read

Roger Hart

Kill a tree, save your website? Content strategy in action, part III

A lot has been written about how driving content strategy from within an organisation is hard. And that’s true. Red...

19 February 2010 4 min read

red@work

Finance: Friends, not foes!

After reading Phil’s blog post about his experiences of working on reception, I thought I would let everyone in on...

19 February 2010 3 min read

Andrew Clarke

Who Tests the Tester?

It is scarcely surprising that it can take up to five years to release a new version of SQL Server...

19 February 2010 15 min read

Tony Davis

Inappropriate Updates?

A recent Simple-talk article by Kathi Kellenberger dissected the fastest SQL solution, submitted by Peter Larsson as part of Phil...

18 February 2010 4 min read

Alex Davies

Why not to use StackTrace to find what method called you

Our obfuscator, SmartAssembly, does some pretty crazy reflection. It’s an obfuscator, it’s sort of its job to do things in...

18 February 2010 1 min read

Carl Niedner

ANTS Profiler Saves Me From A Sordid Fate

A bit of string concatenation never hurt anybody, right? Think again. Carl Niedner has been designing software since 1983, and...

18 February 2010 5 min read

Richard Morris

Bruce Schneier: Geek of the Week

If one were to close one's eyes and imagine a BT Executive, one would never conjure up Bruce Schneier. He...

16 February 2010 12 min read

Joe Celko

Procedural, Semi-Procedural and Declarative Programming in SQL

A lot of the time, the key to making SQL databases perform well is to take a break from the...

15 February 2010 10 min read