Calgary Events

Join us on 16 November 2016 for our last session of the year.

As usual, food and soft drinks will be provided, and entrance is free.

Please RSVP on Eventbrite.

Topic: When Database Corruption Strikes
Speaker: Steve Stedman
When: Wednesday, November 16, 2016
Where: Microsoft Canada, 110 - 9 Ave SW (8th Floor), Calgary AB
RSVP: Click here

Sponsor: 

Join us for our next user group session on 14 September 2016 at 4:30pm.

As usual, food and drinks will be provided free of charge, and entry is free.

To RSVP, visit the Eventbrite page.

Topic: SQL Server 2016: What's new in Database Engine
Venue: Microsoft Canada, 110 - 9 Ave SW (8th Floor), Calgary, AB T2P 1M9
Presenter: Mohit K. Gupta, Microsoft Canada
Sponsor: AMTRA Solutions

AMTRA Solutions

To RSVP, visit the Eventbrite page.

 

PASS Summit 2016 Discount Code

Save $150.00 on your PASS Summit 2016 registration, by using this Calgary PASS Chapter discount code.

LC15RPW2

* This discount code cannot be combined with any other PASS Summit 2016 registration, and cannot be applied retroactively. 

Join us on 10 March 2016 for another user group session.

As always, refreshments will be provided, and entrance is free.

You can RSVP using Eventbrite.

Topic: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)
Presenter: Ed Leighton-Dick
Where: Microsoft Canada, 8th Floor, 110 - 9 Ave SW, Calgary, T2P 1M9

Session:

As DBAs, we are asked all sorts of impossible questions. Who dropped that important table last month? Why was everything slow last week? Who made that user a sysadmin? You’d have to be a mind reader to know the answers to some of those, right? Not necessarily! SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide. In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.

Speaker:

Ed Leighton-Dick is a SQL Server consultant, speaker, and blogger. He is a frequent volunteer with PASS, including roles as chapter leader and regional mentor.

Sponsor:


 

Join us for our next User Group session in January 2016. Snacks and soft drinks will be provided.

You can get your free tickets from Eventbrite.

Topic: How to Become a World Class SQL Server Performance Tuner
Presenter: Mike West
Date: Thursday, 21 January 2016, 4:30pm to 6:30pm
Venue: Microsoft Canada, 110 - 9 Ave SW (8th Floor), Calgary AB, T2P 0T1

SQL Server Slow?

This presentation focuses on making SQL Server more performant.

SQL Server is like a high performance sports car. Anyone can drive it but put it in the hands of a skilled performance tuner and you've just gone from average to incredible.

http://www.thesqlspot.io/courses/sql-server-performance-tuning-101

About the Speaker:

Mike West brings over 20 years of IT experience, including expertise in network administration, and for the last 13 years, SQL Server exclusively.

Prior to becoming a database consultant, Mike worked as a senior level SQL resource for Fortune 500 as well as several small to mid-size companies. He has authored a book on Forex Trading.

Mike is a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Sponsor:

 

Microsoft Data Platform Days

You are invited to the Calgary edition of Microsoft Data Platform Days on October 29, 2015.

Register here.

Top 3 Reasons To Attend:

  • - Discover the latest details about Cortana Analytics Suite‚ Data Lake‚ Azure SQL Data Warehouse and new features in Power BI

  • - Connect with product experts from Microsoft and Partners.

  • - Update and sharpen your skills.

Also‚ with SQL Server 2005 End of Support coming soon‚ if you are still using this legacy technology‚ it is critical to develop a migration plan. We will guide you on how to ensure a successful move to SQL Server 2014 to secure your data and realize significant gains in performance and scalability.

 

Live! 360 Orlando is a unique conference where the IT and Developer community converge to test-drive leading edge technologies and fuel up on current ones.

Register for 5 days of SQL Server networking & training, from November 16 - 20! Save US$600 with code UGOR14.


 

One more event before the 2015 PASS Summit!

Join us for a remote session with Tim Radney, of SQLskills.com.

As always, food and drinks will be provided, and entrance is free.

You can RSVP using this Eventbrite link.

Session: Common SQL Server Mistakes and How to Avoid Them
Presenter: Tim Radney
Date: 7 October 2015
Time: 4:30pm to 6:30pm
Place: Microsoft Canada, 110 - 9th Avenue SW
8th Floor

Calgary, AB

Sponsor:


Zerto 

Join us for our next event:


SQL Server Performance Tuning Starter Kit


Food and drink will be provided.

Where: IBM Canada Ltd, 227 - 11 Ave SW (2nd Floor), Calgary

When: Wednesday, August 19, 2015, 4:30pm to 6:30pm

For your free ticket, please RSVP using this Eventbrite link.

About this session:


"The database is slow" is the most painful sentence a DBA wants to hear.

In this session, you will learn how to make SQL Server go faster, from the ground up.

We will cover server configuration, database settings, as well as index and query tuning.

Buckle up!

Speaker:


Randolph West (Born SQL) is an independent consultant, a SQL Server 2012 MCSE, and specialises in performance tuning and query optimisation.

He has worked with SQL Server since version 6.5, and spent the longest time making SQL Server 2000 go faster.

Sponsor:


Simplivity logo

 

Please join us for our next event, free of charge as always.

Food and drinks will be provided.

You can get your free ticket through Eventbrite by clicking on this link.

Topic: Inside Microsoft Power BI
When: Wednesday, June 24 2015, 4:30pm - 6:30pm
Where: IBM Canada Ltd, 227 - 11 Ave SW (2nd Floor), Calgary AB, T2R 1R9
Speaker: Felipe Ferreira, SQL Server MVP
Sponsor: Microsoft
 

The 2015 PASS Nomination Commitee (NomCom) and Board of Directors elections are coming soon. We want to make sure that you're ready to cast your vote!

As part of the eligibility requirements for voting in PASS elections, members must complete all mandatory fields in their myPASS profile by June 1, 2015. Please take a moment now to confirm that your profile is complete.

Checking your profile is quick and easy:

  • Log in to your myPASS account
  • Click myProfile
  • Review and update all fields
  • Click Save
  • Make sure you see that the eligible voter checkmark in green appears under voting eligibility.

Have more than one profile? Please log in to the profile(s) you no longer use, and click Deactivate My Profile beside the Save button.

By updating your profile by 11:59 pm PDT on June 1, 2015, you will receive an email with your ballot link for the PASS NomCom election on July 16 and another email with your ballot link for the PASS Board of Director elections on September 17. Go here for more information about the 2015 PASS elections timeline.

Need more information or have questions? Please contact governance@sqlpass.org.

 

Microsoft MVP V-Conf

Join Microsoft MVPs from the Americas' region on May 14th and 15th, 2015, as they share their knowledge and real-world expertise during a free event, the MVP Virtual Conference.

Click here to register. Remember, it's free and open to the public!

 

With PASS Summit 2015 just around the corner, save on registration!

Members of Calgary PASS can save $150 off their PASS Summit registration by using the unique Chapter discount code:

LC15RPW2

The PASS Summit 2015 registration rate goes up after April 19, 2015, so we encourage you to register now to get the best possible rate.

Members can also save on accommodation by registering with PASS' partner hotels – PASS has negotiated with the hotels closest to the Conference Center to provide special rooming rates.

 

You are invited.

Data Platform Technologies are constantly evolving. To help you keep up to date, Microsoft Canada introduces a Data Platform webcast series.

Please join us to learn about new generation of Microsoft Data Platform solutions:

  • Power BI
  • Analytical Platform System appliance
  • In-Memory technologies
  • Azure Cloud Data Services
  • SQL Server 2014

 

Click for information in English or French

An Overview of In-Memory OLTP

 

When: Wednesday, November 12, 2014

Where: Microsoft Calgary Office

Presenter: Mohit K. Gupta, Microsoft Canada PFE

Sponsor:

Tickets: Click here

Event Description

Microsoft SQL Server 2014 introduced the new In-Memory OLTP Engine (code-named "Hekaton") for improving the performance of OLTP workloads.

In this discussion we will look at the overview of what In-Memory OLTP means, and how it impacts our current workloads. We will see how to implement it, and what changes you may need to make effective use of it.

We will also look at the configuration and some of the basic troubleshooting techniques you will need to be aware of when implementing In-Memory OLTP.

 


Hello everybody,

PASS Summit 2014 is just around the corner and we would appreciate your help in spreading the word!

You can help your members save on registration by promoting your unique Chapter discount code for $150 off via your website, blog, and meetings, and receive a referral bonus for your Chapter!

Local Chapter Unique Discount Code*

Your Chapter: Calgary PASS
Unique Discount Code: USSCS25

*The Chapter discount code cannot be combined with any other PASS Summit 2014 discount and cannot be applied to an existing registration.

Remember, the PASS Summit 2014 registration rate goes up after June 27, so we encourage you to share your code with members ASAP so they can get the best possible rate. Further details on the referral benefit program will be shared soon.

Regards,
PASS Marketing

Bottom Banner

Contact Us | Privacy Policy | Terms of Use

Copyright © 2014 PASS Professional Association for SQL Server
Suite 2100 - 203 North LaSalle Street
Chicago IL 60601
604.899.6009
www.sqlpass.org

All Rights Reserved.

 

Looking for previous sessions or downloads?
Visit the Meeting Archive page.

 


Big Data Fiday
- Presented by Microsoft and Hitachi Solutions in Calgary - June 13, 2014 

Join us for another User Group Session on April 14, 2016.

Entrance as always is free, and refreshments will be provided.

Please RSVP using Eventbrite.

Topic: Database Design Fundamentals
Presenter: Louis Davidson
When: Thursday, April 14, 2016, 4:30pm - 6:30pm
Where: Microsoft Canada, 8th Floor, 110 - 9 Ave SW, Calgary, T2P 1M9

Session:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense.

In this session you will get an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

Speaker:

Louis Davidson has over 19 years as a corporate database developer and architect. Currently he is the Data Architect for the Christian Broadcasting Network out of Nashville, Tennessee. Nearly all of Louis' professional experience has been with Microsoft SQL Server from the early days, to whatever is the latest version currently in beta.

Louis has been the principal author on several books, including one on DMVs and five editions of a book on database design, including one later this year updated to include SQL Server 2016 features. Louis' primary areas of interest are database architecture and coding in T-SQL, with experience designing many databases and writing thousands of stored procedures and triggers through the years.

Sponsor:

Simplivity 

SQL Server & Power BI Hands On Training - IT Camps -  Jun 19, 2014 

DevTeach will be presenting a developer conference in Montreal from 4 to 8 July 2016 at the Hotel Omni Mont-Royal.

The event features three days for the main conference (July 5-7), as well as Pre-Conference and Post-Conference events.

This DevCon will be presented during the Montreal Jazz Festival. Montreal is the place you would like to be at during next summer and get your training.

Speakers include Itzik Ben-Gan, Kevin Feasel, and Barbara Fusinska.

Use this redemption code to get a discount on the registration fee:

AL000SQLCALGARY

Click here now to register.

 

PASS Summit 2014 is just around the corner and we would appreciate your help in spreading the word!

You can save on registration by using your unique Chapter discount code for $150 off! 

Local Chapter Unique Discount Code*

Your Chapter: Calgary PASS
Unique Discount Code: USSCS25

*The Chapter discount code cannot be combined with any other PASS Summit 2014 discount and cannot be applied to an existing registration. 

Remember, the PASS Summit 2014 registration rate goes up after June 27, so we encourage you to share the code with other members ASAP so they can get the best possible rate.

 
Sponsors
Microsoft     Microsoft SQL Server     Telerik
    CA Technologies
    MaximunASP
                 
        SSWUG.org