Blogs

Browse by Tags

• Maintenance
• PASSMN
• Presentation Materials
• Programming
• SQL Server 2005 Optimizer Enhancements
• SQL Server 2008
• SQL Server Integration Services
• SQL Server Memory

• Moving Day...

  Thanks all for reading my intermittent missives on SQL Server. I am in the process of wrapping up wtih Digineer, which means wrapping up this blog. I will continue to blog with www.sqlblog.com , where I have been cross-posting for the past month. Read More... Posted Wednesday, August 15, 2007 9:34 PM by Lara Rubbelke | 0 Comments

• Smart Index Defragmentation for an ONLINE World

  One of the many reasons I why I love consulting is the constant evolution and challenge. You may have something that works “just fine” until a new customer simple states “This is great. Can you make it do XYZ too?” I love those “could you just” statements, Read More... Posted Monday, July 30, 2007 8:48 AM by Lara Rubbelke | 2 Comments Filed under: Maintenance Attachment(s): RebuildIndex_SmartOnline.zip

• Memory Pressure on 64 Bit SQL Server 2005

  Do you remember the days when you first started learning about 64 bit capabilities and dreaming of the day when you were no longer confined by the barriers of the 32 bit virtual address space? Those ideas produced dreams of a truly capable scale up solution. Read More... Posted Sunday, July 15, 2007 10:07 PM by Lara Rubbelke | 2 Comments Filed under: SQL Server Memory

• New MVP!

  Wow! I received a great email from Microsoft yesterday with a subject "Congratulations! You have received the Microsoft MVP Award". Exciting, humbling, inspiring, and motivating. Wow – did I say that already? The SQL Server MVPs are part of an extraordinary Read More... Posted Monday, July 02, 2007 8:26 AM by Lara Rubbelke | 6 Comments

• After Tech Ed... Whew! What a week!

  Back from Orlando, exhausted and excited! I arrived last night, and slept for 11 hours straight! It was an incredible week with a lot of product news (more on that below), insightful discussions, and a lot of catching up with friends from afar (and friends Read More... Posted Sunday, June 10, 2007 8:50 AM by Lara Rubbelke | 0 Comments Filed under: SQL Server 2008

• In Anticipation of Tech-Ed 2007

  Well, I am making my final adjustments to demos and slides as I prepare to leave for Orlando. Tech-Ed begins Monday, and it promises to be another big year! If you will be at Tech-Ed this year, be sure to stop over to say hi. I will be at the Ask The Read More... Posted Friday, June 01, 2007 2:02 PM by Lara Rubbelke | 0 Comments

• A couple of new resources

  Wow, it has been a long time since I posted to my blog! Well, it isn’t because I have been lazy. I have actually been quite busy writing the past couple of months, although my blog has not been benefiting from this flurry of writing activity. My team Read More... Posted Sunday, March 04, 2007 5:12 PM by Lara Rubbelke | 0 Comments

• PASS Summit 2006 Session: Securing Your Data with SQL Server 2005 Encryption

  Thank to all who attended our session on securing data using SQL Server 2005. As promised, attached are the demo scripts and the presentation. I included the script used to represent the EncryptByPassPhrase function where the text is exposed in Profiler Read More... Posted Wednesday, November 15, 2006 6:16 PM by Lara Rubbelke | 3 Comments Filed under: Presentation Materials Attachment(s): 301PASSEncryption.zip

• Maximum Degree of Parallelism and Hyperthreading

  For those who are challenged with deciphering how to configure the max degree of parallelism on a server where hyperthreading is enabled, the max degree of parallelism configuration is based on physical processors and not logical processors. I recently Read More... Posted Monday, November 13, 2006 10:13 AM by Lara Rubbelke | 1 Comments Filed under: SQL Server 2005 Optimizer Enhancements

• PASSMN Meeting on October 17

  What fun! A pure database topic and a pure BI topic. Should be a fun evening for those who are challenged to settle in one camp or another. Topic Advance SQL Backup solution at nth degree Details Do you really have your backup solutions tuned to its nth Read More... Posted Sunday, October 08, 2006 3:02 PM by Lara Rubbelke | 0 Comments Filed under: PASSMN

• Launch of Visual Studio Team Edition for Database Professionals

  Sign up now for the Microsoft Launch of Visual Studio Team Systems for Database Professionals. http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032310684&Culture=en-US It looks like a rousing lineup of presentations. Joining Forces: Assimilating Read More... Posted Thursday, October 05, 2006 10:26 AM by Lara Rubbelke | 1 Comments Filed under: Programming

• August PASSMN Meeting

  Upcoming PASSMN meeting information below. My esteemed colleague Stan Sajous will be co-presenting with me on Encryption in SQL Server 2005. The topic focuses specifically on resolving performance issues in a scalable encryption scenario. Hope to see Read More... Posted Monday, August 21, 2006 8:34 PM by Lara Rubbelke | 2 Comments Filed under: PASSMN

• Great Post on SSIS Destinations + More Information

  One of my favorite blogs on SQL Server Integration Services (SSIS) is by Jamie Thompson. He does a tremendous job sharing tips, tricks, and lessons learned from working with SSIS. Recently he posted a blog on three of the destination adapters and the Read More... Posted Sunday, August 20, 2006 10:15 PM by Lara Rubbelke | 4 Comments Filed under: SQL Server Integration Services

• Smart Index Defrag/Reindex for a Consolidated SQL Server 2005 Environment

  (Update: An ONLINE version of this procedure is now available) I am sure we all have our own version of a "smart" reindex script for SQL Server 2000. This is a script that assesses the current level of fragmentation, and only executes a reindex or indexdefrag Read More... Posted Wednesday, August 16, 2006 10:15 PM by Lara Rubbelke | 32 Comments Filed under: Programming, Maintenance Attachment(s): RebuildIndex_Smart_Update.zip

• Monitoring SQL Server Using SQL Server Business Intelligence

  Thanks to all who attended the presentation at TechEd and at PASSMN. For all who are interested, attached are the projects to support the Analysis Services cubes and Reporting Services reports demonstrated during the presentation. Have fun! Read More... Posted Wednesday, June 14, 2006 8:28 PM by Lara Rubbelke | 1 Comments Filed under: Presentation Materials Attachment(s): PerformanceAnalysisReports.zip