SQLSaturday #339 - Shanghai 2015

Event Date: 05/09/2015 00:00:00

Event Location:

  • Microsoft (China) Shanghai GGW office
  • 虹桥路3号
  • Shanghai, Shanghai, China

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Programming T-SQL Enhancements in SQL Server 2012

Abstract: As SQL Server evolves, so does Microsoft continue to improve and enhance Transact SQL (T-SQL). In SQL Server 2012, T-SQL remains the primary language for programming the relational database engine. In this informative and demo-packed session, Lenni will guide you through the T-SQL enhancements in the very latest release of SQL Server. We’ll dive into powerful new windowing enhancements with the OVER clause, running and sliding aggregations, new T-SQL functions (all 22 of them!), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence generators, and rich metadata discovery techniques. If you want to learn the new T-SQL enhancements in SQL Server 2012, you won’t want to miss out on this session!


  • Leonard Lobel

Track and Room: Other - N/A

Title: Practical Management Data Warehouse

Abstract: MDW is a free monitoring tool provided with SQL Server since version 2008. This session will cover the following topics:

  • Data Collection basics
  • Data Collector Security
  • MDW report security
  • Custom collectors and reports
  • Multi server/instance monitoring
  • MDW vs. Performance Dashboard
  • DEMO: Basic troubleshooting scenario
  • Real world implementation scenario w/ multi instance monitoring and high availability w/ AAG (Availability Group)
  • Other free/commercial tools


  • Janos Berke

Track and Room: Track 1 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Janos Berke

Twitter: - @JanosBerke

LinkedIn: Janos Berke

Contact: http://www.iamberke.com

I am an IT professional with over a decade of technical and management experience. I am using SQL Server since version 6.5. Currently I am a consultant and helping companies in SQL Server design, migrations, operation and developments as well as providing customized training .

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.

Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page