MDX Member Functions
There are a large number of Member functions in MDX that do everything from returning ancestry of a member to...
2010-02-21
1,684 reads
Blog Posts
Measure Group Properties Explained
When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show...
2010-02-21
2,877 reads
Measure Properties Explained
When configuring measures in SSAS, you want to make sure you address a few important properties. They are show in...
2010-02-21
1,097 reads
Microsoft AdCenter and SQL Server Analysis Services 2008
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
521 reads
New iSCSI Performance Benchmark from Microsoft and Intel
The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware...
2010-02-21
931 reads
Problem Using the Aggregate Function with Calculated Measures
Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup...
2010-02-21
669 reads
SQL Server 2005 CLR execution error after restore
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the...
2010-02-21
1,152 reads
Automate Back Slashes in Your File Path Expressions in SSIS
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,258 reads
Carrier Pigeon Beat Local Telcom
It’s not often that we find stories that make us laugh out loud, unless they have to do with situations...
2010-02-20
242 reads
Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
4,501 reads
Blogs
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)
Update for SQL Server 2025: This post and the GitHub repo have been updated for...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers