I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
4 reads
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,077 reads
At TechEd 2013, I attended many excellent Business Intelligence / Data Platform sessions and thought I’d share an overview of a...
2013-06-11
702 reads
SSRS provides several built-in Lookup functions: Lookup, MultiLookup and LookupSet. Lookup returns a single value while MultiLookup and LookupSet return...
2013-05-27
6,962 reads
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For...
2013-05-22
1,247 reads
I recently implemented an MDX expression to count the number of weekdays in a given timeframe. This logic is likely...
2013-03-25
2,709 reads
A common request from business users is ‘Time Intelligence’ functionality in an SSAS cube. For example, users may wish to...
2013-03-11
5,665 reads
SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files. ...
2013-03-04
23,044 reads
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,111 reads
PerformancePoint provides functionality to map several time dimensions across multiple data sources to a ‘Master Time Dimension’. Data sources that...
2013-02-18
1,836 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers