Next Meeting: Tue, Sep 19 2017

September SQL Server / Power BI User group meeting

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

After a long hiatus, we're starting up the SQL Server / Power BI user group meetings again.

We will get together to discuss SQL Server and/or Power BI. The speaker and topic is still to be determined, but we'll have something interesting.

Please RSVP so that we can determine how much pizza to order.

  • 5:30 pizza and chat
  • 6:00 presentation




Event Time : Tue, Sep 19 2017 17:30 - 20:30 Central Daylight Time


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


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

We highly recommend attending the PASS Summit 2017, October 31-November 4 in Seattle.

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


If you haven't registered for a free membership, please do so now! And make sure you add the Winnipeg SQL Server Users Group to your affiliations. There are tons of great resources and virtual chapters you can join too. Register here.



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