Well... I think I had had too much tea that morning ;-). But, as always, chatting with Richard and Greg was great. Here's the specific show link: http://www.runasradio.com/default.aspx?showNum=76. Oh, and just for the record, I didn't come up with that title. But, I do hope that all your [high-priority and important] ...

OK, I know this post doesn't really apply to most folks but I did want to have the setup instructions on my blog so that I could refer people to it. For the August release we updated all 17 labs and all of the demos for SQL Server 2008 RTM; however, we did use a ''security enabled'' VPC. And, well, security is bugging people right about ...

I first posted an update to sp_helpindex here. My version of sp_helpindex was solely to expand what sp_helpindex showed and adds 1 or 2 things based on version: for SQL2005+ it adds included columns and for SQL2008 it also adds the filter predicate. So, there were two versions of sp_helpindex2 depending on which verison ...

I started this post while Paul and I were in the TechEd Bloggers Lounge... which, from the number of folks ''stopping by'' must be more of an online thing :). We did have lots of folks visit with us in the DAT ''Green'' area but in the bloggers lounge, I thought I'd blog (maybe that's the point?!). But, as luck would have it, I ...

Memorial Day weekend we were in Chicago to celebrate my Father's life. We did a ''Celebration of Life'' memorial and we had a few drinks (celebratory Meyers, Tonic and lime - which was my Father's favorite drink), we (7 of us) gave a few heartfelt speeches, and a few friends wrote a song (and passed out the words - to which we ...

OK - so this has been frustrating me for many months... when you create indexes with included columns (which was a new feature of SQL Server 2005), they're not shown by sp_helpindex or by DBCC SHOW_STATISTICS. I understand this not showing for statistics because included columns are not factored into the histogram (that's only the high ...

A couple of weeks ago, Paul and I recorded two interviews with TechNet Radio... both are ready for download and in multiple formats!  Our specific interviews can be downloaded from the following links/formats:   SQL 2008 Part 1 of 2: Security and Availability WMA | MP3 High | MP3 Low   SQL 2008 Part 2 of 2: ...

I know that Paul and I recommended that you subscribe to Conor's blog... but have you? He's posted some great details on Partitioning (Part 1 and Part 2) as well as statistics and it always reminds me of how much I can learn from other people's perspectives! And, just to dove-tail on some of his statistics comments... ...