Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

March

13

WISSUG March 2018 Meeting

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

WISSUG Mar 2018 Meeting Announcement

March 2018 WISSUG Meeting  - NEW MEETING TIME!

Date:  13 Mar 2018

Time: 11:30 AM     ß NEW MEETING TIME!

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

ATTENTION:  New meeting time!  See below for details.

Why not be 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.

Noteworthy items:

NEW MEETING TIME for WISSUG meeting!

WISSUG meets in Microsoft’s new office in downtown Milwaukee.

The address is: 833 E Michigan Street on the 8th floor. 

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

In an effort to make the Group meetings accessible to more people, our meeting time has changed to start at 11:30 am Central Time. 

Our meeting date remains the second Tuesday of each month.

SQL Saturday 2018 (Madison, WI) 07 April, 2018

SQL Saturday is returning to the Pyle Center in downtown Madison in April of 2018.

Registration is working and the speaker list/agenda is available.  Free training, but no free lunch.

There are no less than five pre-cons (which are not free) on Friday, the 6th.

Pre-con topics Azure, R, “Keeping your DBA happy”, Cloud data security, and PowerShell modules for the DBA.

Check out the GroupBy site.

This is a free community-based training event with the next sessions scheduled for 16 March, 2018. Organized by Brent Ozar, the SQL Server community (you) determines the content – thanks, Brent!  Review, rate, submit an abstract at the GroupBy site.     

SQL Server Developer Edition (including SQL 2016, 2017) available for free.

You need to join (for free) the Visual Studio Dev Essentials program then you can download SQL 2017.

PASS Virtual Groups: Over two dozen virtual groups, focusing on different areas of SQL Server. 

Go to http://www.pass.org/ and click on the Community tab where you’ll find the Virtual Groups link.  There are over a dozen virtual groups from Data Architecture to PowerShell and more.  For free.

Have you checked out Microsoft Virtual Academy?  There’s a ton of free training just waiting for you.

Not just SQL Server.  PowerShell, Windows Server, Networking, and more.  Have a look. 

Mar 2018 WISSUG meeting

SQL Server and PowerShell: Let's Get Serious    Presented by Drew Furgiuele

Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away.  It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA.  In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together.  You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.

Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work.  You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.

Drew Furgiuele    

Drew Furgiuele is a Senior SQL Server DBA at IGS in Dublin, Ohio.

He's also a release manager, and works in the developer operations group to help deploy database and code changes.  When he's not accidently dropping tables in production, Drew enjoys CrossFit, board games, electronics, and spending time with his dog.

Drew helped create the High Altitude SQL Server Project, which is an attempt to put SQL Server in the upper atmosphere.  You can read more about it on his blog:  http://www.port1433.com

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 get 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.

 

Here's how to make sure you can stay 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

16 Mar 2018 – GroupBy  sessions

07 Apr 2018 - SQL Saturday

10 Apr 2018 -  10 Common SQL Server Mistakes and How To Avoid Them – Tim Radney (SQLSkills.com)

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:

SQL Server and PowerShell: Let's Get Serious

Drew Furgiuele, Senior DBA IGS Energy

Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA. In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts. Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.

About Drew:
I am a senior DBA that is passionate about SQL Server, PowerShell, automation, source control, and release management, and mixing them all together in a funky blender. I've been in the game since SQL Server 2000, and I haven't stopped wanting to learn more and share my experiences since.

SQL Server and PowerShell: Let's Get Serious

Drew Furgiuele, Senior DBA IGS Energy

Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA. In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts. Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.

About Drew:
I am a senior DBA that is passionate about SQL Server, PowerShell, automation, source control, and release management, and mixing them all together in a funky blender. I've been in the game since SQL Server 2000, and I haven't stopped wanting to learn more and share my experiences since.

 

 

 

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