PASS Pro Now Available

Welcome to the next evolution of PASS. Unlock exclusive training, discounts, and networking opportunities designed to accelerate your data career. Learn More >

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.

Excited for the Next Phase of PASS

PASS Pro Membership was announced this week and I’m excited to see the launch of a new revenue stream for PASS.  We have all known for a long time that our organization needed this, but what surprised me throughout this process, was what the research taught us.  It showed us that over 50% of our new members have been in their careers for ten years or less, and are looking for opportunities to connect, share, and learn with other data professionals around the world.


Read more

The Importance of Joining the NomCom

Serving on the NomCom

During the month of August, PASS makes a Call for Letters of Interest to serve on the Nominations Committee (NomCom), so we thought it would be a great time to write a blog post about what the NomCom does.  I’ve had the pleasure of serving on the NomCom as a community member in 2015 and as the Board representative in 2019, so hopefully I can share some insight.

Serving on the NomCom is a great way to get understanding about the structure of the Board, the chance to work with current Board members and PASS HQ and the ability to help shape the leadership of PASS.  If you are thinking about serving on the PASS Board, I would highly suggest serving on the NomCom first.

Read more

Announcing PASS Pro Membership

At the start of this year, I shared that the PASS Board would be focusing efforts on diversifying PASS’ revenue.

PASS Summit currently accounts for 94% of PASS’ revenue and in order for our organization to be sustainable and grow in the coming years, we needed to introduce a new revenue stream that could support our 350,000 strong global membership. PASS membership and engagement has been rapidly increasing, and PASS Summit attendance declining. After consulting members and reviewing community surveys, we determined that our best option for sustainable revenue growth was a paid membership offering.

Read more

PASS HQ's Relationship with the PASS Organization

Over the past few weeks, the community has told us you would like a better understanding of the relationship between C&C (PASS HQ) and the PASS organization. In this post, I’ll do my best to give you a better picture of our partnership with C&C, and the value PASS gets from its services as a management company. I understand there are some concerns regarding the use of C&C, which I’ll address, and provide some clarity around C&C’s role within the organization.

We gain an enormous amount – both financially and tactically – from our partnership with C&C. I will admit that, before joining the Board, I had some doubts about PASS’ need for an association management company. I’ve heard the discussions, and I’m glad you’re having them. From outside the organization, it’s hard to imagine the abundance of activities that go on every day with a community of this size. After I got an inside view, I quickly realized that we simply would not be able to run PASS on volunteer support alone. The overwhelming amount of day-to-day administrative activities, community support, finance, website maintenance, troubleshooting, integrations, partner (or sponsor) relations, marketing, event management, data protection, and governance activities are too much for our astounding volunteer force to take on. We rely on the team at PASS HQ to make it happen and keep our organization moving forward year-round with direction from community feedback and Board guidance.

Read more

WorkFlows – What Are They? – Part 2

One of the uses of workflows is to be able to restart them as needed. In the beginning of previous article, it was mentioned that workflows can be used for “Interruptible activities that can be stopped and re-started”. In this article, we will see the stop and restart feature. To see it in action, let’s bring back our Basic_Workflow program, a good candidate for this because it does a lot of things with only a little code: connects to databases, saves data in files, compresses data, and emails reports.

Read more

Getting Started With Big Data Clusters – Part 3

So far, we’ve deployed a Big Data Cluster and explored its Data Virtualization capabilities

Now, it’s time to look how you can use your Big Data Cluster to consume file-based data from a CSV or Parquet file. The Big Data Cluster component to be used is the so-called Storage Pool.

Read more

Insights From Your Database Using PowerShell and TSQL

Hello All.

I have been looking for quite some time for ways to understand my databases better. There are a lot of DMVs and even some DMFs that help us get information from the SQL Server engine that can be very insightful. Many shops use monitoring tools and they are great because they watch things all the time. I used to rely solely on these tools to get me information about my SQL Server environment. That has shifted since I have been managing a SaaS platform built on top of SQL Server. With hundreds of TB of data and many databases being the same, it becomes pretty daunting to know which databases to care about and how much to care.

This article is about what you can do to get ready for a better maintenance strategy or understanding how your indexes are used.

Read more 1 Comments

PASS Summit Selection Process in 2020

Starting the year

While organizing and scheduling the sessions for PASS Summit is always a challenge, this year has been particularly difficult and unusual. While I’ve written before about the web of overlapping constraints we have to deal with, I’m hoping to cover some more of the process and what has made 2020 a unique year.

Read more

Load Streaming Data into Azure Synapse with Azure Stream Analytics

Once streaming data from devices, sensors, applications etc. have been loaded to an Azure Event Hub or IoT Hub, you are ready to configure the Azure Synapse database and the Stream Analytics job to load it.  This part of the series will walk you through the set up and configuration of the Azure Synapse and Stream Analytics job services.  We will run the stream job to pull data from an Event Hub and load it to Synapse while confirming the speed and efficiency of the near real-time data load.

Read more 1 Comments

PASS Virtual Summit 2020 for a Global Community

Hello, g’day, hola, 你好, guten tag, namaste, olá, marhabaan, こんにちは, salām, cześć’, hallo, shalom, 여보세요, bonjour, hej….

Kia ora PASS Global Community – we really are a diverse group of people spread all across the world. I write to you from Christchurch, New Zealand and will publish this blog out of Vancouver, Canada….

As you saw in Wendy’s post and the PASS Connector, due to the unexpected situation with COVID-19, PASS Summit is going virtual this year. This is a first for PASS Summit and it was a difficult decision for the Board to make.

Read more


Theme picker

Back to Top