SQL SERVER Replication – Troubleshooting Steps for Beginners

Few days back there was a replication issue in one of the QA servers. Since the DBA was out of...

Backup script skipping databases – and the fix!

A real head-scratcher
I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost....

Stress Thoughts–Part 1

If I had to tell you that one thing I’ve gotten better at in the past 5 years it would...

Execution Plan for a User Defined Function

When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:

It appears as...

SQLSAT107

I was recently selected to speak at SQL Saturday 107 in Houston TX.  I am really excited to be selected...

Slides & Samples from my SQLSaturday #105 presentation about Advanced SQL Server Troubleshooting

As I have announced in my session last Saturday in Dublin, you can find here the
slides & samples for download.

Thanks...

Building the Enterprise DW/BI System with SQL Server PDW

Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse...

Start Building Your Next Network

Take a look at your network right now and while it probably has some diversity, I bet it’s tied pretty...

Google Research

Interesting to see someone talking about all the research Google is spending money on, which aren’t directly related to their...

Trim Functions in SSIS

In T-SQL there are many functions there to help do a variety of different things.  SSIS is no different.  In...