SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
SQL Server data security from the bottom up
Description
The data we work with every day needs to be kept secure in line with compliancy regulations or with its critcality to the Businesss. Any breaches in the Confidentiality, Integrity or Availability of that data could result in prosection or financial losses.
In this one day workshop we'll be looking at SQL Server security from the ground up. Starting with how the business needs to define it's security requirements and responsibilities. Covering how to setup and configure your SQL Server instances, both on premise and in the cloud using IaaS and PaaS. Exploring how you should you be working with confidential data as a DBA or Developer; do you need or want to see the data, do users need to see everything, is encryption always the best option, are your backups secure, can the right people manage data access, can you have too much security, why isn't the IT team the data owner?
We'll be covering the why as well as the how, referencing the legal guidelines and the ISC2 recommend framework to allow you to make informed decisions and to understand where technical solutions sit in the larger picture.
In this one day workshop we'll be looking at SQL Server security from the ground up. Starting with how the business needs to define it's security requirements and responsibilities. Covering how to setup and configure your SQL Server instances, both on premise and in the cloud using IaaS and PaaS. Exploring how you should you be working with confidential data as a DBA or Developer; do you need or want to see the data, do users need to see everything, is encryption always the best option, are your backups secure, can the right people manage data access, can you have too much security, why isn't the IT team the data owner?
We'll be covering the why as well as the how, referencing the legal guidelines and the ISC2 recommend framework to allow you to make informed decisions and to understand where technical solutions sit in the larger picture.
Learning Objectives
Previous Experience
Tech Covered
Securing, On-prem, Cloud, Azure, DBA, security, SQL 2019, Development, Azure SQL Database, Managed Instance, Database engine, compliance, encryption, policy, Managing