Friends, Before Microsoft introduced Change Data Capture in SQL Server, developers used to create custom solutions using DML Trigger and additional tables (Audit Tables) to track the data which we have modified. DML Triggers are very expensive and executed as part of our transaction which will degrade the performance of the project or server. By creating DML Triggers, we will be able to track the changes in the data. To track the changes, we need to create additional tables with similar columns to store the changes. Drawbacks: 1) Takes...
Hi Friends, I would like to add a pretty good article on “Non-Clustered Column Store Index in SQL Server 2012″ from my friend “Srikanth Manda”. Hope you will enjoy this. Everyone agree the fact that hardware speed and capacity has increased past two or three decades, but disk I/O (Input/Output) or disk access or data transfer rate has not grown up to the expected level and is still the slow. One key point to remember, as time is moving forward the size of the database become larger and larger. Data present now would...
Hello Friends, Back with another video and this time on SSAS cube database backups using XMLA. Generally people prefer to use Wizard to take backups of databases but option using XMLA has more advantages over using Wizard. This is very interesting and useful option to know. So, why late .. just jump into the video .. Hope you too will try this guys !! Regards, Roopesh Valluru ...
Guys – In this post/video we are gonna discuss about the Flight Recorder and its use in SSAS. I feel most of us are not even aware of this (i came to know recently only) and hence adding this video to share my knowledge which will help you guys. Hope this helps you guys !! Regards, Roopesh Valluru ...
Friends, In this Post/Video we are gonna discuss about HOW TO PROCESS MULTIPLE DIMENSIONS AT A TIME FROM SSMS. This might be a very simple topic but very useful one to know for SSAS developers. Let me add couple of points to those who love to READ than WATCHING video .. Connect to the Analysis services using SSMS as shown below. Select any dimension of the cube for which you want to process multiple dimensions as shown below. Select Object Explorer Details options from View menu. Once the details of the dimensions open then...
Guys – In this post/video we are gonna discuss about the steps to be followed to use different attribute in ORDERBY property of a dimension’s attribute. Problem – How to use Attribute Key in OrderBy property of ssas dimension’s attribute. Hope this helped you guys. Do post a comment if this helps you. Regards, Roopesh Valluru ...
Friends, This issue is very common when you are pulling data from Sharepoint list to load parameter values. In this post let us discuss the solution for the same. Step 1 : Create a report and Go to the Report Tab at the top. Step 2 : Go to the Report properties and then code and write the following code in it. Public Function RemoveDuplicates(parameter As string) As String Dim value as String Dim items As Object() = Split(parameter,”~”) System.Array.Sort(items) Dim k As Integer = 0 For i As Integer = 0 To items.Length –...
Friends, This post is very useful to those who wants to learn SSRS with MDX. I have covered almost all concepts and please do drop a message if you are happie with the tutorials. Video 1 - Video 2 - Video 3 - Video 4 - Video 5 - Video 6 - Video 7 - Video 8 - Video 9 - Video 10 - Video 11 - My Best Wishes !! Regards, Roopesh Babu V ...
Friends, I am bringing together all the SSAS Videos. In this post we are gonna discuss about all the SSAS topics in details. Hope you will enjoy the journey through SSAS in detail. My best Wishes !! Video 1 Video 2 Video 3 Video 4 Video 5 Video 6 Video 7 Video 8 Video 9 Video 10 Video 11 Video 12 Video 13 Video 14 Video 15 Regards, Roopesh Babu V ...
Friends, I dunno how many of you guys are aware of the property IsBig in SSIS Aggregate Transformation. If you are aware of it then just skip this post else worth reading this. As you all aware that using aggregate we can calculate SUM,AVG,COUNT and COUNT DISTINCT of a column or columns. In some cases the return value will be soo big like more than 4 billion and to handle those kind of outputs we need this IsBig Property. This can be set on output columns to invoke special handling of big or high-precision numbers. If a column value may...
Friends, You might have seen the properties “Keys Scale” and “Number of Keys” in SSIS Aggregate transformation. What is the difference and in which scenario we use these properties ? Like to know, then continue .. The above two properties are given to improve the performance of the transformation. For the columns with GROUP BY operation in the transformation, we set these TWO properties. Both deals about the number of groups that are expected to result from a Group by operation. For example, if I used Color column...
Merge Join Transformation is one of the useful tool in SSIS to join two sources. The Merge Join transformation provides an output that is generated by joining two sorted datasets using a FULL, LEFT, or INNER join. Let us see how it works. You can configure the Merge Join transformation in the following ways: • Specify the join as FULL, LEFT, or INNER join. • Specify the columns the join uses. • Specify whether the transformation handles null values as equal to other nulls. NOTE: If null values are not treated as equal values, the...