Category: Presentations

• Presentation Materials: SQL Server Cryptology – A Primer

  

  2015-03-31 - Presentations

  Abstract So, you got told you need to encrypt “the database”. Now what? There are many reasons to encrypt your database. You might have to comply with HIPAA or PCI DSS, or you might just have generally sensitive data. Correctly [more…]

• Presentation Materials: Securing Multi-Database Applications

  

  2014-06-02 - Presentations

  Abstract It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable. In this session, we will [more…]

• Presentation Materials: Permission Management – 12 Pitfalls & Misconceptions

  

  2014-03-26 - Presentations

  Your responsibilities as the DBA include the management of access permissions. To be able to live up to the expectation that you will be able to secure the data, you must know the 12 Pitfalls & Misconceptions that we will talk about in this session.

  [more…]

• Presentation Materials: The APPLY Operator

  

  2013-11-03 - Presentations

  Abstract The APPLY operator was introduced with SQL Server 2005. It is an extension to the SQL Standard with the main purpose to allow us to join to a table valued function. But there is more to discover… In this [more…]

• Presentation Materials: Five Secret MERGE Patterns

  

  2013-08-04 - Presentations

  The MERGE statement was introduced into the SQL Standard with SQL2003 and into SQL Server with version 2008. SQL Server goes far beyond the standard and implements the MERGE statement as a very powerful combination of the three statements INSERT, UPDATE and DELETE.

  In this talk I am going to show five use cases that you might not have thought of before. We will also cover some issues that you must be aware of to avoid problems when using the MERGE statement.

  [more…]