insider tips on microsoft sql server 2016
TRANSCRIPT
![Page 1: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/1.jpg)
Insider Tips on Microsoft SQL Server 2016
![Page 2: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/2.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Presenter: Brian D. [email protected]
MCITP/MCSE/MCT Microsoft Technology Specialist Global Knowledge course
director for Microsoft SQL Server Technology experience includes:
15+ years with SQL Server 10+ years in data modeling and
database design 10+ years in application
development, including IMS, DB2, Sybase
Professional experience includes:
25+ years as technical instructor 10+ years as systems consultant
![Page 3: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/3.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
SQL Server 2016 Themes
Mission-critical performanceDeeper insights across dataHyperscale cloud
Brian’s three favorite features: Always encrypted Temporal data Stretch database
![Page 4: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/4.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Always Encrypted
Transparent column encryptionNo application changes neededEnd-to-end securitySeparation of data owners from data managersColumn Master Key (CMK)Column Encryption Key (CEK)Decryption/Encryption occurs on client machineData is always encrypted on server
![Page 5: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/5.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Column Encryption Key Properties
![Page 6: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/6.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Example Table Using Always Encrypted
![Page 7: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/7.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Example Query without Encryption Keys
![Page 8: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/8.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Demo: Always Encrypted
![Page 9: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/9.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Temporal Data
System-versioned tablesAutomatic historical data trackingCan be used for auditing and undo operationsIdeal for Slowly Changing Dimension (SCD)
Can be used to populate SCD Type 2 table in DWCurrent table and History tableANSI SQL 2011 specification
![Page 10: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/10.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Example Table: Temporal Data
![Page 11: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/11.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Example Query: Temporal Data
![Page 12: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/12.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Demo: Temporal Data
![Page 13: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/13.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Stretch Database
Local data and remote data in the cloudLarge occasionally accessed tables off-loaded to cloudNo changes to application queries neededQuery plan includes remote access if necessarySaves local storage and improves local queriesRemote data stored in Azure SQL Database
![Page 14: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/14.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Stretch Database Concept
![Page 15: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/15.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Enable Database for Stretch
![Page 16: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/16.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Enable Table for Stretch
![Page 17: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/17.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Demo: Stretch Database
![Page 18: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/18.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Conclusion: SQL Server 2016
Mission-critical performanceDeeper insights across dataHyperscale cloud
Brian’s three favorite features: Always encrypted Temporal data Stretch database
![Page 19: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/19.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Certification and Training
MCSA: SQL Server (nine-day boot camp)MCSE: Data Platform (five-day boot camp)MCSE: Business Intelligence (five-day boot camp)
Microsoft Official Curriculum courses combinedIntense immersion training, including:
Exam vouchers and retake vouchers 12 months of 24x7 access to labs 12 months of 24x7 chat support by certified
mentors 12 months of Transcender practice exams Training kits and online reference books
![Page 20: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/20.jpg)
© 2015 Global Knowledge Training LLC. All rights reserved.
Learn More
Recommended Global Knowledge Course
Updating Your Skills to Microsoft SQL Server 2016 (coming soon)
Request an On-Site Delivery We can tailor our courses to meet
your needs We can deliver them in a private
setting
Visit Our Knowledge Center Assessments Blog Case Studies Demos Lab Topologies Special Reports Twitter Videos Webinars White Papers
![Page 21: Insider Tips on Microsoft SQL Server 2016](https://reader036.vdocuments.us/reader036/viewer/2022062523/58eecf5d1a28ab04148b4691/html5/thumbnails/21.jpg)
Thank You for Attending
For more information contact us at: www.globalknowledge.com | 1-800-COURSES | [email protected]