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.

Licensing Power BI

Power BI can be licensed in three different ways: by user, by content workspace, or by server. Specifically, there are 5 different Power BI Licenses...


Read More No Comments >

Finding the Slowest Query in a Stored Procedure

It’s not uncommon to see procedures with hundreds, even thousands of lines of code.  You may have been told which stored procedure runs slow by a user or manager, or you might have found it by looking in SQL Server DMVs.  Either way, once you have detected the offending procedure, where do you start?

Read More No Comments >

Agile BI Governance is a Human Problem, Part Two

In part one, we touched on the role played by Excel: the only tool previously capable of providing the Business with sufficiently-nimble reporting and analysis. I’m now going to explain how to turn that previously-frustrating dynamic into a major win for your organization.

Read More No Comments >

PASS Summit 2018 Recap

Well, that’s it for another year, PASS Summit 2018 is a wrap! Thank you to all of our attendees, sponsors, speakers, exhibitors, volunteers, and community members who came out to celebrate this event, making PASS Summit v.20 one to remember. One of the things I love most about attending PASS ...

Read More No Comments >

2018 Board Q&A Recap

November 9, 2018 – We had another great turn out for the annual PASS Board of Directors Q&A session which took place in the PASS Summit Community Zone. Former PASS Board member Douglas McDowell moderated the session and all current Board members were on stage to answer questions from the audience. We got great questions around Microsoft Ignite, vendor presence at PASS Summit, event attendance, diversity, and more.

Read More No Comments >

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

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