SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Salvo(z) SQL

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.

Archives: October 2012

DAX IsFiltered Function

The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on the column.  The syntax is IsFiltered(<columnName>).  More details regarding this function can be found on MSDN.

I recently used the IsFiltered function to create a measure that is only… Read more

0 comments, 1,733 reads

Posted in Salvo(z) SQL on 11 October 2012

SQL Azure–Failed to Update because the database is read-only

An error message for one of our many SQL Azure databases was brought to my attention today.

Msg 40628, Level 16, State 1, Line 1
Failed to update database ‘UAT_US_SS02′ because the database is read-only. Please contact your Azure service owner. There may be billing related issues with your Azure…

Read more

0 comments, 2,286 reads

Posted in Salvo(z) SQL on 5 October 2012

SQL Saturday #149 Minneapolis 2012

This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member of our local PASS chapter.  Adam has his pilot’s license so we flew to Minneapolis the morning of the event.  It was a beautiful and warm fall day – perfect… Read more

0 comments, 812 reads

Posted in Salvo(z) SQL on 3 October 2012