Browse by Tags

• beginners
• best practices
• Conference Resources/Q&A
• Conferences
• Design
• Events
• indexes
• Interviews
• Manageability
• new dba
• Opinions
• Optimizing Procedural Code
• Personal
• Samples
• SQL Server
• SQL Server 2005
• SQL Server 2008
• tips
• Where in the World are Kimberly and Paul?

• Interviews with MidnightDBA are posted

  At PASS we hung out with Sean McCown and Jen McCown (of MidnightDBA ) and chatted... and, despite our better judgement, it was recorded. ;-) These aren't overly technical but they are fun! Enjoy!! Part 1 of 2: http://midnightdba.itbookworm.com/VidPages/DBAsAtMidnightTripps1of2/DBAsAtMidnightTripps1of2.aspx Read More... Posted Tuesday, November 17, 2009 9:47 AM from Kimberly L. Tripp | (Comments Off) Filed under: resources, Interviews

• SQL Server MVP Deep Dives (book for charity)

  Well... it's finally been released and last week was the book launch. This book came together first as a goal by Paul Nielsen who was motivated by Steve Ballmer's request that MVPs "give back" even more and even outside of the direct Read More... Posted Thursday, November 12, 2009 9:17 AM from Kimberly L. Tripp | (Comments Off) Filed under: Conferences, resources

• Companion content for Chapter 6 (Index Internals) of SQL Server 2008 Internals

  Recently, the SQL Server 2008 Internals title was released (and only in the past few days have people actually received their copies! In fact, I still haven't seen the book in person... soon though!) Anyway, Kalen , Paul , Conor , Adam and I worked Read More... Posted Monday, April 13, 2009 4:20 PM from Kimberly L. Tripp | (Comments Off) Filed under: indexes, SQL Server 2008, resources

• RunAsRadio Interview about Developers and DBAs - whose job is it?

  A couple of weeks ago I wrote a blog post titled Whose job is it anyway? It's an interesting debate and something I've been hearing more and more - that SQL Server is a "set it and forget it" technology - a black box where you just don't Read More... Posted Saturday, April 11, 2009 3:52 AM from Kimberly L. Tripp | (Comments Off) Filed under: Events, SQL Server 2008, resources, tips, SQL Server 2005, Design, Opinions, Manageability

• Don't worry - it's not facebook...

  OK, I've been pretty quiet this week... I had high hopes that I'd blog at least once or twice this week but the week turned out to be crazy busy as I presented T-W-Th at the SQL MCM (Microsoft Certified Masters) and then Fr at the Sharepoint MCM. Read More... Posted Saturday, March 21, 2009 1:08 PM from Kimberly L. Tripp | (Comments Off) Filed under: resources

• Where in the world does time go?

  I know where I go but where the heck does the time go (it seems to move much faster than I)? First off, I hope everyone had a truly lovely holiday season. I know they've long since past for everyone but maybe this reminder will bring back a nice memory Read More... Posted Thursday, February 05, 2009 6:24 PM from Kimberly L. Tripp | (Comments Off) Filed under: resources, Where in the World are Kimberly and Paul?, Opinions

• RunAs Radio Interview Posted - "Kim Tripp Indexes Everything"

  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 Read More... Posted Saturday, October 04, 2008 4:51 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, indexes, SQL Server 2008, resources, SQL Server 2005

• SQL2008HOLsVPC setup instructions and a note for the August 2008 release

  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 Read More... Posted Saturday, October 04, 2008 4:36 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: SQL Server 2008, resources, Conference Resources/Q&A

• 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 Read More... Posted Tuesday, August 26, 2008 6:13 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Personal, resources, Opinions

• Updates (fixes) to sp_helpindex2

  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. Read More... Posted Monday, August 25, 2008 5:23 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, resources, SQL Server 2005

• TechEd has completed!

  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 Read More... Posted Thursday, June 12, 2008 5:54 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, SQL Server 2008, resources, Conference Resources/Q&A

• Time for TechEd ITPro and, it's hot as hell here in Orlando.........

  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, Read More... Posted Sunday, June 08, 2008 11:57 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, SQL Server 2008, resources, SQL Server 2005, Conference Resources/Q&A

• When did you last backup your home/personal/less-critical system... is it really less-critical?

  Have you ever written something and then lost it... for whatever reason: your own stupidity ( come on we've all accidentally done something at some point where we lost data or a spreadsheet or a document or something... ), the software eats it ( this Read More... Posted Saturday, May 10, 2008 8:11 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Personal, resources, Opinions

• Catching up on resources - the Accidental DBA workshops!

  OK, we were in Iceland and then Florida for our Accidental DBA workshops and both went really well. People agree that there are quite a few involuntary/accidental DBAs out there and overall, we helped quite a few to see a lot of options for better performance, Read More... Posted Monday, April 28, 2008 11:29 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, resources, SQL Server 2005, Conference Resources/Q&A, Optimizing Procedural Code

• sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex

  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 Read More... Posted Thursday, April 03, 2008 4:22 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, resources, SQL Server 2005