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.

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

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 the rest of entry » 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 the rest of entry » 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 the rest of entry » 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 the rest of entry » Comments

Top 5 Reasons You Should Be Excited About Power BI Composite Models

In July there were many exciting new features that were released to Power BI, but perhaps the most eagerly awaited feature was the introduction of the Power BI Composite Models. While this feature is still in preview, it’s hard not to be enthusiastic about how this feature will solve problems that have been plaguing Power BI developers since the product’s release. In this post I’d like to share my top 5 reasons you should be excited about these new capabilities.

Read the rest of entry » Comments

Securing an Azure SQL Database

Microsoft SQL is one of the most common workloads being deployed or migrated to Azure public cloud. The main reason why organizations are doing this is because it provides performance benefits, ease of management and deployment, and also because it provides several security features.

Read the rest of entry » Comments

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