So, you got told you need to encrypt "the
database". Now what?
Join this session by security expert Sebastian Meine (Ph.D.)
for an introduction to the fascinating world of cryptology. In this session,
geared towards the DBA, you will learn the difference between symmetric and
asymmetric encryption, discover what a cryptographic one-way hash function is
and probe into cryptographically secure pseudo random number generation. After
exploring the different definitions, you will be able to observe how to
implement encryption, decryption, transparent data encryption (TDE) and hashing
in SQL Server. We will pay special attention to areas where the choice of
encryption technology affects your database maintenance and recovery
After attending this session, you will be able to
the difference between symmetric and asymmetric encryption.
•• select the
right cryptographic technology for your special security requirement.•• identify
when to use one-way hashing instead of encryption.To benefit from this 200 level session, you should feel
comfortable writing stored procedures and views and have basic permission
18:00 – 20:00 (Snacks & drinks will be provided from 17:30)
Microsoft Cape Town Office, Golf Park 3, Engen House, Raapenberg Road, Mowbray, Cape Town
Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net).
After receiving his PhD in Computer Science at the University of Linz, Austria
he spent several years at a global Fortune 50 company as software architect
responsible for code quality and performance of dozens of large-scale database
installations throughout the US. In 2010, to fully engage in his passion for
SQL Server, he founded sqlity.net. Since that time, he has been helping his
clients to boost their SQL Server health and performance, enhance their T-SQL
coding skills and tighten their SQL Server security. A sought-after educator
and published author, Sebastian shares his knowledge regularly within the
worldwide SQL community through his writings and public speaking engagements. Additionally,
he is coauthor of tSQLt, the Database Unit Testing Framework for SQL Server.
tSQLt is open source and available at http://tSQLt.org.Sebastian is currently
serving as president of the Philadelphia SQL Server User Group
(http://pssug.org/), a nonprofit that is dedicated to further the education of
the local SQL Server community.
This archive module depends on EventDisplay module to display event detail. Please make sure you have at least one instance of EventDisplay added to a page first. Click Settings to start module configuration.