SSAS Cache Warming with an SSIS package
There are several techniques that can be used for performance tuning Analysis Services. You may already be familiar with the...
2010-07-01
2,864 reads
Devin Knight
MDX webinar
Today I did a webinar on MDX solutions. For those of you interested you can grab the slides here and...
2010-06-24
1,213 reads
SSIS R2 Configuration File Issue Fixed
Using configurations files in SSIS is a great way to change how your package will run from outside the development...
2010-05-14
869 reads
Reporting Services 2008 R2 Report Parts
Reporting Services 2008 R2 has many new great features that I’ve written about lately (Data Bars and Indicators). Today I...
2010-04-24
1,337 reads
SQL Saturday #38 Jacksonville Update
With less than a month away, May 8, before the big event in Jacksonville I wanted to give you a little inside...
2010-04-15
576 reads
Reporting Services 2008 R2 Data Bars
Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be...
2010-04-12
2,087 reads
Reporting Services 2008 R2 KPI Ready
As I begin to explore more and more of the new feature that will be available in SQL Server 2008...
2010-04-09
1,842 reads
Auditing Report Executions with Free Source Code
Have you been looking for a way to measure report performance? Want to know who accesses your reports most frequently? ...
2010-03-30
1,716 reads
Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also...
2010-03-17
6,084 reads
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
2010-03-12
511 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
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