Next Meeting: Tue, Nov 08 2016

November SQL/Power BI Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None

It may be US Election night, but we are getting together to talk about the PASS Summit and to talk about the good, bad, and ugly of adopting Power BI in a large organization.

Mike Diehl attended the PASS Summit in late October, and will show an overview of the announcements that were made there, and some of the things he learned.

We are pleased to welcome Patrick Molloy, Chief Innovation Officer from The Workers Compensation Board of Manitoba. Patrick will discuss the Good, Bad, and Ugly of a recent implementation of Power BI as a partner reporting portal.

Pizza will be at 5:30 and we'll kick off the presentations at 6.

We will be meeting in the upstairs meeting room at the St. Boniface Library.

Please RSVP so that we know how much pizza to order. Tell your friends and colleagues about the meeting, it's free!


Event Time : Tue, Nov 08 2016 17:30 - 20:30 (UTC-06:00) Central Time (US & Canada)


St. Boniface Library - Salle Marie Lynn Bernard
131 Provencher Blvd
Winnipeg, Manitoba
Direction: None

Featured Presentation

PASS Summit 2016

Speaker: Mike Diehl, Practice Lead, Databases and Business Intelligence Imaginet

Summary: A review of the announcements made at the PASS Summit and some of the sessions that Mike attended.

About Mike: Mike Diehl is the practice lead for Databases and Business Intelligence at Imaginet Resources, a Microsoft partner with offices in Dallas, Calgary, and Winnipeg. Mike has over 20 years of experience using Microsoft database technologies and is an expert in Agile Analytics, Scrum, Kanban, and Microsoft Team Foundation Server.

Power BI: The Good, Bad, and Ugly

Speaker: Patrick Molloy, Chief Innovation Officer WCB Manitoba

Summary: The WCB recently implemented Power BI as a partner reporting platform. Patrick Molloy will talk about the progress and the lessons learned.

About Patrick: Patrick Molloy, Chief Innovation Officer at the WCB, has held many titles over his career in each of those roles a large portion of his duties involved business analytics. This has evolved into a passion and a cornerstone of his management style. Patrick has used his skills to advance business analytics in retail, telecom, online advertising and now the public sector. Patrick is currently pursuing his MBA and is an dedicated boxing coach and trainer.


Welcome to the Winnipeg SQL Server User Group, a PASS Associated Organization!

We highly recommend attending the PASS Summit 2016, October 25-28 in Seattle. The price goes up July 17, so register early.

As a Winnipeg SQL PASS Chapter member, you can use discount code LC15QNK9 when you register to get $150 off.

We meet approximately monthly Fall through Spring at the St. Boniface library branch, 131 Provencher Boulevard (just over the Provencher Bridge).

We are always looking for the next topic to present - so if you want to try out an idea with a friendly group, please let us know.

Here are some ideas for topics that might help you think of something you can present.

  • What I learned about indexing that changed my life.
  • Data warehousing - is it just a bigger data mart?
  • I love/hate Entity Framework
  • I could not live without these tools
  • My personal naming conventions, and why I will defend them to the death!
  • Big data - so what?
  • How I implemented a fault tolerant, highly available database on the cheap (or not so cheap)
  • How to convince the network/server guys that you need more resources for your virtual machine
  • What I learned when I tried to restore a database and it didn't go well
  • Power Query saved me weeks!
  • SQL Management Studio shortcuts you should know
  • How much control should DBAs and Developers have?
  • Techniques for masking or sanitizing data
  • Managing private data securely - encryption and decryption
  • What to ask for from the SAN administrator
  • How can I put my database into Azure? Is it safe? Is it expensive?
  • How I discovered bad queries and optimized them and saved the world!
  • T-SQL Smells
  • Backups, transaction logs, and recovery settings - myths debunked
  • Determining how to prevent deadlocks
  • How to use the SSIS Catalog
  • How I use Policies to manage servers
  • Maintenance plans - hero or zero?
  • Life with Replication