Creating Dimension Table ==> Time (Example)

Script for Dimension table for Time.
Here Date_ID is the primary key which can be used as the foreign key...

Parallel Data Warehouse (PDW) Tip: Useful Appliance Queries

This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance...

SQL Saturday 207 Yaounde Cameroon

SQL Saturday 207 Yaoundé Cameroon, is holding its first SQL Saturday on June 8th. Due to the remoteness from the...

SQL Saturday Total NOVICE sessions

Have you ever been to a SQL Saturday where someone 'rocks up' for a beginner's presentation. In fact he or...

In which we compare CISPA to Rick Astley

Wherever you click, either CISPA or Rick Astley is there…
I’m studying up on CISPA for a segment on our webshow....

Linked Server created using a script is missing Product name and Data source fields !

Today I will discuss about an issue which was observed while creating a linked server via script.
The existing linked server was scripted...

Doing Your Job

I wish this were the mantra of all people, but certainly those in technology:

Filed under: Blog Tagged: career, syndicated

Reblog: April 12 to April 18

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Upcoming April speaking engagements

I have a very busy next week in the works! Here are the upcoming speaking engagements that I am working...

SQL Server – Differences between Clustered and Non-Clustered Indexes

Both Clustered and Nonclustered Indexes have same physical structure in SQL Server. Both are stored as a B-Tree structure in...