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...
2014-01-22 (first published: 2014-01-20)
2,247 reads
Mike Davis SQL
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...
2014-01-17 (first published: 2014-01-13)
2,054 reads
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...
2014-01-09 (first published: 2014-01-06)
2,607 reads
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...
2013-12-30
1,864 reads
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...
2013-12-30 (first published: 2013-12-23)
2,690 reads
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...
2013-12-20 (first published: 2013-12-16)
1,545 reads
SSAS – Setting Attributes as Properties for Excel
When a user is browsing your cube with excel they may not understand how to slice the data and end...
2013-12-09
1,267 reads
SSRS – Self Referencing Reports or Drill through to same report
When looking at a report and wanting to drill through to get more detail, we often create two reports for...
2013-12-04 (first published: 2013-12-02)
3,002 reads
Reverse or Mirrored Bar Chart in SSRS
There are some pretty charts out there and most of them can be done in Reporting Services. There is one...
2013-11-25
1,207 reads
SSIS Execute SQL error – No disconnected record set is available
If you get the error in SSIS that says:
…failed with the following error: “No disconnected record set is available for...
2013-11-18
2,521 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers