Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

April

09

Principle of Least Privilege: The Key to Strong Security

  • In-Person @ 833 E Michigan St Milwaukee, Wisconsin, United States (map)
  • 11:30 - 13:30 Central Daylight Time
  • Language: English

WISSUG April 2019 Meeting Announcement

April 2019 WISSUG Meeting

Date:   09 Apr 2019

Time: 11:30 AM  (Central Time)

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

NEW - 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 April meeting, please register by noon on Monday, April 8th.

Are you attending in-person?  You must register by noon on Monday, April 8th on the EventBrite site:

Register to attend WISSUG meeting in-person

Noteworthy items:

WISSUG meets in Microsoft’s office in downtown Milwaukee at 11:30 am on the 2nd Tuesday of the month.   The address is: 833 E Michigan Street on the 8th floor. 

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

Upcoming events:

SQL Saturday Madison (#842)  06.Apr.2019 – note the new location for this year!

PASS Summit 2019 04-08 Nov 2019 in Seattle, WA

Wanna save $150 off registration?  You’re in luck!  Just use this handy code: LGDISC9YE

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.

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 an abstract at the GroupBy site. The next session is scheduled for 11 April 2019.

Don’t forget about Microsoft Virtual Academy.  Lots of free training on SQL Server, PowerShell, PowerBI, SQL Azure – you name it, it’s probably there.

April 2019 WISSUG meeting

Principle of Least Privilege: The Key to Strong Security

Presented by: Ed Leighton-Dick

A truly strong security model starts with no permissions and adds what is necessary to allow

the user or application to do their assigned task - no more, no less. This is called the

Principle of Least Privilege. It's a simple concept, but it can be quite difficult to

implement in practice, especially if the prevailing practice has been much more permissive.

In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll

discuss ways to implement it for the three primary classes of users - general users,

applications, and administrators. Each has their own set of needs that requires a separate

approach to allowing the security to meet those needs. You'll leave with actionable ideas

on ways that you can improve your company's security while minimizing the impact of the changes.

Ed Leighton-Dick (kingfisherdata.com)

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist,

and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer

with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server

User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching

sessions at local, regional, and national events, including user groups, SQLSaturday,

and PASS Summit.

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.

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

14 May 2019 - Azure SQL Database for the Production DBA – Tim Radney  (SQLSkills.com)

11 Jun 2019 - Tracking Data Transformations Using Temporal Tables – Thomas Lane, PhD.

09 Jul 2019 - Deadlocking for Mere Mortals - Jonathan Kehayias  (SQLSkills.com)

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.

We are pleased to have Manning Press as a continuing WISSUG sponsor.

Manning has generously offered all WISSUG members a 36% discount on all their titles.

Simply enter UG367 in the Promotional Code box when checking out.

Featured Presentation:

Principle of Least Privilege: The Key to Strong Security

Ed Leighton-Dick, President Kingfisher Technologies

A truly strong security model starts with no permissions and adds what is necessary to allow the user or application to do their assigned task - no more, no less. This is called the Principle of Least Privilege. It's a simple concept, but it can be quite difficult to implement in practice, especially if the prevailing practice has been much more permissive. In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.

About Ed:
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including roles as Regional Mentor, leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

 

 

 

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