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,038 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,226 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,341 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

822 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

892 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,078 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,520 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,159 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,332 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

955 reads

Blogs

Take Time to Gain Perspective

By Brian Kelley

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Demo for Parameter Sniffing and Memory Grant Feedback

By MarlonRibunal

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Read the latest Blogs

Forums

Learn From History

By Grant Fritchey

Comments posted to this topic are about the item Learn From History

The SQL Server MCP Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server MCP Server

The Hidden Danger of Wildcard Operators In Join Operations

Comments posted to this topic are about the item The Hidden Danger of Wildcard...

Visit the forum

Question of the Day

The SQL Server MCP Server

How do I get an MCP server for my SQL Server 2025 database from Microsoft?

See possible answers