Husband | Dad | DBA | MCT | Data Platform MVP | UG Leader
Mąż | Tata | DBA | Trener Microsoft | Microsoft Data Platform MVP | Lider grupy użytkowników
Southampton, United Kingdom
What do I do? I select, I select stars!
Data enthusiast with a mathematics background. Working with SQL Server for over 15 years. Works as a Data Platform Architect at datamasterminds.io (Microsoft SQL Server). Microsoft Data Platform MVP and Microsoft Certified Trainer with a couple of certificates sharing knowledge. Blogger at (bronowski.it).
Not long ago Poland Data Community member, now proud UK Data Platform active member and SotonDataCloud.org leader.
When not working or teaching, learns new things or attends various data/technical conferences and meetups.
Italian Calcio fan and traveller, amateur photographer catching anything that moves.
Michał jest miłośnikiem danych, który pracuje z serwerem SQL po ponad 17 lat. Obecnie pracuje jako architekt platformy danych, skupiając się głównie wokół technologii Microsoft SQL Server.
Michał jest trenerem Microsoft, a w roku 2021 roku nagrodzony przez Microsoft tytułem Most Valuable Professional w obszarze Data Platform.
W wolnych chwilach prowadzi blog bronowski.it.
Nie tak dawno był członkiem Data Community Polska, a obecnie jest aktywnym uczestnikiem życia społeczności danych w Wielkiej Brytanii.
Kiedy nie pracuje lub nie uczy innych, uczy się nowych rzeczy na różnych konferencjach czy spotkaniach dotyczących technologii oraz danych.
Area of Expertise
This session will cover few things you might not know about SQL, like the thing with variables, or that other thing when inserting data, or... and many more - as many as can fit in this session. WARNING: The results you might see in your SSMS will blow your mind - be careful out there.
This little wordplay is about the Bicep a domain-specific language (DSL) and PowerShell Desired State Configuration (DSC) for Windows. We will cover the basics of both concepts, we will mention the ARM templates and show some examples. The goal of this session is to present the tools to those who want an easier way to create their environment or labs.
Azure Synapse Analytics is a hot topic. It can be even hotter if you could run it with PowerShell instead of a graphic interface.
In this session, we will go through the Az.Synapse PowerShell module and see how to make our life easier.
A very quick overview of Azure Synapse Studio notebooks.
Managing SQL Server can be very exciting, but there are times when one needs to do a number of similar operations and it may become frustrating.
In this session, you will learn about PowerShell community modules that will help you to manage the SQL Server in a way you only dreamed of years ago.
The talk will cover dbatools and dbachecks, as well as importExcel.
In this session, we will go through a number of useful predefined shortcuts in Azure Data Studio. And because the sky is the limit, we will learn how to create our own combinations.
Do you miss keyboard shortcuts from the SQL Server Management Studio? Do not worry, you will learn where to find them!
Let's CTRL+X yourself from the comfy sofa and CTRL+V into this session.
PS: I promise to use the mouse only in emergency.
The good ol' agent, SQL Server Agent, is known widely in the DBA world. It is powerful, but... Azure SQL Database requires something more, something different. Meet elastic Elastic Database agent and its jobs!
The ImportExcel PowerShell module is a tool to help you manage the Microsoft Excel spreadsheets without having MS Excel installed. Create pivot tables, charts, and conditional formatting with few lines of code.
This talk will be about multi-server administration using MSX and TSX servers. Built-in feature you may have seen, but was too scared to play with. Will show you how to configure multi-server environment and how to manage it with least possible resources.
What SQL Server and pigeons have in common? Not much, besides that you do not want to be a pigeon - pigeon post to be specific.
I have been a DBA pigeon in my past. Managing hundreds of SQL Servers and visiting every single SQL Agent to setup the maintenance jobs, backup jobs or any jobs that would help me to keep the servers up and running. Sometimes using SQL scripts, other times Powershell scripts to deploy or update new jobs, but it was still the same ol' way. Flying between instances like a bird. Until, one day, I found out about MSX and TSX! And now my life is full of happy faces! I want your face to be happy too.
In this session you will learn how easy is to setup this hidden and forgotten feature of SQL Server. Will show you how quick is to make a master server and add some new target servers. If you discover an urge to go back to your shop and make a revolution - you can leave before the end - to save the world! Your world!
The pigeon says: "coo roo-c'too-coo"
Ta sesja pozwoli przybliżyć słuchaczom kocept języka dziedzinowego Bicep (ang. DSL, domain-specific language) oraz Usługa konfiguracji żądanego stanu programu Windows PowerShell (and. DSC, Desired State Configuration). Zaprezentujemy postawy obu rozwiązań, a także wspomnimy o usłudze Azure Resource Manager (ARM) i pokażemy przykłady jej zastosowania. Celem tej prezentacji jest pokazanie narzędzi osobom, którym zależy na łatwiejszym sposobie tworzenia własnych rozwiązań czy przestrzeni testowej w środowisku Microsoft Azure.
Are you a busy DBA who spends most of the time fixing ad-hoc issues and working on unexpected incidents? Do you wish you have more time to focus on fixing your environment, so there is less unplanned work? Or maybe you do not even have time to know exactly where your estate is hurting?
We have been there and that is why we want to share our hands-on experience with you. During this training session, you will learn about the following modules:
- Chocolatey - the environment to install your
- SqlServerDsc - module containing Desired State Configuration resources for SQL Server. Manage your infrastructure configuration as a code.
- SqlServer - have you heard about SQLPS? SqlServer is the updated version from Microsoft. Some earlier versions come with SSMS, so it is at your disposal.
- dbatools - open-source, community maintained tool that servers as SQL Server Management Studio in the command line. The actual SSMS will feel like an old rusty car in comparison to a robust PowerShell module.
- Pester - a module that helps you to write custom tests to make sure your PowerShell code is always working. You will start writing custom Pester tests even on your home PC.
- dbachecks - Pester wrapper to validate and keep an eye on your estate and track if it follows the best practice. The same stable as dbatools. The same excellent quality.
- AZ.Sql - Authored by Microsoft, alternative way to manage the cloud resources. There is a good chance you won't even open the Azure Portal after this training.
- ImportExcel - Have you ever had to deal with Microsoft Excel spreadsheets but felt like there is too much clicking around? This open-source and free module will help you to create and manage workbooks without Microsoft Office on your machine.
We will start with building the environment and applying the custom configurations from scratch. Once we have a working SQL Server we will see how to be a PowerDBA. We will cover SQL Server patches, database backups and environment refreshes. Migration from one server to another won't be a mystery and a struggle anymore. You will find security management and keeping up with best practices extremely easy. Finding issues in your environment and tracking the progress of fixing them in Power BI dashboards won't be a dream, it will become your reality.
After this full day of training, you will get incredible powerful tools in your DBA tool belt. The tools that not only will make your work easier and more efficient, but you will find time to enjoy your work. More time to make friends. We want you to be our friend.
This workshop is designed to be demo-heavy with PowerPoint slides reduced to a minimum. The goal is that attendees learn about useful tools and why and how to apply them in their environment. Most of the time we will be working with VS Code.
Prior PowerShell knowledge is not required although it will not hurt. Most of these modules can be used with some basic understanding of scripting languages. The workshop is going to be presented in VS Code and Azure Data Studio, but prior experience with that environment is not required. It is expected from the attendees to know at least the basics of SQL Server database administration, including the best practices. This is a session for database administrators who are busy fighting with fires and more efficient tools to be able to work on preventing those in the future. Primary the attendee works with the on-premises estate and works hard on upgrading, migrating the servers to newer versions. The DBAs who work with SQL in the cloud (Azure) may find this session valuable.
Data South West UK User group
Husband | Dad | DBA | MCT | Data Platform MVP | UG Leader
Southampton, United Kingdom