SQL Server Reporting

Data Mining Cluster Analysis in SQL Server

Grouping is something we naturally do in our day to day life. We group foods depending on taste, we group friends depending on their different attributes.  Clustering is an algorithm which finds natural groupings inside your data when these groupings are not obvious. It finds the hidden variable that accurately classifies your data. How Clustering […]

Creating A Financial Year Dimension Using SSAS

A common requirement of financial reports is to have a financial year dimension for analysing the fiscal year data. This is complicated by the fact that financial years differs from country to country. Creating A Fiscal Year Using SSAS Dimension Wizard The financial year can be implemented easily using the SSAS dimension wizard. Let us […]

SSAS Deployment Strategies

Introduction Building a data warehouse and then a cube based on the data warehouse has become child’s play, thanks to Microsoft’s business intelligence tools. SQL Server Analysis Service is used to build cubes for slicing and dicing data. After the cube has been built we need to deploy it to the SSAS server in order […]

Backup and Restore of an Analysis Services Database

Introduction One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user […]

Executing an SSIS Package Programmatically

Pre-requistes To execute a package programatically you need to have basic knowledge of either C# or VB which are both object oriented languages. Visual Studio 2008 SP1 or higher needs to be installed along with SQL Server 2008 or higher. Introduction  Most of us are pretty familiar with SSIS package development as well as deployment. […]

A Journey from OLTP to OLAP- Part 2

In my last  article we saw the basics of the data warehousing in which we saw looked at how OLAP and OLTP technologies differ in their functionalities, what were the models being used to develop the data warehouse and what were the schemas under consideration for designing the data warehouse. In this article I will […]

Export to XML Using SSIS

Recently I was given a task to export data in XML format using SSIS. I initially thought it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in […]

Getting Started Formatting SSRS Reports

Formatting SSRS Report Introduction The SSRS report once ready  needs to be formatted to make it pixel perfect for viewing and printing. The formatting can be classified into the following types: Conditional Formatting Unconditional Formatting Conditional Formatting The conditional formatting  is done using the  IIF and  switch  statements. For conditional formatting can be used to […]

Transactional Replication – Unable to Replicate Data onto the Subscriber – A Practical Example

Scenario: A couple of days back, I got a call from one of my users saying that the Data is not being replicated properly onto the Production Reporting Server from the Production OLTP server. We have Transactional Replication scheduled for every 15 minutes between our OLTP and the Reporting server. Approach: I started investigating this […]

Generalizing Charts in Reporting Services

I recently had to create a chart in SSRS which nneded to be have some generalized settings – in this case the X-axis of the chart needed to be adjusted as per the supplied parameters. The X-axis can be any type of values : Category values, Year or Month values. I have a tablix in […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |