The Parallel Data Warehouse Edition of SQL Server 2008 R2 – TechEd 2010

It’s the million dollar question. Literally.
I stopped by the SQL Server area at TechEd in the expo to talk to...

T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2

T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2

This blog entry is participating in T-SQL Tuesday #007, hosted...

T-SQL Tuesday #007 - Policy Based Management

It's that time of the month again, time for the next round of T-SQL Tuesday posts. This month is being...

T-SQL Tuesday #7 - StreamInsight

The 7th T-SQL Tuesday is upon us and you can read about it on SQL Chicken’s blog. He’s hosting this...

T-SQL Tuesday #7: T-SQL Enhancements in SQL 2008.

In this edition of T-SQL Tuesday, Jorge Segarra (Blog | Twitter) asks us what our favorite new feature of SQL 2008...

Blogging at TechEd

I’ll be at TechEd on Monday/Tuesday. Not going to sessions as I don’t have the time to stay there all...

Cannot Connect to SQL Server

I recently installed a new SQL Server 2008 instance on a brand new Windows 2008 R2. When I tried to...

Daily SQL Server 2008 New Feature – Day 17

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...

Defensive Database Programming Chapter 01

Today I am finally getting around to the review of the first chapter as promised.  I talked about the book...

Get Index Details

We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One...