MDX Datasets with Date Parameters
How should date type parameters be prompted? There are two common approaches
depending on how you want the parameter to appear. ...
2010-03-11
411 reads
Blog Posts
Navigating to a Report in a Pop-up Window
When using the Jump to Report action int he web browser, the target report is displayed
in the same browser window...
2010-03-11
434 reads
Nested Tables in a Repeating List Data Region
Report designers often revert to overly complex report designs and often use subreports
unnecessarily. Building a report on a single dataset...
2010-03-11
588 reads
Oracle .NET Data Provider not Supported but Necessary for Cube Design
I've decided that from now on, consulting project estimates will be padded for an
additional week to get Oracle connectivity working...
2010-03-11
452 reads
Parameterized Top Values Report
Top ranked lists are a common type of report. In many cases business users may want
to see only a specific...
2010-03-11
665 reads
PASS European Conference in April
While it is probably out of reach for most DBAs in the United States to attend, the PASS European Conference...
2010-03-11
405 reads
PASS Releases Survey Results & Summit Location – Reactions
The Impetus
So after Andy Warren’s (@SqlAndy) blog post, PASS Update #24, last week and the follow-up posts by myself (A...
2010-03-11
680 reads
PASS Update #25 (Summit Location and More)
By now you’ve probably seen the official announcement from PASS about the Summit being located in Seattle for both 2011...
2010-03-11
676 reads
Report Parameter Date Range
A forum poster wanted to use a StartDate parameter to limit the range of dates available
in a second parameter to...
2010-03-11
546 reads
SCSUG (Space Coast SQL Users Group) Meeting Tonight Featuring PFE David Pless
In case you missed David Pless in Orlando on Tuesday, you have another chance to see his presentation tonight (Thursday...
2010-03-11
525 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries