What we're about

CincyPASS is a user group dedicated to enhancing careers of SQL Server (and related technologies too!) professionals through networking and learning. CincyPASS is a PASS affiliated user group.

We attempt to schedule meetings at 5:30pm on the third Tuesday of each month, and they are open to all individuals who work with all areas of Microsoft's data platform (or are aspiring to do so).

Meetings typically include an update from PASS HQ along with a featured speaker. We are constantly looking for volunteers to speak, so if you are interested please volunteer.

Upcoming events (2)

Matt Gordon - Turn Runbooks Into Notebooks: Handling Maint/Emerg with Azure DS

Registration Link:- https://cincypass.pass.org/?EventID=15596 On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks. Matt Gordon, Architect Insight Digital Innovation Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.

Ned Otter - Understanding Always Encrypted

Microsoft Cincinnati Office

First released in SQL 2016 with many restrictions, SQL 2019 greatly enhances Always Encrypted. It is a complex feature with no shortage of subtle gotchas, and this session will reveal many of them. Should Always Encrypted be used instead of TDE? What’s an “enclave”, and what are the requirements for using one? Are there any storage or performance implications when deploying Always Encrypted? We’ll answer these questions and many more in this in-depth dialog, and you’ll gain a thorough understanding of what to consider when deploying Always Encrypted with secure enclaves in SQL 2019.

Past events (49)

Mohammad Darab - An Intro to Big Data Clusters

Online event

Photos (33)