Posted on Dec 31 2014 - 11:47pm by roopesh.valluru
Comments Off on Change Data Capture in SQL Server by Srikanth Manda

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...

Posted on Dec 29 2014 - 8:29am by roopesh.valluru
Comments Off on Non-Clustered Column Store Index in SQL Server 2012 by Srikanth Manda

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...

Posted on Apr 26 2014 - 1:40am by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – How to change the default data folder location in SSAS

Friends – One of the Very helpful property of SSAS is discussed in this video. The data folder needs to be moved to a new loaction in few cases and the same is discussed in this post. Enjoy !! Regards, Roopesh Valluru ...

Posted on Apr 26 2014 - 1:37am by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – Where the data will be stored in MOLAP Storage mode

Friends, In this post/video, we are gonna explore DATA folder and it’s uses in SSAS. Hope this will help you in understanding the concept MOLAP Storage Mode very clearly. Hope you understood the concepts Regards, Roopesh Valluru ...

Posted on Apr 20 2014 - 5:30am by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – How to delete Huge Cube Databases

Friends – If you wish to know How I delete huge SSAS cube databases, then jump into the below given video. Hope you liked it !! Regards, Roopesh Valluru ...

Posted on Apr 19 2014 - 8:46pm by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – How to copy ONLY Structure or Schema of Cube database to new server

Friends – To copy ONLY Structure or Schema of Cube database to new server, we need solution file. But, without solution you can do it using the DB deployed to one server and XMLA. check out how. Hope you liked  it!! Regards, Roopesh Valluru ...

Posted on Apr 19 2014 - 8:43pm by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – Use of REPLAY option in Sql Server Profiler Trace

Friends – REPLAY option in Sql Server Profiler Trace is one of my favorite options. This options helps you to replicate load of once server to the another and check out how .. Hope you liked it !! Regards, Roopesh Valluru   ...

Posted on Apr 19 2014 - 8:39pm by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – How to ProcessAdd or ProcessIncremental of Dimension from SSMS

Friends – When you try to ProcessAdd of dimension from SSAS, you will not find any such option. Is it really available for us from SSMS or not ? Check it out here .. Hope you understood now 🙂 Regards, Roopesh Valluru ...

Posted on Apr 19 2014 - 11:43am by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – SSAS database backup using XMLA

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 ...

Posted on Apr 19 2014 - 10:00am by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – Flight Recorder in SSAS

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 ...

Posted on Apr 11 2014 - 3:25am by roopesh.valluru
Comments Off on SSAS DBA Tips & Tricks – How to process multiple dimensions or measures from SSMS

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...

Posted on Apr 9 2014 - 2:53am by roopesh.valluru
Comments Off on Sort SSAS dimension attribute based on another attribute with example

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 ...

Posted on Mar 27 2014 - 3:27am by roopesh.valluru
Comments Off on How to implement OR condition in MDX

Friends, This post explains about “How to implement OR condition in MDX”. This is a youtube video and if you are unable to see the same then youtube might be blocked in your company .. 😉 Here it goes .. Hope this helped you guys !! Best Regards, Roopesh Valluru   ...

Posted on Dec 13 2013 - 9:34am by roopesh.valluru
Comments Off on Distinct values for SSRS Parameter when query returns Duplicates

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 –...

Posted on Oct 20 2013 - 5:05am by roopesh.valluru
Comments Off on MDX Detailed Training Videos by Roopesh Valluru (7 Videos)

Friends, I am bringing together all the MDX Videos in this post. In this post we are gonna discuss about all the MDX topics in details. Hope you will enjoy the journey through MDX in detail. My best Wishes !! Video 1 Video 2 Video 3 Video 4 Video 5 Video 6 Video 7 Regards, Roopesh Babu V ...

Posted on Oct 20 2013 - 4:54am by roopesh.valluru
Comments Off on SSRS with MDX Detailed Training Videos by Roopesh Valluru (11 Videos)

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 ...

Posted on Oct 20 2013 - 4:41am by roopesh.valluru
Comments Off on SSAS Detailed Training Videos by Roopesh Valluru (15 Videos)

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 ...

Posted on Oct 19 2013 - 10:46am by roopesh.valluru
Comments Off on IsBig Property of Aggregate Transformation in SSIS 2008 R2

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...

Posted on Oct 19 2013 - 10:45am by roopesh.valluru
Comments Off on Difference between Keys Scale and Number of Keys properties in SSIS Aggregate Transformation

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...

Posted on Oct 19 2013 - 10:39am by roopesh.valluru
Comments Off on Merge Join Transformation in SSIS 2008R2 Example

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...