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.

February Board Meeting Recap

On February 12 we held our first in-person Board meeting of 2019, taking place over 2 days in Kirkland, Washington. This was also our first on-site meeting with newly appointed Board members Roberto Fonseca, Lori Edwards, and Jennifer Moser. We officially welcomed them to the Board and launched them straight into the deep end!

Read More No Comments >

Pivoting Stacked Data with Power Query

No matter the program you use to build your self-service BI solution, data will be at the heart of it.  And the challenge with data – of course – is that it’s seldom ready to be consumed.  Even if it’s as simple as just changing a column name, you’ll no doubt want to modify something.

Read More No Comments >

Why You Shouldn't Use ADS - And Why I Am

According to Microsoft's own documentation, ADS (that's Azure Data Studio) is "a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux." To be blunt, it is the replacement for SQL Server Management Studio. There, I said it. And I'm not taking it back.

Read More No Comments >

Properly Upgrading SQL Server

For several reasons, upgrading to modern versions of SQL Server can be more challenging than it was when you upgraded to SQL Server 2012 or older. 

Read More No Comments >

FY2018 Financial Audit Process

You may have seen the recent PASS News post about the completion of our FY2018 financial audit. This is a rigorous process that our management team at PASS HQ (C&C) undertakes every year starting in June and ending in October.
But, what is an annual audit and why does PASS engage in one?

Read More No Comments >

Getting the Most Out of Entity Framework Core

This blog post is my attempt to bring a few nuggets of knowledge about Entity Framework Core (EF Core) to developers to make sure that their data queries are efficient and optimized. 

Read More No Comments >

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 2 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 >

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