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.

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 More No 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 More No 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 More No 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 More No 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 More No 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 More No 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 More No 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 More No Comments >

PASS Summit 2019 Announcement

As we prepare for the upcoming PASS Summit 2018, I wanted to share an update on our planning progress for PASS Summit 2019, which is already well underway.

 

I’m pleased to announce that next year’s event will be taking place in Seattle on November 5 - 8, 2019.

Read More No Comments >

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