T-SQL Function for Capitalize Word and Sentences

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 about T-SQL Function for Capitalize Word and Sentences[…]

Speaking about Master Data Services

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 about Speaking about Master Data Services[…]

I am Trainer of SQL Server for the Oracle DBA Course

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 about I am Trainer of SQL Server for the Oracle DBA Course[…]

SSDT as a Database Schema Compare Tool

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 about SSDT as a Database Schema Compare Tool[…]

Book Published: Microsoft SQL Server 2012 Integration Services: An Expert Cookbook

Hi folks, As I mentioned previously,َ Today I am happy to inform you that my book on SSIS 2012 published already, Me (Reza Rad) with my friend (Pedro Perfeito) who is another SQL Server MVP from Portugal wrote a book on SSIS 2012,we had Phil Brammer as technical reviewer. and book published already, If you Read more about Book Published: Microsoft SQL Server 2012 Integration Services: An Expert Cookbook[…]

T-SQL Script: Find Keyword in whole Database

There are some times that you need to find all occurrence (or some of them) of a keyword in all columns/tables in a database, This is a usual scenario in data profiling. I wrote script below to fulfill this requirement, this script will search for specific keyword in all columns and tables of a database Read more about T-SQL Script: Find Keyword in whole Database[…]

My Presentation on New Features of SSIS 2012 – Auckland SQL User Group

Hi folks, I had a presentation on New Features of SSIS 2012 on Auckland SQL User Group at Microsoft NZ venue at 16 May 2012. in following you will find more details about my presentation Session Topic: New Features of SSIS 2012 Description: SQL Server Integration Services (SSIS) is a leading tool in the data Read more about My Presentation on New Features of SSIS 2012 – Auckland SQL User Group[…]

MCITP – Business Intelligence Developer 2008

Today I want to talk about exam 70-452 which is PRO exam for achieving MCITP BI 2008. for sitting on this exam you should pass 70-448 (MCTS – BI 2008) as first step. exam 70-452 access your solution design abilities with Microsoft SQL Server 2008 to create Business Intelligence technologies. exam may contains 64 questions Read more about MCITP – Business Intelligence Developer 2008[…]

MCTS – SQL Server 2008, Business Itelligence Development and Maintenance

In this post I will talk about MCTS BI 2008; Microsoft certification plan for Business Intelligence in SQL Server 2008 contains two exams: 70-448 ; MCTS (Microsoft Certified Technology Specialist) – SQL Server 2008, Business Itelligence Development and Maintenance 70-452 ; MCITP (Microsoft Certified IT Professional) – Business Intelligence Developer 2008 so if you want Read more about MCTS – SQL Server 2008, Business Itelligence Development and Maintenance[…]

My Session at SQL Saturday 136 – New Features of SSIS 2012 (Presentation and Demo)

Hi folks, April was busy month for me, I was finishing the book from one side, preparing presentation for SQL Saturday 136 and attending at Microsoft exam from other side! SQL Saturday 136 ran at 14 April at Wellington – New Zealand with 14 session, and that was good opportunity for me to meet Rob Read more about My Session at SQL Saturday 136 – New Features of SSIS 2012 (Presentation and Demo)[…]