Archive

RSS64bit Computing (1)

Date Title Comments Rating
2005-02-14 Moving one of my new laptops to x64 OS this week, will your application(s) work? 4 None

RSSAre you kidding me? (3)

Date Title Comments Rating
2009-03-05 GUIDs as PRIMARY KEYs and/or the clustering key 14 None
2009-03-05 Whose job is it anyway? 19 None
2009-03-04 Seriously, are you kidding me? 4 None

RSSBackup & Restore (4)

Date Title Comments Rating
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2010-04-02 Backup Resources - Where, oh where, can they be? 4 None
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-02-13 Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008 0 None

RSSClustered Index (1)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None

RSSClustering Key (4)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2009-03-05 GUIDs as PRIMARY KEYs and/or the clustering key 14 None
2007-02-02 The Clustered Index Debate Continues... 4 None
2005-06-06 Ever-increasing clustering key - the Clustered Index Debate..........again! 2 None

RSSCommunity (1)

Date Title Comments Rating
2010-08-13 Women in Tech - a great post by Stacia Misner 0 None

RSSConference Resources/Q&A (9)

Date Title Comments Rating
2008-11-23 Conference craziness comes to a close... (and DVD information) 1 None
2008-10-03 SQL2008HOLsVPC setup instructions and a note for the August 2008 release 3 None
2008-06-11 TechEd has completed! 0 None
2008-06-08 Indexes in SQL Server 2005/2008 - Part 2 - Internals 3 None
2008-06-08 Time for TechEd ITPro and, it's hot as hell here in Orlando......... 0 None
2008-04-28 Catching up on resources - the Accidental DBA workshops! 4 None
2008-01-13 Starting to catch up (finally)............................ and, Happy New Year! 0 None
2007-11-07 Resources and Q&A from our SQLConnections pre-conference workshop: Disaster Recovery - from Planning to Practice to Post-Mortem 0 None
2007-11-05 Resources and Q&A from our SQLConnection [PRE] pre-conference workshop: Database Maintenance - from Planning to Practice to Post-Mortem 0 None

RSSConferences (9)

Date Title Comments Rating
2010-04-19 SQL Connections Fall 2010 - Call for Abstracts 0 None
2010-01-19 Upcoming events - great topics, great locations! 0 None
2009-11-17 Travel tips - tagged by Kevin! 8 None
2009-11-11 SQL Server MVP Deep Dives (book for charity) 11 None
2009-08-24 The fall line-up and event list - we hope to see you there! 2 None
2009-03-27 Good strategies - excellent improvements... thanks Jim! 0 None
2009-03-01 Connections is 3 weeks away and counting! 0 None
2009-02-24 Getting the most from the system you have now! 0 None
2009-02-15 Getting started in speaking publicly - clear and concise presentations 2 None

RSSConsolidation (1)

Date Title Comments Rating
2009-03-02 Server consolidation and Green IT Computing 0 None

RSSdasBlog (0)

Date Title Comments Rating

RSSDatabase Maintenance (7)

Date Title Comments Rating
2010-04-29 The MOSS Show Sharepoint Podcast - Episode 21 is live! 2 None
2009-03-27 Spring cleaning your indexes - Part II 2 None
2009-03-23 Spring cleaning your indexes - Part I 6 None
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2009-03-05 GUIDs as PRIMARY KEYs and/or the clustering key 14 None

RSSDesign (22)

Date Title Comments Rating
2009-08-10 Column order doesn't matter... generally, but - IT DEPENDS! 11 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-05 GUIDs as PRIMARY KEYs and/or the clustering key 14 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None
2008-02-05 Statistics, query plans, and are you reading Conor's blog? 1 None
2006-07-11 Designing for Performance - opinions, tips, tricks, techniques?! 3 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-05 Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB 8 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-08-23 The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment 0 None
2005-08-20 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10 1 None
2005-08-04 MSDN Webcast Series to start tomorrow! 0 None
2005-06-06 You learn something new everyday! 0 None
2005-05-15 Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005 5 None
2004-10-25 When did SQL Server stop putting indexes on Foreign Key columns? 4 None
2004-07-21 MSDN Webcast Q&A - almost ready.... 1 None
2004-07-09 A Simple Start - Table Creation Best Practices 3 None
2004-07-08 Database Design considerations - where's the silver bullet? 0 None

RSSDynamic String Execution (6)

Date Title Comments Rating
2010-04-28 Clearing the cache - are there other options? 5 None
2010-04-15 Using the OPTION (RECOMPILE) option for a statement 10 None
2010-04-05 EXEC and sp_executesql - how are they different? 8 None
2010-04-04 Little Bobby Tables, SQL Injection and EXECUTE AS 9 None
2009-06-30 Looking for security vulnerabilities in database code 19 None
2007-07-24 "EXECUTE AS" and an important update your DDL Triggers (for auditing or prevention) 4 None

RSSEvents (112)

Date Title Comments Rating
2010-07-22 RunAs Radio interview posted 0 None
2010-05-21 Just added - NEW SQL Immersion Event in Bellevue, WA - in August 2 None
2010-05-14 Upcoming Events for May, June, July and August - including a new Immersion Event! 1 None
2010-04-23 Public classes coming up in Dublin (including prior course testimonials) 1 None
2010-04-22 Upcoming User Group Presentations 0 None
2010-04-19 SQL Connections Fall 2010 - Call for Abstracts 0 None
2010-01-19 Upcoming events - great topics, great locations! 0 None
2009-08-24 The fall line-up and event list - we hope to see you there! 2 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-01 Connections is 3 weeks away and counting! 0 None
2009-02-24 Getting the most from the system you have now! 0 None
2008-11-23 Conference craziness comes to a close... (and DVD information) 1 None
2008-10-03 RunAs Radio Interview Posted - "Kim Tripp Indexes Everything" 1 None
2008-09-23 Budgets, training, where is your money best spent? 0 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None
2008-06-11 TechEd has completed! 0 None
2008-06-08 Indexes in SQL Server 2005/2008 - Part 2 - Internals 3 None
2008-06-08 Time for TechEd ITPro and, it's hot as hell here in Orlando......... 0 None
2008-04-28 Catching up on resources - the Accidental DBA workshops! 4 None
2008-03-12 TechNet Radio Interviews are ready for download 0 None
2008-03-10 SQL Server Magazine Connections Fall 2008 Call For Abstracts 0 None
2007-11-07 Resources and Q&A from our SQLConnections pre-conference workshop: Disaster Recovery - from Planning to Practice to Post-Mortem 0 None
2007-11-05 Resources and Q&A from our SQLConnection [PRE] pre-conference workshop: Database Maintenance - from Planning to Practice to Post-Mortem 0 None
2007-11-03 And so another conference begins... it's time for Fall SQL Connections - in Vegas! 2 None
2007-10-19 He could be doing worse things... 0 None
2007-10-05 SQL Server Magazine Connections Spring 2008 - Call for presentations 0 None
2007-10-04 November in Spain -> TechEd ITForum 2007 0 None
2007-10-03 November in Las Vegas -> SQL Server Magazine Connections Fall Show 0 None
2007-09-05 Exciting news from SQLskills... Paul Randal has officially started AND moved his blog over! 0 None
2007-06-05 Exciting news from TechEd 2007 - SQL Server 2008's CTP3 is ready for public download! 1 None
2007-04-27 SP2, VLDB Maintenance and TechEd 11 None
2007-04-06 We got our mugs on SSWUG TV! 2 None
2007-03-11 Sometimes life just happens... a sincere apology to the OpenWorld Attendees 3 None
2007-03-06 I was ambushed... 2 None
2007-02-13 Upcoming Events and Instant Initialization is not............. 0 None
2006-12-01 Way, way, way overdue 4 None
2006-09-08 Getting into speaking, presenting, and possibly making a career change? 3 None
2006-06-28 Immersion Events are back! 2 None
2006-06-24 Geeking out at 36,000 feet 3 None
2006-06-23 Events, Events and more Events 0 None
2006-06-16 TechEd is over for me... I owe you some blog posts! 0 None
2006-06-09 Data Dude Down Under 0 None
2006-06-08 Getting ready for TechEd - it's amazing what goes on behind the scenes! 0 None
2006-06-02 DotNetRocks got me again! 1 None
2006-05-25 TechNet Webcast Series for the ITPro - Series Links 0 None
2006-05-22 TechNet Webcast Series for the ITPro - Part 11 of 11 0 None
2006-05-14 TechNet Webcast Series for the ITPro - Part 9 of 11 0 None
2006-05-13 TechNet Webcast Series for the ITPro - Part 10 of 11 - errata 0 None
2006-05-12 TechNet Webcast Series for the ITPro - Part 10 of 11 0 None
2006-05-05 TechNet Webcast Series for the ITPro - Part 8 of 11 0 None
2006-05-04 Chatting with Greg Low from SQLDownUnder.com 0 None
2006-04-24 TechNet Webcast Series for the ITPro - Part 7 of 11 0 None
2006-04-18 What, am I crazy??? 11 features/topics for this Friday's TechNet webcast! 0 None
2006-04-10 TechNet Webcast Series for the ITPro - Part 5 of 11 0 None
2006-04-01 TechNet Webcast Series for the ITPro - Part 4 of 11 2 None
2006-03-27 TechNet Webcast Series for the ITPro - Part 3 of 11 0 None
2006-03-10 TechNet Webcast Series for the ITPro - Part 1 of 11 8 None
2006-02-27 Long time since I last blogged - wow...too much going on! 0 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-23 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10 0 None
2005-09-18 PDC Pre-conference Workshop Resources...and what a list it is! 0 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-09-02 Another Immersion Event ends... 0 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-08-20 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10 1 None
2005-08-12 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10 0 None
2005-08-04 MSDN Webcast Series to start tomorrow! 0 None
2005-08-01 SQLskills welcomes Bob Beauchemin 0 None
2005-07-01 Two contests...GREAT prizes... Good luck! 0 None
2005-06-27 GrokTalks have been posted! 0 None
2005-06-24 An interview with theServerside.net has been posted! 0 None
2005-06-23 SQL Server 2005 Tools - Resources to effectively use SQLCMD 0 None
2005-06-06 Ever-increasing clustering key - the Clustered Index Debate..........again! 2 None
2005-06-06 You learn something new everyday! 0 None
2005-05-15 Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005 5 None
2005-04-20 Kimberly on .NET Rocks Again - Friday, April 22, 2005 @ 3PM Pacific Time 0 None
2005-03-30 Exciting Events Ahead... 0 None
2005-01-24 Buy an hour of time for a good cause! 6 None
2004-10-26 SQL Server 2005 Developer Webcast Series Coming Soon to MSDN 0 None
2004-10-25 My home town was a great place to kick off our first SQL Immersion Event 0 None
2004-10-20 So much to blog about, so little time :( 0 None
2004-09-26 SQL Server 2005 Partitioned Tables and Indexes 1 None
2004-09-05 PASS in Orlando, September 27 - October 1 - Are you going to be there? 0 None
2004-09-03 SQL Server 2005 - Profiler with Performance Monitor Integration and a bit more with Management Studio 0 None
2004-09-02 SQL Server 2005 - Management Studio Scripting Option and SQLCMD (loving it!) 2 None
2004-08-31 SQLskills SQL Immersion Event Almost Full! 0 None
2004-08-30 Is it Boeing or Bowing? Highlights from the ECC... 0 None
2004-08-27 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation, Deletes and the “Sliding Window” Scenario and it's the LAST one! 1 None
2004-08-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part III 2 None
2004-08-23 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part II 0 None
2004-08-20 Blogging backlog - time to start catching up!!! 0 None
2004-07-28 Kimberly on .NET Rocks - TOMORROW - Thursday, July 29 from 7 to 9 p.m. Pacific Time 5 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part I 2 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Index Usage Questions 0 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - Clustering Key Choice 1 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - General Questions 1 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - Related Resource Questions 0 None
2004-07-21 MSDN Webcast Q&A - almost ready.... 1 None
2004-07-15 Upcoming MSDN Webcast - Index Defrag Best Practices 0 None
2004-07-05 Goodbye Amsterdam - hello Chicago! 0 None
2004-06-29 They do more than just technology! 1 None
2004-06-15 MSDN Webcast Archive Available but... 0 None
2004-06-14 SQLskills SQL Immersion Event (Oct 2004) will add open lab time and extended hours! 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Management/Maintenance Questions 3 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Creation Questions 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: General Questions 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Tools 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Related Resources 0 None
2004-06-09 Indexes from Every Angle - Finding the Right Balance 3 None

RSSFILLFACTOR (2)

Date Title Comments Rating
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2004-06-19 Sounds like Fillfactor... 1 None

RSSFiltered Indexes (3)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2009-09-24 Filtered indexes and filtered stats might become seriously out-of-date 11 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None

RSSForeign Keys (1)

Date Title Comments Rating
2009-02-28 Foreign Keys can reference UNIQUE indexes (without constraints) 0 None

RSSGreen Computing (1)

Date Title Comments Rating
2009-03-02 Server consolidation and Green IT Computing 0 None

RSSHOLs DVD (2)

Date Title Comments Rating
2008-11-23 Conference craziness comes to a close... (and DVD information) 1 None
2008-10-03 SQL2008HOLsVPC setup instructions and a note for the August 2008 release 3 None

RSSIndexes (50)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2009-09-24 Filtered indexes and filtered stats might become seriously out-of-date 11 None
2009-04-12 Companion content for Chapter 6 (Index Internals) of SQL Server 2008 Internals 0 None
2009-03-27 Spring cleaning your indexes - Part II 2 None
2009-03-23 Spring cleaning your indexes - Part I 6 None
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2009-03-09 Tipping Point Queries - More Questions To Really Test You! 2 None
2009-03-08 Why aren't those nonclustered indexes being used? 1 None
2009-03-05 GUIDs as PRIMARY KEYs and/or the clustering key 14 None
2009-03-04 Seriously, are you kidding me? 4 None
2009-02-28 Foreign Keys can reference UNIQUE indexes (without constraints) 0 None
2009-02-05 Where in the world does time go? 1 None
2008-10-03 RunAs Radio Interview Posted - "Kim Tripp Indexes Everything" 1 None
2008-08-24 Updates (fixes) to sp_helpindex2 0 None
2008-08-24 Auto update statistics and auto create statistics - should you leave them on and/or turn them on?? 4 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None
2008-06-08 Indexes in SQL Server 2005/2008 - Part 2 - Internals 3 None
2008-04-16 Indexes in SQL Server 2005/2008 - Best Practices, Part 1 1 None
2008-04-02 sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex 6 None
2008-02-05 Statistics, query plans, and are you reading Conor's blog? 1 None
2007-02-02 The Clustered Index Debate Continues... 4 None
2006-05-04 Chatting with Greg Low from SQLDownUnder.com 0 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-06-24 An interview with theServerside.net has been posted! 0 None
2005-06-06 Ever-increasing clustering key - the Clustered Index Debate..........again! 2 None
2004-10-25 When did SQL Server stop putting indexes on Foreign Key columns? 4 None
2004-08-27 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation, Deletes and the “Sliding Window” Scenario and it's the LAST one! 1 None
2004-08-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part III 2 None
2004-08-23 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part II 0 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part I 2 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Index Usage Questions 0 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - Clustering Key Choice 1 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - General Questions 1 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - Related Resource Questions 0 None
2004-07-21 MSDN Webcast Q&A - almost ready.... 1 None
2004-07-15 Upcoming MSDN Webcast - Index Defrag Best Practices 0 None
2004-07-08 Database Design considerations - where's the silver bullet? 0 None
2004-06-15 MSDN Webcast Archive Available but... 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Management/Maintenance Questions 3 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Creation Questions 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: General Questions 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Tools 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Related Resources 0 None

RSSInside the storage engine (4)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2009-09-24 Filtered indexes and filtered stats might become seriously out-of-date 11 None
2009-08-10 Column order doesn't matter... generally, but - IT DEPENDS! 11 None
2009-04-12 Companion content for Chapter 6 (Index Internals) of SQL Server 2008 Internals 0 None

RSSInstant Initialization (1)

Date Title Comments Rating
2007-03-04 Instant Initialization - What, Why and How? 14 None

RSSInterviews (1)

Date Title Comments Rating
2009-11-16 Interviews with MidnightDBA are posted 1 None

RSSJoins (1)

Date Title Comments Rating
2010-05-16 Determining the position of search arguments in a join 2 None

RSSManageability (8)

Date Title Comments Rating
2010-04-20 Microsoft eLearning Resources - BI and 2008 R2 2 None
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2009-06-06 Favorite SSMS Options - and some gotchas 160 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2008-11-09 SQL Server 2008 Central Management Servers - have you seen these? 13 None

RSSMicrosoft eLearning (3)

Date Title Comments Rating
2010-04-20 Microsoft eLearning Resources - BI and 2008 R2 2 None
2010-04-20 Microsoft eLearning Resources - Developer Content - 2008 & 2008 R2 0 None
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None

RSSMSDN Webcasts (10)

Date Title Comments Rating
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-23 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10 0 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-08-20 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10 1 None
2005-08-12 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10 0 None
2005-08-04 MSDN Webcast Series to start tomorrow! 0 None

RSSNonclustered Indexes (4)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2009-06-07 The Tipping Point Query Answers 87 None
2009-03-09 Tipping Point Queries - More Questions To Really Test You! 2 None
2009-03-08 Why aren't those nonclustered indexes being used? 1 None

RSSOpinions (61)

Date Title Comments Rating
2010-08-13 Women in Tech - a great post by Stacia Misner 0 None
2010-05-16 Determining the position of search arguments in a join 2 None
2009-11-17 Travel tips - tagged by Kevin! 8 None
2009-04-29 Social networking, keeping up with friends/family and getting more tech info! 0 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-15 Things I know now... 5 None
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2009-03-05 Whose job is it anyway? 19 None
2009-02-24 Getting the most from the system you have now! 0 None
2009-02-15 Getting started in speaking publicly - clear and concise presentations 2 None
2009-02-05 Where in the world does time go? 1 None
2008-08-25 Resources: A panel on HA and a second on Women In Tech 0 None
2008-05-09 When did you last backup your home/personal/less-critical system... is it really less-critical? 10 None
2007-07-27 Opinions wanted - are you considering skipping 2005? 9 None
2007-04-06 We got our mugs on SSWUG TV! 2 None
2007-03-12 Next Generation User Group podcast ready for download 0 None
2007-03-11 Sometimes life just happens... a sincere apology to the OpenWorld Attendees 3 None
2007-02-20 SP2 was released today... and, did you know about the Feature Pack? 0 None
2007-02-02 The Clustered Index Debate Continues... 4 None
2007-01-31 Time to make the doughnuts! 2 None
2006-12-01 Way, way, way overdue 4 None
2006-09-28 DasBlog 1.9 ROCKS 0 None
2006-09-08 Getting into speaking, presenting, and possibly making a career change? 3 None
2006-09-01 Is it really September? Here are some resources to check out! 2 None
2006-06-28 Immersion Events are back! 2 None
2006-06-24 Geeking out at 36,000 feet 3 None
2006-06-16 TechEd is over for me... I owe you some blog posts! 0 None
2006-05-12 TechNet Webcast Series for the ITPro - Part 10 of 11 0 None
2006-05-11 Sun caused brain damage (not really) but... 0 None
2006-01-17 The impact of logging - terms and confusion! 3 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-05 Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB 8 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-08-25 Congratulations to Bob, Niels and Dan! 0 None
2005-08-20 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10 1 None
2005-08-04 MSDN Webcast Series to start tomorrow! 0 None
2005-08-01 SQLskills welcomes Bob Beauchemin 0 None
2005-06-06 You learn something new everyday! 0 None
2005-05-15 Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005 5 None
2005-04-01 SQLCLR: A DBA's friend or foe? 0 None
2005-02-14 Moving one of my new laptops to x64 OS this week, will your application(s) work? 4 None
2005-01-24 Buy an hour of time for a good cause! 6 None
2004-12-08 From Microsoft: Research Survey for leading edge developers 0 None
2004-10-25 My home town was a great place to kick off our first SQL Immersion Event 0 None
2004-10-22 If you can't beat 'em, join 'em... 4 None
2004-08-30 Is it Boeing or Bowing? Highlights from the ECC... 0 None
2004-08-20 Blogging backlog - time to start catching up!!! 0 None
2004-07-27 SQL Server reaches new heights... literally! 2 None
2004-07-26 Three Perfect Days - Anacortes, Victoria, Vancouver 1 None
2004-07-08 Database Design considerations - where's the silver bullet? 0 None
2004-07-06 Electric winch, roller furling, in-mast mainsail furling.... not like the boats I've sailed before! 1 None
2004-07-05 Goodbye Amsterdam - hello Chicago! 0 None
2004-06-19 Sounds like Fillfactor... 1 None
2004-06-12 Great MSDN Webcast today - had a ball!! 0 None
2004-06-08 And the blog goes live! 6 None
2004-06-06 I can't not blog any longer! 5 None

RSSOptimizing Procedural Code (14)

Date Title Comments Rating
2010-04-28 Clearing the cache - are there other options? 5 None
2010-04-26 Plan cache, adhoc workloads and clearing the single-use plan cache bloat 3 None
2010-04-22 Plan cache and optimizing for adhoc workloads 25 None
2010-04-21 Statement execution and why you should use stored procedures 2 None
2010-04-15 Using the OPTION (RECOMPILE) option for a statement 10 None
2010-04-05 EXEC and sp_executesql - how are they different? 8 None
2010-04-04 Little Bobby Tables, SQL Injection and EXECUTE AS 9 None
2008-04-28 Catching up on resources - the Accidental DBA workshops! 4 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-05 Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB 8 None
2005-06-27 GrokTalks have been posted! 0 None
2005-06-24 An interview with theServerside.net has been posted! 0 None
2004-06-16 Stored Procedure Parameters giving you grief in a multi-purpose procedure? 7 None
2004-06-06 Stored Procedures are NOT evil... but they can be frustrating! 0 None

RSSPartitioning (4)

Date Title Comments Rating
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2009-02-05 Where in the world does time go? 1 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-05-15 Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005 5 None

RSSPersonal (12)

Date Title Comments Rating
2010-04-22 Social networking - how many is too many? 0 None
2010-01-18 What led me to where I am today and what’s inspired me along the way? 8 None
2009-04-29 Social networking, keeping up with friends/family and getting more tech info! 0 None
2009-03-27 Good strategies - excellent improvements... thanks Jim! 0 None
2008-08-25 Resources: A panel on HA and a second on Women In Tech 0 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None
2008-05-18 Something to think about as we approach Memorial Day... 3 None
2008-05-09 When did you last backup your home/personal/less-critical system... is it really less-critical? 10 None
2008-02-03 Our first trip of the New Year...Shanghai and Beijing 0 None
2007-12-03 Donald Wayne Tripp, August 6, 1944 - November 28, 2007 7 None
2007-10-19 He could be doing worse things... 0 None
2007-07-31 Our Perfect Weekend... 7 None

RSSPlan cache (3)

Date Title Comments Rating
2010-04-28 Clearing the cache - are there other options? 5 None
2010-04-26 Plan cache, adhoc workloads and clearing the single-use plan cache bloat 3 None
2010-04-22 Plan cache and optimizing for adhoc workloads 25 None

RSSPolicy-based Management (1)

Date Title Comments Rating
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None

RSSPresenting (2)

Date Title Comments Rating
2009-02-24 Getting the most from the system you have now! 0 None
2009-02-15 Getting started in speaking publicly - clear and concise presentations 2 None

RSSPrimary Keys (1)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None

RSSResources (101)

Date Title Comments Rating
2010-04-22 SQL Server Magazine's new column: Kimberly & Paul - Questions Answered 0 None
2010-04-20 Media Alert: Microsoft Announces Conference Call With Senior Vice President Ted Kummert 0 None
2010-04-20 Microsoft eLearning Resources - Developer Content - 2008 & 2008 R2 0 None
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2010-04-02 Backup Resources - Where, oh where, can they be? 4 None
2010-03-30 Our new Q&A on SQL Server Magazine is LIVE! 0 None
2009-11-16 Interviews with MidnightDBA are posted 1 None
2009-11-11 SQL Server MVP Deep Dives (book for charity) 11 None
2009-04-12 Companion content for Chapter 6 (Index Internals) of SQL Server 2008 Internals 0 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-20 Don't worry - it's not facebook... 0 None
2009-03-02 Server consolidation and Green IT Computing 0 None
2009-02-24 Getting the most from the system you have now! 0 None
2009-02-05 Where in the world does time go? 1 None
2008-10-03 RunAs Radio Interview Posted - "Kim Tripp Indexes Everything" 1 None
2008-10-03 SQL2008HOLsVPC setup instructions and a note for the August 2008 release 3 None
2008-08-25 Resources: A panel on HA and a second on Women In Tech 0 None
2008-08-24 Updates (fixes) to sp_helpindex2 0 None
2008-06-11 TechEd has completed! 0 None
2008-06-08 Time for TechEd ITPro and, it's hot as hell here in Orlando......... 0 None
2008-05-09 When did you last backup your home/personal/less-critical system... is it really less-critical? 10 None
2008-04-28 Catching up on resources - the Accidental DBA workshops! 4 None
2008-04-02 sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex 6 None
2008-03-12 TechNet Radio Interviews are ready for download 0 None
2008-02-05 Statistics, query plans, and are you reading Conor's blog? 1 None
2008-01-13 Starting to catch up (finally)............................ and, Happy New Year! 0 None
2008-01-13 Releasing the DDM (Dual Database Monitor) 0 None
2007-12-06 Question for all of you.... interest in printouts++ of our workshops? 1 None
2007-11-05 Resources and Q&A from our SQLConnection [PRE] pre-conference workshop: Database Maintenance - from Planning to Practice to Post-Mortem 0 None
2007-09-05 Exciting news from SQLskills... Paul Randal has officially started AND moved his blog over! 0 None
2007-06-05 Exciting news from TechEd 2007 - SQL Server 2008's CTP3 is ready for public download! 1 None
2007-04-27 SP2, VLDB Maintenance and TechEd 11 None
2007-04-02 SQL Server 2005 Books Online Scoped Search 0 None
2007-03-26 Whitepapers, whitepapers and more whitepapers - where the heck are they??? 10 None
2007-03-06 I was ambushed... 2 None
2007-03-05 Moving databases around - what are your options and across what versions? 1 None
2007-03-04 Instant Initialization - What, Why and How? 14 None
2007-02-20 SP2 was released today... and, did you know about the Feature Pack? 0 None
2007-01-31 Time to make the doughnuts! 2 None
2006-12-01 Way, way, way overdue 4 None
2006-09-28 DasBlog 1.9 ROCKS 0 None
2006-09-01 Is it really September? Here are some resources to check out! 2 None
2006-07-03 Welcome to Blogging Liz! 1 None
2006-06-23 Events, Events and more Events 0 None
2006-06-08 Getting ready for TechEd - it's amazing what goes on behind the scenes! 0 None
2006-06-02 DBAs definitely should NOT read this blog entry... 0 None
2006-05-31 SQL Server Migration Assistants 0 None
2006-05-30 SQL Server Team Blogs - a new one and some existing ones! 3 None
2006-05-25 TechNet Webcast Series for the ITPro - Series Links 0 None
2006-05-22 TechNet Webcast Series for the ITPro - Part 11 of 11 0 None
2006-05-14 TechNet Webcast Series for the ITPro - Part 9 of 11 0 None
2006-05-13 TechNet Webcast Series for the ITPro - Part 10 of 11 - errata 0 None
2006-05-12 TechNet Webcast Series for the ITPro - Part 10 of 11 0 None
2006-05-11 Sun caused brain damage (not really) but... 0 None
2006-05-05 TechNet Webcast Series for the ITPro - Part 8 of 11 0 None
2006-04-24 TechNet Webcast Series for the ITPro - Part 7 of 11 0 None
2006-04-18 What, am I crazy??? 11 features/topics for this Friday's TechNet webcast! 0 None
2006-04-10 TechNet Webcast Series for the ITPro - Part 5 of 11 0 None
2006-04-01 TechNet Webcast Series for the ITPro - Part 4 of 11 2 None
2006-03-27 TechNet Webcast Series for the ITPro - Part 3 of 11 0 None
2006-03-10 TechNet Webcast Series for the ITPro - Part 1 of 11 8 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-23 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10 0 None
2005-09-18 PDC Pre-conference Workshop Resources...and what a list it is! 0 None
2005-09-05 Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB 8 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-08-23 The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment 0 None
2005-08-20 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10 1 None
2005-08-12 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10 0 None
2005-08-04 MSDN Webcast Series to start tomorrow! 0 None
2005-06-27 GrokTalks have been posted! 0 None
2005-06-25 8 Steps to better Transaction Log throughput 23 None
2005-06-24 An interview with theServerside.net has been posted! 0 None
2005-06-23 SQL Server 2005 Tools - Resources to effectively use SQLCMD 0 None
2005-06-06 You learn something new everyday! 0 None
2005-04-11 So many ways to get your hands on SQL Server 2005 0 None
2004-10-26 SQL Server 2005 Developer Webcast Series Coming Soon to MSDN 0 None
2004-10-25 When did SQL Server stop putting indexes on Foreign Key columns? 4 None
2004-09-26 SQL Server 2005 Partitioned Tables and Indexes 1 None
2004-09-03 SQL Server 2005 - Profiler with Performance Monitor Integration and a bit more with Management Studio 0 None
2004-08-27 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation, Deletes and the “Sliding Window” Scenario and it's the LAST one! 1 None
2004-08-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part III 2 None
2004-08-23 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part II 0 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part I 2 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Index Usage Questions 0 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - Clustering Key Choice 1 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - General Questions 1 None
2004-07-24 MSDN Webcast Q&A: Index Defrag Best Practices - Related Resource Questions 0 None
2004-07-21 MSDN Webcast Q&A - almost ready.... 1 None
2004-07-15 Upcoming MSDN Webcast - Index Defrag Best Practices 0 None
2004-06-16 Stored Procedure Parameters giving you grief in a multi-purpose procedure? 7 None
2004-06-15 MSDN Webcast Archive Available but... 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Management/Maintenance Questions 3 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Creation Questions 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: General Questions 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Tools 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Related Resources 0 None

RSSSecurity (10)

Date Title Comments Rating
2010-04-21 Statement execution and why you should use stored procedures 2 None
2010-04-20 Microsoft eLearning Resources - Developer Content - 2008 & 2008 R2 0 None
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2010-04-05 EXEC and sp_executesql - how are they different? 8 None
2010-04-04 Little Bobby Tables, SQL Injection and EXECUTE AS 9 None
2009-06-30 Looking for security vulnerabilities in database code 19 None
2007-07-24 "EXECUTE AS" and an important update your DDL Triggers (for auditing or prevention) 4 None
2007-03-04 Instant Initialization - What, Why and How? 14 None
2004-06-07 Security Best Practices 1 None
2004-06-06 Stored Procedures are NOT evil... but they can be frustrating! 0 None

RSSSharepoint (5)

Date Title Comments Rating
2010-04-29 The MOSS Show Sharepoint Podcast - Episode 21 is live! 2 None
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2009-03-05 GUIDs as PRIMARY KEYs and/or the clustering key 14 None

RSSSocial Networking (1)

Date Title Comments Rating
2010-04-22 Social networking - how many is too many? 0 None

RSSsp_executesql (6)

Date Title Comments Rating
2010-04-28 Clearing the cache - are there other options? 5 None
2010-04-15 Using the OPTION (RECOMPILE) option for a statement 10 None
2010-04-05 EXEC and sp_executesql - how are they different? 8 None
2010-04-04 Little Bobby Tables, SQL Injection and EXECUTE AS 9 None
2009-06-30 Looking for security vulnerabilities in database code 19 None
2007-07-24 "EXECUTE AS" and an important update your DDL Triggers (for auditing or prevention) 4 None

RSSSparse Columns (3)

Date Title Comments Rating
2010-04-20 Microsoft eLearning Resources - Developer Content - 2008 & 2008 R2 0 None
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None

RSSSQL Server 2005 (109)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2010-04-28 Clearing the cache - are there other options? 5 None
2010-04-26 Plan cache, adhoc workloads and clearing the single-use plan cache bloat 3 None
2010-04-21 Statement execution and why you should use stored procedures 2 None
2010-04-19 SQL Connections Fall 2010 - Call for Abstracts 0 None
2009-08-10 Column order doesn't matter... generally, but - IT DEPENDS! 11 None
2009-06-30 Looking for security vulnerabilities in database code 19 None
2009-06-07 The Tipping Point Query Answers 87 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-27 Spring cleaning your indexes - Part II 2 None
2009-03-23 Spring cleaning your indexes - Part I 6 None
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2009-03-09 Tipping Point Queries - More Questions To Really Test You! 2 None
2009-03-08 Why aren't those nonclustered indexes being used? 1 None
2009-03-01 Connections is 3 weeks away and counting! 0 None
2009-02-28 Foreign Keys can reference UNIQUE indexes (without constraints) 0 None
2009-02-24 Getting the most from the system you have now! 0 None
2009-02-13 Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008 0 None
2008-11-13 Transaction Log VLFs - too many or too few? 21 None
2008-10-03 RunAs Radio Interview Posted - "Kim Tripp Indexes Everything" 1 None
2008-08-24 Updates (fixes) to sp_helpindex2 0 None
2008-08-24 Auto update statistics and auto create statistics - should you leave them on and/or turn them on?? 4 None
2008-06-08 Indexes in SQL Server 2005/2008 - Part 2 - Internals 3 None
2008-06-08 Time for TechEd ITPro and, it's hot as hell here in Orlando......... 0 None
2008-04-28 Catching up on resources - the Accidental DBA workshops! 4 None
2008-04-16 Indexes in SQL Server 2005/2008 - Best Practices, Part 1 1 None
2008-04-02 sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex 6 None
2007-10-22 SQL Server 2005 and 2008 - Compression 2 None
2007-10-04 Follow on post to "The perils of case-insensitive data (and our life in tangent-land)" 0 None
2007-10-04 November in Spain -> TechEd ITForum 2007 0 None
2007-10-03 November in Las Vegas -> SQL Server Magazine Connections Fall Show 0 None
2007-10-03 SQL Server 2008 offers partition-level lock escalation excellent, but... 1 None
2007-10-03 The perils of case-insensitive data (and our life in tangent-land) 6 None
2007-07-24 "EXECUTE AS" and an important update your DDL Triggers (for auditing or prevention) 4 None
2007-04-27 SP2, VLDB Maintenance and TechEd 11 None
2007-04-06 We got our mugs on SSWUG TV! 2 None
2007-04-02 SQL Server 2005 Books Online Scoped Search 0 None
2007-03-26 Whitepapers, whitepapers and more whitepapers - where the heck are they??? 10 None
2007-03-12 Next Generation User Group podcast ready for download 0 None
2007-03-06 I was ambushed... 2 None
2007-03-05 Moving databases around - what are your options and across what versions? 1 None
2007-03-04 Instant Initialization - What, Why and How? 14 None
2007-02-20 SP2 was released today... and, did you know about the Feature Pack? 0 None
2007-02-13 Upcoming Events and Instant Initialization is not............. 0 None
2007-02-02 The Clustered Index Debate Continues... 4 None
2007-01-31 Time to make the doughnuts! 2 None
2006-12-01 Way, way, way overdue 4 None
2006-09-01 Is it really September? Here are some resources to check out! 2 None
2006-07-11 Designing for Performance - opinions, tips, tricks, techniques?! 3 None
2006-07-03 Welcome to Blogging Liz! 1 None
2006-06-30 SQL 2000 v. 2005 - Using Top 100 Percent in a View 5 None
2006-06-24 Geeking out at 36,000 feet 3 None
2006-06-23 Events, Events and more Events 0 None
2006-06-08 Getting ready for TechEd - it's amazing what goes on behind the scenes! 0 None
2006-06-02 DBAs definitely should NOT read this blog entry... 0 None
2006-06-02 DotNetRocks got me again! 1 None
2006-05-31 SQL Server Migration Assistants 0 None
2006-05-30 Changing Database Collation and dealing with TempDB Objects 4 None
2006-05-30 SQL Server Team Blogs - a new one and some existing ones! 3 None
2006-05-25 TechNet Webcast Series for the ITPro - Series Links 0 None
2006-05-22 TechNet Webcast Series for the ITPro - Part 11 of 11 0 None
2006-05-14 TechNet Webcast Series for the ITPro - Part 9 of 11 0 None
2006-05-13 TechNet Webcast Series for the ITPro - Part 10 of 11 - errata 0 None
2006-05-12 TechNet Webcast Series for the ITPro - Part 10 of 11 0 None
2006-05-11 Sun caused brain damage (not really) but... 0 None
2006-05-05 TechNet Webcast Series for the ITPro - Part 8 of 11 0 None
2006-04-24 TechNet Webcast Series for the ITPro - Part 7 of 11 0 None
2006-04-18 What, am I crazy??? 11 features/topics for this Friday's TechNet webcast! 0 None
2006-04-10 TechNet Webcast Series for the ITPro - Part 5 of 11 0 None
2006-04-01 TechNet Webcast Series for the ITPro - Part 4 of 11 2 None
2006-03-27 TechNet Webcast Series for the ITPro - Part 3 of 11 0 None
2006-03-10 TechNet Webcast Series for the ITPro - Part 1 of 11 8 None
2006-02-27 Long time since I last blogged - wow...too much going on! 0 None
2006-01-17 The impact of logging - terms and confusion! 3 None
2006-01-16 Scalable Share Databases are supported by SQL Server 2005 RTM 3 None
2006-01-15 SQL Server 2005 Books Online Refresh 2 None
2005-11-06 SQL Server 2005 Launches TOMORROW in San Francisco - Watch a LIVE Broadcast 0 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-23 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10 0 None
2005-09-18 PDC Pre-conference Workshop Resources...and what a list it is! 0 None
2005-09-05 Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB 8 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-09-02 Another Immersion Event ends... 0 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-08-25 Congratulations to Bob, Niels and Dan! 0 None
2005-08-23 The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment 0 None
2005-08-20 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10 1 None
2005-08-12 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10 0 None
2005-08-04 MSDN Webcast Series to start tomorrow! 0 None
2005-08-01 SQLskills welcomes Bob Beauchemin 0 None
2005-07-01 Two contests...GREAT prizes... Good luck! 0 None
2005-06-27 GrokTalks have been posted! 0 None
2005-06-25 8 Steps to better Transaction Log throughput 23 None
2005-06-24 An interview with theServerside.net has been posted! 0 None
2005-06-23 SQL Server 2005 Tools - Resources to effectively use SQLCMD 0 None
2005-06-06 Ever-increasing clustering key - the Clustered Index Debate..........again! 2 None
2005-06-06 You learn something new everyday! 0 None
2005-05-15 Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005 5 None
2005-04-11 So many ways to get your hands on SQL Server 2005 0 None
2005-04-01 SQLCLR: A DBA's friend or foe? 0 None
2005-03-30 Exciting Events Ahead... 0 None
2004-10-26 SQL Server 2005 Developer Webcast Series Coming Soon to MSDN 0 None
2004-09-26 SQL Server 2005 Partitioned Tables and Indexes 1 None
2004-09-03 SQL Server 2005 - Profiler with Performance Monitor Integration and a bit more with Management Studio 0 None
2004-09-02 SQL Server 2005 - Management Studio Scripting Option and SQLCMD (loving it!) 2 None

RSSSQL Server 2008 (55)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2010-04-28 Clearing the cache - are there other options? 5 None
2010-04-26 Plan cache, adhoc workloads and clearing the single-use plan cache bloat 3 None
2010-04-23 Public classes coming up in Dublin (including prior course testimonials) 1 None
2010-04-22 Plan cache and optimizing for adhoc workloads 25 None
2010-04-21 Statement execution and why you should use stored procedures 2 None
2010-04-20 Microsoft eLearning Resources - BI and 2008 R2 2 None
2010-04-20 Microsoft eLearning Resources - Developer Content - 2008 & 2008 R2 0 None
2010-04-20 Microsoft eLearning Resources - Clinic 10259 (SQL 2008 DBIS) 0 None
2010-04-19 SQL Connections Fall 2010 - Call for Abstracts 0 None
2009-09-24 Filtered indexes and filtered stats might become seriously out-of-date 11 None
2009-08-10 Column order doesn't matter... generally, but - IT DEPENDS! 11 None
2009-06-30 Looking for security vulnerabilities in database code 19 None
2009-06-07 The Tipping Point Query Answers 87 None
2009-04-12 Companion content for Chapter 6 (Index Internals) of SQL Server 2008 Internals 0 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-27 Spring cleaning your indexes - Part II 2 None
2009-03-23 Spring cleaning your indexes - Part I 6 None
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2009-03-09 Tipping Point Queries - More Questions To Really Test You! 2 None
2009-03-08 Why aren't those nonclustered indexes being used? 1 None
2009-03-01 Connections is 3 weeks away and counting! 0 None
2009-02-28 Foreign Keys can reference UNIQUE indexes (without constraints) 0 None
2009-02-24 Getting the most from the system you have now! 0 None
2009-02-13 Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008 0 None
2008-11-23 Conference craziness comes to a close... (and DVD information) 1 None
2008-11-14 Virtualization with SQL Server 3 None
2008-11-13 Transaction Log VLFs - too many or too few? 21 None
2008-11-09 SQL Server 2008 Central Management Servers - have you seen these? 13 None
2008-10-03 RunAs Radio Interview Posted - "Kim Tripp Indexes Everything" 1 None
2008-10-03 SQL2008HOLsVPC setup instructions and a note for the August 2008 release 3 None
2008-09-23 Budgets, training, where is your money best spent? 0 None
2008-08-24 Updates (fixes) to sp_helpindex2 0 None
2008-08-24 Auto update statistics and auto create statistics - should you leave them on and/or turn them on?? 4 None
2008-08-24 Installing Data Dude CTP16 with SQL 2008 and Visual Studio 0 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None
2008-06-11 TechEd has completed! 0 None
2008-06-08 Indexes in SQL Server 2005/2008 - Part 2 - Internals 3 None
2008-06-08 Time for TechEd ITPro and, it's hot as hell here in Orlando......... 0 None
2008-04-16 Indexes in SQL Server 2005/2008 - Best Practices, Part 1 1 None
2008-04-02 sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex 6 None
2008-03-12 TechNet Radio Interviews are ready for download 0 None
2008-03-10 SQL Server Magazine Connections Fall 2008 Call For Abstracts 0 None
2008-02-05 Statistics, query plans, and are you reading Conor's blog? 1 None
2007-10-22 SQL Server 2005 and 2008 - Compression 2 None
2007-10-07 SQL Server 2008 - Transparent Data Encryption 1 None
2007-10-05 SQL Server Magazine Connections Spring 2008 - Call for presentations 0 None
2007-10-04 November in Spain -> TechEd ITForum 2007 0 None
2007-10-03 November in Las Vegas -> SQL Server Magazine Connections Fall Show 0 None
2007-10-03 SQL Server 2008 offers partition-level lock escalation excellent, but... 1 None
2007-08-01 SQL Server 2008 July CTP 0 None
2007-07-27 Opinions wanted - are you considering skipping 2005? 9 None
2007-06-05 Exciting news from TechEd 2007 - SQL Server 2008's CTP3 is ready for public download! 1 None
2005-06-25 8 Steps to better Transaction Log throughput 23 None

RSSSQL Server 2008 R2 (3)

Date Title Comments Rating
2010-04-20 Media Alert: Microsoft Announces Conference Call With Senior Vice President Ted Kummert 0 None
2010-04-20 Microsoft eLearning Resources - BI and 2008 R2 2 None
2010-04-20 Microsoft eLearning Resources - Developer Content - 2008 & 2008 R2 0 None

RSSSQL Server Magazine (2)

Date Title Comments Rating
2010-05-16 Determining the position of search arguments in a join 2 None
2010-04-22 SQL Server Magazine's new column: Kimberly & Paul - Questions Answered 0 None

RSSSQLskills News (2)

Date Title Comments Rating
2008-01-17 Exciting times... 0 None
2007-09-05 Exciting news from SQLskills... Paul Randal has officially started AND moved his blog over! 0 None

RSSStandard Reports (0)

Date Title Comments Rating

RSSStatistics (4)

Date Title Comments Rating
2009-09-24 Filtered indexes and filtered stats might become seriously out-of-date 11 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None
2008-08-24 Auto update statistics and auto create statistics - should you leave them on and/or turn them on?? 4 None
2008-02-05 Statistics, query plans, and are you reading Conor's blog? 1 None

RSSSurvey (2)

Date Title Comments Rating
2009-03-09 Tipping Point Queries - More Questions To Really Test You! 2 None
2009-03-08 Why aren't those nonclustered indexes being used? 1 None

RSSTechNet Webcasts (13)

Date Title Comments Rating
2006-05-31 SQL Server Migration Assistants 0 None
2006-05-25 TechNet Webcast Series for the ITPro - Series Links 0 None
2006-05-22 TechNet Webcast Series for the ITPro - Part 11 of 11 0 None
2006-05-14 TechNet Webcast Series for the ITPro - Part 9 of 11 0 None
2006-05-13 TechNet Webcast Series for the ITPro - Part 10 of 11 - errata 0 None
2006-05-12 TechNet Webcast Series for the ITPro - Part 10 of 11 0 None
2006-05-05 TechNet Webcast Series for the ITPro - Part 8 of 11 0 None
2006-04-24 TechNet Webcast Series for the ITPro - Part 7 of 11 0 None
2006-04-18 What, am I crazy??? 11 features/topics for this Friday's TechNet webcast! 0 None
2006-04-10 TechNet Webcast Series for the ITPro - Part 5 of 11 0 None
2006-04-01 TechNet Webcast Series for the ITPro - Part 4 of 11 2 None
2006-03-27 TechNet Webcast Series for the ITPro - Part 3 of 11 0 None
2006-03-10 TechNet Webcast Series for the ITPro - Part 1 of 11 8 None

RSStempdb (2)

Date Title Comments Rating
2006-05-30 Changing Database Collation and dealing with TempDB Objects 4 None
2005-09-05 Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB 8 None

RSSTFS (3)

Date Title Comments Rating
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2009-03-12 Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint 11 None

RSSThe Tipping Point (3)

Date Title Comments Rating
2009-06-07 The Tipping Point Query Answers 87 None
2009-03-09 Tipping Point Queries - More Questions To Really Test You! 2 None
2009-03-08 Why aren't those nonclustered indexes being used? 1 None

RSSTips (63)

Date Title Comments Rating
2009-11-18 Data Dude moving into lower priced VS Editions in VS 2010 - excellent! 6 None
2009-04-10 RunAsRadio Interview about Developers and DBAs - whose job is it? 3 None
2009-03-27 Spring cleaning your indexes - Part II 2 None
2009-03-23 Spring cleaning your indexes - Part I 6 None
2009-03-15 Things I know now... 5 None
2009-03-13 Database Maintenance Best Practices Part II – Setting FILLFACTOR 0 None
2008-08-24 Auto update statistics and auto create statistics - should you leave them on and/or turn them on?? 4 None
2008-08-24 Installing Data Dude CTP16 with SQL 2008 and Visual Studio 0 None
2008-08-24 SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)! 0 None
2007-10-04 Follow on post to "The perils of case-insensitive data (and our life in tangent-land)" 0 None
2007-07-24 "EXECUTE AS" and an important update your DDL Triggers (for auditing or prevention) 4 None
2007-03-05 Moving databases around - what are your options and across what versions? 1 None
2007-02-02 The Clustered Index Debate Continues... 4 None
2006-12-01 Way, way, way overdue 4 None
2006-07-11 Designing for Performance - opinions, tips, tricks, techniques?! 3 None
2006-07-03 Welcome to Blogging Liz! 1 None
2006-06-30 SQL 2000 v. 2005 - Using Top 100 Percent in a View 5 None
2006-06-02 DBAs definitely should NOT read this blog entry... 0 None
2006-05-30 Changing Database Collation and dealing with TempDB Objects 4 None
2006-05-25 TechNet Webcast Series for the ITPro - Series Links 0 None
2006-05-22 TechNet Webcast Series for the ITPro - Part 11 of 11 0 None
2006-05-14 TechNet Webcast Series for the ITPro - Part 9 of 11 0 None
2006-05-13 TechNet Webcast Series for the ITPro - Part 10 of 11 - errata 0 None
2006-05-12 TechNet Webcast Series for the ITPro - Part 10 of 11 0 None
2006-05-04 Chatting with Greg Low from SQLDownUnder.com 0 None
2006-04-10 TechNet Webcast Series for the ITPro - Part 5 of 11 0 None
2006-04-01 TechNet Webcast Series for the ITPro - Part 4 of 11 2 None
2006-03-10 TechNet Webcast Series for the ITPro - Part 1 of 11 8 None
2005-11-05 MSDN Webcast Series Wrap-up Resources 0 None
2005-09-05 Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB 8 None
2005-09-05 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10 3 None
2005-08-31 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10 2 None
2005-08-26 MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10 0 None
2005-08-26 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10 0 None
2005-08-25 Getting ready for Part 4, "Best Practices in Indexing" in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database 0 None
2005-08-20 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10 1 None
2005-08-12 MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10 0 None
2005-08-04 MSDN Webcast Series to start tomorrow! 0 None
2005-06-25 8 Steps to better Transaction Log throughput 23 None
2005-06-24 An interview with theServerside.net has been posted! 0 None
2005-06-06 Ever-increasing clustering key - the Clustered Index Debate..........again! 2 None
2005-06-06 You learn something new everyday! 0 None
2005-05-15 Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005 5 None
2004-10-25 When did SQL Server stop putting indexes on Foreign Key columns? 4 None
2004-09-02 SQL Server 2005 - Management Studio Scripting Option and SQLCMD (loving it!) 2 None
2004-08-27 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation, Deletes and the “Sliding Window” Scenario and it's the LAST one! 1 None
2004-08-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part III 2 None
2004-08-23 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part II 0 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Fragmentation Questions, Part I 2 None
2004-07-26 MSDN Webcast Q&A: Index Defrag Best Practices - Index Usage Questions 0 None
2004-07-21 MSDN Webcast Q&A - almost ready.... 1 None
2004-07-09 A Simple Start - Table Creation Best Practices 3 None
2004-07-08 Database Design considerations - where's the silver bullet? 0 None
2004-06-16 Stored Procedure Parameters giving you grief in a multi-purpose procedure? 7 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Management/Maintenance Questions 3 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Index Creation Questions 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Tools 0 None
2004-06-12 MSDN Webcast SQL Index Tuning Q&A: Related Resources 0 None
2004-06-07 Kicking users out of a database for... 0 None
2004-06-06 Profiler - STOP that scrolling!!! 0 None
2004-06-06 For Keyboard/keystroke geeks only 0 None
2004-06-06 Random info about documentation and the Books Online 0 None
2004-06-06 Text in Row table option - a good thing??? 0 None

RSSTools (2)

Date Title Comments Rating
2010-05-18 A new and improved sp_helpindex (jokingly sp_helpindex8) 3 None
2009-06-06 Favorite SSMS Options - and some gotchas 160 None

RSSTransaction Log (4)

Date Title Comments Rating
2009-03-14 Database Maintenance Best Practices Part III - Transaction Log Maintenance 4 None
2009-02-13 Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008 0 None
2008-11-13 Transaction Log VLFs - too many or too few? 21 None
2005-06-25 8 Steps to better Transaction Log throughput 23 None

RSSVirtualization (2)

Date Title Comments Rating
2009-03-02 Server consolidation and Green IT Computing 0 None
2008-11-14 Virtualization with SQL Server 3 None

RSSVS DBPro (1)

Date Title Comments Rating
2009-11-18 Data Dude moving into lower priced VS Editions in VS 2010 - excellent! 6 None

RSSWeb Releases (3)

Date Title Comments Rating
2007-02-20 SP2 was released today... and, did you know about the Feature Pack? 0 None
2005-04-11 So many ways to get your hands on SQL Server 2005 0 None
2004-06-06 Best Practices Analyzer Releases 0 None

RSSWhere in the World are Kimberly and Paul? (3)

Date Title Comments Rating
2009-02-05 Where in the world does time go? 1 None
2008-10-03 Scotland is amazingly beautiful but, ah, the weather IS worse than Seattle! 1 None
2008-02-03 Our first trip of the New Year...Shanghai and Beijing 0 None

RSSWIT (2)

Date Title Comments Rating
2010-08-13 Women in Tech - a great post by Stacia Misner 0 None
2008-08-25 Resources: A panel on HA and a second on Women In Tech 0 None

RSSUncategorized (4)

Date Title Comments Rating
2009-07-10 Public SQL Server Immersion Event in Dublin in September 0 None
2006-06-04 Just wondering - what SQL Server version are you using in production? 23 None
2004-10-23 Per capita, I trained 34,000 people this week! 0 None
2004-06-24 Events, Events, Events!!! 0 None

Total

245 posts
826 comments
0 raters

Theme design by Nukeation based on Jelle Druyts