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[…]
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[…]
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[…]
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[…]
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[…]
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[…]
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)[…]
Hi folks, the event schedule of SQL Saturday 136 of ANZ 2012 defined already, This event will be in Wellington at 14 April, Agenda of 14 sessions listed here. You can register for this free tutorial day of SQL Server and enjoy it. there are a range of good SQL Server speakers there which I Read more about My Session at SQL Saturday 136 Wellington[…]
Hi friends, after about 7 month hardworking I wants to inform you that my upcoming book about SSIS 2012 will be published about 1 month later, So I like to share the link of the book here. Pedro Perfeito one of my friends who is a SSIS expert and also SQL Server MVP in Portugal Read more about My new SSIS 2012 Book Will be Published Soon[…]
Hi folks, Finally SQL Server 2012 Virtual Launch event comes at 7th of Mar 2012, go here to find more: www.sqlserverlaunch.com?WT.mc_id=otc-n-ca-loc–40210 I will be there also to help you and would be happy to meet you and show you SQL Server 2012 great new features.