Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

August

08

WISSUG August 2017 meeting

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

WISSUG Aug 2017 Meeting Announcement

August 2017 WISSUG Meeting

Date:  08 Aug 2017

Time: 4:30 PM

Location: Microsoft office (833 E Michigan St, Milwaukee, WI  53202)

ATTENTION:  New meeting location!  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 LOCATION for WISSUG meetings!

Microsoft has completed the process of moving to their new office in downtown Milwaukee.

833 E Michigan Street (8th floor) to be precise. 

This will be our meeting location beginning with the June 2017 meeting. 

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

SQL PASS Summit 2017

The SQL PASS Summit is returning to Seattle this year and runs from 30 October – 03 November.

Psssttt..  Here’s a $150 discount code, just for you: LC15HFK3.  You’re welcome.

Have you seen the GroupBy site?

This is a free community-based training event with the next sessions scheduled for September 2017. Organized by Brent Ozar, the SQL Server community determines the content – thanks, Brent! 

Review, rate, submit an abstract at the GroupBy site.     

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

Microsoft has decided to make Developer Edition freely available.  No, it’s not time-bombed.

All you have to do is join (for free) the Visual Studio Dev Essentials program then download the software.

PASS Virtual Groups (Chapters): 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. 

Aug 2017 WISSUG meeting

Gathering Data for Trending with PowerShell   

Presented by Ben Miller  (Ben Miller & Associates, Inc.)

Think of questions that you could ask about an environment that is database rich.

How many databases do you have, across how many servers?

How has the data grown and how much disk space will we need over the next 2 years?

So many questions to be asked and there are not a lot if any views or functions

that can tell you what happened a day ago or even last week. Do you know how many

databases you had at the beginning of the year or at the end of the year without

having to dig through logs or other places?

This session will cover using PowerShell to get information quickly and putting it

in a repository that you can use the answer these questions. Not only that, but you

can use it proactively in your career as a DBA. PowerShell has some great tools and

using SMO you can gather and store all that information.

Join me in the quest to become a PowerShell DBA and have information at your

fingertips to help you in your career.

Ben Miller (Ben Miller & Associates, Inc.)   

Ben has been a member of the SQL Server Community since 2000. He is currently working

at MaritzCX revolutionizing the SQL Server environment and loving it. He also consults. 

He is a SQL Server MVP and MCM: SQL 2008, and has spent time in the field using

SQL Server since 1997. He has worked at various companies throughout the US, as well

as at Microsoft for 7 years. He is passionate about SQL Server and automation and

integration and uses SMO and PowerShell regularly.

WISSUG Chapter – 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 now using GoToWebinar for a better remote attendee experience.

Please be aware of the following: 

1.    You must register (any time before the meeting) here: WISSUG Chapter 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

12 Sep 2017 - Jason Granat – SSIS: Can’t We Just Get Along?

October – no meeting – see you at the PASS Summit in Seattle!

14 Nov 2017 – Kimberly Tripp - Statement Execution and the Plan Cache

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:

Gathering Data for Trending with PowerShell

Ben Miller, SQL Server Architect Ben Miller & Associates, Inc.

Think of questions that you could ask about an environment that is database rich. How many databases do you have, across how many servers? How has the data grown and how much disk space will we need over the next 2 years? So many questions to be asked and there are not a lot if any views or functions that can tell you what happened a day ago or even last week. Do you know how many databases you had at the beginning of the year or at the end of the year without having to dig through logs or other places? This session will cover using PowerShell to get information quickly and putting it in a repository that you can use the answer these questions. Not only that, but you can use it proactively in your career as a DBA. PowerShell has some great tools and using SMO you can gather and store all that information. Join me in the quest to become a PowerShell DBA and have information at your fingertips to help you in your career.

About Ben:
Ben has been a member of the SQL Server Community since 2000. He is currently working at MaritzCX revolutionizing the SQL Server environment and loving it. He also consults on SQL Server problems. He is a SQL Server MVP a SQL Server MCM, and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US, as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration and uses SMO and PowerShell regularly. He teaches DBAs how to use PowerShell as well.

 

 

 

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