SA no more!

Despite it being such an obvious security problem, developers still use the sa login, or assign sysadmin privileges to their...

28 October 2010 2 min read

Jonathan Allen

Looking for long term friendship

No, this isn’t some cheesy Singles column advert posted in the wrong place. I am seriously looking for some friends....

28 October 2010 4 min read

Robert Sheldon

Working with Window Functions in SQL Server

With SQL Server 2005, SQL Server introduced some of SQL's window functions, that apply, not to the full set, but...

28 October 2010 12 min read

Joe Celko

VALUES() and Long Parameter Lists – Part II

The use of the comma-separated list of parameters to a SQL routine, that Phil Factor calls the 'comedy-limited list, is...

28 October 2010 10 min read

Alex Kuznetsov

Defensive Error Handling

TRY...CATCH error handling in SQL Server has certain limitations and inconsistencies that will trap the unwary developer, used to the...

28 October 2010 35 min read

Roger Hart

Lorem ipsum, 18th century novels, and a new Red Gate website

I came across three things a while back that made me smile: Nation Shudders At Large Block Of Uninterrupted Text...

27 October 2010 5 min read

Holger Schmeling

SQL Server Statistics: Problems and Solutions

SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common...

27 October 2010 39 min read

Damon Armstrong

Using SharePoint 2010 as a DataSource: Presentation and Source Code from the Tyson Developer's Conference

I wanted to thank everyone who came out to my presentation. Below you will find the source code and the...

25 October 2010 1 min read

The .NET Team

The #1 Tip

The best IT articles and suggestions come from the grizzled front-line veterans, and the best grizzled front-line veterans are the...

21 October 2010 3 min read

Jaap Wesselius

Importing PSTs with PowerShell in Exchange 2010 SP1

Unless you use Red Gate's PST Importer, the import and export of PST files with Exchange 2010 is a complex...

21 October 2010 8 min read

Neil Hobson

Exchange 2010 DAG Creation and Configuration, Part 2

Now that you've created your first DAG in Exchange 2010, you'll need to be sure it's correctly configured for failovers...

20 October 2010 16 min read

Tony Davis

Best Practice and Judgement

Until the recent promise of generally-available broadband, the industry had to wrestle with the task of providing a solution to...

19 October 2010 3 min read

red@work

11 ways to celebrate a birthday

Another year flies by and Red Gate reaches the grand old age of 11. Here’s what we got up to...

18 October 2010 2 min read

Richard Morris

Kevan Riley: DBA of the Day

When the ASK.SQLServerCentral.com site started, something magical happened. A band of DBA and developer volunteers got together to ensure the...

18 October 2010 13 min read

Jonathan Allen

Dynamic Management Views (High Performance SQL Server)

(written by Louis Davidson (@DRSQL) and Tim Ford(@SQLAgentMan), published by Simple Talk Publishing 2010) Firstly, this is a review of...

14 October 2010 2 min read

Holger Schmeling

Queries, Damned Queries and Statistics

In a perfect world, we should just be able to write queries and leave the RDBMS to decide the perfect...

14 October 2010 43 min read

Corrin Lakeland

Snapper’s Sweet Source Control

Corrin Lakeland's busy role as a Data Manager includes supervising the work of all database development. Although he was already...

12 October 2010 6 min read

Fabiano Amorim

Showplan Operator of the Week – SORT

Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the...

11 October 2010 5 min read

Joe Celko

State Transition Constraints

Data Validation in a database is a lot more complex than seeing if a string parameter really is an integer....

08 October 2010 13 min read

Laila Lotfi

Orchard? No harvest quite yet.

Microsoft announced last week that it was scrapping its Windows Live Spaces blogging technology, and would make Automattic’s WordPress the...

07 October 2010 3 min read

Register for Simple Talk

Articles