Speaker

Kamil Nowinski

Kamil Nowinski

Strategic data architecture for the Microsoft & Databricks stack - deliberately, not accidentally

Strategic data architecture for the Microsoft & Databricks stack - deliberately, not accidentally.

Stevenage, United Kingdom

Actions

Kamil Nowinski is a Databricks Solutions Architect Champion, former Microsoft Data Platform MVP, and Azure Data Engineer & Architect focused on designing strategic, AI-ready data platforms for the modern enterprise.
With over 25 years of experience in data engineering and SQL Server technologies, Kamil specialises in building scalable Lakehouse and Lake-centric architectures across Microsoft Fabric, Azure, and Databricks. His expertise spans Data Strategy, Data Integration, governance frameworks, and platform maturity models - helping organisations move from fragmented analytics to unified, high-performance data ecosystems.
Kamil's work centres on architecting robust foundations, including implementing Unity Catalog with classification, designing real-time and event-driven architectures, modernising legacy BI estates, and embedding DevOps practices into data platforms. He believes that successful AI and advanced analytics are not accidental - they are the result of deliberate architectural decisions, strong governance, and disciplined engineering practices.
As a consultant working with enterprises across the UK market, he partners with organisations to troubleshoot complex data challenges, prototype next-generation BI and Big Data solutions, and optimise Microsoft-centric data environments for scale, automation, and long-term sustainability.
He is the founder of AzurePlayer.net blog, creator of the "Ask SQL Family" podcast and actively publishes technical content on his YouTube channel, sharing practical insights on Data Strategy, Microsoft Fabric, Databricks, and modern cloud data engineering with the global #sqlfamily community.
Privately happy husband and father of 2 wonderful girls.

Kamil Nowiński - Databricks Solutions Architect Champion, były Microsoft Data Platform MVP oraz Azure Data Engineer & Architect, specjalizujący się w projektowaniu strategicznych, gotowych na AI platform danych dla nowoczesnych organizacji.
Z ponad 25-letnim doświadczeniem w obszarze inżynierii danych oraz technologii SQL Server, Kamil koncentruje się na budowie skalowalnych architektur typu Lakehouse w środowiskach Microsoft Fabric, Azure i Databricks. Jego kompetencje obejmują Data Strategy, Data Integration, frameworki zarządzania danymi oraz modele dojrzałości platform danych — pomagając organizacjom przechodzić od rozproszonej analityki do spójnych, wysokowydajnych ekosystemów danych.
W swojej pracy skupia się na projektowaniu solidnych fundamentów architektonicznych, obejmujących wdrażanie Unity Catalog z klasyfikacją danych, projektowanie architektur czasu rzeczywistego i rozwiązań event-driven, modernizację istniejących środowisk BI oraz wprowadzanie praktyk DevOps do platform danych. Wierzy, że skuteczne AI i zaawansowana analityka nie są dziełem przypadku - są rezultatem świadomych decyzji architektonicznych, uporządkowania danych oraz zdyscyplinowanego podejścia inżynierskiego.
Jako konsultant współpracujący z organizacjami na rynku UK, pomaga rozwiązywać złożone wyzwania związane z danymi, prototypować rozwiązania nowej generacji w obszarze BI i Big Data oraz optymalizować środowiska oparte na technologiach Microsoft pod kątem skalowalności, automatyzacji i długoterminowej stabilności.
Jest założycielem bloga AzurePlayer.net, twórcą podcastu "Ask SQL Family" oraz aktywnie publikuje treści techniczne na swoim kanale YouTube, dzieląc się praktyczną wiedzą z zakresu Data Strategy, Microsoft Fabric, Databricks oraz nowoczesnej inżynierii danych w chmurze z globalną społecznością #sqlfamily.
Prywatnie szczęśliwy mąż i ojciec dwóch wspaniałych córek.

Badges

  • Most Active Speaker 2023

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Server Data Tools
  • Azure Data Factory
  • DevOps & Automation
  • Microsoft Azure DevOps
  • Microsoft SQL Server
  • PowerShell
  • GitHub
  • Databricks
  • CI/CD
  • Microsoft Fabric

Databricks & DevOps - How Declarative Automation Bundles help with CI/CD

Declarative Automation Bundles (DABs, previously known as Databricks Asset Bundles) bring an "infrastructure-as-code" approach to packaging and deploying notebooks, jobs, pipelines, and workflows across environments. Instead of clicking through the workspace UI or stitching together ad-hoc scripts, teams can define their entire Databricks project - code, configuration, and infrastructure - in YAML, version it alongside their source code, and deploy it consistently through a CI/CD pipeline.

In this session, we'll explore how DevOps practices translate into the Databricks world. We'll cover what Bundles are and how they compare to notebook-based deployments, how to structure a bundle for dev/test/prod environments, and how to wire them into a CI/CD pipeline (GitHub Actions/Azure DevOps) for automated validation and deployment. Along the way, we'll look at common pitfalls, testing strategies, and how Bundles fit into a broader data platform governance and release process.

You'll leave with a practical blueprint for automating Databricks deployments - reducing manual work, improving repeatability, and bringing real DevOps discipline to your data engineering workflows.

Grant, Revoke, Repeat: A Declarative Approach to Unity Catalog Permissions

Unity Catalog gives Databricks a proper permission model - but managing it by hand, click by click, doesn't scale. As the number of catalogs, schemas, and principals grows, so does the risk of drift, inconsistency, and permissions nobody can fully explain anymore.

This session starts with the fundamentals: how Unity Catalog's permission model works at the catalog and schema level, how privileges are inherited, and the principles worth designing around before you write a single line of automation. From there, we go practical: a demo of a custom, YAML-driven script that treats permissions as configuration - describing who should have access to what, then applying it as a set of GRANT and REVOKE statements against the target environment.

You'll see how a declarative, config-as-code approach turns permission management into something repeatable, auditable, and safe to run again and again - closing the gap between what your permissions should be and what they actually are.

Enforcing Data Quality at Every Layer: Lakeflow Declarative Pipelines Expectations in Databricks

Bad data doesn't announce itself - it slips quietly into dashboards, breaks downstream models, and erodes trust in your Lakehouse long before anyone notices the root cause. Lakeflow Declarative Pipelines (formerly Delta Live Tables) expectations let you catch it at the source, enforcing data quality rules directly inline as data moves through bronze, silver, and gold - without bolting on a separate framework.

This session is a hands-on look at LDP expectations: how to define them, the difference between warn, drop, and fail actions, how to quarantine and inspect violating records, and how to structure expectations across pipeline layers so quality gets stricter as data gets closer to production. We'll also look at how expectations surface in pipeline event logs and metrics, so failures are visible, not silent.

You'll leave knowing exactly how to design an expectations strategy for your own pipelines - catching bad data before it ships, without leaving the Databricks-native tooling you already have.

The Lakehouse and The Medallion Architecture

This session is focused on Data Engineering and the evolution of the different architecture paradigms over the course of the last decades.
We’ll talk about:
• The evolution of the Data Warehouse to Data Lake and to Data Lakehouse.
• The Medallion Architecture.
• The most important Data Engineering principles to adopt in your Data Platform, e.g.:
• Data Validation
• Data Pipeline Dependencies
• Referential Integrity

Azure Data Factory - Deployment challenges

ADF is an important brick in the architecture of any modern data warehousing solution and many other scenarios.
As it exists for some time now and we know its capability pretty well, the deployment of the service is still something that leaves much to be desired, specifically in a bit more complex instances.
In this session, I will show a few challenges to publishing ADF and solution for them.

ADF Deployments with Azure DevOps

Azure Data Factory is a great orchestration tool in the cloud, is mature and for a while now with us.
Authoring the pipelines and other objects as a developer via browser (v2), working appropriately with branches, debug mode and understanding an integration with Git repo might be a bit tricky.
If you add to this, the need for deployment to different environments, adf_publish branch and why actually two methods of deployment exist - these things can be overwhelming.
Learn the best ways of working with ADF, scripts and tools for deployment and differences between them. See, how to automatically (not via UI) generate/export arm template files and use them in further steps in Azure DevOps, if you prefer using this way.

Delta Lake Tables 101

There are more and more file formats nowadays: Parquet format is not the best shiny star any longer. Now, the Delta Lake takes the prim.
Why people do confuse it with Parquet and always talk about files in this case?
In this session, we'll take a look at the evolution of ETL into ELT and its storage aspect, which explain why it is "a must" for modern data warehouse solutions and how is it related Delta Lake technology in cloud environments like Databricks or Synapse Analytics. Finally, we'll check what's Delta-Parquet creature presented in Microsoft Fabric OneLake recently.
We will see also what data layers (stages) are commonly set up and why they make sense.

In this session, we'll take a look at the evolution of ETL into ELT and its storage aspect, which explain why it is "a must" for modern data warehouse solutions and how is it related Delta Lake technology in cloud environments like Databricks, Synapse Analytics or the newest Microsoft Fabric.

Microsoft Fabric Overview - where to start?

Microsoft Fabric is a unified software-as-a-service (SaaS) data platform built around a Data Lakehouse architecture.
But do you know how to use it, how to make it work for you?
In this session, I will walk you through various personas available in Fabric: Data Factory, Data Engineering, Data Science, Data Warehouse, Real-Time Analytics & Data Activator. Which one should you use? Let's check together what problems and architectures can we address with Microsoft Fabric and whether we can build a reliable Data Platform efficiently.

Fully automated CI/CD of SQL database within Azure DevOps

When working on a database in SSDT, there is a need to deploy our changes to further environments and at the same time maintain the consistency of databases between environments. During the session, I will present how we can publish the solution manually and then go to the Continuous Integration and Continuous Deployment process using the Azure DevOps environment (formerly VSTS). In addition, we will work on inserting the unit tests, approval steps and the others using Pester and PowerShell in order to gain full automation in our database deployment process.

SSDT allows you to import and maintenance a database project within Visual Studio. Prepare a few steps more to test and deploy changes and data into target SQL Server with Azure DevOps pipelines.

DATA:Scotland 2025 Sessionize Event

September 2025 Glasgow, United Kingdom

Discovery Day 2025 Sofia Sessionize Event

June 2025 Sofia, Bulgaria

SQLDay 2025 Sessionize Event

May 2025 Wrocław, Poland

DataSaturday Madrid 2024 (SQLSatMadrid) Sessionize Event

November 2024 Madrid, Spain

DATA:Scotland 2024 Sessionize Event

September 2024

SQLDay 2024 Sessionize Event

May 2024 Wrocław, Poland

Data Saturday Slovenia 2023 Sessionize Event

December 2023

Data Platform Next Step 2023 Sessionize Event

June 2023 Billund, Denmark

SQLDay 2023 Sessionize Event

May 2023 Wrocław, Poland

Data Saturday Oslo 2022 Sessionize Event

September 2022 Oslo, Norway

SQLBits 2022 Sessionize Event

March 2022 London, United Kingdom

#DataWeekender v3.1 Sessionize Event

May 2021

Global Azure 2021 Sessionize Event

April 2021

SQLDay 2020

November 2020 Wrocław, Poland

dataMinds Connect 2020 (Virtual Edition) Sessionize Event

October 2020 Mechelen, Belgium

SQLBits 2020

September 2020 London, United Kingdom

SQLSaturday Slovenia

December 2019 Ljubljana, Slovenia

SQL Saturday #926 Lisbon

November 2019 Lisbon, Portugal

Data Relay 2019 Sessionize Event

October 2019

SQL Saturday #904 Madrid

September 2019 Madrid, Spain

SQL Saturday #898 Gothenburg

September 2019 Göteborg, Sweden

SQL Saturday #857 Kyiv

May 2019 Kyiv, Ukraine

SQLDay 2019

May 2019 Wrocław, Poland

Data in Devon 2019 Sessionize Event

April 2019 Exeter, United Kingdom

SQLBits 2019

February 2019 Manchester, United Kingdom

SQL Saturday #829 Pordenone

February 2019 Pordenone, Italy

Kamil Nowinski

Strategic data architecture for the Microsoft & Databricks stack - deliberately, not accidentally

Stevenage, United Kingdom

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top