MSSQL Analysis Services - Attribute Member Names

  • Article

Business Intelligence Architect Bill Pearson continues his exploration of Attribute Members, in another member of a subseries surrounding significant components of the Analysis Services dimensional model. In this article we examine the attribute member Name property, whose appropriate use is important to good model design and overall system performance.


2,199 reads

Basic Set Functions: The BottomCount() Function, Part I

  • Article

Isolate worst / lowest performers from the member population at large, and perform sophisticated analysis with BottomCount(). Join MSAS Architect Bill Pearson in the first of a pair of articles focusing upon the powerful BottomCount() function, where we experience “hands-on” some of the possible ways it can offer multi-perspective decision support.


2,879 reads


Replicate permissions to new Login/User with dbatools


Continuing to share tips and tricks using dbatools like the Refresh databases that belongs...

SQL Server Sample Databases


[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Using WAITFOR to Test Slow Code–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs


The Challenges of Working Under Quarantine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Challenges of Working Under...

Upgrade SQL 2008R2 Cluster to SQL 2017

By AdamJSawyer

Hi, I've been asked to develop an implementation plan for upgrading a SQL 2008R2...

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers