Protect your data – Security in SQL Server

Speaker: Uwe Ricken

Duration: Full Day


"In which newspaper can you read that a woman throws her husband out of the apartment?

In "Better Homes and Gardens". What this sentence certainly must do in Microsoft SQL Server can be found in this one-day workshop on the individual security components of Microsoft SQL Server.

Starting with the correct security settings for the service account of Microsoft SQL Server, the same goes on in the staircase of the databases. What rights should you give to a login without endangering the security of the system or securing the data.

Once arrived in the "honourable tenement", one would of course like the nice rented apartment. But stop! - What am I allowed to do in my apartment? A lawyer is no longer required after attending the workshop. In this workshop, the following topics will be taught with examples and exercises:

Proper configuration of the service account of Microsoft SQL Server and SQL Server Agent

TDE and encrypted backup

The special features of sysadmin

Danger and Beauty from "xp_cmdshell"

Minimal Rights principal when creating logins

Database permissions and their consequences

Use of certificates for the execution of stored procedures

Schemes and objects

Owners of objects and access via stored procedures / views / functions


All security aspects of Microsoft SQL Server are covered in detail in this workshop and will be tested on your own laptops with extensive demos and exercises themselves.

Uwe Ricken  Precon