Winnipeg SQL Server User Group

Next Meeting: Mon, Jan 28 2019

January SQL Server / PowerBI meetup

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Winnipeg-SQL-Server-Power-BI-User-Group/events/258280036/

Free pizza and drinks at 5:30, session starts at 6.

 

When

iCal
Event Time : Mon, Jan 28 2019 17:30 - 19:30 (UTC-06:00) Central Time (US & Canada)

Where

100-131 Provencher Blvd

Winnipeg, Manitoba
Direction: Upstairs meeting room.

Featured Presentation

Database cloning

Speaker: Kirill Kravtsov, Database Administrator Wawanesa Mutual Insurance

Summary: One of the most regularly occurring tasks of a SQL Server DBA is database cloning. There is a surprisingly large number of ways how to clone a database and on this session I will go through each of them and talk about their strengths and weaknesses. Some of the neat tricks that you will see: * How to clone a database without an intermediate database dump * How to clone a database without data * How to clone a database to a previous(!) version of SQL Server * How to mask sensitive data in a clone * ... and how to automate all of the above using TSQL and/or Powershell

About Kirill: DBA for more than 10 years, Powershell enthusiast and major dbatools contributor. I'm also a huge fan of DevOps mentality and an active Jenkins user, which left me with no choice other than using and developing tools that automate most of the aspects of the database management. In my free time I enjoy travelling, playing video games, heavy metal music and many more.

Intro to Azure Data Catalog

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

Summary: Do you have a data dictionary? Or wish you had? Or wish your data dictionary was easier to maintain? Maybe Azure Data Catalog can help you. We'll be covering the basics of the capabilities and operations of Azure Data Catalog.

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.

Attachments

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

We highly recommend attending the

PASS Summit 2018, November 6-9, 2018 in Seattle.

 

Save $150 USD
Register for PASS Summit and as a member of Winnipeg SQL Server / Power BI User Group you can save $150 USD off your conference registration price. 
To access your exclusive discount, use code LSDISTIV9 when you register and your savings will calculate at time of registration.
*Unique discount code cannot be applied retroactively and cannot be combined with any other offers

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

   

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids