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,021 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,210 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,328 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

817 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

884 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,048 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,510 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,143 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,324 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

941 reads

Blogs

Using Cron in Postgres Flex

By hellosqlkitty

pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...

Can I Change a Primary Key Value? #SQLNewBlogger

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Read the latest Blogs

Forums

Multiple Collations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Collations

How do you keep track of the purpose for SQL Logins?

Wondering how others keep track of the purpose for SQL Logins? I'm not talking...

Just a rant about the SQL Server 2022 upgrade

Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...

Visit the forum

Question of the Day

Multiple Collations

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...

See possible answers