Hi folks, I am glad that I’ve been awarded for another year as SQL Server MVP. this is my fourth year as MVP and I’m proud to be part of this community and share technologies that I’m passionate about to people. I believe I’ve got this award because of my contribution on online communities, writing Read more about Recognized as MVP for 2014[…]
2014 is coming and like many of you I have some resolutions for the New Year. Before that I wish you a new year full of success and happiness. Year 2013 was a year that I did some speaking on webinars such as PASS DWBI virtual chapter, I’ve also done some international speaking such as Read more about Year 2014 Resolution[…]
Almost a year ago I published first version of T-SQL script to generate and populate a general purpose date dimension here. Today I want to publish the second version of that date dimension which has some corrections (fiscal calendar calculation fixed), and additional attributes (such as current year, current month, and current day) Multiple countries Read more about Script to Generate and Populate Date Dimension Version 2: Adding Multiple Financial Years[…]
Most of you faced such situation that you’ve set the FormatString property of your measures in the cube from BIDS or SSDT, But when you browser the cube in Excel you will not see that format. Let’s say you applied format string to add thousands separator, two decimal points, and dollar sign to your Amount Read more about Format String Issue of SSAS Measures in Excel Front-End[…]
Thanks for all attendees in my session about Master Data Management with SQL Server 2012 as part of NetCom Learning free webinars. In this session below contents covered: Creating Entities for reference data Relationship between entities Business Rules and their usages User Interfaces for working with Master Data Services Hierarchies Integration Views for using in Read more about Session Materials to Download: Master Data Management with SQL Server 2012[…]
This summit was my first summit ever, and I enjoyed the conference so much, Quality of presentations and session was high as I expected that. I’ve met lots of MVPs, Speakers, Blog and Book Authors, and SQL Server geeks that I knew online, but hadn’t chance to meet them in person. I’ve met Andy Leonard, Read more about PASS Summit 2013 – my first PASS Summit experience[…]
One of the most common errors that you might face in join statements is this error: Msg 4104, Level 16, State 1, Line … The multi-part identifier …… could not be bound. The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, Read more about Fixing the error: The multi-part identifier … could not be bound in Join statements[…]
SQL Server 2012 has a set of useful functions to work in T-SQL environment. Lead and Lag are one of the most useful functions introduced in 2012. Lag function helps to access values from previous records, and Lead function helps to access values from next records in the data set. structure of working with these Read more about Lag and Lead Functions in SQL Server 2012[…]
Previously I’ve wrote about design and implementation an UPSERT with SSIS. UPSERT is about Update existing records, and Insert new records. Today I want to extend this to cover DELETED records as well. So method used in this post can be used to find INSERTED / UPDATED / DELETED records from the source table and Read more about Insert, Update, and Delete Destination table with SSIS[…]
Hi folks, I proud to announce that I will speak in the SQL Saturday #237 Charlotte BI Edition Which will run in 19th of October 2013 in Charlotte, North Carolina In this session I will speak on one of my favorite topics which is Design and implementation architecture for Inferred Dimension Members with SSIS and Read more about Speaking about Inferred Dimension Members with SSIS and MDS: Charlotte SQL Saturday[…]