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.

We've moved!

Looking for the latest blog posts? We've recently moved the PASS Blog to its new home at https://www.pass.org/PASSBlog.aspx. You can still view older blog posts here but please update your bookmarks so you can continue getting the latest posts from the PASS Blog.

Microsoft Employee Call for Speakers Submissions

I’d like to address and clarify the uncertainty regarding recent questions about Microsoft employees—and all other sponsor/vendor employees—submitting sessions in the PASS Summit community Call for Speakers.

Read the rest of entry » Comments

Delete Most of Your Reports

Report ownership is like boat ownership. The second happiest day in a boat owner’s life is the day they sell their boat. Start deleting reports and watch your productivity soar!

Read the rest of entry » Comments

Is Normalization Still a Relevant Topic?

When we normalize a database, the process works to eliminate redundant and overcomplicated data in multiple ways, making sure your rows and columns have a single meaning. 

Read the rest of entry » Comments

WebAssembly: Bringing Diversity of Language to the Web

Developers are closer than ever to acquiring what is widely considered the “Holy Grail” of software: the ability to write code once and have it run anywhere. 

Read the rest of entry » Comments

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

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