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,356 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,090 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
708 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,498 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,261 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,734 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,680 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,439 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,118 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,845 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers