|
|
-
|
|
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what events you were going to log, which containers you were going to collect logs for, and where you were going to store those logs.
In SSIS for SQL Server 2012 that all goes away. ......
|
|
-
|
|
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right tools is vital to keeping me productive. The tools used for conferencing should have IM, presence indicator, voice and video calls, desktop sharing, file transfer and ad hoc conferences......
|
|
-
|
|
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it is strongly recommended that surrogate keys be created and used for primary keys for all dimension tables instead of using natural keys. Surrogate keys are keys that are main......
|
|
-
|
|
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in ......
|
|
-
|
|
ETL is the most common method used when transferring data from a source system to a data warehouse. But there are cases where you might want to use ELT. What is the difference between the two? Read on:
Extract, Transform, and Load (ETL) is a process that involves extracting data from outside sou......
|
|
-
|
|
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 navigate and feels like a “1.0″ version. In SQL Server 2012, it......
|
|
-
|
|
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 Windows Group rather than an individual user in o......
|
|
-
|
|
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, mul......
|
|
-
|
|
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, and one is for describing conditions.
An event establishes the......
|
|
-
|
|
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 R2 Performance Guide
SQL Server 2008 R2 Analysis Services Op......
|
|