2019-10-10 North America Sessions

Azure Data Studio ❤ SQL People

Target Audience: SSMS Users Abstract: Azure Data Studio is not replacing SSMS, but it is accelerating the speed of development, by adding feature that would take years to add to SSMS. These tools work together, hand-in-hand in some places. How so? Well, in SSMS 18+ you can right-click in many places and launch ADS with…
Read More

Power BI for the Data Systems Administrator

Data systems administrators pride themselves on their ability to dig deep into the weeds of their systems and get to the root of problems. However, when it comes time to explain a complex or intermittent issue we find that others don’t enjoy those weeds. Ever wish you could draw a better picture of what’s going…
Read More

Databases 101 for the Aspiring App Dev

Target Audience: Students from high school on up, new to dealing with databases in general, or looking for a re-set of foundational database understanding. Abstract: We’ll cover what you need to know about relational databases entering a career in development, including the different kinds of databases, terminology when entering the workforce, the basics of backups,…
Read More

SQL Admin Best Practices with DMVs

Target Audience: This session will be informative and eye-opening to anyone from a junior DBA on up. Abstract: In this practical and script-focused session, with roots in SQL 2005 but updated continuously thru SQL 2019, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential…
Read More

SQL Security Principals and Permissions 101

Target Audience: This session is perfect for junior DBAs, developers and system admins of on-prem and Azure-based SQL platforms. Abstract: A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and much more. Why I Want…
Read More

Certification Exams Inside Out

1 Comment
Target Audience: IT professionals of any skillset considering cert exams as a career motivator. Abstract: Preparing for Microsoft certification? Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation from an item writer's viewpoint,…
Read More