Next Meeting

Next Meeting: Wed, Sep 02 2015

TorPASS Sept Meeting: TSQL Bullet-Dodging & Spoon-Bending

It's time for our season of the Toronto SQL Server User Group to start again! 


Please register if you will be attending, and let us know if you have registered but cannot join.

2 Sept 2015
http://www.meetup.com/Toronto-SQL-Server-User-Group/events/224807579/

 

In our kickoff meeting we will have Mike DeFehr, a SQL Server MVP from Winnipeg joining us to talk about TSQL, SQL Server's query language.

TSQL Bullet-Dodging and Spoon-bending 

Did you think you could dodge bullets with SQL Server? Well, with some of these techniques, you won't have to. Learn some of the newer language elements in SQL server: 
  • Recursive CTE's,
  • Composable DML, 
  • the MERGE statement, 
  • Row numbering and 
  • table-valued parameters. 

This fast-paced session that is almost exclusively demos is sure to leave you with a few ideas to make your TSQL development life easier.

 

Agenda

5:45-6:00 PM Pizza and Networking
6:00 PM -7:45 PM Presentation
8:00 PM - ??? Option to head to local pub for more discussions

 

About Mike DeFehr 

 
Michael DeFehr is an independent SQL Server consultant doing business through MDD Solutions Ltd. based in Winnipeg, Manitoba. His career has focused on database administration and development using Microsoft SQL Server. A SQL Server MVP, Professional Engineer and Microsoft Certified Information Technology Professional in both Database Development and Administration, Mike has spent the past 20 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity. Mike is the chapter president of the Winnipeg SQL Server Users Group 

 

Important Info

Registration for our meeting is used as the skills testing question for our prize draws.  It's also important for our getting food and drink orders correct.  Please register and also let us know if you can't make it.  


 

When

iCal
UTC : Wed, Sep 02 2015 22:00 - 00:00
Event Time : Wed, Sep 02 2015 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Wed, Sep 02 2015 22:00 - 00:00

Featured Presentation

TSQL Bullet-Dodging and Spoon-bending

Speaker: Michael DeFehr, Consultant MDD Solutions

Summary: Did you think you could dodge bullets with SQL Server? Well, with some of these techniques, you won't have to. Learn some of the newer language elements in SQL server: Recursive CTE's, Composable DML, the MERGE statement, Row numbering and table-valued parameters. This fast-paced session that is almost exclusively demos is sure to leave you with a few ideas to make your TSQL development life easier.

About Michael: Michael DeFehr is an independent SQL Server consultant based in Winnipeg, Canada. He is focused on database administration and development using Microsoft SQL Server. A SQL Server MVP, Professional Engineer and MCITP in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity.

Please ensure you pre-register for our meetings. Registration allows you to participate in our awesome drawings and helps us plan for the meetings.