I'm a Midnight DBA

Well, not really. However when I was recently up in Seattle, Jen and Sean McCown contacted me about being on...

Column Based Indexing in Denali

Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had...

XQuery for the Non-Expert – Exist

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts

In the...

What’s New In Denali for SSRS

I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...

2010 PASS Summit Recap

The 2010 PASS Summit has been over for a week and a half now and I've finally recovered & processed everything...

INDEX DEFRAGMENTATION SCRIPT

Advertisements 
INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005
I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me...

Roundup: Un-SQL #001 – Branding

Hi-ho all, and a wonderful Un-SQL event it’s been!  We had at least twenty-six entries!! First, the recap:
While T-SQL Tuesday...

Dynamic PowerShell

I learned something new while giving my PowerShell session at the PASS Community Summit a couple of weeks ago.

One astute...

Building A PowerShell Module Installer

As part of the 2.3 build of SQLPSX I built an MSI based installer to package all 10 SQLPSX modules....

SQL server basics for beginners

Advertisements 
In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.
SQL–Structured Query...