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.

A Message to the Amazing Data Community

Hello to the Amazing Data Community,

In case you haven’t heard, on June 3rd, PASS announced that our premier event, and as it so happens, fundraiser, was officially changed from an in-person event to a virtual conference. A lot of you registered early for the event and a bunch of you have registered since we switched over to a virtual Summit. Thank you, one and all. Not only are you supporting your education through our unique content and unparalleled networking opportunities, but you’re showing support for our community of data professionals.

Read more

Getting Started With Big Data Clusters – Part 2

In the previous post, we’ve deployed a Big Data Cluster. Now it’s time to use this system and get some work done on it.

Let’s start with a feature called “Data Virtualization” which is basically PolyBase 2.0. While PolyBase (unlike other BDC features) is also available for standalone SQL Server 2019 installations, it plays an essential role in the BDC architecture. It allows you to bring in data from other data sources like SQL Server, Oracle, and Teradata. It also allows you to bring in data from SharePoint, CRM, or Cloudera through the concept of an external table.

Read more

Choose the Right Azure SQL Database Deployment Options for Your Solution

Happy 10th birthday, Azure SQL Database! Yes, that’s right – Microsoft’s Platform as a Service (PaaS) SQL database is ten years old this year! It’s grown from “Azure SQL” to a multi-faceted service with many options. At its core, though, it has had the same goal for a decade – the service manages the hardware, patching, backups, high availability, and even tuning plans and indexes; you focus on development and performance.

As it’s grown from one limited offering to a set of services, choosing the best option for your application and database can be confusing. Single database or managed instance, DTU or vCore, serverless, hyperscale - how do you know which one is right for you? In this article, I’ll explain the many options available and provide guidance on how to choose the best one for your project.

Read more

PASS Summit 2020 has Gone Virtual

I am pleased to be able to share that this year’s PASS Summit event has gone virtual! We are excited to proceed with a virtual conference and we look forward to welcoming attendees from around the world that would not normally be able to join us at the in-person event.

Launching the PASS Virtual Summit was a massive undertaking for a not-for-profit, especially under such challenging circumstances. Thanks to the community feedback we received over the last few months, and the dedicated team at PASS HQ, we were able to make this conference a reality. Thank you to the dozens of community members that participated in focus groups and provided the insights that informed this change and the revised pricing.

Read more

PASS Financials Update

We are currently in the midst of what we consider the PASS budget season for our Fiscal Year (FY), running from July 1 to June 30. This is typically the time of year where we are deep into reviewing and adjusting the extensive PASS budget in anticipation of voting on the budget in June. This year, however, is an unprecedented time for us with the uncertainty surrounding PASS Summit, which accounts for 94% of PASS’ revenue. As we’ve discussed over the last few months we have been looking at ways to diversify that revenue, but the reality is that for FY 2021, PASS Summit will be the primary source of income for our community. COVID-19 has had a significant impact. Registrations have slowed to a trickle at a time when we would expect to see our biggest numbers. We are facing an unprecedented situation where we are having to re-evaluate our path forward and the timeline.

Read more

Monitor Exceptions in Your Database

Introduction This article started with a problem my co-workers had: they got bug reports from users where the application displayed an error message from SQL Server. Since the issue occurred only occasionally, it was difficult for them to reproduce the problem and find out where the error...

Read more 1 Comments

PASS Summit 2020 Update – June Announcement

In my previous blog post, I mentioned that PASS Summit 2020 will be taking place this year, and that I would update the community throughout every step of the process and with every new development.

As we get further in understanding the logistics and financial impact of transitioning to a virtual PASS Summit conference, I wanted to share that we are confident that we will be in a place to announce whether this year’s event will be delivered in-person or virtually by early June.

Read more

Getting Started with Big Data Clusters – Part 1

So, you’ve heard about Big Data Clusters in SQL Server 2019 and want to get some hands-on experience? Let’s get you started today! This article will guide you step-by-step on how to deploy a Big Data Cluster in Azure Kubernetes Services (AKS) from a Windows client. The idea is to get your Big Data Cluster up and running fast without going into detail on every step involved, so don’t expect a deep dive on every component along the way.

Read more 1 Comments

Back to the Basics: Backups

For many organizations, backups tend to be a hassle-task; relegated to the bottom of the pile to be dealt with by whoever has a few minutes to spare to throw something together. For others, backups are deemed unnecessary due to other high availability or disaster recovery features in their software/hardware stacks. These assumptions are often made when time and money are limited resources, and developing new features is seen as more profitable than adding infrastructure and using up precious developer time. To begin to counter these (and other) common misconceptions, it is best to start out with the reasons that backups are important.

Read more 2 Comments

PASS Summit 2019 All Access Winner - Susan Dallegro

As the winner of the PASS Summit 2019 All Access contest I was awarded a complimentary 3-day general session registration for PASS Summit 2019 plus some perks that really made my first PASS Summit experience very special.  These included on-site VIP meet and greets, free ticket to a community-hosted games night, a PASStv interview, reserved front row seating for the PASS Summit 2019 Keynote sessions, a full USB of all PASS Summit 2019 recordings, and some nice swag a PASS Summit branded back pack and water bottle.

I was super excited when I found out that I had won.  I knew that the PASS Summit would be an excellent opportunity to receive world class technical training, learn where the future of the field is heading, make new friends, and experience everything that the community has to offer.  I intended to take full advantage of the opportunity.  I thoroughly and enjoyed every minute of my time at the event.

Read more


Theme picker

Back to Top