Latest Power BI and AI articles from RADACAD team
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[…]
Few minutes ago I received the MVP Award email from Microsoft. this is my second year as SQL Server MVP. I believe that this award achieved because of my dedication in Microsoft BI Stack and SSIS. I like to thanks from all friends, other SQL Server MVPs and my dear Leila I want to use Read more about Microsoft SQL Server MVP Award for 2012[…]
Dear folks, I’ve submitted two sessions in SqlBits 10, with these topics: SSIS Programming; SSIS Can Do Everything! Boost SSIS power with XML Topics are in one hour sessions details of each topic are : SSIS Programming; SSIS Can Do Everything! Level: 400 Description: SSIS is a RAD tool and many SSIS Developers only need Read more about My Submitted Sessions for SqlBits 10[…]
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[…]
I will speak at SqlBits 9 At Liverpool about "Programming SSIS" The SqlBits 9 will start from 29 September to 1 October 2011 at Liverpool Adelphi Hotel. Full Agenda of event listed here. My Speaking session is at Saturday, 1st of October at 10:50 AM, with the "Programming SSIS" title. this is a short overview Read more about I will Speak at SqlBits[…]
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[…]
SSIS Denali 2011 CTP 3 released at 12 July 2011, you can get it from here, If you try SSIS Denali you will see a new task in Control flow, named Expression Task. In this post I’ll talk about the Expression Task; Expression Task created to do assignment on package variables or parameters. you can Read more about SSIS 2011 Denali Expression Task[…]