Monthly Meetings

Our regular monthly meetings occur on the last Friday of each month from 11:30 AM - 1:00 PM. Lunch is served during the first half hour and the scheduled session begins at noon. We meet at The Microsoft Heartland Office which is located at

The Microsoft Heartland Office
8 City Blvd, Suite 403
Nashville, TN 37209
Phone: (615) 778-2500
Fax: (615) 778-2510      

For the month of July, 2016, we will be meeting in a special place, Nashville Software School.

Next Meeting: Fri, Apr 28 2017

NashSQL April Meeting: Louis Davidson

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Nash-SQL/events/239474368/

April Meeting

 

Sponsor: TEKsystems

TEKsystems is the nation’s leading IT staffing and services firm.  Here in Nashville we support over 80 different clients within Applications Services.  We focus on delivering consistent employment opportunities, continual communication throughout contracts, and advancing consultant careers through contract opportunities as well as direct hire roles.  We build a recruiting force committed to building relationships with IT professionals here in Nashville and offer opportunities both locally and nationally.  Here at TEKsystems Nashville we look to serve our professionals with consistent communication, strategic partnership, and career advancement.  We are grateful to have the opportunity to partner with the IT professional community and are always looking to improve our relationships and partnerships.

When

iCal
UTC : Fri, Apr 28 2017 16:30 - 18:00
Event Time : Fri, Apr 28 2017 11:30 - 13:00 Central Daylight Time
Your Local Time: Fri, Apr 28 2017 16:30 - 18:00

Where

8 City Blvd
Nashville, Tennessee

Direction: None

Featured Presentation

A Survey of New T-SQL Features in SQL Server 2016 (Sp1)

Speaker: Louis Davidson, Data Architect drsql.org

Summary: Last year, Robert Verell gave a presentation to the group on 2016 features where he gave examples of the new features in SQL Server 2016 at the product level. Our promise then was to give deeper dive sessions on the features, so this presentation is demo filled on the T-SQL features that are new for 2016. The features covered will include: Temporal Tables - The new table structures and syntax that let you capture history of all changes to a table, allowing you to query the table as it existed at a certain point in time in a very straightforward manner. Row Level Security - A mechanism to filter a user's access to data at the row level, in a manner that your code (stored procedures and views included) will honor with no changes to your existing code. Data Masking - Lets you define a pattern to mask a column's output in your T-SQL statements to obfuscate sensitive data. JSON - Allows you to format the output of a query as a JSON document (much like the FOR XML clause does for XML). New Syntax and Commands - Even if you don't use any of these new features in your coding, I will also show a selection of new functions and syntax constructs that you will definitely want to know about.

About Louis: Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 10 years and has written five books on database design. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Attachments

 

Exclusive Offers for User Group Members

Oreilly Book Discounts

 Thanks to Oreilly for providing us books to give away and providing a discount code for our users. Buy ebooks at 50% off and print books at 40% off: When you purchase a book or ebook on oreilly.com use the UG Program discount code: DSUG

 

Great Microsoft Learning Offers

Microsoft Learning has released a collection of valuable offers for the PASS user group community. Get the Microsoft Learning products that you want for less. Take advantage today of these special offers for home and office users, IT professionals, and developers by visiting: www.microsoft.com/learning/offers

 

Carry all your tech books with you anytime with one-click reference on Microsoft technologies

Microsoft Press has developed a virtual library for IT Professionals, developers and information workers who want to learn about Microsoft products and related technologies. And we want to share it with the Microsoft user group members. To learn more about the E-Reference Library, please click here (http://www.microsoft.com/learning/books/ereference/default.mspx).

Nashville SQL Server Users Group