Understanding the concept of SQL Server Failover Cluster

Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...

A Quick Introduction to Data Compression in SQL Server 2008

There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups...

Command Prompt connectivity –U option

When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...

DBA supertech . Specialise or generalise?

Specialise or a generalise?  It all depends on how you define these terms. 
A  SQL Server DBA may be considered to...

Houston Area SQL Server User Group Presentation

Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL...

Parsing T-SQL – The easy way

UPDATE 2012-09-12 : For my latest adventures with TSQL Parsers please see this post
Every once in a while, I hit an issue...

SQL Server 2012 Books

SQL Server 2012 was released to manufacturing last week, you can download it from MSDN if you have subscription or...

Synchronizing subscriptions in SQL Server Express

I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a...

T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It

If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
 
Being a specialist means you're...

T-SQL Tuesday #028 – Is it really specialization?

This is the first time I've participated in T-SQL Tuesday - I hope to do so more often...

I can recall several...