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,103 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,883 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,690 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
534 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
527 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
532 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,510 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
353 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers