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.
The DBA of the Future: Hands-on with Automation
Description
With each passing year, data professionals are asked to do more with less. We manage more servers, more databases, and more data today than ever before. Automation allows for DBAs to achieve the necessary level of scalability to maintain the ever increasing workload.
DevOps and Continuous Integration demand high levels of automation throughout a database development process. In response, Microsoft has embedded automation into everything, including Azure services and SQL Server 2016.
In many shops today, traditional automation and scripting remain a largely reactive task. While being responsive and responsible are admirable qualities for any professional, the future of automation for DBAs must have an element of proactivity.
In this session, we'll look at the ways a modern professional DBA must be automating their job in order to keep their job. Topics discussed will include the following:
- High availability and disaster recovery
- Performance tuning and monitoring
- Data security, privacy, and compliance
- Monitoring and alerting
- Standardizing installation, configuration, and inventory
The day will include lecture style format as well as interactive discussions and lab exercises.
Attendees will leave this session with an understanding of the following:
- Advanced automation features in SQL Server 2016 and Azure SQL Database
- How to architect and prioritize automation tasks in the modern hybrid enterprise
- Key differences between automation tools and features
Attend this session and learn how the DBA of the future will leverage automation to make their tasks more like a boogie wonderland and less like a disco inferno.
Attendee prerequisites: Hands-on experience with SQL Server (any version). Familiarity with scripting features including T-SQL, PowerShell and SQLCMD. Basic understanding of database administration concepts. Familiarity with basic Azure and Data Platform features.
DevOps and Continuous Integration demand high levels of automation throughout a database development process. In response, Microsoft has embedded automation into everything, including Azure services and SQL Server 2016.
In many shops today, traditional automation and scripting remain a largely reactive task. While being responsive and responsible are admirable qualities for any professional, the future of automation for DBAs must have an element of proactivity.
In this session, we'll look at the ways a modern professional DBA must be automating their job in order to keep their job. Topics discussed will include the following:
- High availability and disaster recovery
- Performance tuning and monitoring
- Data security, privacy, and compliance
- Monitoring and alerting
- Standardizing installation, configuration, and inventory
The day will include lecture style format as well as interactive discussions and lab exercises.
Attendees will leave this session with an understanding of the following:
- Advanced automation features in SQL Server 2016 and Azure SQL Database
- How to architect and prioritize automation tasks in the modern hybrid enterprise
- Key differences between automation tools and features
Attend this session and learn how the DBA of the future will leverage automation to make their tasks more like a boogie wonderland and less like a disco inferno.
Attendee prerequisites: Hands-on experience with SQL Server (any version). Familiarity with scripting features including T-SQL, PowerShell and SQLCMD. Basic understanding of database administration concepts. Familiarity with basic Azure and Data Platform features.
Learning Objectives
Previous Experience
Tech Covered
performance, high availability, Azure, DBA, PowerShell