Nr: 339
SQLSaturday #339 - Shanghai 2015
SessionID: 15766
Practical Management Data Warehouse
Event Date: 09-05-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Janos Berke
Title: Practical Management Data Warehouse
Abstract:
- 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
SessionID: 19090
Programming T-SQL Enhancements in SQL Server 2012
Event Date: 09-05-2015 - Session time: 00:00:00 - Track: Other
Speaker: Leonard Lobel
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!