Most Active Speaker

Mikey Bronowski

Mikey Bronowski

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. 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.

Awards

Area of Expertise

  • Information & Communications Technology

Sessions

Automate management tasks using elastic jobs in Azure SQL Database en pl

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!

Usługa elastycznych zadań w Azure en pl

Stary dobry agent serwera SQL jest dobrze znany administratorom baz danych. Ma wiele opcji i możliwości, jednak jest niedostępny dla usługi Azure SQL Database. W tym miejscu na pomoc przychodzi agent elastycznych zadań Azure! Ta sesja pomoże nam zrozumieć dlaczego i jak można poruszać się w elastycznym świecie zadań chmury Azure. Będzie Azure Portal i PowerShell.

Niezwykłe trio ARM, Bicep oraz DSC - by łatwiej budować nowe środowiska w Microsoft Azure pl en

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.

Arm your Bicep with D(i)SC - how to make your life easier while building new environments pl en

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.

AutomatedLab 101 en pl

The AutomatedLab PowerShell module enables you to set up test and lab environments on Hyper-v or Microsoft Azure with multiple products or just a single VM in a very short time.
This introductory session will give you a taste of what it does and hope it can help you.

AutomatedLab - własne środowisko testowe en pl

AutomatedLab - moduł PowerShell, który pozwala na stworzenie własnego środowiska testowego na platformie Hyper-V lub Microsoft Azure. W krótkim czasie możemy uruchomić pojedynczą maszynę wirtualną lub całe środowisko z wieloma aplikacjami.

Ta sesja wprowadza w świat bardzo interesującego narzędzia i być może pozwoli nabrać apetytu na więcej.

Not what you expect to see in SQL Server Management Studio en

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.

Azure Synapse Analytics in PowerShell en

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.

Azure Synapse Studio notebooks... en

A very quick overview of Azure Synapse Studio notebooks.

SQL Server and PowerShell walk into a bar... en

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.

Azure Data Studio and keyboard shortcuts - all you can eat en

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.

An introduction to the ImportExcel PowerShell module en

The ImportExcel PowerShell module is a tool to help you manage Microsoft Excel spreadsheets without having MS Excel installed. Create pivot tables, charts, and conditional formatting with few lines of code.

Multi-server agent jobs administration with happy faces and pigeons en

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"

How to become PowerDBA - PowerShell and SQL Server training for a busy SQL Server DBA? en

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.

Is Your Job at Risk? Strategies to Thrive in a World of Automation en

How can you use the power of PowerShell and AI to secure your career? Learn how to use PowerShell to create automated processes that can help you stay ahead of the curve.

SQLDay 2023 Sessionize Event

May 2023 Wrocław, Poland

Data Platform Diversity, Equity, and Inclusion Virtual Group User group Sessionize Event

February 2022, April 2023

DataGrillen 2022 Sessionize Event

June 2022 Lingen, Germany

Data South West UK User group Sessionize Event

May 2022

#DataWeekender CU5 Sessionize Event

May 2022

SQLDay 2022 Sessionize Event

May 2022 Wrocław, Poland

SQLBits 2022 Sessionize Event

March 2022 London, United Kingdom

DataMinutes #2 Sessionize Event

January 2022

Festive Tech Calendar 2021 Sessionize Event

December 2021

PASS Data Community Summit 2021 Sessionize Event

November 2021

#DataWeekender v4.2 Sessionize Event

November 2021

Azure Community Conference 2021 Sessionize Event

October 2021

DataSaturdays #13 - Minnesota - Oct 16 2021 Sessionize Event

October 2021

Azure Summit Sessionize Event

September 2021

Virtual 2021 Data.SQL.Saturday.LA Sessionize Event

June 2021

Data.Toboggan - Cool Runnings Sessionize Event

June 2021

DataMinutes #1 Sessionize Event

June 2021

#DataWeekender v3.1 Sessionize Event

May 2021

Malta Data Saturday 2021 Sessionize Event

April 2021

HaitianSQLOneDayEvent Sessionize Event

March 2021

Festive Tech Calendar Sessionize Event

December 2020

#DataWeekender #TheSQL Sessionize Event

October 2020

DATA:Scotland 2019 Sessionize Event

September 2019 Glasgow, United Kingdom

Mikey Bronowski

Husband | Dad | DBA | MCT | Data Platform MVP | UG Leader

Southampton, United Kingdom