Jan 26 2010
Tonight is the first meeting of our reboot of the WMSSUG. The information is listed below. Hope you can attend! We will have an audio line on reserve if we see that the computer-based audio is dragging down performance on the presentation. I’d like to thank Blue Granite for offering to host the event and [...]
Dec 28 2009
The next round of SQL Saturdays is rapidly approaching: Tampa on 1/23/2010 followed by Boston and Richmond on 1/30/2010. I received notification that two of my sessions were accepted so now comes the time when I need to get back into the swing of all-things-SQL and switch out of Holiday Mode to get some things [...]
Nov 23 2009
I really don’t know why it took me so long to embrace the use of templates in SQL Server Management Studio. Really, they’re right there in plain sight. They even have their own Explorer for cryin’ out loud! Even the DMVs don’t have that and look how much press they get! Unless one of the templates [...]
Nov 16 2009
It’s been a week now since the 2009 PASS Community Summit ended. The last of us filed out of Seattle on Monday and here it is, Monday all over again. So did you implement anything you learned at the Summit yet? All those fresh ideas in your head are starting to get swept out by those [...]
Nov 12 2009
(…put down Cleveland) I’d like to thank Jeremiah Peschka (twitter | web) for inviting me to speak at the Columbus SQL Server Users Group November meeting tonight. Through technical difficulties with Live Meeting (their end) and the oncoming symptoms of the flu (my end) I think it went off pretty well. The slide deck and queries [...]
Oct 8 2009
I’ll be in Richmond, VA tonight to present the discussion: DMOs, DMVs, DMFs… WTH? For the Richmond, VA SQL Server Users Group. Should be a good time. Slide deck will be up on the site at some point in the next couple days. Please look under Presentations on this site for all slide decks related [...]
Sep 18 2009
I’m pimping out… my laptop that is, but I need your help. Lando can only do so much!
Sep 11 2009
You would expect that a unique combination of database_id, object_id, index_id, and partition_number would be returned when calling sys.dm_db_index_operational_stats. Sometimes it does and sometimes it does not. SQL Server should not be a “sometimes” environment.
