Articles

Proxy Accounts to run SSIS Package from Sql Server Agent Jobs

roopesh.valluru - December 21, 2012 73

SSAS DBA Tips & Tricks – SSAS database backup using XMLA

roopesh.valluru - April 19, 2014 64

How to move data from Multiple files to different destinations using...

roopesh.valluru - October 18, 2013 0

Log Providers in SSIS

roopesh.valluru - December 19, 2012 37

Exporting a SSRS report to multiple Excel tabs

roopesh.valluru - January 16, 2013 14

Alternating Table Row Colors in SSRS

roopesh.valluru - January 12, 2013 31

LEAD Function in MDX

roopesh.valluru - February 5, 2012 59

SSAS DBA Tips & Tricks – Use of REPLAY option in...

roopesh.valluru - April 19, 2014 94

Copy Column DataFlow Item in SSIS

roopesh.valluru - December 26, 2011 8

Document Map Property in SSRS

roopesh.valluru - January 6, 2012 21

RowCount Transformation in SSIS 2008R2 Example

roopesh.valluru - October 19, 2013 96

What is the use of Input columns tab in RowCount transformation

roopesh.valluru - October 19, 2013 133

Multi Valued Parameters in SSRS

roopesh.valluru - February 15, 2012 77

Row Sampling Transformation in SSIS with Example

roopesh.valluru - November 8, 2012 67

SSAS DBA Tips & Tricks – How to process multiple dimensions...

roopesh.valluru - April 11, 2014 121

Conditional Split Transformation in SSIS with Example

roopesh.valluru - November 12, 2012 302

Referenced Relationship Type in SSAS

roopesh.valluru - January 12, 2012 55

Change Data Capture in SQL Server by Srikanth Manda

roopesh.valluru - December 31, 2014 277

Non-Clustered Column Store Index in SQL Server 2012 by Srikanth Manda

roopesh.valluru - December 29, 2014 22

BottomPercent in MDX

roopesh.valluru - February 12, 2012 36

1...345...7 Page 4 of 7

Ancestor Function in MDX

What is MOLAP and its advantages and disadvantages?

Logging in SSIS

LAG Function in MDX

Impersonation in SSAS Data Source