SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates
Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...
2014-11-14 (first published: 2014-11-11)
9,176 reads
Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...
2014-11-14 (first published: 2014-11-11)
9,176 reads
Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The...
2014-11-13
1,469 reads
Finding out MDX calculation scripts is a common task
A co-worker recently asked me what the calculation for a calculated measure...
2014-11-12
1,350 reads
Expert Cube Development with SSAS 2012 Multidimensional Models was published earlier this year by Packt Publishing. It’s the second edition...
2014-06-15
831 reads
Table of contents
Need to remove employees who have zero sales amountCreate a calculated measure with the IIF() function The NON...
2014-05-30
1,484 reads
Table of contents
IsNumeric() funciton is too forgivenUse Pattern Matching with LIKE keywordLIKE keyword in T-SQL doesn’t support regular expressionReplace white...
2014-05-30
1,533 reads
OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we...
2014-05-09 (first published: 2014-04-30)
14,319 reads
Some SSRS reports have a large number of parameters
I recently had a chance to help a co-worker to modify...
2014-05-09
1,764 reads
Keyboard shortcut Alt + F1 works now
SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS...
2014-04-30
6,244 reads
I recently attended a virtual training of Tabular and Power Pivot for Developers taught by Kathy Vick at Pragmatic Works....
2014-04-25
1,893 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers