T-SQL Script: Find Keyword in whole Database

Posted by on May 22, 2012 in SQL Server, T-SQL | No Comments

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

MCITP – Business Intelligence Developer 2008

Posted by on Apr 29, 2012 in SQL Server | No Comments

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

MCTS – SQL Server 2008, Business Itelligence Development and Maintenance

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

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

SQL Server 2012 Finally

Posted by on Mar 6, 2012 in SQL Server | No Comments

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.

Read More

SQL Server 2012 Future Exams

Posted by on Feb 22, 2012 in SQL Server | No Comments

Hi folks, Seems SQL Server 2012 beta exams will be available soon, but actual exams will be released at June 2012. The BI part seems to be much more design and architecture oriented in these new exams, and I am happy for that. Because current BI exams are completely technology and tool oriented. These are ...

Read More