SSRS: Display Series on SSRS Chart Based on Parameter Value
I recently modified an SSRS report to display average run times for various SQL Agent jobs over the past 30,...
2013-08-09 (first published: 2013-08-05)
3,348 reads
Salvo(z) SQL
SSAS Data Mining – Time Series Algorithm
At TechEd 2013, I attended a few sessions on the topics of Data Mining and Predictive Analytics. I thought I’d...
2013-06-19
7,083 reads
TechEd 2013–Favorite Sessions
At TechEd 2013, I attended many excellent Business Intelligence / Data Platform sessions and thought I’d share an overview of a...
2013-06-11
703 reads
Sum Result of SSRS LookupSet Function
SSRS provides several built-in Lookup functions: Lookup, MultiLookup and LookupSet. Lookup returns a single value while MultiLookup and LookupSet return...
2013-05-27
7,360 reads
SSAS Event Type Calculation Dimension
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For...
2013-05-22
1,254 reads
Count Weekdays in MDX
I recently implemented an MDX expression to count the number of weekdays in a given timeframe. This logic is likely...
2013-03-25
2,724 reads
Implementing a ‘Time Calculations’ Dimension in Tabular via DAX
A common request from business users is ‘Time Intelligence’ functionality in an SSAS cube. For example, users may wish to...
2013-03-11
5,673 reads
Introduction to the SQL BCP Utility
SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files. ...
2013-03-04
23,265 reads
PerformancePoint ‘Named Set’ Filter
PerformancePoint provides several options to create filters. One of the options available is ‘Named Set’. Within SSAS cubes we can...
2013-03-01 (first published: 2013-02-25)
2,113 reads
Configuring PerformancePoint Data Source for Time Intelligence
PerformancePoint provides functionality to map several time dimensions across multiple data sources to a ‘Master Time Dimension’. Data sources that...
2013-02-18
1,840 reads
Blogs
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
The End of Year Vacation Burn
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Speaking at PASS Summit 2025
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Powershell script to generate SQL server Inventory in CSV format
Comments posted to this topic are about the item Powershell script to generate SQL...
Database Ledger in SQL Server 2022
Comments posted to this topic are about the item Database Ledger in SQL Server...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers