|
|
-
|
|
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice. Sometimes it is better to report off of the data warehouse that the cube is built from.
For example, say you want to create a P&L statement using a financial cube. You want it to look like a ......
|
|
-
|
|
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if you run into something similar:
A data warehouse has an advertising table that has these four fields: Product Type, Inches, Lines, Pieces. The Inches, Lines and Pieces fields will onl......
|
|
-
|
|
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and more companies want cube processing during the day instead of the usual off-hours time when no one is using the cube. Partitioning the cube can help to reduce the processing time. So can......
|
|
-
|
|
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......
|
|