DevOps: Nostrums or Knowledge?

There are good reasons for the management of the release of applications. Businesses see it as a safety-net to ensure...

16 August 2011 3 min read

Richard Mitchell

Save hours-get a command prompt

Recently somebody showed me a little trick to get a command prompt in any directory. Simply hold down SHIFT whilst...

15 August 2011 1 min read

PowerShell

Sean Duffy in PowerShell

Disk Space Monitoring and Early Warning with PowerShell

Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to...

15 August 2011 11 min read

Grant Fritchey

Preventing Problems in SQL Server

It is never a good idea to let your users be the ones to tell you of database server outages....

15 August 2011 9 min read

Louis Davidson

What Counts For A DBA: Blindness

Anyone who remembers the rock opera Tommy might have guessed that this blog will describe my forthcoming rock opera about...

12 August 2011 6 min read

John Spears

Introducing: SQL Tab Magic

Yesterday I wrote about Down Tools Week and trying to build a working product in 5 days. I also released...

11 August 2011 1 min read

Phil Factor

Making HTML tables easier on the eye- CSS Structural Pseudo-classes

We asked Phil why his PowerShell tabular reports looked so nice. 'CSS structural pseudo-classes' he muttered mystically. Later on, without...

11 August 2011 22 min read

Chris Farrell

The Top 5 WPF and Silverlight Gotchas

As WPF and Silverlight sit on the .NET framework, they're subject to the rules of the Garbage Collector. That means...

10 August 2011 13 min read

Phil Factor

SQL Programmer’s workshop

Phil Factor records, as closely as possible, the twists and turns of creating a SQL Server T-SQL stored procedure, describing...

05 August 2011 26 min read

James Moore

A trip back to the sharp end

On 1st August, James Moore, head of the team at Red Gate who brought to the world the likes of...

04 August 2011 3 min read

Benjamin Nevarez

The SQL Server Query Optimizer

To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the...

03 August 2011 35 min read

Damon Armstrong

How to Check if a Binary File Has Been Updated in an SPItemEventReceiver

I’ve been dealing with a number of item event receivers in SharePoint and I ran across the need to figure...

02 August 2011 2 min read

General

Wesley David in General

High Availability or High Recoverability?

Having pierced the veil of confusion surrounding High Availability, Wesley David finds himself asked (and being asked) whether HA is...

01 August 2011 20 min read

Ben Challenor

Learning to Xcode: thoughts of a C# developer

Here at Red Gate we’ve been running a “New Business” division for a while. The goal of New Business is...

27 July 2011 8 min read

red@work

SQL in the City London

Last Friday I was made to wake up obscenely early, which is something that I generally avoid. On this occasion,...

27 July 2011 3 min read

Clive Tong

The Top 5 .NET Memory Management Misconceptions

.NET Memory management is an impressive and comprehensive system, but it's not flawless, and it's occasionally a little anti-intuitive. As...

27 July 2011 26 min read

Database Administration

Laerte Junior in Database Administration

Using PowerShell and WMI Events Queries for Powerful Notifications

With PowerShell in one hand, and WMI in the other, DBAs can do almost anything in their Window's environments, and...

25 July 2011 11 min read

BI

Robert Sheldon in BI

Adding the Script Task to Your SSIS Packages

Script tasks are a great way of extending SSIS functionality, when the buit-in functionality isn't quite Script tasks are a...

21 July 2011 19 min read

T-SQL Programming

Solomon Rutzky in T-SQL Programming

CLR Performance Testing

Are Common Language Runtime routines in SQL Server faster or slower than the equivalent TSQL code? How would you go...