Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
605 reads
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
605 reads
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
526 reads
Ok so I know a statement like that will whip some of you into a frenzy, but it’s true. No...
2010-02-21
531 reads
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
346 reads
There are a large number of Member functions in MDX that do everything from returning ancestry of a member to...
2010-02-21
1,687 reads
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
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
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
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
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,310 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers