Browse by Tags

• Beyond Relational
• books online
• community
• Conferences
• connect
• debugger
• DMVs
• dts
• Education
• Events
• Express
• fun
• high availability
• Management Studio
• New Features
• notification services
• over()
• Registered Servers
• Screencast
• SQL 2000
• SQL 2005
• SQL 2008
• SQL Community
• SQL Server 2008
• SQL Server Performance
• ssis
• SSMS
• ssns
• surface area
• upgrade
• User Group Meetings

• How do the links in YOUR copy of SQL Server 2008 Books Online work?

  I am just taking a quick show of hands; and maybe some information, if you are willing. (And if this hasn't happened to you, I apologize for taking up your time.) I have had various problems on multiple installations of Books Online throughout the entire Read More... Posted Sunday, July 20, 2008 9:55 AM from Aaron Bertrand | (Comments Off) Filed under: Katmai, SQL Server 2008, books online

• It's Q3 - where is SQL Server 2008?

  Microsoft has publicly stated that SQL Server 2008 will RTM in Q3. It is Quarter 3 now. Where is it? :-) I'm sure that the final touches will now get taken care of now that Bill Gates is no longer a full-time MSFT employee. I'm sure that his "short-timer" Read More... Posted Thursday, July 03, 2008 2:02 PM from Rick Heiges | (Comments Off) Filed under: fun, SQL 2008, Katmai

• Are You Ready for SQL Server 2005? Use Upgrade Advisor for 2008!

  If you have systems that are stil on SQL Server 2000 and that you are preparing for SQL Server 2005, run the Upgrade Avisor for SQl Server 2008 as well. So, while you are under the hood of your database and app getting it ready for 2005, get it ready Read More... Posted Wednesday, June 11, 2008 11:18 PM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, upgrade, SQL 2000

• SQL Server has a new logo

  SQL Server's new logo has been published: Courtesy of Wesley from http://blogs.msdn.com/wesleyb/archive/2008/06/03/sql-server-logo.aspx Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Wednesday, June 04, 2008 7:51 AM from Aaron Bertrand | (Comments Off) Filed under: Katmai, SQL Server 2008

• 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 Monday, April 28, 2008 9:09 AM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, high availability

• SQL Server 2008 is getting close... I can smell it!

  No, this is not a "funny funny, ha ha!" April Fool's Day post (though I do find those entertaining, and considered posting one myself). This is for real, and it almost made me tingle a little. I saw this comment from Eric Kang in a Connect item yesterday Read More... Posted Tuesday, April 01, 2008 11:05 PM from Aaron Bertrand | (Comments Off) Filed under: Katmai, SQL Server 2008

• 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 Wednesday, March 19, 2008 2:47 AM from Rick Heiges | (Comments Off) Filed under: SQL Server Performance, SQL 2008, Katmai, New Features

• Increased limits for columns / indexes / statistics

  I am still on the fence about whether this is a good thing or a bad thing. However, in the next build of SQL Server 2008 you will be able to get your hands on, you will find that some element limits have changed, just a bit. With the introduction of sparse Read More... Posted Wednesday, March 12, 2008 4:33 AM from Aaron Bertrand | (Comments Off) Filed under: Katmai, SQL Server 2008

• 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 Thursday, February 28, 2008 2:56 AM from Rick Heiges | (Comments Off) Filed under: community, SQL Community, Education, Events, SQL 2008, Katmai

• 16 Changed Dynamic Management Views in SQL Server 2008

  Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008 ; previously, I had noticed that a few of the existing DMVs from 2005 had changed slightly. So, Denis sparked my curiosity, and I ran the following query on a recent build of SQL Server Read More... Posted Thursday, February 07, 2008 11:46 PM from Aaron Bertrand | (Comments Off) Filed under: Katmai, SQL Server 2008, DMVs

• 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 Thursday, February 07, 2008 12:57 AM from Rick Heiges | (Comments Off) Filed under: community, SQL Community, Education, Events, 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 Sunday, January 20, 2008 12:13 AM from Rick Heiges | (Comments Off) Filed under: community, SQL Community, Education, Events, Conferences, SQL 2008, Katmai, SQL 2005

• Katmai's 3 Blunders

  an open blog post to the SQL Server product managers... Katmai is a great release of SQL Server, new features are a clear evolution of the core product. I like Katami more than Yukon. But, I see three 'areas of opportunity': 1) Not including full support Read More... Posted Saturday, January 19, 2008 4:44 AM from Paul Nielsen | (Comments Off) Filed under: Katmai, debugger, over(), surface area

• 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 Thursday, January 10, 2008 12:25 PM from Rick Heiges | (Comments Off) Filed under: community, SQL Community, Education, SQL 2008, Katmai

• Screencast: Katmai SSMS Manage Multiple Servers

  Katmai Management Studio has the Way Cool ability to send T-SQL to multiple servers with a single F5 Execute. Watch the Screencast (4:00). Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Friday, January 04, 2008 4:51 PM from Paul Nielsen | (Comments Off) Filed under: Katmai, SSMS, Screencast, Management Studio, Registered Servers