April PASSMN Meeting–SQL 2012 and Apply T-SQL Magic

Sponsor: Techfuse 2012 – May 16th & 17th

Date: April 17, 2012

Time: 4:00 PM – 7:00 PM

Location: 3601 West 76th Street, Suite 600 Edina, MN  55437 

Live Meeting:

• URL: https://www.livemeeting.com/cc/usergroups/join?id=F863BG&role=attend&pw=44%2Cj5N%40t7
• Meeting ID: F863BG
• Entry Code: 44,j5N@t7

Agenda:

• 4:00-4:30 : Registration / hospitality / networking
• 4:30-4:45 : Intro / Greetings
• 4:45-5:45 : Ted Kummert and Mark Souza – SQL 2012 Discussion and Q+A
• 5:45-6:00 : Break
• 6:00-7:00 : Itzik Ben-Gan – Apply T-SQL Magic
• 7:00-7:15 : Closing comments/prize giveaways

Presentation/Discussion:

SQL 2012 Discussion and Q+A

Ted Kummert, Microsoft and Mark Souza, Microsoft

SQL2012 discussion covering the following topics:

• Running your Business and Mission Critical environments
• BIG Data and scaling breakthrough insights throughout your organization
• Unlock New Insights With Pervasive Data Discovery Across the Organization
• Adopting the Cloud on your own terms

Ted Kummert is corporate vice president of the Business Platform Division (BPD) within the Microsoft Server and Tools Business at Microsoft Corp. He is responsible for leading the product strategy and development of an integrated application platform – including database and application servers, cloud services, and data programmability and modeling technologies.

Mark Souza (Site/Twitter) is a General Manager in the Microsoft Business Platform Division. He is responsible for all Customer/Partner interaction, Content and Community for the business platform products at Microsoft: Middleware, Database and Cloud. Using Customer Experiences he ensures the BPD division is building and shipping products that customers need to build enterprise class solutions. He is responsible for building the best, most vibrant technical community in the world. He also ensures that the Business Platform community has the highest quality content at their fingertips at the time they need it. Mr. Souza’s twenty eight+ years in the Information Technology business has consisted of database administration, end-user tool management, systems engineering database specialist/lead, client/server architect, Microsoft regional data technology specialist, SQL Server development customer advisory team and most recently general manager of customer, content and community.

Presentation:

Apply T-SQL Magic

Itzik Ben-Gan, SolidQ

When a new version of SQL Server is released, with most of the new T-SQL features that are introduced you can usually quickly tell what their benefits are and what you can use them for. But with some features, it can take some time before people start discovering their true value and what you can do with them. Such is the APPLY operator that was added in SQL Server 2005. Initially it seemed just like an ordinary language element with a couple of uses, but with time people found very creative and interesting uses for it. This session describes the APPLY operator, and focuses on advanced, creative uses.

Itzik Ben-Gan (Blog/Twitter) is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written articles for SQL Server Magazine, SolidQ Journal and MSDN. Itzik’s speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ’s events to name a few. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.