Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-09 (first published: 2014-09-05)
7,446 reads
Devin Knight
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-05
640 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
3,046 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
784 reads
MDX Time Calculations Built to Scale
When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...
2014-08-14
1,609 reads
MDX Time Calculations Built to Scale
When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...
2014-08-14
633 reads
Writing Parametrized MDX for Reporting Services
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all...
2014-08-13 (first published: 2014-08-04)
8,691 reads
Writing Parametrized MDX for Reporting Services
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all...
2014-08-04
559 reads
Understanding Analysis Services Relationships using Dimension Usage
As a part of designing an Analysis Services cube you must define how each dimension is related to each measure...
2014-07-15
1,723 reads
Using PowerShell to Build your Azure VM Environment
In a previous post I wrote about Using a Hyper-V VHD in an Azure VM. Today I’d like to show...
2014-06-23
1,653 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers