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.

Category: PASS General

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 >

Get Ready for the Next Evolution of Analytics

Analytics work, as you know it, is quickly changing. Soon, machines guided by humans will tremendously scale analytics capabilities to extract extraordinary value from data. According to McKinsey & Company, "analytics presents an enormous opportunity: an estimated global value of $9.5-$15.4 trillion. About 40% of this value can be realized using the most advanced AI techniques."

Read More No Comments >

Demystifying the Multi-Model Capabilities in Azure Cosmos DB

When someone asks me, “Hey, what is Cosmos DB?” I casually respond, “Well, that’s Microsoft’s globally distributed, massively scalable, horizontally partitioned, low latency, fully indexed, multi-model NoSQL database, of course.” One of two things happen then: I’ll get a long weird look, after which the other person will politely excuse themselves and move along, or, I’ll hear “wow, that sounds awesome, tell me more!”. If you’re still reading this, then I’m guessing you’re in the latter category.

Read More No Comments >

PASS FY 2019 Financials

As a not-for-profit corporation, PASS is required to post the approved annual budget, quarterly financials, and the FY final audited statements. I encourage all of you to take the time to not only view the line items within the budget, but also to understand what’s new, what’s changed, and how the budget contributes to our progress as an organization.

Read More No Comments >

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