Browse by Tags

• Community
• Conferences
• DTS
• Education
• Events
• Express
• fun
• High Availability
• Katmai
• KB
• New Features
• PASS
• Performance
• Review
• Social Networking
• SQL 2000
• SQL 2005
• SQL 2012
• SQL Community
• SQL Server Performance
• SSIS
• Upgrade
• User Group Meetings
• VM

• Some things don't change - DB Snapshots & Backups of Snapshots

  Again, I wanted to blog about something that still does not change between 2005 and 2008. At a recent conference, there were some great questions/ideas that should make it to Connect if they haven't already. When DB Snapshots were first introduced, one Read More... Posted Wednesday, May 07, 2008 11:40 AM by RickHeiges | 0 Comments Filed under: SQL 2008, SQL 2005, High Availability

• Some things don't change - Partitioning

  After spending the past couple of weeks at the MVP Summit in Seattle and at SQL Connections in Orlando, I thought I should blog about things that do not change in 2008 (at least partially). One of the reason s to partition your tables is to make it more Read More... Posted Sunday, April 27, 2008 8:09 PM by RickHeiges | 0 Comments Filed under: SQL 2008, Katmai, High Availability

• Filtered Indexes

  In SQL Server 2008, you can have what is called a "Filtered Index". What does this mean? An index may be created for a subset of rows in your table. For instance you could create a filtered index for a "state" column if the value is "CA" for California; Read More... Posted Tuesday, March 18, 2008 1:47 PM by RickHeiges | 2 Comments Filed under: SQL Server Performance, SQL 2008, Katmai, New Features

• Happy Launch Day!

  It's Official, today! We have a party for SQL Server 2008 in LA! The product may not be shipping, but that won't stop us from having our party. Seriously, Today marks the beginning of a more useful Launch than the 2005 launch. What am I saying? The Launch Read More... Posted Wednesday, February 27, 2008 12:56 PM by RickHeiges | 0 Comments Filed under: SQL Community, Education, Events, Community, SQL 2008, Katmai

• In case you did not hear, PASS Call for Speakers is now open!

  In the latest PASS Community Connector, there is a call for Speakers for this year's summit in Seattle in November. If you have never been to Seattle in November, it really makes you want to learn more about SQL Server in the breakout sessions. ;-) But Read More... Posted Friday, February 22, 2008 8:39 AM by RickHeiges | 2 Comments Filed under: SQL Community, Education, Events, Community, Conferences, SQL 2008, User Group Meetings, SQL 2005

• 3 More Weeks 'til Launch!

  3 weeks from today, the launch party for SQl Serve 2008 will be on! If you are in Southern California, you will be in the "happening" spot. Enjoy! Why have a launch without the release of the product? SQL Server 2008 is more of an incremental release. Read More... Posted Wednesday, February 06, 2008 10:57 AM by RickHeiges | 1 Comments Filed under: SQL Community, Education, Events, Community, SQL 2008, Katmai, User Group Meetings

• Get Ready for SQL Server 2008!

  On Jan. 24, there is a FREE virtual conference focused on SQL Server 2008. This is not just a webcast that you can view online. The sessions are scheduled at specific times with Live Q&A following the session from the speakers. Grab one of your SQL Read More... Posted Saturday, January 19, 2008 10:13 AM by RickHeiges | 1 Comments Filed under: SQL Community, Education, Events, Community, Conferences, SQL 2008, Katmai, SQL 2005

• Try out SQL 2008 without downloading it!

  In case you have not heard yet....... SQL Server 2008 CTP5 Beta Now Available for Free in a Secure Hosted Environment! PASS, MaximumASP, Dell and Intel have partnered to offer this advance preview... Try out real-world data online in a secure, hosted Read More... Posted Wednesday, January 09, 2008 10:25 PM by RickHeiges | 3 Comments Filed under: SQL Community, Education, Community, SQL 2008, Katmai

• No More HCL - in 2008

  The old Hardware Compatibility List which was renamed the "Windows Catalog" is no more. When creating a Clustered Solution, you need to have a system that is Certified for clustering or there will be no official support. This has been a point of pain Read More... Posted Wednesday, December 19, 2007 10:25 AM by RickHeiges | 0 Comments Filed under: SQL Community, SQL 2008, Katmai, High Availability, New Features

• Compression in DB Mirroring

  When you start to look at SQL Server 2008, there is a sub-theme of using compression to help drive performance and usefulness. When I hear the word compression, my first thought is "No - I remember Stacker". How many years ago was that obscure reference? Read More... Posted Tuesday, November 20, 2007 7:19 AM by RickHeiges | 4 Comments Filed under: SQL 2008, Katmai, High Availability, New Features

• Who's got your DB's back?

  While I was reviewing one of the sessions from the PASS Community Summit using the streaming media on some new things in SQL Server 2008, I stumbled across a new reason to mirror. The primary reason to mirror of course is availability and to give DBAs Read More... Posted Friday, November 09, 2007 10:05 AM by RickHeiges | 1 Comments Filed under: Conferences, SQL 2008, High Availability

• Seemless Upgrade or "seem" less like an upgrade

  Last week at the PASS Community Summit, I was so busy that I did not get a chance to blog about anything. Looking back, I had a great time and learned a few things. In one of the keynotes, I heard MSFT say that the upgrade experience from 2005 to 2008 Read More... Posted Wednesday, September 26, 2007 7:37 AM by RickHeiges | 0 Comments Filed under: SQL Community, Conferences, SQL 2008, Katmai

• DTS still alive in 2008?

  I was on a call with several other folks the other day discussing "Katmai". The topic of DTS came up. MSFT had indicated that support for DTS would not go beyond SQL Server 2005 in a variety of channels. I can remember the dozens of Upgrade Advisor messages Read More... Posted Wednesday, August 22, 2007 6:55 AM by RickHeiges | 1 Comments Filed under: SQL 2008, Katmai, Express, SSIS, DTS

• PASS is next month!

  I can't believe it. The PASS COmmunity Summit is only a month away! Check out the strong SQL Server content at www.sqlpass.org and register today. BI is a growing part of your business and is also a growing part of the content that you will find in Denver Read More... Posted Wednesday, August 15, 2007 11:45 AM by RickHeiges | 0 Comments Filed under: SQL Community, Events, Community, Conferences, SQL 2008

• Caught by the roving eye at TechEd, Catching Up on Katmai

  I was in Orlando for Tech for 2.5 days. It was great to see some old friends and make new ones too. I saw fellow SQLBloggers like Kalen, Kevin, and of course Peter to drop a few names. Today, a colleague of mine on the Board of Directors with PASS shot Read More... Posted Wednesday, June 13, 2007 10:52 PM by RickHeiges | 0 Comments Filed under: SQL Community, Events, Community, Conferences, fun, SQL 2008, Katmai