St. Louis SQL Server User Group

Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!
http://groups.yahoo.com/group/stlssug

PASS Summit 2017 Seattle, WA  October 31-November 3

Use code LC15MTQ9 to receive a $150 discount on your PASS Summit 2017 registration

EventDisplay

Next Meeting

Tuesday,

September

12

STLSSUG September 12, 2017 Meeting

  • In-Person @ 622 Emerson Road St. Louis, Missouri, United States (map)
  • 13:00 - 16:00 Central Daylight Time
  • Language: English

 St. Louis SQL Server User Group Meeting

September 12th 1:00 pm- 4:00 pm

 The next St. Louis SQL Server User Group meeting will be on September 12th from 1:00 pm – 4:00 pm. 

 

Please RSVP, so that we can have a count for a lunch order,

https://www.eventbrite.com/e/stlssug-september-12-2017-meeting-tickets-36960780690

 

Also, please feel free to forward this meeting announcement to anyone who may be interested in attending.

 

This will be broadcasted as a Skype meeting. 

 

Location:        Oakwood Systems Group www.oakwoodsys.com

622 Emerson Road

2nd Floor Room B

St. Louis, MO 63141 

 

Agenda

12:30 – 1:00    Registration –  Lunch by Daugherty https://www.daugherty.com/

 

1:00                 Ed Leighton-Dick – Understanding SQL Server 2016 Always Encrypted and Protecting your Data with Encryption

 

2:30                 Ed Leighton-Dick – Dammit Jim!  Dr. McCoy’s Field Guide to System_health (and the default trace)

 

4:00                 Raffle Drawing –  Apress, Wrox, McGraw-Hill, Murach, Wiley, O'Reilly/MS Publishing Books and more!

 

Abstract:

 

Understanding SQL Server 2016 Always Encrypted

Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs.  Does that sound too good to be true?  It isn’t – Always Encrypted is an incredible feature – but like any new technology, it does have some limitations.  In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

 

Protecting Your Data with Encryption

We’ve all seen the recent news stories about companies whose data has been stolen by hackers.  What was once a rare event has become all too common, and companies large and small are at risk.  While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data.  In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption.  We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.

 

 

Dammit Jim!  Dr. McCoy’s Field Guid to System_health (and the default trace)

As DBAs, we are asked all sorts of impossible questions.  Who dropped that important table last month?  Why was everything slow last week?  Who made that user a sysadmin?  You’d have to be a mind reader to know the answers to some of those, right?  Not necessarily!  SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide.  In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.

 

Ed Leighton-Dick

Is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

.........................................................................................................................................

 

à Join Skype Meeting

Trouble Joining? Try Skype Web App

Join by phone

Toll-free number: +1 (866) 679-9995, access code: 53112940 (Dial-in Number) English (United States)

Toll number: +1 (323) 849-4874, access code: 53112940 (Dial-in Number) English (United States)

Find a local number

Conference ID: 53112940 (same as access code above)

Forgot your dial-in PIN? |Help

Welcome to Skype for Business Online Meetings. All participants who use the Join by Phone option must dial the full number for call access.

 


PASSChapterLogo.jpg

sql_micro_sm.gif

sql_ca_sm.gif

Back to Top