June 11th Meeting

Please join us this Wednesday, June 11th, 2014 5:30pm for the Charlotte SQL Server User Group meeting at the local Microsoft campus. Note we will be in the AP2 (right) building, Mt Everest Conference room, 8050 Microsoft Way.

Please RSVP here so we may plan enough food for the event.  Only RSVP if you will attend.

The event is free, so invite a friend and network with Charlotte’s finest SQL Server experts. If you can attend, please make an effort to introduce yourself to newcomers and welcome them to the group.

Food usually starts at 5:30pm and the presentations start at 6pm and usually last until 7:45pm at the latest.

Please sign in and make a name tag when you arrive so we may verify attendance and encourage networking. For other FAQ, see our FAQ page.

Agenda

• 5:30 PM Networking with Food & Refreshments
• 6:00 PM Technical Presentation
  • ​“Querying in the 21st century – A Window into Windowing functions“
  •  by Jana Sattainathan
• ​7:30 PM Meeting End

The Technical Presentation

“Querying in the 21st century – A Window into Windowing functions”

by Jana Sattainathan

SQL Server introduced Windowing functions in version 2005. Intended to offer the ability to work with windows of data (as a set) in SQL, they pack the power, ease of use and flexibility to query data that traditional SQL lacked (possible but complicated). 2012 rounded the capabilities and added quite a bit. In this session, we will take a look at the available features and how to apply them in practice.

About Jana Sattainathan

Jana Sattainathan works as an Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. In his free time, he dabbles in .Net and Powershell. He has an MCITP in SQL Server Administration as well as Development and is an Oracle Certified Professional DBA. Outside work, he enjoys nature, movies, playing tennis, poker, biking and hiking (not to mention beer).

Follow Jana‘s Blog: http://sqljana.wordpress.com/ and on Twitter: @SQLJana