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.

DAX IsFiltered Function

by Jennifer-Salvo

Salvo(z) SQL

The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...

2012-10-11

2,033 reads

Ten SQL Kindle eBooks for Under $10

by Jennifer-Salvo

Salvo(z) SQL

Introducing Microsoft SQL Server 201231 Days of SSIS with SQL Server 2008 R2SQL Server Interview Questions and AnswersPerformance Tuning with...

2012-10-07

1,220 reads

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

by Jennifer-Salvo

Salvo(z) SQL

An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...

2012-10-05

2,338 reads

SQL Saturday #149 Minneapolis 2012

by Jennifer-Salvo

Salvo(z) SQL

This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member...

2012-10-03

821 reads

T-SQL Tuesday – Help! I Need Somebody

by Jennifer-Salvo

Salvo(z) SQL

By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need...

2012-09-11

888 reads

Azure Virtual Machine TempDb Placement

by Jennifer-Salvo

Salvo(z) SQL

The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually...

2012-09-06

2,070 reads

Personal Goals

by Jennifer-Salvo

Salvo(z) SQL

With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming...

2012-09-01

1,514 reads

Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA

by Jennifer-Salvo

Salvo(z) SQL

Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended...

2012-08-24

2,154 reads

Meme15: Top 5 Reasons I Like My Job

by Jennifer-Salvo

Salvo(z) SQL

This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started...

2012-08-16

1,329 reads

T-SQL Tuesday: Trick Shots (Currency Conversion in SSAS)

by Jennifer-Salvo

Salvo(z) SQL

Today is T-SQL Tuesday #33 hosted by Mike Fal. The topic is SQL Server – Trick Shots. This assignment involves blogging...

2012-08-14

951 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

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