Pacific Northwest SQL Server User Group

March 14, 2018 (Wednesday), 7pm 

35/Kalaloch, Microsoft campus, Redmond

Guest Speaker: Mirek Sztajno, Senior Program Manager SQL Data Platforms, Microsoft

What is new in Azure Active Directory Authentication to SQL DB/DW

Azure SQL Database and Azure Data Warehouse support Azure Active Directory authentication, a mechanism of connecting to SQL DB/DW  by using identities in Azure Active Directory (Azure AD) for managed and federated domains as well as  user credentials not being part of Azure AD. With Azure AD authentication, you can centrally manage the identities of database users and other Microsoft services in one central location. Central ID management provides a single place to manage SQL Database users and simplifies permission management. We start by reviewing the basic concept by an introduction to Azure AD authentication for SQL DB, and focus on Multi-factor authentication using Azure AD Condition Access to demonstrate the MFA authentication method using the Azure Portal and SQL Server Management Studio (SSMS).  

Mirek Sztajno is a Senior Program Manager (PM) in SQL Server development team. Mirek started his Microsoft career in 1999 as a member of the development team delivering SQL Server 2000.  He participated in all SQL Server releases including the latest release of Azure SQL DB/DW and SQL Server 2017,  delivering many different features. Mirek’s PM contribution is mostly focused on SQL Server engine, primarily Metadata, Partitioning, Snapshot Isolation, Online Operations, Metadata and Security  areas.

Welcome to the Pacific Northwest SQL Server User Group (PNWSQL) web site!

We meet every second Wednesday of the month on the Microsoft Redmond Campus, usually in Building 35/Kalaloch (just behind reception.) Check the signs when you arrive to confirm.

The PNWSQL group is one of the original SQL Server User Groups, meeting monthly on the Microsoft Redmond campus since the early 1990's.

Directions: From I-5 or I-405, go east on SR-520 toward Redmond, take the 40th Street exit, turn right at the end of the ramp, continue straight through the first traffic light at 156th AVE NE, take the next right, and then first left.  Park in the lot on your right, when facing east, the meeting is the building to your left. Please consult this campus map for more information. (Contact the PNWSQL Chapter Leader.)

7:00 - 7:30 - Announcements and Technical Q&A
7:30 - 9:00 - Presentation

IMPORTANT: If you park on campus and do not have authorized Microsoft parking, please bring a current printout of the webpage or this email invitation to fill out and be submitted to Microsoft Security if you bring your own car. Register your name, vehicle make, model, license#, and picture ID at the registration desk. Your printout may also be used in a prize drawing.

Name: _________________________________________

Vehicle Make/Model: _________________________________________

Vehicle License #: _________________________________________

Upcoming PNWSQL Meetings:

December 13, 2017 - TBD


February 9, 2018 - SQL Saturday PreCons, Redmond (Building 34)

February 10, 2018 - SQL Saturday, Redmond (Building 92)




Sorry, there are no upcoming meetings. Please check back for updates.





Back to Top