Resources: A panel on HA and a second on Women In Tech

OK, in my quest to blog more often, I realized I have the perfect thing to blog about today… stuff I did that I haven't yet told you about. :) :) At TechEd US, Paul and I were on a panel created to debunk some of the more common questions/concerns when setting up High Availability. […]

Updates (fixes) to sp_helpindex2

NOTE: I've released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! 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 […]

Auto update statistics and auto create statistics – should you leave them on and/or turn them on??

YES!!! OK, well, I guess I should be more specific because as in most things in SQL Server, the real answer is “it depends”. And for these two options, it depends mostly on your SQL Server version. Since SQL Server 7.0, the way that auto update works, has changed (much so for the better!!). So, […]

Installing Data Dude CTP16 with SQL 2008 and Visual Studio

OK, so SQL Server 2008 came out *BEFORE* Visual Studio SP1 but VSSP1 was required (this was a bit annoying and created a lot of confusion/emails/newsgroup posts, etc.) but luckily VSSP1 came out only a couple of days after SQL Server 2008 RTM’ed. As for Data Dude, well, it’s not RTM’ing until later this year […]

SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and – as usual – catching up (i.e. cookies)!

OK, so, I don't blog very often. I don't know what it is… I think it's that I feel like I always need to blog huge posts and the thought of writing my huge post makes me not want to blog… so, sometimes my time-between-blogging (TBB :) is long. I'm going to turn over a […]