Monthly Archives: December 2011

SSIS Community Tasks and Components

Posted on December 30, 2011 by

Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free?  Why re-invent the wheel?  Take a look at this exhaustive list created by Todd McDermid on CodePlex: SSIS Community Tasks and Components.  It … Continue reading →

Posted in SQLServerPedia Syndication, SSIS | Leave a comment

SQL Server 2012 (“Denali”): Master Data Services

Posted on December 28, 2011 by

SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012: Improved web user interface – If you are a current user of MDS in SQL Server 2008 R2 you know that it’s pretty difficult to … Continue reading →

Posted in DQS, MDS/MDM, SQL Server 2012, SQLServerPedia Syndication | 1 Comment

SQL Server 2012 (“Denali”): New Security Features

Posted on December 23, 2011 by

SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups, Audit enhancements, and User-Defined Server Roles. Default Schema for Windows Groups A database schema can now be tied to a … Continue reading →

Posted in Security, SQL Server, SQL Server 2012, SQLServerPedia Syndication | 1 Comment

SQL Server 2012 (“Denali”): AlwaysOn

Posted on December 21, 2011 by

AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters to help enable fast application failover during planned and unplanned downtime.  Specifically, AlwaysOn delivers failover cluster instances, multiple secondaries, active … Continue reading →

Posted in SQL Server, SQL Server 2012, SQLServerPedia Syndication | 3 Comments

Junk dimensions

Posted on December 19, 2011 by

Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators.  When designing a data warehouse, you might come across a source system that has a bunch of yes/no indicator fields.  If those fields needs to be tracked … Continue reading →

Posted in Dimensions, SSAS | Leave a comment

Factless fact table

Posted on December 16, 2011 by

A factless fact table is a fact table that does not have any measures.  It is essentially an intersection of dimensions (it contains nothing but dimensional keys). There are two types of factless tables:  One is for capturing an event, … Continue reading →

Posted in SQLServerPedia Syndication, SSAS | 1 Comment

TechNet Virtual Labs

Posted on December 14, 2011 by

There is an excellent site called TechNet Virtual Labs that enables you to quickly and easily evaluate Microsoft’s newest products and technologies via hands-on labs in which you are guided through the lab in about 90 minutes. There is nothing to … Continue reading →

Posted in SQLServerPedia Syndication, Training | Leave a comment

Top SSAS white papers

Posted on December 12, 2011 by

These are my favorite SSAS white papers released by Microsoft, with many from SQLCAT.  I’ll keep this post updated with new versions of the white papers as well as new ones that come along that I find useful: Analysis Services 2008 … Continue reading →

Posted in SQLServerPedia Syndication, SSAS | Leave a comment

Reduce heap table fragmentation

Posted on December 9, 2011 by

A table that does not have a clustered index is referred to as a Heap.  While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication | Leave a comment

Create SQL Server scripts with Visio 2010

Posted on December 7, 2011 by

If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to learn there is not a way to build CREATE TABLE scripts from your resulting diagram.  The last release that supported … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication, Visio | 6 Comments