Sunday, December 31, 2006

The Road to Hell By Chris Rea Or Highway to Hell By AC/DC

›
So here is my last goofy post of the year, I will have some posts that have at least something to do with SQL and databases from tomorrow on...
1 comment:
Friday, December 29, 2006

SQL Server 2005 SP2 Backup With Vardecimal Enabled Can't Be Restored On SQL Server 2005 SP1 or Earlier

›
SQL Server 2005 SP2 introduces the Vardecimal storage format. The Vardecimal storage format is a new storage format to store decimal/numeric...
Thursday, December 28, 2006

Guess Who Gave This Answer In A Newsgroup?

›
Try to guess who gave this answer. Here is a small hint, the person looks like Anton Szandor LaVey Question : I guess the key question for m...
3 comments:
Wednesday, December 27, 2006

Sweet Child O' Mine By Guns N' Roses Or Child in Time By Deep Purple?

›
Yesterday we talked about Whole Lotta Love and whole Lotta Rosie today we are talking about Sweet Child O' Mine and Child In Time. So wh...
1 comment:
Tuesday, December 26, 2006

sys.dm_db_session_space_usage

›
Okay so today we will talk about the sys.dm_db_session_space_usage dynamic management view. This is the third dynamic management view that I...

Whole Lotta Rosie By AC/DC or Whole Lotta Love By Led Zeppelin?

›
I got a new MP3 player from my sister in law for Christmas and have been listening to some good old R & R So the question is which of th...
6 comments:
Thursday, December 21, 2006

Display 1 When Any Column Is 1 And 0 Otherwise by Using SIGN, SUM Or (Bitwise OR)

›
You have three columns; if any of the columns is 1 you want to display 1 if they are all 0 you want to display 0. how can you do that? there...
1 comment:
Wednesday, December 20, 2006

SQL Server 2005 Will Be Supported On Vista And Windows Server Longhorn

›
Don't get scared of those people at Badvista.org Microsoft announced on September 27, 2006 that SQL Server 2005 would be supported on V...

SQL Server 2005 Service Pack 2 - Community Technology Preview (CTP) December 2006 Available For Download

›
That's right it's here. Download it now and play around with vardecimal and custom reports for Management Studio http://www.microsof...
Tuesday, December 19, 2006

How Well Do You Interview And Do You Use Wizard Driven Programming?

›
We were interviewing people for developer and architect positions. The developer position required about 5 years C# and SQL Server. We got a...
4 comments:
Sunday, December 17, 2006

BadVista: The Worst FUD You Will Ever Read.... St. Ignucious Has Gone Wild

›
Richard Stallman (RMS, St. I gnu cious ) is at it again. let's see what the site says: The Free Software Foundation (FSF) today launched...
2 comments:
Friday, December 15, 2006

Three Ways To Display Two Counts From a Table Side By Side

›
This question came up on tek-tips. I want to count the CA and the UT states from the authors table and output this in different columns name...
8 comments:

Visual Studio 2005 Service Pack 1 (SP1) Released

›
Visual Studio 2005 Service Pack 1 (SP1) has been released. From the site: Service Pack 1 addresses issues that were found through a combinat...
Wednesday, December 13, 2006

Index Build Strategy In SQL Server

›
The Tips, Tricks, and Advice from the SQL Server Query Processing Team blog has 3 really good posts about Index Build strategy in SQL Serve...

Problems With ROW_NUMBER() In A WHERE Clause

›
This is a question that came up today. A person had a query like this USE AdventureWorks GO SELECT ROW_NUMBER() OVER ( ORDER BY addressli...
Tuesday, December 12, 2006

SQL Server 2005 Practical Troubleshooting: The Database Engine Is Shipping!

›
Amazon is shipping SQL Server 2005 Practical Troubleshooting: The Database Engine . This is a must have for all SQL developers who run into ...

Visual Studio Team Edition for Database Professionals links

›
By now you know that Visual Studio Team Edition for Database Professionals has been released. But do you know all the links to the newsgroup...
Sunday, December 10, 2006

Wedding Anniversary

›
So here we are 9 years later. We are still married have 3 kids and bought our second home this year. So let me give you a little background ...
8 comments:
Friday, December 08, 2006

Plan For The Day…Gone Wrong In a Big Way

›
It is my 9th year wedding anniversary this weekend so I took the day off today and below is a list of things I planned to do today [ ] Get a...
Thursday, December 07, 2006

Get The Domain Name Of Your SQL Server Machine

›
How do you get the domain name that your SQL Server machine belongs to with T-SQL code? You can use the undocumented procedure xp_regread; I...