** Rescheduled from 21st June **
SQL London User-Group 19th July 2012 with (Neil Hambly, Dave Ballantyne, Avanade)
Nearest Tube : St. Paul’s
Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
6.00 - 6:15pm Registration and networking
Meet and greet. (maybe time for a 5 minute Nugget)
6:15 – 7:15pm Neil Hambly Policy Based Management
Learn
how to leverage the power of BPM and gain control of multiple SQL instances in
your environments.. Learn more than just the terminology, making the
administration of the servers simplier through PBM framework
7:15 – 7:45pm (Avanade) TBC
Topic & Speaker to be confirmed soon
7:45 – 8:00pm Break: Light refreshments
More time to network, ask questions and eat dinner..
8:00 – 9:00pm Dave Ballantyne - What's new in SQL Server 2012 -TSQL
With the release of SQL Server 2012, the T-SQL language has been extended further to enable greater productivity and more optimal queries.
Following the ANSI SQL standard support has been included for PAGING and SEQUENCES. Many cumbersome sub-queries will be banished by the clutch of new analytic functions, but perhaps the biggest is the window framing extensions. These now allow a true sliding window of data to process such common problems as rolling balances.
This will be a high-level look session, but will be diving a bit deeper to highlight some caveats as we go as its not all plain sailing.