Maintenance Plan Issues
I think maintenance plans were a great improvement in SQL Server 2005, with a more visual designer and the ability...
2010-03-11
816 reads
Blog Posts
Managing Report Project Deployments & Version Control
What lessons have we learned about managing report projects and what are the best
practices?
Since each report is stored in a...
2010-03-11
1,245 reads
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
409 reads
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
433 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
584 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
451 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
660 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
675 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers