Goodbye to PASS

On December 17, the PASS organization announced the news that it would cease operations on January 15, 2021. Since the announcement, folks have been scrambling to figure out how to keep their user groups and events going or downloading recordings.

By the way, if you need assistance with your user group, please reach out to Redgate (communities@red-gate.com) if there is anything we can do to help.

For many of us, this news means more than just finding a new way to conduct user group business. It feels like we have lost something more personal. Many people in the community have stories about how their involvement with PASS lead to growing friendships, finding new jobs, or taking their careers to places they never imagined. PASS has been a big part of the lives of many in the data community, and losing it hurts.

Many of us called PASS Summit a big family reunion, but like most families, we didn’t always get along. Several in the community have criticized PASS for years. I’m sure some of it was justified, but I'm not going to rehash it here. I do know that the board members, volunteers, and employees at “HQ” put their hearts and souls into PASS and worked extremely hard. We are losing more than just a conference; we are losing a big part of our lives.

The world is much different than it was 20 plus years ago when PASS began, and PASS might have evolved in time, but the pandemic forced the end. Jeff Bezos once told the employees at Amazon “I predict one day Amazon will fail. Amazon will go bankrupt.” That seems impossible, but if you were around in the 60s or 70s, you might have thought the same thing about Sears.

The bonds formed through PASS over the years are still in place, and the data platform community will continue to grow and thrive.

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the number of rows for testing.

This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers.

An SQL Server database contains primary data files, secondary data files (optional), and transaction log files...

This is a guest post by another friend of Dallas DBAs – Brendan Mason (L|T) Upgrading and migrating databases can be a daunting exercise if it’s not something you...

Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.

In the previous article Find columns with NULL values across the table we discussed that storage space can be saved by removing columns with NULL value across the table... The...

This blog is a quick guide on how to back up an Az...

       Azure Cosmos DB has a new storage engine specialized for analyzing data in databases. All available APIs do all operations in Transactional Storage, data is saved in...

Series of Azure Databricks posts: Dec 01: What is...

Azure Synapse Analytics brings the worlds of data integration, big data, and enterprise data warehousing together into a single service for end-to-end analytics—at cloud scale. In this blog post we will focus on using T-SQL to explore and analyze data.

In this series I would like to give you some examp...

Feature branching and pull requests are two important concepts when using Git. In this article, Kendra Little explains these patterns and even provides a video to demonstrate.

My friend, Sandy Winarko, recently published a fantastic summary of the efforts of the Microsoft SSIS Team to mitigate friction for enterprises seeking to lift and shift SSIS workloads...

I’ve been working on a project where I use Azure...

(2020-Dec-21) While working with Azure Functions that provide a serverless environment to run my computer program code, I’m still struggling to understand how it actually works. Yes, I admit, there... The...

One of the most significant design considerations ...

I mentioned this in a few previous posts, but for for those who may have missed it or forgotten, here’s a quick refresher - we use Always On Availability Groups at Stack Overflow on all of our main production servers running the network of public Q&A sites,

Click to learn more about author Alex Williams.  NoSQL databases are incredibly versatile and flexible, and while it would be great if there was a general approach to creating...

Since linking or cross-referencing question has come up from time-to-time, let me try document this here, including a known issue that is currently in the backlog as of Dec 22, 2020...

King Of The DMV Many people will go their entire lives without using or seeing a lock hint other than NOLOCK. Thankfully, NOLOCK only ever leads to weird errors and incorrect...

Welcome to part fourteen of the plansplaining series, where I wrap up the mini-series on how simple foreign keys have huge effects on execution plans for data modifications. We...

Announced last week is a major new feature for Pow...

When using slicers in Power BI reports, multiple selections filter data with OR logic. For example, if you...

My wife bought me a nice telescope for Christmas. I’ve wanted one since I was a kid. We opened gifts early because we’re going to take the RV out in the dessert to watch the great convergence of Jupiter and Saturn next week...

While the long-awaited small multiples feature that previewed in the December 2020 release is an obvious boost to Power BI’s data visualisation capabilities, did you know that you can...

This time the simple useless function will generate a scrambled word or will generated a sentence of scrambled words. Imagine the pangram – “The quick brown fox jumps over...

In this year’s end post I will give you a little programming challenge! Everybody knows the Christmas song “The Twelve Days of Christmas”! Your task is to write an...

Enjoy! Thanks for watching!   A Word From Our Sponsors First, a huge thank you to everyone who has bought my training so far. You all are incredible, and I owe all of...

Another post for me that is simple and hopefully s...

Serverless Synapse SQL pools in Azure Synapse Analytics have a new set of features that will enable you to analyze your Azure data more efficiently. The new Transact-SQL (T-SQL) language features that you can use in serverless SQL pools are STRING_AGG, OFFSET/FETCH, PIVOT/UNPIVOT, SESSION_CONTEXT, and CONTEXT_INFO...

I've seen this accidental pattern more times than I care to remember, and it still bothers me no end. There's a valuable lesson to be had at the end,...

You’ve got a staging table with millions of rows, and you want to join that over to a production table and update the contents. However, when you try to...

Total: 2 Average: 5The first time Karl heard of SQL CTE was when he was looking for something to make his SQL code easier for the eye. It’s kind...

Total: 1 Average: 5This article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and some useful tips on working with it. Also, it...