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.
Professional and Proficient PowerShell: From Writing Scripts
Description
DBAs are seeing the benefit of using PowerShell to automate away the mundane. A modern data professional needs to be able to interact with multiple technologies and learning PowerShell increases your ability to do that and your usefulness to your company.
At the end of this fun filled day with Rob, a former SQL Server DBA turned professional automator, you will be much more confident in being able to approach any task with PowerShell
and you will leave with all of the code and demos. You can even follow along if you bring a laptop with an instance of SQL Server installed.
We will cover
• How to learn how to interact with any technology using PowerShell
• Understanding the syntax
• The importance of Get-Help and how PowerShell enables you to help yourself
• Why to write your own Modules and how to make them available to all of your team
• A quick automated method to creating your module framework
• Unit testing and debugging your code
• How to continuously deliver changes to your PowerShell modules using GitHub and Azure DevOps
• Tips and tricks for script writing with the popular open-source community dbatools module
• How to validate your SQL Server estate with PowerShell
• Advanced SQL Server Agent and PowerShell management
We will have a lot of fun along the way and you will return to work with a lot of ideas, samples and better habits to become a PowerShell ninja and save yourself and your organisation time and effort.
Prerequisites: Know how to open PowerShell!! It is better if you have typed in a command. Those brand new to PowerShell might find the learning curve steep but everyone will find benefit. Bring your laptop with SQL Server and WideWorldImporters and you can follow along.
At the end of this fun filled day with Rob, a former SQL Server DBA turned professional automator, you will be much more confident in being able to approach any task with PowerShell
and you will leave with all of the code and demos. You can even follow along if you bring a laptop with an instance of SQL Server installed.
We will cover
• How to learn how to interact with any technology using PowerShell
• Understanding the syntax
• The importance of Get-Help and how PowerShell enables you to help yourself
• Why to write your own Modules and how to make them available to all of your team
• A quick automated method to creating your module framework
• Unit testing and debugging your code
• How to continuously deliver changes to your PowerShell modules using GitHub and Azure DevOps
• Tips and tricks for script writing with the popular open-source community dbatools module
• How to validate your SQL Server estate with PowerShell
• Advanced SQL Server Agent and PowerShell management
We will have a lot of fun along the way and you will return to work with a lot of ideas, samples and better habits to become a PowerShell ninja and save yourself and your organisation time and effort.
Prerequisites: Know how to open PowerShell!! It is better if you have typed in a command. Those brand new to PowerShell might find the learning curve steep but everyone will find benefit. Bring your laptop with SQL Server and WideWorldImporters and you can follow along.
Pre-requisites
Very basic experience with PowerShell
Laptop Required: Optional
- Software: Powershell ISE, SQL Server, WorldWideImporters database
Learning Objectives
Previous Experience
Tech Covered
Azure, DBA, PowerShell, SQL, SQL Server, Testing