Pass Summit 2011
SQL Rally
Author Archives: MikeDavisSQL
SSRS Report Models no Primary Keys
When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, one with first names, … Continue reading
SSRS – Creating Drill Through reports with MDX
If you are reporting from a Cube in SSRS and you want to drill through to another report you can set up actions just like any other drill through except one small change. The parameter you pass to the drill … Continue reading
SSIS – Using Kill with SP_Who to Break locks
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How can I get rid of these table locks?” This blog will show you how to build a package that will … Continue reading
SSAS Trending KPI
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in right direction based on previous levels. If you want to show a measure has increased or decreased since last month, … Continue reading
SSAS Reporting Action with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the … Continue reading
SSAS – Using the Euro or Pound currency Symbol in a measure Format String
If you have a set of measures and some of them are US dollars, some are Euros, and some are UK Pounds, you want to format them correctly in SSAS. First you will need to know the ASCII command to … Continue reading
SSAS Dynamic KPI from a table
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or below a goal. Managing the goal numbers can be a headache because they made need to be updated often. By … Continue reading
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as … Continue reading
SSIS For Loop Skip Files
When running a For Each Loop through a set of files, sometimes you will have specific files that you do not want to load. For example, I have a set of files named: Abc.txtMno.txtRts.txtWln.txtXyz.txt If I want to skip the … Continue reading
Setting up Security on sub sites in SharePoint 2010
A lot of companies have several departments and want to limit the sub sites users can view. For example, the IT department should only see the IT sub site, but the HR department may need to be able to see … Continue reading
MikeDavisSQL 