What we're about

Welcome to the Triangle SQL Server User Group (TriPASS)! We are an active group of SQL Server professionals that meet monthly for formal presentations on many SQL Server topics. We cover everything from database design, development, deployment, performance, and IT support. We also Business Intelligence topics like data warehousing, reporting, ETL and Big Data. Visit us at our monthly meetings where our sponsors always provide us with free food and beverages. Many times we will have a raffle for books and other items provided by our sponsors.

Upcoming events (4)

Shop Talk

Online event

Do you have a question about SQL Server or the data platform space? Are you running into technical problems in the office and want a second opinion? Do you have an urge to stump our panel with arcane or weird scenarios--or watch others do just that to us? Then Shop Talk is for you. Shop Talk is a Q&A-driven broadcast featuring Tom Norman, Mala Mahadevan, Tracy Boggiano, and Kevin Feasel. Each week, we will dedicate one hour to answering your questions, including live questions with no prep (and I can't see how that could possibly go wrong!). Send questions to us on the air at https://www.twitch.tv/trianglessug or get them to us early by e-mailing [masked] and give us a fighting chance to come up with the right answer. Prior episodes' show notes are available at https://shoptalk.tripass.org .

Dynamic Search Conditions by Erland Sommarskog

Online event

** Please note that the starting time for this presentation will be 4 PM EDT instead of 6 PM! A common requirement in database applications is that users want a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons. Erland Sommarskog is an independent consultant based in Stockholm. He has worked with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and he has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

What You Need to Know to Administer Power BI by Melissa Coates

The Power BI administrator is a very high privilege role which includes a wide breadth of responsibilities. Some administration activities apply consistently for every organization, whereas others depend on how Power BI is being used for self-service and corporate business intelligence initiatives. Each organization's needs related to security, governance, auditing, and data management influence the scope of responsibilities for a Power BI administrator. This session will cover considerations for effectively overseeing a Power BI implementation, as well as suggestions for what to focus on. Melissa Coates is a data architect with a focus on data warehousing, data lake, and business intelligence solutions in the cloud. As the owner of Coates Data Strategies, Melissa offers training and consulting services to help data professionals be successful with enterprise-level Power BI and Azure deployments. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013.

How about a fun night?
Needs a date and time

Needs a location

How about a fun quiz night or lightning talks just to get everyone back together again?

Photos (46)