Latest Power BI and AI articles from RADACAD team
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[…]
Hi folks, I’ll speak about Master Data Services at Microsoft Venue in Auckland on 9th of October of 2012. Session Topic and description: Managing Reference Data with Master Data Services In most of companies there are some reference data which are in use from different applications and databases, This reference data should be consistent and Read more about Speaking about Master Data Services[…]
Hi folks, I am speaking a 50 minute session on SSIS Catalog in Action at NZ CodeCamp 2012 in Auckland at 9th September. If you are attending there just come to me and say hi. New Zealand Code Camp 2012 will be running at 9th September at Auckland (University of Auckland, Business School). Sessions organized Read more about I am Speaking at NZ CodeCamp 2012: SSIS Catalog in Action[…]
Hi folks, I want to give you a heads up about my new course which will be presented at 15-16 of November in Auckland. Title of Course is : Microsoft SQL Server 2012 for the Oracle DBA. Registration are open now under this website: http://www.auldhouse.co.nz/courses-schedules/vendors/microsoft-technical/sql-server/microsoft-sql-server-2012-for-the-oracle-dba This is a 2 day course, and I and Dave Read more about I am Trainer of SQL Server for the Oracle DBA Course[…]
In previous post of SSIS 2012 Catalog series, I talked about Logging and query log tables from Catalog. In this post you will read more about Operations tables about different tasks like deploy project with detailed information about each operation. I also provide some helper tables to help for writing more descriptive queries on operation Read more about SSIS Catalog: Part 6 – Operations[…]
In previous blog post of SSIS Catalog series, I talked about how to execute a package, and what are tables in SSISDB which store information about execution of package. In this post I will talk about logging in SSIS 2012, and different logging options and how we can set logging level at the time of Read more about SSIS Catalog: Part 5 – Logging and Execution Reports[…]