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.

Program Announcement: Introducing Streams

The PASS community has rapidly expanded over the years to include a wide variety of data professionals from across the industry. As our membership grows, our commitment remains unchanged; to provide industry-leading educational content that meets the needs of all of our members.

Read More No Comments >

SQL Server Perfmon Counters that are Still Interesting in 2019

Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I've moved onwait stats are a much better starting pointbut there are still 3 good Perfmon counters that I rely on.

Read More No Comments >

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

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