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
677 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,107 reads
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,888 reads
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,692 reads
Free Data From Across the Pond
Ok so I know a statement like that will whip some of you into a frenzy, but it’s true. No...
2010-02-21
538 reads
I'm Speaking at SQLLunch
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
349 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
529 reads
Disk Partition Alignment
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
534 reads
Data Type Precedence and Implicit Conversions
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...
2010-02-21
4,528 reads
Modifying SQL in a Lookup Transform
Oftentimes you need to make a more advanced join that the default LookUp Transform will allow. The challenge is when...
2010-02-20
357 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers