Script for Creating and Generating members for Date Dimensions: General Purpose

Posted by on Jan 9, 2013 in Business Intelligence, ETL, SQL Server, T-SQL | No Comments

Date Dimension can be found in every Data Warehouse, because Date dimension is one of the most important factors of each operational system that users like to view reports based on date dimension. So the importance and requirement to a date dimension persuade me to write a t-sql script to generate records for date dimension. ...

Read More

Capitalize Function (Version 2.0) – T-SQL

Posted by on Oct 28, 2012 in SQL Server, T-SQL | No Comments

Hi folks, I’ve changed the t-sql code for Capitalize function, the previous capitalize function worked only if there is one space between words, but this version works even if there be more than one space between words. with this version of Capitalize; you can run the function like this: select dbo.Capitalize(‘st    charles‘) and this ...

Read More

T-SQL Function for Capitalize Word and Sentences

Posted by on Oct 25, 2012 in SQL Server, T-SQL | No Comments

Hi folks, Today I faced a situation that I need to capitalize sentences in one column of a SQL Server database table, so I created a function to do that, I put this here to share with you. this function will change sentences like  : select dbo.Capitalize(‘sample text for capitalization!‘) to : Sample Text For Capitalization! Here ...

Read More

Speaking about Master Data Services

Posted by on Sep 27, 2012 in MDS, SQL Server | No Comments

Hi folks, I’ll speak about Master Data Services at Microsoft Venue in Auckland on 9th of October of 2012. Session Topic and description: Managing Reference Data with Master Data Services In most of companies there are some reference data which are in use from different applications and databases, This reference data should be consistent and ...

Read More

I am Trainer of SQL Server for the Oracle DBA Course

Posted by on Aug 28, 2012 in Presentations, SQL Server | No Comments

Hi folks, I want to give you a heads up about my new course which will be presented at 15-16 of November in Auckland. Title of Course is : Microsoft SQL Server 2012 for the Oracle DBA. Registration are open now under this website: http://www.auldhouse.co.nz/courses-schedules/vendors/microsoft-technical/sql-server/microsoft-sql-server-2012-for-the-oracle-dba This is a 2 day course, and I and Dave ...

Read More

SSDT as a Database Schema Compare Tool

Posted by on Jul 15, 2012 in SQL Server, SSDT | No Comments

Today I want to write about new feature in SSDT (SQL Server Data Tools) to compare two databases in term of structure. With a free installation of SSDT you can have ability to compare two SQL Server databases and review changes, create changes script and apply it on destination database. there are some options also ...

Read More