Buck Woody put together a list of resources for the exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance. This is a good list of resources for those looking to take the exam and I do recommend that people do take the exam. With the economy as it is, it’s good to build up [...]
Monthly Archives: February 2009
Monitoring Index Contention With DMFs
Often when I am load testing an application with a client I want to check to see if there is any index contention in a database. To do this, I use the DMF sys.dm_db_index_operational_stats. For a good rundown on this DMF, I recommend reading Louis Davidson’s blog entry on sys.dm_db_index_operational_stats. Instead of repeating that content, [...]
Never Tell Them The Odds… (OT)
I’ve been waiting a long time for the movie Fanboys to hit theaters and it has finally come. The first time I saw a preview for this movie was more than three years ago. Throughout all of the delays, I’ve been waiting patiently to see it. Starwars blog posted an announcement today that three theaters [...]
SQL Server 2008 Service Pack 1 CTP
The SQL Server team released SQL Server 2008 Service Pack 1 CTP last night. Not too long now and the argument to “wait until the first Service Pack 1 to upgrade” will be dead. I will enjoy when those discussions are over. If you’d like to hear more about upgrading, check out the SSWUG Ultimate [...]
Reasons to Attend SSWUG’s Ultimate vConference
I’m speaking at the upcoming SSWUG Ultimate vConference and thought I’d share some reasons to attend the upcoming conference that I got in an e-mail today… "6 Reasons to Attend SSWUG’s Ultimate vConference This Spring" (Second round early-bird discounts end on March 1st – Register Now and Save $45!) No planes, no trains and definitely [...]
Big Tempdb Table
This won’t be the most exciting post. But hey, it’s Monday! What’s exciting about that? Maybe someone will bring in donuts. Or maybe I should since I am still on my couch and not headed to the office yet. Anyways, every now and then I need a big table to test some code out on [...]
My First Computer and Favorite Old Games (OT)
Continuing this thread, I was tagged by Rob Boek to post about my first computer and and favorite games. The first computer that I had access to was a Commodore 64 that my dad purchased when I was probably about 10 years old. That thing was awesome! We had it all — the monitor, keyboard, [...]
Learning SharePoint Day 1
It’s become necessary for me to dig into SharePoint a bit. I’m a huge newbie here so I figure I’ll share all of the links for things I look up in these SharePointy travels. I expect some of these posts will be very trivial but “hey, I’m learning.” I had two goals today with the [...]
Certification Skills Week
Microsoft is hosting a week long certification event coming up from March 9-13. There will be some deep discounts (40%!) on certification exams and discounts on training. You can also win a Zune and other prizes at these events – who doesn’t like free stuff. The Minnesota certification event will be at New Horizons of [...]
Rounding Up to the Nearest 1,000
A co-worker came over and asked how to round up to the nearest 1,000. He tried to use ROUND but found that it always split between going up or going down depending on the value and the report he was working on always had to round up. Almost before he finished asking, actually before he [...]
_1262.png)
