Commenting TSQL Scripts

If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even...

What Indexes are on My Table!

In this quick blog, I want to show you one way of how to find out what indexes you have on a table...

Indexes and their Effect on Query Performance

Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the...

Checking Users AD Groups Using Windows CMD

Blog Title: Checking Users AD Groups Using Windows CMD

Depending on your role in the organization, there may be a time...

Limiting Table Access for Reporting Part 2

Blog Title: Limiting Table Access for Reporting Part 2

In the first blog post of this series, I showed you how...

Limiting Table Access for Reporting Part 1

End users may have a need to do some form of reporting of data from source systems. Opening up the...

Introduction to Parallel Data Warehousing

What are we talking about?
Recently Microsoft released a new version of SQL Server 2008 R2 called Parallel Data Warehouse Edition....

The Dangers of Sub-queries!!!!

Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...

Sharing Remote Desktop Sessions

I work for a very large company where divisions are spread out literally all over the world. There are many...

SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai

Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...