Virtualization for SQL Server DBAs – SQL Saturday Pre-Con Training

My next all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL Server DBAs” will be held on January 17th...

Welcome To 2014

A quiet and rainy day here in Orlando today. Not my favorite weather, but good for thinking, mostly about what...

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:
The Louvre Museum has 8.5 million...

Answer - Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)

Question :- 

How many non clustered indexes are possible in a table in SQL Server 2008R2

1)  1
2) 249
3) 999  (Correct answer)
4)...

Answer - Question of the Week - 28/12/2013 - Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...

Day 8 – Ring in The New

This is the eighth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

Day 8 – Ring in The New

This is the eighth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Final Giveaway And Some Stats

Today I'm honored to give the final prize in a month of free giveaways here, the book; Professional SQL Server 2012...

Goodbye, 2013

For me, 2013 was one of the most interesting and busy years of my life.  It was a good year...

Happy new year!

Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...