Big Data is one of the hottest topics on data systems nowadays. Many of organizations tries to find a clue to start work with Big Data, and there are many courses and conference sessions on Big Data. Microsoft as a Database and software vendor started to provide specific solutions for Big Data. In this post Read more about Introduction to Microsoft Big Data Solution – Microsoft HDInsight[…]
First of all; I wish a happy and Prosperous New Year for all of you my friends, family and visitors of my blog. I wish you all the best in 2013. Today I re-awarded for the 3rd times for Microsoft MVP Award in Microsoft SQL Server. I really appreciate support of all of you my Read more about I Re-Awarded MVP for 3rd year[…]
Following the previous PIVOT Transformation Tutorial which was in 2008 R2 and earlier versions of SSIS, I got some feedback recently to create new version of that Tutorial for PIVOT transformation in SSIS 2012. Fortunately Pivot Transformation GUI improved too much in SSIS 2012 and you don’t need to set PivotUsage in the Advanced Editor Read more about PIVOT Transformation – SSIS 2012 – Complete Tutorial[…]
Hi folks, Today I face a question regarding usage of OLE DB VS. ADO.NET Connection managers in SSIS, there are some blog posts about difference between connection providers and speed and performance of them. So I thought that this will be helpful if I list different Control Flow Tasks and Data Flow Components in SSIS Read more about Difference Between Connection Managers used in SSIS Control Flow Tasks and Data Flow Components[…]
Hi folks, I’ve changed the t-sql code for Capitalize function, the previous capitalize function worked only if there is one space between words, but this version works even if there be more than one space between words. with this version of Capitalize; you can run the function like this: select dbo.Capitalize(‘st charles‘) and this Read more about Capitalize Function (Version 2.0) – T-SQL[…]
T-SQL code (working in SQL Server) to replace duplicate spaces (or triple or more) with a single space is : declare @text varchar(max) set @text=’ St Charles’ while charindex(‘ ‘,@text)>0 set @text=replace(@text,’ ‘,’ ‘) select @text and the result is : St Charles
Hi folks, Yesterday I faced a situation in one of SSAS cubes, which dimension processing was failed because it found two different members with different attribute values, like Auckland and auckland ! I found out that reason of this problem is SSAS dimension will inherits its collation from underlying database and if you don’t change Read more about SSAS Dimension Processing: Be Careful about Case Sensitivity[…]
Hi folks, Today I faced a situation that I need to capitalize sentences in one column of a SQL Server database table, so I created a function to do that, I put this here to share with you. this function will change sentences like : select dbo.Capitalize(‘sample text for capitalization!‘) to : Sample Text For Capitalization! Here Read more about T-SQL Function for Capitalize Word and Sentences[…]
Hi Folks, In previous video of SQL Server 2012 Integration Services tutorial videos I’ll introduced SSIS as an ETL and Data Transfer tool, I’ve talked about Import and Export Wizard and we had a quick look at SSDT. In this video I talk about the structure of package and control flow tasks and the Execute Read more about SSIS 2012 Tutorial Vidoes – 2 : Introduction to Control Flow Tasks & Execute SQL Task[…]
Hi folks, I started to create a full set of tutorial videos for SSIS 2012 here. You can view the first video (Introduction to SQL Server 2012 Integration Services) here. This video covers below headlines: Introduction to SQL Server 2012 Integration Services Requirements for a Tool ETL What is SSIS Which Read more about SSIS 2012 Tutorial Vidoes – 1 : Introduction[…]