Browse by Tags

• authentication
• books online
• community
• Conferences
• connect
• DDL
• Documentation
• Education
• Events
• high availability
• hofixes
• Katmai
• object explorer
• product enhancements
• service packs
• SQL 2008
• SQL Community
• SQL Server Performance
• SSMS
• T-SQL
• User Group Meetings

• Connect Digest : 2009-05-30 : please vote!

  Here are some issues I came across recently; most involve SSMS in some way, though Erland's assertion suggestion is a great one. At the bottom I also compare the current vote counts + rating for the items I submitted last week. ==================== ASSERTIONS Read More... Posted Sunday, May 31, 2009 2:47 AM from Aaron Bertrand | (Comments Off) Filed under: T-SQL, SSMS, connect, New Features, product enhancements

• Connect Digest : 2009-05-23 : please vote!

  Here are the items from this week that I feel deserve some attention. I'm also adding a little bit of analysis to this. I am always curious if my vote-pimping has any effect, so I am going to start taking a note of the ratings at the time I publish the Read More... Posted Sunday, May 24, 2009 2:02 AM from Aaron Bertrand | (Comments Off) Filed under: T-SQL, connect, New Features, product enhancements, object explorer, DDL

• Connect Digest : 2009-05-16 : please vote!

  Here are the items from this week that I feel deserve some attention. ==================== Hotfixes / service packs should leave authentication mode alone I may have talked about this issue here before, I'm not sure, but I thought I was the only one who Read More... Posted Sunday, May 17, 2009 1:33 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, connect, authentication, New Features, books online, service packs, product enhancements, hofixes

• Come on, it's Saturday, get out and vote!

  I was encouraged by some fellow MVPs (well, mostly Alexander Kuznetsov ) to periodically post a set of Connect items to encourage voting for items that I found relevant but that are maybe being largely ignored. Saturday is probably my best opportunity Read More... Posted Sunday, April 19, 2009 4:07 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, connect, New Features, books online, product enhancements

• PASS Website Overhaul

  PASS has launched its new website. There has been a lot of hard work behind the scenes over the past year to be ready for this. Nothing ever goes as planned, but I believe that you will agree with me that the improvements made are huge. If you are not Read More... Posted Thursday, September 25, 2008 10:25 AM from Rick Heiges | (Comments Off) Filed under: community, SQL Community, Education, Events, Conferences, User Group Meetings, New Features

• 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

• 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 Thursday, December 20, 2007 12:25 AM from Rick Heiges | (Comments Off) 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 9:19 PM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, high availability, New Features