Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

May

10

May 2016 WISSUG Meeting

  • In-Person & Online @ N19W24133 Riverwood Drive, suite 150 Waukesha, Wisconsin, United States (map)
  • 16:30 - 18:00 Central Daylight Time
  • Language: English

WISSUG Feb 2015 Meeting Announcement

May 2016 WISSUG Meeting

 

Date: 10 May 2016

Time: 4:30 PM

Location: Microsoft Office in Waukesha   (N19W24133 Riverwood Drive, Waukesha, WI  53188)

 

Driving directions: Take I-94 to County J/Waukesha (Exit 294). Take County J north for  about 1/4 mile. Go past the stone entrance to Riverwood office park (on your left), and proceed to the next entrance, which is Riverwood Drive, marked by a street sign.  Go to the building designated Riverwood 2, which will be on your left.

 

We need presenters.  Really.  Check out Kendra Little’s post on Speaking.

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

 

Newsworthy items:


SQL Server 2016 to be released 01 June 2016 

Read about the new version of SQL Server here: https://blogs.technet.microsoft.com/dataplatforminsider/2016/05/02/get-ready-sql-server-2016-coming-on-june-1st/

 

PASS Summit 2016  (October 26-28, Seattle, WA)

The 2016 PASS SQL Server Summit is returning to Seattle in October.

Planning to go?  Great!  Thinking of going?  Great idea!

Here’s some help.  Use this super secret code (LC15HFK3) when you register and save $150 off the registration fee. But don’t wait too long; the fee goes up after 17 July.      

SQL Server Developer Edition is now 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 Chapters: Over two dozen virtual chapters, each focusing on a different area of SQL Server.  Go to http://www.sqlpass.org/ and click on the Join a Virtual Chapter button to view the list and just click to the chapters that interest you.

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

May 2016 WISSUG meeting

In case you hadn’t noticed, Microsoft has really been highlighting PowerBI lately.  What’s all the fuss, you may ask?  It turns out there’s some pretty cool stuff in there.  Okay, great.  How does it work? Where do I start?    Attend this month’s Chapter meeting and find out.

 

Presentation Preview

Putting Power Query and DAX to Work in Power BI    Presented by Dr. Thomas Lane (Solve100.com).         

Within the ever expanding product that is called Power BI Microsoft has added two tools for ETL.

One tool used during the extraction and loading process is called Power Query (formally "M") and is applied before the data is loaded in Power BI.

The second tool is called DAX. First used with Power Pivot and Power View, DAX helps you create new information from data already in your model.
We will explore and hopefully exploit these two tools to create better visualizations within Power BI.     

Dr. Thomas Lane (Solve100.com) is a BI/DW Consultant at Solve (www.Solve100.com). 
He received his Ph.D. in Chemistry, did his post-doctoral study at Marquette University, taught programming and database classes at Marquette University, worked as an instructor for a private teaching firm, worked as a developer, and for the past fourteen years worked with SQL server as DBA, ETL specialist, and Data Architect at various Midwestern companies
.

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 "in the know".

       

1. Go to www.sqlpass.org

2. If you've never registered with this site before, use the Register 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, go to MyChapters and make sure to join WISSUG as a Local Chapter.

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

 

WISSUG Meeting Agenda

* Networking with your peers: Got a problem? Got an answer?  Share it!

* WISSUG Business: Don’t just sit there – participate!  Volunteer, present a topic, share your expertise (or your painful learning experience) with chapter members, suggest a topic for a presentation.  The more people participate, the better the group becomes.

* Presentation by Dr. Thomas Lane

     

Join the Meeting!

Copy this address and paste it into your web browser:        

       

Please register for WISSUG Monthly User Group Meeting at:

After registering, you will receive a confirmation email containing information about joining the webinar.

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

Brought to you by GoToWebinar®

Webinars Made Easy®  

 

Upcoming WISSUG Meetings

14 June 2016 – Gary Schultz – SSMS Tips & Tricks

12 July 2016 – Dave Levy (Microsoft) – Always Encrypted in SQL 2016

09 August 2016 – TBD

 

Special Offer from Manning Press:

         

We are pleased to welcome 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.

______________________________________________________________________

Special thanks to our sponsors:

WiSSUG sponsors are the best - Please support our sponsors with your patronage.