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,848 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
868 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
575 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,086 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,075 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
509 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers