When connecting to a SQL Server instance in SQL Server Management Studio, there are built in reports for databases you can use for free. These RDL...
5 Database Reports In SQL Server Management Tools
read more
Thomas LeBlanc
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to...
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling...
Analysis Services: Solving Hierarchy Errors of Uniqueness
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group...
Cost Threshold and Max Degree of Parallelism
SQL Server has many options for configuring a database system. Most do not become apparent until some part of the system does not function...