C# - Sparks from the Anvil

Browse by Tags

All Tags » C# (RSS)

Supercharge your SSDT database projects using T4 to auto-generate T-SQL code!

There are many techniques that data warehouse developers could learn from other parts of the software industry and automated code generation is one of them. Most database developers have at some point in their careers written T-SQL code to query the SQL...
Posted by DrJohn | with no comments

Dynamic Partition Creation in SSAS multidimensional using the SSAS Partition Manager

<<Updated blog entry to reflect the new release of SSAS Partition Manager>> There are plenty of blog entries out there that outline how to dynamically create partitions in SSAS multidimensional databases. However, all of them suffer the same...
Posted by DrJohn | with no comments

SSAS Partition Manager for both SSAS Tabular Models and SSAS Multidimensional Cubes

Today I am proud to announce the release of SSAS Partition Manager that can dynamically create partitions in both SSAS Tabular models and SSAS Multidimensional cubes using a wide variety of partitioning schemes (yearly, monthly, weekly etc.).  ...

SSAS: Automating OLAP cube deployment, dynamic partitioning and processing

Imagine been able to deploy your OLAP database, dynamically partition the cube and then process the new database all in one step from an .asDatabase file with minimal configuration.  Well now you can!  Today’s release of the SSAS Partition Manager...
Posted by DrJohn | 1 comment(s)

SSAS: Utility to check you have the correct data types and sizes in your cube definition

This blog describes a tool I developed which allows you to compare the data types and data sizes found in the cube’s data source view with the data types/sizes of the corresponding dimensional attribute. Why is this important? Well when creating named...
Posted by DrJohn | 2 comment(s)
Filed under: ,

SSAS: Utility to export SQL code from your cube's Data Source View (DSV)

When you are working on a cube, particularly in a multi-person team, it is sometimes necessary to review what changes that have been done to the SQL queries in the cube's data source view (DSV). This can be a problem as the SQL editor in the DSV is...
Posted by DrJohn | 1 comment(s)
Filed under: ,

SSIS: Deploying OLAP cubes using C# script tasks and AMO

As part of the continuing series on Building dynamic OLAP data marts on-the-fly , this blog entry will focus on how to automate the deployment of OLAP cubes using SQL Server Integration Services (SSIS) and Analysis Services Management Objects (AMO). OLAP...
Posted by DrJohn | 2 comment(s)

SSAS Stored Procedures - connecting to the transactional data source

There are often circumstances where an SSAS stored procedure needs to connect to the transactional database to perform a query. This is certainly the case in a near-real-time OLAP solution where the cube sits directly on top of the application database...
Posted by DrJohn | 1 comment(s)
Filed under: ,

Converting C# to VB.NET for use in SSIS

If you much prefer C# over VB.NET but are forced to use VB.NET as that is the only language supported by SSIS, you will love the tool I discovered. Some cool guys over at DeveloperFusion have created an on-line C# to VB.NET convertor which makes the transition...
Posted by DrJohn | 2 comment(s)
Filed under: ,