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.

Browse by Tags

PowerPivot for SharePoint Installation Guides DRAFT
The installation of PowerPivot for SharePoint can be a little complex at times - especially the PowerPivot for SharePoint multi-server farm scenario. In order to help with this, the Analysis Services team and the SQLCAT team came together and created Read More...
PowerPivot Jump Start!
As you may already know, the new name for Project Gemini is PowerPivot and the official names are PowerPivot for Excel and PowerPivot for SharePoint. For information and to sign up for notification on the release dates, check out the official PowerPivot Read More...
Are you going to SQL PASS Nov. 3rd- Nov. 5th?
Are you going to SQLPASS in Seattle on Nov 3 rd -Nov 5 th ? If you are going or even thinking about it, then read about how you can spend some quality time with the SQLCAT team. We will be there with our famous ugly lime green shirts, so you won’t miss Read More...
Looking deeper into SQL Server using Minidumps
Author: Thomas Kejser Reviewers and Contributors: Bob Ward, Michael Thomassy, Juergen Thomas, Hermann Daeubler, Mark Souza, Lubor Kollar, Henk van der Valk (Unisys) and Peter Scharlock For advanced troubleshooting and understanding of SQL Server, you Read More...
Using HierarchyID in SQL Server
Implementing a hierarchy structure in a relational data base normally takes a bit of work. The new SQL Server data type for hierarchyID gives a good shortcut to the old methods, makes it faster to get a solution in place and makes it much easier to maintain. Read More...
Gemini - Self Service BI!
Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI) capabilities being delivered in the SQL Server 2008 R2 release. Gemini enables end users to build BI applications by integrating data from a variety of sources, modeling, Read More...
Multi user SSAS writebacks may result to blocks on similar functions and new connections.
Author: Nicholas Dritsas Reviewers: Akshai Mirchandani, Kevin Cox, Lubor Kollar, Thomas Kejser Writeback consists of two distinct processes. The first one is an update cube process that updates the current session with the changes. Only the current user Read More...
Fast ordered delete
We have a visit from MySpace database team in our lab this week. I have used this opportunity and asked Kevin Stephenson, MySpace’s Senior Database Developer, about “pain points” he encounters while doing his everyday job supporting SQL Server. He brought Read More...
Assigning surrogate keys to early arriving facts using Integration Services
In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When Read More...
Proper partitioning can improve dramatically the writeback process when dealing with large data sets
Proper partitioning can improve dramatically the writeback process when dealing with large data sets Author: Nicholas Dritsas Reviewers: Richard Tkachuk, Akshai Mirchandani CASE : Customer is using SQL 2008 and SSAS's writeback abilties to do 52-weeks Read More...
SQL Resources for Compliance
Author : Denny Lee Reviewers : Prem Mehra, Kevin Cox With the terabytes of data that are being stored today - truly representing the data explosion that we've always talked about - it's becoming more and more difficult to provide an audit trail or utilize Read More...
Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
Author: Nicholas Dritsas Reviewers: Thomas Kejser, Stuart Ozer In SSAS 2005 and later, there is a dimension property called ProcessingGroup. It has two values; ByAttribute (default) and ByTable. When you use ByAttribute, SSAS will send a SELECT DISTINCT Read More...
Useful links for upgrading to SQL Server 2008
There is plenty of material available to help you upgrade to SQL Server 2008. This blog is intended as a short list for the most useful guidance that I have found. And you may have different experiences upgrading from SQL Server 2000 and SQL Server 2005 Read More...
Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008
Some customers prefer to upgrade to SQL Server 2008 by detaching all databases from their SQL Server 2005 instance and then reattaching them to a completely new SQL Server 2008 instance. If you choose this upgrade strategy, you should be aware that you Read More...
Analysis Services Partition Size
Thomas and I updated the SQL Server 2008 Analysis Services Performance Guide principally to address features available in the latest release. But there was one important change related to partition size driven by changes in hardware. The earlier version Read More...
More Posts Next page »
Page view tracker