Michał Poręba
A data and software enthusiast
Swansea, United Kingdom
Actions
I'm intrinsically curious about all things data and software development, and architecture of computer systems. I am a Civil Servant, a Chief Data Architect, but I spend a lot of time with data engineers and other digital professionals trying to use what I know to build some interesting things. After hours I contribute to a few open source projects, plays music or go diving in caves.
Links
Area of Expertise
Topics
Semi structured (JSON) data in SQL Server
We live in the age of Web APIs and microservices. JSON appears to be the data format of choice of the applications we, as DBAs, need to support. It would be easy to say, that perhaps SQL Server is not the right choice there, but then, sometimes we don’t have a choice so…
Let me tell you about my experience of working with JSON data in SQL Server, about the problems, the possibilities and the surprises discovered along the way. Let’s talk about what’s practical, what’s not when dealing with semi-structured data in a relational database. Let me show you the techniques I have learnt on the way and their performance implications.
SQL Server, Containers and Active Directory
It has been few years since SQL Server can run on docker. There has been a lot of excitement but far less adoption. Why is that? There are many reasons, but for me, one clearly stands out: problems with integrations with existing systems based on windows and windows domains. And still developers want to build microservices and run them in Docker containers and we, as DBAs, need to find ways to support them and their applications. If you find yourself in this situation, if you managed SQL Server in Windows domains and you hear developers talking about docker, containers and such, this is the session for you. Let me explain what they are talking about and show you in detail what options are available to you, what problems to look out for. Yes, there will be problems, quite a few, but I will share my solutions and workarounds, show you how I use SQL Server and containers to support my development and production environments.
(To fully participate in the session, you should have a basic understanding of windows domains and PowerShell. Docker or Linux knowledge is not necessary).
Not So SQL Anymore
Relational and non-relational databases evolved to solve very different problems and they solve them well. But binary solutions are not necessarily very pragmatic, or possible.
In this session you will learn how the latest features of SQL Server help to bridge the gap, allowing you to get some of the NoSQL benefits in your existing RDBMS systems. Of course, nothing is free so, we will also look at potential problems and performance implications when working with XML, JSON documents or Graphs in SQL Server, and how they can be mitigated.
Data for all, not just power users
In today’s data-driven world, everyone needs access to tools to make better decisions based on data. And yet, many organisations rely on complex and expensive data platforms that require specialised skills to operate. Power tools for power users.
In this session, I will show you an alternative. We call it Data Workspace - a set of (mostly) free, accessible, open-source tools any organisation can run to help empower all their users to take the first steps towards harnessing the power of data. We build it because data should be for everybody. After all, a diverse pool of data users makes for better decision-making.
Join me and learn about other benefits of this approach, how to try it yourself and how to help your organisation get more out of data.
Michał Poręba
A data and software enthusiast
Swansea, United Kingdom
Links
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