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,881 reads
Blog Posts
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,100 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
524 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
933 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
674 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,170 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,296 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
245 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
1,678 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,504 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers