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…]
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…]
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.
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…]
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.