Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

February 2009 - Posts

Using BIDS 2008 to validate Analysis Services 2005 cubes
If you have experimented with cube design in SQL Server 2008, you will probably have run into the new AMO design warnings in Business Intelligence Development Studio 2008 (BIDS). We find that these warnings help customers a lot: they allow them to quickly Read More...
Posted: Thursday, February 26, 2009 11:25 AM by tkejser | 1 Comments
Filed under: , ,
New Version of Partition Management Utility Available
I’m happy to announce availability of an updated version of the SQL Server Partition Management tool – now offering full support for SQL Server 2008 as well as improvements in handling SQL Server 2005. The tool is available along with source code at http://www.codeplex.com/SQLPartitionMgmt Read More...
Posted: Monday, February 23, 2009 1:19 PM by stuarto | 1 Comments
Filed under: , ,
The Data Loading Performance Guide - Now available from MSDN
By popular request, the SQL Customer Advisory Team has collected our lessons learned about tuning data loading into a new whitepaper. We call it the “Data Loading Performance Guide” and you can find it on MDSN: http://msdn.microsoft.com/en-us/library/dd425070.aspx Read More...
Posted: Thursday, February 12, 2009 2:57 PM by tkejser | 1 Comments
Minimize downtime with DB Mirroring
At one high volume OLTP project we are involved in, the customer likes to use DB Mirroring to minimize downtime for planned failovers. This usually involves patching either Windows or SQL Server. The interesting part of this strategy is that they switch Read More...
Posted: Monday, February 09, 2009 8:55 PM by kevincox | 2 Comments
Page view tracker