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 about SQL Server 2012 Future Exams[…]
Hi, Today one of my colleagues in company faced a problem, He wants to split a text field by a delimiter character. This motivate me to write a Split function for my own use and put it here for help others. Suppose that our Primary Data is like this image and delimited by single slash Read more about T-SQL Split Function : Split Field By a Delimiter[…]
Regular Expressions are very useful expressions for text processing there are many usages like validation a text against a pattern or find appropriate parts of text with defined patterns which can be solved with Regular Expressions. To find out more about Regular Expressions read here. Today I find a simple case of such things in Read more about Regular Expression in SSIS[…]
Messaging is one of the most useful features of SSIS. Actually if you want to make a robust and fault tolerant package you need to design logging on errors and warnings properly. there are some options for send notifications in SSIS; Send Mail Task, Script Task ( scripting exactly any type of message ) and Read more about Notify Operator Task – SSIS[…]
Finally the SQL Server MVP Deep Dive Volume 2 going to be available soon . This book is all about SQL Server, but not an ordinal book about SQL Server from begin to end or on special aspect of SQL Server. This book covers 5 major topics of SQL Server ( Architecture and Design, Administration, Read more about My Contribution in SQL Server MVP Deep Dive Volume 2[…]
There are lots of times which you need a "Gregorian to Persian ( Shamsi ) Converter" in t-sql. below code will convert gregorian date string for example 2011-08-25 to persian or shamsi date string for example 1390-06-03 . just note this code will work on sql server 2005 or above because I used the Floor Read more about T-SQL Gregorian To Persian Converter[…]
Using dynamic t-sql is one of the good abilities in SQL Server, and there are times which you need to do this in SSIS. Suppose you have a data stream in SSIS Data flow task and you want to run a dynamic t-sql query per each data row values, probably your first stop is OLE Read more about How To Run Dynamic T-SQL In SSIS OLE DB Command[…]
This is a very common question everywhere; how can I check if data is exists in destination table then update it, otherwise insert new records. This Scenario named Upsert in common ( Update / Insert ), there are lots of ways to do it, but in this post I’ll describe how to do it with Read more about SSIS Upsert With Lookup Transform[…]
Dear friends, I’ve submitted two sessions at http://www.sqlbits.com for 29th September to 1st October 2011 at Liverpool. sessions are open to vote already, and you can vote any sessions you like, for voting you can go here and vote from 108 sessions. my submitted sessions are : Programming SSIS SSIS Programming seems to be a Read more about My Submitted Sessions to SqlBits[…]
The Audit Transformation in SSIS Data Flow task purposed to fetch some of system variables besides data stream columns to create a log for data stream, You can audit transformation with source columns to have columns data besides audit information like guid of package, name of data flow task, time of execution and few other Read more about SSIS Audit Transformation[…]