Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

January

08

WISSUG January 2019 meeting

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

WISSUG Jan 2019 Meeting Announcement

 

January 2019 WISSUG Meeting

Date:  08 Jan 2019

Time: 11:30 AM  (Central Time)

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

 

ATTENTION:  New meeting time!  See below for details.

 

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.

 

 

Noteworthy items:

NEW MEETING TIME for WISSUG meeting!

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

SQL Saturday Chicago (#825)  23.Mar.2019

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

 

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.

 

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.

 

 

 

January 2019 WISSUG meeting

PowerShell + SQL Server = Better Together

Presented by: Mike F Robbins (mikefrobbins.com)

As a SQL Server professional, are you able to make a rhyme or reason to this thing called PowerShell?

Need to accomplish something?  Do you use Windows PowerShell or PowerShell Core?

How will you interface with PowerShell?  With the PowerShell console, the PowerShell ISE, VSCode,

SAPIEN PowerShell Studio, or something else?  

Will you use Cmdlets from one of the various SQL related PowerShell modules? If so, which one? SQLPS, SQLServer, DBATools, etc.

Or maybe you should use the SQL PS provider?  What about SQL DMO?

Or maybe you should just write your own custom .NET code that can be executed with PowerShell?

With it being so difficult to determine how to go about running something in PowerShell, it’s no wonder that most people resort to searching the Internet to figure out how to accomplish something.

 

The sad thing is that most of the PowerShell code you’ll find on the Internet is less than

optimal to say the least. During this session, Mike F. Robbins will clarify and demonstrate

how and when to use different approaches along with adhering to the community’s best practices

for writing PowerShell code.

 

 

Mike F. Robbins (mikefrobbins.com)

Mike F. Robbins is a Microsoft Cloud and Datacenter Management MVP for Windows PowerShell.

He is the creator of The PowerShell Conference Book, author of PowerShell 101: The No-Nonsense

Beginner’s Guide to PowerShell, co-author of Windows PowerShell TFM 4th Edition, and a contributing author of a chapter in the PowerShell Deep Dives book.

Mike is also the leader and co-founder of the Mississippi PowerShell User Group.

He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.

 

 

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

12 Feb 2019 – Tom Lane – Data Warehousing with SQL Azure

12 Mar 2019 – Erin Stellato (SQLSkills) - Replacing Profiler with Extended Events

09 Apr 2019 – TBD (insert your name here…)

 

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:

PowerShell + SQL Server = Better Together

Mike F Robbins, Microsoft Cloud and Datacenter Management MVP

As a SQL Server professional, are you able to make a rhyme or reason to this thing called PowerShell? Need to accomplish something? Do you use Windows PowerShell or PowerShell Core? How will you interface with PowerShell? With the PowerShell console, the PowerShell ISE, VSCode, SAPIEN PowerShell Studio, or something else? Will you use Cmdlets from one of the various SQL related PowerShell modules? If so, which one? SQLPS, SQLServer, DBATools, etc. Or maybe you should use the SQL PS provider? What about SQL DMO? Or maybe you should just write your own custom .NET code that can be executed with PowerShell? With it being so difficult to determine how to go about running something in PowerShell, it’s no wonder that most people resort to searching the Internet to figure out how to accomplish something. The sad thing is that most of the PowerShell code you’ll find on the Internet is less than optimal to say the least. During this session, Mike F. Robbins will clarify and demonstrate how and when to use different approaches along with adhering to the community’s best practices for writing PowerShell code.

About Mike F:
Mike F. Robbins is a Microsoft Cloud and Datacenter Management MVP for Windows PowerShell. He is the creator of The PowerShell Conference Book, author of PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell, co-author of Windows PowerShell TFM 4th Edition, and a contributing author of a chapter in the PowerShell Deep Dives book. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.

 

 

 

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