My Session at SQL Saturday 136 Wellington

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[…]

My new SSIS 2012 Book Will be Published Soon

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[…]

SQL Server 2012 Future Exams

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[…]

T-SQL Split Function : Split Field By a Delimiter

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 Expression in SSIS

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[…]

My Contribution in SQL Server MVP Deep Dive Volume 2

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[…]

T-SQL Gregorian To Persian Converter

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[…]