The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

We've moved!

Looking for the latest blog posts? We've recently moved the PASS Blog to its new home at https://www.pass.org/PASSBlog.aspx. You can still view older blog posts here but please update your bookmarks so you can continue getting the latest posts from the PASS Blog.

Using Triage Tables for Suspect Data

As part of the transformation of data, it’s inevitable that some data will be discovered to be suspect. Whether it is a possible duplicate, one or more rows that failed validation, or data type errors, there will be some deficiencies that cannot reliably be corrected in the ETL. When this happens, you are left with one of three options...

Read the rest of entry » Comments

The Turbo Button is Here - The Batch Mode on Rowstore Indexes

The introduction of the Batch Execution Mode on the Rowstore Indexes has caused a significant change in how things will work for the big aggregation queries on the Microsoft Data Platform.

Read the rest of entry » Comments

3 Reasons Why Data Storytellers are the Future

Data storytellers understand that data is an asset, but only when it is communicated correctly. By itself, stats and figures do nothing to help the users understand what they represent. Below are three reasons why data storytellers will continue to be the #1 sought after skillset in the data world.

Read the rest of entry » Comments

Performance Tuning Made Easy – Optimizing Lazy Spool

Performance tuning is often considered as a complex technique to master. However, it is not as complex as often perceived. In this blog post, we will discuss one of the most infamous operators – Lazy Spool – and how to optimize the query containing it.

Read the rest of entry » Comments

Microsoft Ignite

As you may be aware, Microsoft recently announced that Microsoft Ignite 2019 will take place November 4-8, which is the same week as PASS Summit.

Read the rest of entry » Comments

Agile BI Governance is a Human Problem

The timelines for acceptable insight delivery have contracted dramatically – from years or months down to days or even hours.  In BI, the name of the game is now Agility.

Read the rest of entry » Comments

Introducing Azure Data Factory Design Patterns

The cloud is literally changing everything. As a data engineer, I am excited to see recent advancements in cloud-based data integration solutions. My personal favorite these days is Azure Data Factory (adf.azure.com).

Read the rest of entry » Comments

Why Queries May Easily Return Incorrect Data in SQL Server

SQL Server has an interesting question when it comes to running multiple queries at the same time. If my session is reading data while other queries are modifying data, what should happen? Should my query hold locks to protect that data? If so, how many locks should it hold, and how long should it hold them for? 

Read the rest of entry » Comments

The Importance of the PASS AHP

I know firsthand how difficult and upsetting it can be to file a report after a violation occurs, but the Anti-Harassment Policy (AHP) exists to protect you by putting preventative measures in place.

Read the rest of entry » Comments

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids