www.sqlpass.org    Professional Association for SQL Server

Welcome to SQLCape!
We are based in the beautiful Western Cape, South Africa

 Next Meeting


Topic :

 

SQL Server Cryptology – A Primer

 

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 strategies.

After attending this session, you will be able to

 

••           explain 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 management skills.

 

 

 

 

 

When

 

Tuesday, 13 October 2015

18:00 – 20:00 (Snacks & drinks will be provided from 17:30)

 

Where

    

Microsoft Cape Town Office, Golf Park 3, Engen House, Raapenberg Road, Mowbray, Cape Town

 

 

Presenter

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sebastian Meine


           

   

Sebastian's Bio:
           

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.




 



 

 

 

 

  

 

 

 

 

 

 

 

 

   
   
   
   
   

 

 

 


Starting out as an accidental DB, managing online banking back office systems, I have since built up 15 years of DBA and database development experience.  I have become quite fond of the Microsoft SQL stack, and everything SQL. 
Starting out as an accidental DB, managing online banking back office systems, I have since built up 15 years of DBA and database development experience.  I have become quite fond of the Microsoft SQL stack, and everything SQL. 
Starting out as an accidental DB, managing online banking back office systems, I have since built up 15 years of DBA and database development experience.  I have become quite fond of the Microsoft SQL stack, and everything SQL. 

 EventDisplay
There are currently no upcoming meetings scheduled. Please check back for updates.
 EventArchive

You are almost there!

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.

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif