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.

Upcoming Microsoft Certifications for Data & AI

Qualified data professionals are always in demand. And their importance in digital transformation is undeniable. They modernize relational SQL Server databases on-premises, migrate and administer them on Microsoft Azure, or use the best of both worlds in hybrid environments. Plus, they drive insights at cloud scale, managing great volumes of data—from ingesting and storing to reporting and visualizing.

As a PASS member and a technical professional, you can probably identify with these tasks. In fact, they might even describe your typical workday. So I’m excited to share some big Microsoft Certification news with the PASS community! Effective early April 2020, Microsoft will offer two new role-based certifications, and they’re designed especially for data professionals. Microsoft Certified: Azure Database Administrator Associate and Microsoft Certified: Data Analyst Associate will expand the Microsoft Certifications Data & AI portfolio, which includes Azure Data Engineer Associate, Azure Data Scientist Associate, and Azure AI Engineer Associate.

Read more

PASS and the Anti-Harassment Policy

In 2012, PASS implemented the PASS Summit Anti-Harassment Policy because of our commitment to providing a safe environment for all of our members. Much of what led up to the creation of this policy was the need to have an avenue to investigate alleged harassment incidents. Unfortunately, most of us have either been a victim of or witness to an incident of harassment. The Anti-Harassment Policy is in place to support a safe and inclusive environment and covers far more than some of us know. From the policy:

“Harassment includes, but is not limited to, offensive verbal comments related to gender, race, sexual orientation, disability, religion, or any other protected classification directed toward an individual or group.”

Read more

Data, AI and Cloud: The Top Data Jobs of Tomorrow

Good news for the PASS community. World Economic Forum’s 2020 Future of Jobs report continues to forecast an exceptionally bright outlook for Data, AI, and Cloud Computing professionals. The Jobs of Tomorrow: Mapping Opportunity in the New Economy examines digital era changes and top emerging professions. World Economic Forum sourced the data from partnerships between New Metrics CoLab, Burning Glass Technologies, Coursera and LinkedIn. Let’s peek at the highlights.

Read more

Speaker Diversity Analytics with the AI Face API

How do we increase diversity amongst our event speakers?  To improve something, we must first measure it.  The Face API allows us to collect some of these demographics from past events that we may not otherwise be able to collect, which may allow us greater insight into how we can improve these trends.

The Facial Recognition API is part of the Microsoft AI Cognitive Services suite.  The Face service detects human faces in an image and returns the rectangle coordinates of their locations. Optionally, face detection can extract a series of face-related attributes. Examples are head pose, gender, age, emotion, facial hair, and glasses.  The Face API is Azure based and is a subset of the Vision API functionality.  To leverage the Face API an image can be programmatically sent to the API via a number of languages.  Along with the image file, the caller can also submit parameters detailing which subset of return values to send back.

Read more 1 Comments

Go Azure SQL!

Pardon the pun in title here, but the goal for this post is to introduce how to start interacting with Azure SQL through Go (, an open source programming language gaining lots of traction in developers’ community thanks to its simplicity and efficiency in scenarios like microservices and server apps (did I mention that Kubernetes itself is written in Go?).  

Azure SQL provides full support for Go developers on both control plane (deploy, manage and configure Azure SQL servers and databases), and data plane activities (connect, execute commands and queries against Azure SQL instances) through Azure SDK for Go and Microsoft SQL Server Driver for Go.

A companion code sample for this article, written using VS Code, can be found here.

Read more 1 Comments

February Board Meeting Recap

We hosted our first in-person PASS Board meeting of 2020 in Kirkland, Washington, from February 3-4. This was also our first in-person meeting with newly appointed Board members Mindy Curnutt, Melody Zacharias, and Hamish Watson. We look forward to their experience and insights as we continue to work together on the Board.

To kick off the meeting, we reiterated our commitment to our FY 2020 priorities and focusEducational Content, Accessibility, and Engagement. These pillars provide us with a strong foundation to grow our organization, and will allow us to pivot as needed in the future to support our membership.

Read more 1 Comments

#SQLLove Story


While people attend PASS Summit for many different reasons, including the fantastic speakers or opportunities to network, most don’t come expecting to attend a wedding.

Tamera Clark and Kerry Tyler started dating after meeting at Purdue University in Indiana. Both working as data professionals, they both dreamed of the day where each of their respective companies would pay their registration fees to attend PASS Summit. They started an inside joke saying “it’s all fun and games until you go to PASS Summit,” and told one another that if they ever got the opportunity to attend the conference, they would get married there. It was October 2011, when they finally got their chance.

Read more

How to Pass a List of Values Into a Stored Procedure

Say we have a stored procedure that queries the Stack Overflow Users table to find people in a given location. Here's what the table looks like:

And here's what my starting stored procedure looks like:

Read more

Handling Flexible Search Needs Using Stored Procedures and Dapper


Data access from applications has traditionally followed one of two routes: either using stored procedures or using ORMs. Both have their advantages and drawbacks. In this article, we look at how to handle flexible searching needs using the stored procedure approach.


Traditionally, even systems that perform data access only through stored procedures face challenges when it comes to searching data. While simple CRUD is easy, searching on multiple fields can lead to one of several suboptimal solutions. Developers may introduce a stored procedure for each search combination – this often happens when a system evolves its search capabilities – or they may introduce branching logic to existing stored procedures, or they may decide to introduce an ORM just for searching, such as Entity Framework or LINQ-to-SQL.

Read more

PASS Summit: A Big Part of My Life

I attended my first PASS Summit in Seattle in 2003 after about eighteen months in my job as a DBA. SQL Server Central had a post about a price increase coming up for Summit, and I showed the information to my manager not really thinking she would approve. Attending the conference meant a week away from the office as well as the expense of the conference and travel so I was thrilled when she said yes.

Read more


Theme picker

Back to Top