Free SQL Performance Tool Worth Checking

First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur).  This is...

TOP WITH TIES

I have been working with SQL Server for quite a few years now, and it still happens quite often that...

Error when creating a subscription

When creating a subscription in SQL Server sometimes the following error will occur:
The remote server "%s" does not exist, or...

Hungarian Notation is misunderstood

Hungarian notation refers to a identifier naming convention.  The variable indicates the variables use – as opposed to what they are....

Capacity Planning – Monitor and Extrapolate

I wrote a post recently on capacity planning, and then thought of one more thing. In addition to planning for...

SQL Server 2012 (“Denali”): SSIS Logging

In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...

The Value of Twitter #meme15

Last week, I posted this month’s question for #meme15.  As was mentioned in that post, the aim of these posts...

Meme15 Twitter

Twitter and Your Career With the new blog party on the block, we have Jason Strate (blog | twitter) asking us this month these two questions: Why should average...

Meme15 Twitter

Twitter and Your Career

With the new blog party on the block, we have Jason Strate (blog | twitter) asking us this...

Introduction to XML DML (Part 1) - Using the modify() method: insert

This is the first part of a 3 part blog which will attempt to show some different ways of how...