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.
Future DBA
Automate your DBA tasks with dbatools and dbachecks
Description
Let us show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed modules dbatools and dbachecks.
Join Jess Pomfret and Rob Sewell, two of the dbatools in a Month of Lunches authors and take your dbatools and dbachecks skills to the next level or be introduced to dbatools and learn how effective it can make you. We will show you the skills, scripts, and tricks that we have learned with dbatools and dbachecks and tell you how they have rocketed our careers
There will be many practical examples of how dbatools and dbachecks can help to save time in DBA administration duties
- Creating Availability Groups
- Syncing Agent Jobs and Logins between replicas
- Finding SQL Instances on your estate
- Working with Central Management Server
- Disaster Recovery
- Backup Testing
- Simple instance migrations
- Complex instance migrations
- Tracking Activity
- Simplify application upgrades with database snapshots
- Working with other community tools with dbatools
- Encompassing dbatools in DevOps
- Validating your estate
- Using dbatools in the cloud (i.e. working with Azure SQL Database)
And much much more
Come and join us for a great day of PowerShell and SQL full of demos and useful solutions that you will be able to take back to your workplace. You will improve your knowledge and skills, see how the modern DBA will work and have fun at the same time.
Who Are You?
You are a DBA, senior or junior, looking after 1 or 100,000 instances, a developer who interacts with SQL Server, an accidental DBA or you have DevOps in your job title.
You are interested in improving your PowerShell skills for SQL Server or reducing the time you and your team spend administering SQL Server.
You have spent 1 day or 20 years working with SQL Server.
You know that you work in a field where automation is king and want to understand more of what is available.
You are interested in learning and improving your automation skillset.
What do you need?
All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.
All scripts and slides will be provided to you. If you wish to follow along with most of the demos you should have access to a machine that can run Docker as we will be demoing with a Dev Container. Alternatively, you may be able to follow along on a machine with PowerShell v 5 or above and a SQL Server 2012 or above instance.
feedback link: https://sqlb.it/?7228
Join Jess Pomfret and Rob Sewell, two of the dbatools in a Month of Lunches authors and take your dbatools and dbachecks skills to the next level or be introduced to dbatools and learn how effective it can make you. We will show you the skills, scripts, and tricks that we have learned with dbatools and dbachecks and tell you how they have rocketed our careers
There will be many practical examples of how dbatools and dbachecks can help to save time in DBA administration duties
- Creating Availability Groups
- Syncing Agent Jobs and Logins between replicas
- Finding SQL Instances on your estate
- Working with Central Management Server
- Disaster Recovery
- Backup Testing
- Simple instance migrations
- Complex instance migrations
- Tracking Activity
- Simplify application upgrades with database snapshots
- Working with other community tools with dbatools
- Encompassing dbatools in DevOps
- Validating your estate
- Using dbatools in the cloud (i.e. working with Azure SQL Database)
And much much more
Come and join us for a great day of PowerShell and SQL full of demos and useful solutions that you will be able to take back to your workplace. You will improve your knowledge and skills, see how the modern DBA will work and have fun at the same time.
Who Are You?
You are a DBA, senior or junior, looking after 1 or 100,000 instances, a developer who interacts with SQL Server, an accidental DBA or you have DevOps in your job title.
You are interested in improving your PowerShell skills for SQL Server or reducing the time you and your team spend administering SQL Server.
You have spent 1 day or 20 years working with SQL Server.
You know that you work in a field where automation is king and want to understand more of what is available.
You are interested in learning and improving your automation skillset.
What do you need?
All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.
All scripts and slides will be provided to you. If you wish to follow along with most of the demos you should have access to a machine that can run Docker as we will be demoing with a Dev Container. Alternatively, you may be able to follow along on a machine with PowerShell v 5 or above and a SQL Server 2012 or above instance.
feedback link: https://sqlb.it/?7228
Learning Objectives
Previous Experience
Tech Covered
Azure, PowerShell, security, SQL 2019, Testing, Azure SQL Database, Managed Instance, SQL Linux, Database engine, deployment, On Premise, IAAS VM Based, Future DBA, Operational Databases, Secure and Govern, Managing, Monitoring, Successful Delivery, On Premises