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.

Welcoming our New PASS Board Members in 2019

After having some time over the holidays to recharge batteries and get ready for the year ahead, I’d like to thank our outgoing Board members Allen White, Chris Woodruff, and Eduardo Castro for their countless hours of service to the PASS community. They will be transitioning off the PASS Board on December 31, 2018.

Read the rest of entry » Comments

Technology Architecture Analysis with Databricks or Data Lake Analytics

Databricks is a recent addition to Azure that is greatly influencing the technology choices that people are making when determining how to process data.  Prior to the introduction of Databricks to Azure in March of 2018, if you had a lot of unstructured data which was stored in HDFS clusters, and wanted to analyze it in a scalable fashion, the choice was Data Lake and using USQL with Data Lake Analytics.  With the introduction of Databricks, there is now a choice for analysis between Data Lake Analytics and Databricks for analyzing data.

Read the rest of entry » Comments

Are you Wasting Half the Capacity of IDENTITY?

Over time, I have worked on many databases that have used an INTEGER identity as a primary key or clustered index value. Most of the time there haven’t been any issues, but occasionally, I come across a problem table where the IDENTITY value ran out and inserts statements, then failed. This has typically been in a case of a logging table of some type.

Read the rest of entry » Comments

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

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