Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

January

14

WISSUG January 2020 meeting

  • In-Person @ 833 E Michigan St Milwaukee, Wisconsin, United States (map)
  • 11:30 - 13:30 (UTC-06:00) Central Time (US & Canada)
  • Language: English

WISSUG - Jan 2020 Meeting

Date:   14 Jan 2020   (Second Tuesday of the month)

Time: 11:30 AM  (Central Time)

Location: Microsoft office (833 E Michigan St, Milwaukee, WI  53202)  8th floor.

Milwaukee County Transit System (MCTS) details are available here.

 

IMPORTANT!

The Microsoft office building now requires that *everyone* be on a visitor list in order to be admitted to the office.  You must register (see below) for the meeting no later than noon of the Monday before the meeting date.  Thus, for the January meeting, please register by noon on Monday, January 13th.

 

Are you attending in-person?   Register to attend WISSUG meeting in-person

 

Upcoming events:

 

SQL Saturday Chicago (in Lisle, IL): Saturday, March 21st, 2020

(Session list / schedule TBA)

 

SQL Saturday Madison: Saturday, April 4th, 2020

(Session list / schedule TBA)

 

SQL PASS Summit 2020:  Nov 10th – 13th, 2020 (Houston, TX)

 

 

Jan 2020 WISSUG meeting

Dipping Your Toes In: Azure Data Lake for DBAs

Presented by: Bob Pusateri

As a data professional, you know what data is, and hopefully know what a lake is too.

 

But what's a Data Lake?

 

This session covers the very basics of Azure Data Lake, and is geared towards those who are familiar with relational databases and also curious about other technologies. Topics covered will include Data Lake storage, security basics, and an introduction to U-SQL, Azure Data Lake's query language.  

 

We will finish up with architecture examples showing real-world use cases highlighting Azure Data Lake's strengths. Attend this presentation to see how Azure Data Lake can complement your existing relational

database skills, and give you a great new tool in your data toolbox!

 

Bob Pusateri          

Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over

10 years of experience on SQL Server.  His interests involve internals, performance optimization,

and cloud technologies. He is an active member of both Chicago-area PASS Local Groups,

a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).

 

SQL Server Learning Resources

 

PASS Virtual Groups: Over two dozen (free) virtual groups, focusing on different areas of SQL Server, PowerShell, PowerBI and more.  Go to http://www.pass.org/ and click on the Community tab where you’ll find the Virtual Groups link.  Here are just some of the PASS Virtual Groups:

 

PASS Virtual Group

Link to Group

Application Development

https://appdev.pass.org/

Business Analytics

https://ba.pass.org/

Business Intelligence 

https://bi.pass.org/

Cloud

https://cloud.pass.org/

Data Architecture

https://dataarch.pass.org/default.aspx

Data Science

https://datascience.pass.org/

Database Administration

https://dba.pass.org/

DBA Fundamentals

https://fundamentals.pass.org/

DevOps

https://devops.pass.org/

High Availability and Disaster Recovery

https://hadrvc.pass.org/

Performance

https://performance.pass.org/

PowerShell

https://powershell.pass.org/

Professional Development

https://profdev.pass.org/

Virtualization

https://virtualization.pass.org/

Women in Technology

https://wit.pass.org/

 

                                   

Check out the GroupBy site.

This is a free community-based training site organized by Brent Ozar. The SQL Server community (you) determines the content – thanks, Brent!  Submit, review, rate, vote for an abstract at the GroupBy site.

 

 

Join the Meeting!   Powered by GoToWebinar

We are using GoToWebinar for remote attendees.

Please be aware of the following: 

1.    You must register (any time before the meeting) here: WISSUG Group Meeting Link  

2.    Choose the appropriate meeting date from the presented list.

3.    After registering, you will receive a confirmation email to join the webinar.

4.    Phone-in audio is not supported; you must use your computer connection for audio.

 

 

Upcoming WISSUG Meetings and events

11 Feb 2020 – Replacing Profiler with Extended Events – Erin Stellato

10 Mar 2020 – SSRS – Ashley Day

14 Apr 2020 – Introduction to Azure Managed instances – Tim Radney

 

 

We need presenters!  Thinking about being a presenter?   Check out Kendra Little’s post on speaking.

Here’s a video of Kendra with her Top 5 Tips For Your First Presentation video.

 

 

 

WISSUG Group – Stay Informed

If you would like to continue to receive information about upcoming meetings and events for both WISSUG & PASS, please make sure you are registered with an account on SQLPASS.  All communications about WISSUG will be sent via a mailing list to users registered as WISSUG members with sqlpass.org.

 

Keep up to date:

 

1. Go to www.pass.org

2. If you've never registered with this site before, use the Sign Up For Free link in the upper right-hand corner to create your account.

3. If you already receive messages from PASS, login with your account information.

4. Once you're logged in, click the Community tab and choose Local Groups.  Enter Wisconsin in the Filter by Keyword box and click the Search button. Be sure to join WISSUG as a Local Group.

5. Make sure the Subscribe to Email Newsletter checkbox is checked.

 

Featured Presentation:

Dipping Your Toes In: Azure Data Lake for DBAs

Bob Pusateri, Lead Database Engineer Salesforce

As a data professional, you know what data is, and hopefully know what a lake is too. But what's a Data Lake? This session covers the very basics of Azure Data Lake, and is geared towards those who are familiar with relational databases and also curious about other technologies. Topics covered will include Data Lake storage, security basics, and an introduction to U-SQL, Azure Data Lake's query language. We will finish up with architecture examples showing real-world use cases highlighting Azure Data Lake's strengths. Attend this presentation and see how Azure Data Lake can complement your existing relational database skills, and give you a great new tool in your data toolbox!

About Bob:
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of both Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).

 

 

 

PASSChapterLogo.jpg

sql_micro_sm.gif

PASSChapterLogo100.jpg

Powered by Office 365

sql_micro_sm.gif

sql_ca_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids