Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.

Blog Post

MDX Root Function

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here....

2014-01-08 (first published: )

2,137 reads

Blog Post

MDX Root Function

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here. In the past, I have encountered scenarios where I...

2014-01-05

24 reads

Blog Post

MDX Root Function

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here. In the past, I have encountered scenarios where I...

2014-01-05

3 reads

Blogs

Friday Flyway Tips: State-based deployment with Flyway Teams

By

I was asked about state-based deployments in Flyway Teams, so I decided to show...

Advice I Like: The Main Thing

By

The main thing is to keep the main thing the main thing. – from...

Sic Transit Gloria Community

By

When Covid took out the PASS organization, I had someone say to me, “Well,...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Installing SQL FCI Instance certificates

By Raxso1

SQL FCI Instance certificates I have a client who has a requirement for certificates...

Log Shipping Not Able to Restore Log Files in Secondary

By regnar

I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL...

Visit the forum

Question of the Day

Counting Bits IV

What do these two selects return?

SELECT BIT_COUNT (CAST (-1 as smallint))
     , BIT_COUNT (CAST (-1 as bigint))

See possible answers