Bob Pusateri

Bob Pusateri is a Microsoft Certified Master of SQL Server, speaker, blogger, volunteer, and author who loves finding new and exciting ways to break and fix things. He works as a consultant and architect, specializing in data, virtualization, and cloud technologies.

May 202019
 
PASS Summit Official Blogger Logo

As an attendee, deciding which sessions to attend at conferences can be a daunting endeavor. With so many choices available and the impossibility of being able to attend every interesting session, it really can make sense to buy recordings if they are available.

One of the ways PASS is trying to help for Summit 2019 is by introducing Learning Pathways, which are curated sets of sessions designed to help attendees achieve a goal. Each pathway will consist of at least three sessions, presented by at least two different speakers. The pathways being offered in 2019 will be:

  • AI for Everyone – Understand the basic concepts of artificial intelligence, how they differ from machine learning and cognitive services, and how you can support AI in your organization.
  • Cloud Migration – Learn how to assess your environment and build a cloud migration plan that makes sense for your organization. Understand the resources that can help along the way.
  • Data Visualization & Storytelling – Determine the right visualization for different situations, and see how to craft meaningful stories with data.
  • Linux for SQL Server Professionals – Understand differences between Windows and Linux, and how to install, manage, and monitor SQL Server on Linux.
  • Communication & Collaboration – Find how to tailor your message for maximum impact and leverage communication skills into better work outcomes.
  • Data Security – Understand security vulnerabilities and how to mitigate risk, see how to ensure security throughout the development lifecycle, and learn how to track and audit database activity.
  • SQL Performance for Developers – Learn how to capture, review, and act on execution plans, and see how to improve schema and code design for performance improvement.
  • Technical Leadership – Learn what you need to grow as a leader, understand the balance and gaps between technical skills and management skills.
  • Modernizing with SQL Server 2019 – Understand new features, the steps necessary, and tools available to help migrate to SQL Server 2019, Azure SQL Database, or other cloud-based options.
  • Becoming an Azure Data Engineer – Learn what this relatively new role entails and the exciting new doors it can open for your career!

I think these pathways are a great idea, and one of my favorite aspects is that they will be scheduled in chronological order. Within each pathway, introductory sessions will take place before the more advanced ones so it will be easy to enhance your skillset with sessions that build upon each other.

I’m really excited for these learning pathways at PASS Summit this year, and I hope you are too. I can’t wait to see you there!

May 062019
 
PASS Summit Official Blogger Logo

This year, PASS is introducing the PASS Summit Official Blogger program, and I’m very happy to announce that I’m a part of the inaugural group!

For many years there has been a bloggers’ table at PASS Summit keynotes, where community members can live blog all the latest happenings and announcements. This year, PASS is kicking it up a notch with the creation of the official blogger program!

Official bloggers not only get the opportunity to cover the keynote events live as before, but also get exclusive interview access with the PASS Executive Committee, exhibitors, sponsors, and other industry leaders that will be in attendance.

I’m really looking forward to this exciting opportunity. I’ve been attending and blogging about PASS Summit for years, including my PASS Summit Tips series last year, and I really can’t wait to see what new content I’m able to create this time around!

Apr 112019
 

The Call for Speakers for PASS Summit 2019 has just closed, and now the Program Committee will begin the task of evaluating speakers and sessions and using those results to build a schedule.

It’s not easy.

Really, it’s not. I’ve served on the Program Committee numerous times and there’s a lot of effort that goes into building that schedule. There are also many difficult decisions made, and many great sessions that there just isn’t a timeslot for because they were pre-empted by an even better or more timely topic.

These unfortunate facts got me thinking about topics that will probably never again be presented at PASS Summit or other major conferences.

Log Shipping

Log Shipping is the 1994 Toyota Camry of SQL Server. It’s not new or sexy, but it’s extremely reliable and can be a very simple way to implement disaster recovery, especially for smaller shops without a lot of resources. It doesn’t require Enterprise Edition, and works in every version* of SQL Server. As an added bonus, it’s based on transaction log backup and restore technology, so there’s not much of a learning curve.

Policy-Based Management

Still an awesome book!

If you want to make sure your server(s) are configured in a certain way or abide by a specific set of requirements, Policy-Based Management is an incredible tool to help get you there. You can define lists of requirements, known as “policies”, and then go evaluate those policies against other SQL Servers. Regular reports of servers that don’t comply can be an incredible tool, and PBM makes this easy.

Database Mirroring

Yes, Database Mirroring has been deprecated is in maintenance mode. And with the introduction of Basic Availability Groups in SQL Server 2016 there’s a newer alternative. But I feel mirroring is still going to be around for quite a while because lots of environments depend on it.

Transactional Replication

Unlike mirroring, replication has not been deprecated, likely because it offers unique capabilities that no newer feature competes with. But it’s an old technology that hasn’t changed much recently. It can be difficult to set up, and a pain to fix if it breaks, but if you truly need it then nothing else will do.

So why aren’t conferences covering these topics?

Like I said above, I get it. There are many hard decisions to be made, and topics like I listed above are easily the first to head to the conference schedule chopping block for many reasons, including:

  • They’re old. The newest of the 4 features above is Policy-Based Management, and that was introduced in SQL Server 2008.
  • Many have been replaced by newer features.
  • They don’t work in the cloud. The only above feature that works in Azure SaaS is replication. Azure SQL Database can be a subscriber for transactional or snapshot replication, and Azure SQL Database Managed Instance supports transactional replication.

Why should conferences cover these topics?

To put it frankly, because users still depend on them! I just spent two years consulting for customers of widely-varying sizes, and for many of them, vendor software forbids usage of the cloud. Yes, it’s often stupid, and you can grumble all you like, but that’s the reality right now for lots of third-party software. Other clients were being held hostage on old (sometimes very old) versions of SQL Server. It stinks, because “newer” features of SQL Sever 2014 and later are still out of reach in many shops.

So a lot of the time, these “old” features are what a lot of environments are stuck with, and what a lot of people would benefit from learning about. So it’s a shame that conferences can’t dedicate just a little more time to topics that may not be new or flashy, but would likely make a big impact.

*These days, when I say “every version” I mean SQL Server 2005 or later

Mar 262019
 

Another SQL Saturday Chicago has come and gone, and I wanted to take a moment to reflect on what we have spent the last 11 months planning.

It truly was our best SQL Saturday yet, with 422 attendees. We also ended with 130 on our waiting list, which is another record. Even with this larger venue it appears our demand still exceeds the amount of room we have.

We also had more churn this year than ever before in terms of attendees. This is a great thing, as many people realized they were unable to attend ahead of time and cancelled their registration, thereby opening up a spot for someone else.

New This Year: Less Paper

In years past, we printed a “welcome guide” which included a schedule, map of the venue, and other pertinent information. This time around we wanted to reduce printing and paper usage, so we discontinued the printed guide.

In addition to encouraging attendees to consult the online schedule or use the Guidebook app, we had large poster-size schedules printed and placed them around the venue. These seemed quite popular as there were often several people gathering around them deciding which session to go to. They also used considerably less paper and reduced our printing costs by 75%.

Thank Yous

Finally, I would be remiss if I didn’t thank the people and organizations who helped make this year’s event a great success.

Thank you to all of our attendees – without people willing to come and learn there would be no reason to do any of this.

Thank you to our speakers, who are willing to take time out of their lives to prepare presentations and then present them at our event. Many of them also traveled to Chicago at their own expense to do so!

Thanks to our sponsors. Without their financial support, this event would not be possible.

A huge thank you to our venue, Benedictine University. Not only do they have a great space to host our event, but they are extremely easy to work with as well.

Also deserving of some shoutouts are Clara’s Restaurant for hosting our speaker dinner (their food is awesome – very worth a visit if you’re in the Chicago suburbs) and to Bar Louie for hosting our after-party on Saturday.

And finally, to our SQL Saturday organizing team, which is a well-oiled machine at this point. I feel very fortunate to have such a dedicated and dependable team to plan and execute this event with, and I can’t wait to do it again in 2020!

SQL Saturday Chicago 2019 Organizing Team
Feb 202019
 

With SQLBits coming up quickly (it’s next week!) I wanted to take a few moments to write about what very quickly has become my favorite conference. It’s an awesome experience and I am so grateful that I am able to attend, volunteer, and present there for a second year.

It’s Not PASS Summit

I love PASS Summit – no surprises there. I’ve written many posts about it, why you should attend, and how to prepare for it over the years. But I think it’s really important to point out that SQLBits is not PASS Summit, nor is it organized by PASS in any capacity. It’s a completely separate event, arranged by a tremendous group of dedicated organizers, and it also happens to be Europe’s largest SQL Server conference for data professionals.

SQLBits has a completely different feel than PASS Summit; to me it seems there is a stronger sense of community there. Which I realize is a tall order when PASS Summit is known and marketed as ‘a conference for the community, by the community’. But in some ways, PASS Summit feels “corporate”. And that corporate feeling makes sense, given that Summit is put on by a professional event organizing company. Bits, on the other hand, is put on completely by the community, in the form of a small army of volunteers. And in my opinion, the difference is palpable.

Another aspect that may play a big role in this is the physical layout of the conference. PASS Summit’s venue, the Washington State Convention Center, is enormous, and the conference itself is spread out across multiple different floors spanning two buildings. There’s plenty of places to hide and get lost there. SQLBits, on the other hand, is much more compact. Envision a large, open, exhibition space with rooms for sessions lining the perimeter. The central area is wide open – and not only are all the sponsors located there, but this is the space that everyone mills around in-between sessions. In my opinion the layout alone helps you meet more people, because there’s there’s really no way to avoid them.

SQLBits 2018 as seen from above

The Food

Food at SQLBits is also totally different than any conference I’ve been to. There’s no enormous industrial-sized dining hall hundreds of yards away from sessions and speakers. Instead, the food is placed in the center common area, with the idea that you can grab a bite to eat and mingle. It’s incredibly easy to connect with old friends, make new ones, and speak with sponsors, all while enjoying some great food. Seriously, it’s really good stuff. (And I’m a picky eater, so if I like it you know it has to be good!) There’s zero reasons to leave the event to eat at SQLBits.

The Party

Each SQLBits has a theme, and the organizers do a great job of integrating that theme throughout the conference. And if you didn’t know, there’s a costume party on Friday night that’s kind of a big deal. They really go all-out for this – it’s by far the best conference party I’ve ever been to. This year’s theme is “speakeasy”, so I’m expecting lots of 1920’s gangster attire. I can’t wait!

Volunteer!

If SQLBits sounds like something you would like to experience for yourself, there are a few ways to do that. You of course are welcome to register as an attendee, or to answer the next call for speakers and submit abstracts. Another great way to help this conference work like a finely-tuned machine is to be one of the volunteers I mentioned earlier. It’s an amazing way to meet people and help a wonderful community-run event be the best that it can be.

SQLBits 2018 Volunteers

It’s going to be an amazing week, and I can’t wait to connect with old friends and make new ones in Manchester. I hope to see you there!