Sunday, July 31, 2016

Dimension Loading: Source sends same record with different Source ID

›
An interesting question was raised during my lecture today and it was related to dimension loading. The question was; how can we identify ...
Saturday, July 30, 2016

SQL Server Brain Basher of the Week #049 - SSIS Package Store

›
Let's talk about Integration Services in this week for Brain Basher. SQL Server supports two deployment models named Package Deploymen...
Friday, July 29, 2016

Fact Loading: Switching a loaded temporary table into an empty partition of the fact table

›
Fact table in data warehouses are always partitioned and with most of solutions, it is partitioned on a date key. Generally, we use SSIS f...
Thursday, July 28, 2016

SSIS - Fact Loading with Dimension Type II and Dimension Type I

›
The Dimensional Modeling in data warehousing, either using Star or Snowflake schema is still the most famous structure applied and widely ...
Wednesday, July 27, 2016

What is Table Value Constructor?

›
I am sure that many have used this without knowing the term. However it is always better to know the term before applying because that mak...
Tuesday, July 26, 2016

Result shows asterisk when converting int to varchar

›
I was sent a code by one engineer saying they he gets an odd error with one of calculations written. He gets the following error; Conv...
Sunday, July 24, 2016

SQL Server Brain Basher of the Week #048 - Dropping Clustered Index

›
SQL Server mainly maintains two structures for tables: Heap  and Clustered . If there is no clustered index created with the table, table ...
Saturday, July 23, 2016

Install SQL Server with just three clicks - The SQL Server Basic Installer

›
We have been installing SQL Server for long time, different versions and different editions. Everyone is familiar with installation wizard...
Friday, July 22, 2016

What is CATS, CRTAS and CETAS? - SQL Server CREATE TABLE AS SELECT

›
I am sure that everyone is well aware on SELECT INTO statement. This statement allows us to create a table using a SELECT statement just li...
Thursday, July 21, 2016

Two new Free SQL Server / PowerBI / Azure related books

›
There are two new free eBooks available for downloading those who want to learn Power BI and Azure SQL Database. Here are the links, worth ...
Wednesday, July 20, 2016

Handout to Resolve SQL Server Connectivity Issues [Guest Post]

›
This post is written by Andrew Jackson . Problem Statement While launching Microsoft SQL Server Management Studio, sometimes user ...
Tuesday, July 19, 2016

How to add a Watch Windows in SSIS

›
My post S SIS Progress / Execution Results Tab  talked about few things related to debugging and thought to add another post on it, specif...
Monday, July 18, 2016

SSIS Progress / Execution Results Tab

›
SQL Server Integration Services is The Enterprise ETL platform  that supports on all ETLing scenario. Covering from small data transfer to...
2 comments: