2 Fast 2 Furious – designing for speed, concurrency, and correctness

With the multitude of isolation levels, concurrency models, and specialist technologies available in SQL Server, it is no surprise that transaction throughput and correctness can be directly correlated to the ability and knowledge of the person that wrote the code. In this session, we will reveal how SQL Server concurrency and correctness often goes wrong,…

6R w migracji hurtowni danych do chmury

Sesja opisująca realny przykład migracji hurtowni danych ze środowiska on-premises do chmury Microsoft Azure ze szczególnym naciskiem na 6 różnych strategii migracji (tak zwana zasada 6 R). Sesja ma charakter architektoniczny, ale obfituje w przykłady konfiguracji narzędzi i przykłady kodu do automatyzacji procesów.

A Masters view on Locking and blocking

How do the wait stats show you that you have a locking issue?This session will show you how to detect and view blocking and lock waits, and understand the cause of it.An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks.And finally a real-world quick list of suggestions on what you…

ADFv2 – Data Integration in Azure Just Got Awesome

Azure Data Factory version 2 (ADFv2) arrived in Sept17 with a bunch of new concepts and features to support our Azure data integration pipelines. In this session, we’ll update your ADFv1 knowledge and start to understand the true nature of scale out control flows and data flows. What’s the integration runtime? Can we easily lift…

Advanced Data Visualisations for Your Reports with R and Python libraries

One picture tells more than thousand words. Effective report needs informative and good looking visuals. Standard Reporting Services capabilities are huge and strong but sometimes you feel you need more. And you can have more, much more with graphic libraries used in R and Python. Come and see what can you do with ggplot2, seaborn…

AI Adventures on the Edge

We had a customer problem, and this presentation is how we solved the issue using computer vision. Is a story of trying and evaluating options and to see how to do it. As test evaluation rig we used a Raspberry PI and camera., and we tried anything and on everything, from running bare metal, training…

AI and Data Science in industry

In today’s world, AI and Data Science are gaining popularity. This happens not only because they offer technologically advanced and interesting solutions, but mainly because they find a very wide application in solving real problems. The session aims to inspire people working in industry and broadly understood business to use the capabilities of artificial intelligence…

AI enrichment with Azure Cognitive Search

AI enrichment is a capability of Azure Cognitive Search indexing that is used to extract latent information from images, blobs, and other unstructured, non-text data sources – enriching the content to make it more searchable in an index or knowledge store. Both extraction and enrichment tasks are implemented through cognitive skills such as natural language…

Analityka w chmurze Azure – Demo Hour

Paweł Potasiński Bartłomiej Graczyk Analityka na Azure może mieć różne oblicza. Chmura Microsoft oferuje mnóstwo usług, które można wykorzystać budując rozwiązania realizujące różne rodzaje analizy danych – od analiz historycznych, przez analizy predykcyjne, aż po analitykę preskryptywną, w której informacja jest zaledwie inicjatorem procesu biznesowego. W trakcie tej sesji zademonstrujemy w działaniu praktyczne i inspirujące…

Anomaly Detection in Predictive Maintenance for Sql Server

The amount of data we collect, store and process is rapidly growing and goes hand in hand with growing amount of work related to managing it. Automation is a key if we want to stay in control and AIOps represents its next major level with potential to revolutionise IT operations. This session explains what AIOps…

Another brick in the lake – introduction to Delta Lake on Databricks

During the session we will go through some practical examples & watchouts of using Delta Lake in Databricks environment. I will explain why Delta matters so much, what is important to remember, but also where it doesn’t fit!

AQP czy IQP?

SQL Server 2017 rewolucyjnie rozpoczął wsparcie dla automatycznego tuningu zapytań. Początkowo nieśmiało wykorzystano informacje przechowywane w plan cache oraz query store. Nadchodzi jednak SQL Server 2019, a w nim już cała plejada całkiem przydatnych nowości: batch mode on rowstore, memory grant feedback, interleaved execution, adaptative joins, deferred compilation oraz approximate query processing. Owe nowości tworzą…

Are You Optimistic About Concurrency?

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012’s SNAPSHOT Isolation optimistic? How can SQL Server 2016’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new technology…

Attention Contention!!!

In this session we will discuss about tempdb contention in SQL Server on-premises, Azure SQL Managed Instance and Azure SQL Database.We will analyze both, Allocation Contention and Metadata contention, describing in detail WHEN and HOW it occurs, How to diagnose it, Best Practices and how to prevent it.The session will have both approaches in on-premisses…

Automating Database Deployments Using Azure DevOps

Nothing beats having an automated way to validate your code before it gets anywhere near your production servers. However, validating databases presents whole new challenges to the automation process. We’ll go over how to use Azure DevOps to automate the deployment of your database systems. Azure DevOps is a powerful tool, already used in a…

Automating the testing of your BI solutions with NBi

If you want to accelerate the testing of your BI solution, the best strategy is to automate your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (nbi.codeplex.com). This framework is providing support for automated tests on the fields of…

Avoid report limitations with advanced Power BI and DAX

The most of you are familiar with Power BI and had already created a lot o reports. But what to do when limitations disallow you to satisfy business needs? During this session we’ll face with this issue. Having number of different business requirements we’d walk around limitations and provide fully useful solutions. We’d play with…

Azure CosmosDB – how to use it, when and where! Cases from the field

During this short session I will show you how some customers in Poland are using CosmosDB and what are prefered scenarios for it. As the NoSQL databases have a lot tempting features, they should not be used for all the scenarios. During the session we will review couple of them.

Azure Data Factory i proces CI/CD w Azure DevOps

Pracując nad przepływami w Azure Data Factory pojawia się naturalna potrzeba, mądrego i w miarę możliwości zautomatyzowanego wdrażania naszych zmian na kolejne środowiska. Dobrze, gdybyśmy mieli również możliwość porównania zmian pomiędzy wersjami oraz w razie potrzeby cofnięcia się do wcześniejszej wersji naszych przepływów. Na sesji zaprezentuję w jaki sposób możemy wykonać automatyczny proces CI/CD (Continuous…

Azure Databricks 101

Many sources? Various format? Unstructured data? Big Data? You might think that these only a buzz words. Not really. These days it’s a part of modern data flow architecture. No matter what do you use – SQL Server, Cosmos DB, Azure SQL DW, Azure Data Factory, Data Lake… somewhere there you can find Databricks. So,…

Azure Databricks: big data made easy

Databricks is to Spark as PaaS is to IaaS. If you’ve ever wanted to explore big data world but shied away because of its complexity, worry no more! During this session we will not only focus on Spark basics, but also cover practical examples of batch, interactive and streaming processing.

Azure Digital Twins in a Nutshell

Digital twins make it possible to simulate, analyze and test scenarios digitally, before implementing changes in the real world. There are already huge advantages in being able to digitally monitor and control physical objects near or far and at any time. It also possible to explore and experiment further on these objects by building virtual…

Azure IoT Solution Architecture Best Practices

The Internet of Things is becoming reality at a rapid pace. Many objects in the real world can be connected to the Internet. Cloud computing is the best option for the IoT backend. Microsoft Azure offers the offers a wide range of services, used in the Internet of Things solutions This presentation provides a deeper…

Azure Machine Learning Workbench

Microsoft has added a new Azure Machine Learning Workbench to a rich offer of solutions for building machine learning models. Let’s get to know the possibilities of this solution during the session, going through the typical machine learning path. We will see a variety of scenarios ranging from local work, containers, as well as working…

Azure Orchestration – Applying Data Factory in Production

If you have already mastered the basics of Azure Data Factory (ADF) and you are now looking to advance your knowledge of the tool, this is the session for you. Yes, Data Factory can handle the orchestration of our ETL pipelines. But what about our wider Azure environment? In this session we will take a…

Azure SQL anywhere. An Introduction to Azure Arc enabled Data Services

Until very recently, Azure SQL was just for… well. Azure. Join Data Platform MVP Ben Weissman as he explores Azure Arc for Data Services, Microsoft‘s solution to deploy services like Azure SQL to any cloud – including private clouds – using kubernetes. He will take us through the core concepts of Arc enabled Data Services…

Azure SQL Data Warehouse – raport z pola walki

SQL Data Warehouse jest jedną z tych usług PaaS w Azure, których można użyć, jeśli elementem rozwiązania analitycznego powinna być hurtownia danych przez duże “hurt” (czytaj – ilość danych taka, że aż boli). W teorii usługa ta przypomina platformę SQL Server albo – może bardziej – rozwiązanie sprzętowo-programowe Analytics Platform System (dawniejsze Parallel Data Warehouse).…

Azure SQL Database – yesterday, today and tommorow

Od dłuższego czasu obserwujemy dynamiczny rozwój usługi SQL Database – coraz więcej korzyści wynikających z przenoszenia rozwiązania do modelu PaaS, nowe możliwości w Data Platform, dostępne najpierw w chmurze. Podczas sesji przedstawię najnowsze zmiany i kierunki w których następuje ewolucja SQL Database w zakresie wydajności, bezpieczeństwa czy zarządzania usługą.

Azure SQL Datawarehouse – The Complete Introduction

Azure SQL Datawarehouse is not really the standard SQL Server that you could point your existing SSIS packages and reporting queries at and expect the same behaviour and performance. So why is that? And what should you do different to get the most out of Azure SQL DB? In this session I will explain what…

Azure Synapse vs Azure Databricks which one is right for you?

Azure Synapse Workspace provides the ability to use both Apache Spark and Databricks. Which one should you use? The answer of course is “It Depends”. In this session we are going to review what the use cases are which would determine why you would select one tool over another. Here we will examine the costs,…

Back to the Future: Accelerating the Cloud Migration of Legacy SSIS with Azure Data Factory

This session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS, such as 2008 or earlier versions, with Azure Data Factory (ADF). We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – and extend it with custom/Open Source/3rd party components. We will…

Bazy danych w SSDT (cz.1): Praca z projektem oraz praktyczne wskazówki

Zadanie wydaje się proste: utrzymywać projekt bazy danych w repozytorium, traktować go jako master-version oraz wykonywać wdrożenia w regularnych i niezbyt długich odstępach czasu. Proste? Pozornie. Sprawy się komplikują gdy ilość obiektów w bazie rośnie. Gdy zamiast jednej bazy, mamy kilkanaście. Kiedy bazy danych posiadają referencje do siebie nawzajem. A co z tabelami słownikowymi? Gdzie…

Bazy danych w SSDT (cz.2): Wdrażanie w procesie CI/CD z Azure DevOps

Pracując nad bazą danych w SSDT pojawia się potrzeba wdrożenia naszych zmian na kolejne środowiska i jednocześne utrzymanie spójności baz pomiędzy środowiskami. Na sesji zaprezentujemy jak możemy wykonać wdrożenia ręcznie a nastepnie przejść do procesu Continuous Integration oraz Continuous Deployment z zastosowaniem środowiska Azure DevOps (dawniej VSTS).Ponadto popracujemy nad wpleceniem w nasz proces unit testów…

Beyond SQL Server – Open Source Databases on Azure

As we went through the journey of launching Postgres, MariaDB and MySQL as a first class services in Azure, it has been a very humbling experience learning from our customers and the community. We want to share a few learnings from this journey with you all. Azure Database for MySQL, PostgreSQL and MariaDB are fully…

Brief introduction into SQL Server Execution Plans

The goal for this session is to present what Query Execution Plans are and how they are created. Attendees will learn how to get them, how to read them, and what is the most valuable information they deliver us. In addition, Marek Maśko will discuss few most popular operators and their important properties. This knowledge…

Building efficient and reliable Enterprise Reporting Platform with Microsoft Power BI

How to create and deploy Power BI reports that are fast and reliable? Join us and learn how to build serious, secure, and scalable reporting solutions with Power BI. We’ll cover the common patterns for Power BI usage, performance implications and best practices in deployment, monitoring, data source configurations, reports publishing and security aspects. You…

Call for action – Raporty motywujące do działania z wykorzystaniem Power BI

Czy raport ma po prostu ładnie wyglądać i pokazywać liczby? Nie! Ma angażować użytkownika końcowego, wzbudzać w nim emocje, prowokować do działania a przez to maksymalizować wartość z jego utrzymywania. O tym sobie poopowiadamy na sesji z wykorzystaniem przykładów biznesowych i narzędzia Power BI.

Case study: Wdrożenie mechanizmu klasy Transactional Analytics w Straży Granicznej

Czasami od systemu oczekujemy zarówno wydajności hurtowni danych, jak i wysokiej współbieżności w przetwarzaniu transakcji. Choć są ich setki milionów, każda jest potencjalnie tak samo ważna i musi być dostępna w najdrobniejszych szczegółach. Na sesji opowiemy, dlaczego system obsługi odpraw granicznych ma wszystkie te cechy, w jaki sposób poradziliśmy sobie z potrzebami analitycznymi na danych…

Challenges on GDPR from a database perspective

GDPR is the European Regulation that gives directives about data protection from an individual level. Every person in Europe is entitled to the some data rights which, at the organizational side, cause some major changes in how the information is managed and, consequently, affects the design and implementation of any applications that utilizes data. DBAs,…

Chatbots: Let People Talk To Your Data So You Don’t Have To Talk To Them

Are you a data professional tired of answering the same questions over and over again? Whether you’re a DBA or a developer, those constant, monotonous questions can take your focus away from the task at hand. “What server is that on?” “What report contains that data?” “What environment has that bug?” While it may be…

Chmura czy on-premise, IaaS czy PaaS – “… baba z wozu, koniom lżej” – czy aby na pewno?

Porównanie dostępnych środowisk, ich zalety i wady, mocne i słabe strony, chmura (jaka?) czy on-premise. Poruszymy zagadnienia bezpieczeństwa, dostępności SLA, realnych kosztów, łatwości implementacji oraz możliwości dla użytkowników końcowych oraz środowisk raportowych.

Choosing the Right Database for Microservices Solutions

The past years have seen the explosive growth of large-scale distributed systems. This trend has changed the database world that is arguably without precedent in the history of the software industry. The result is a ompetitive database marketplace with a huge variety of platforms for us to choose from. But how do we go about…

Classifying support tickets using text analysis and machine learning

Machine learning is a very rapidly evolving branch of IT and you can find examples of companies using it almost in every industry. In my presentation I would like to talk about one particular company I collaborated with to build a solution for automatic classification of support tickets. I will discuss different tools and technics…

Cloud Data Wars: The Force Awakens

Each cloud has its own army of data services. Each one claims they are the best and unique. Let’s see if this is really the force awakens and who followed the light and who followed the dark side of the Force. May the Force of data services be with you…

Co powinieneś wiedzieć o Databricksach, a o czym prawdopodobnie nie masz pojęcia

Azure Databricks to usługa szybko adaptowana przez wiele firm. Pozwala na wykonywanie zapytań potrzebujących dużej mocy obliczeniowej. Sama może się skalować w celu przyspieszenia obliczeń. Do tego pozwala na używanie kilku języków programowania. Można pokusić się o stwierdzenie, że rozwiąże wszystkie problemy… ale tylko i wyłącznie świadomych użytkowników. W trakcie sesji pokażemy o czym należy…

Columnstore Clustered vs Nonclustered, when to choose what

The incredible Columnstore Indexes can increase your analytical query processing speed multiple times, they are updatable (Clustered from SQL Server 2014 and Nonclustered from SQL Server 2016 respectively), but they keep on supporting different sets of the functionalities – such as CDC (Nonclustered Columnstore) and LOBs (Clustered Columnstore), and this brings a great confusion. This…

Common Data Model – hurtownia danych z pudełka?

Jedno narzędzie by wszystkimi danymi rządzić… Czy możliwe jest wykorzystanie jednej platformy jako bazy dla różnych aplikacji biznesowych i raportowych, łącząc tym samym świat danych transakcyjnych i analitycznych? Opowiemy czym jest Common Data Model oraz zaprezentujemy przykłady jego wykorzystania jako substytutu hurtowni danych oraz integrację z Power BI.

Common Enterprise Analytics Architectures with Azure Data Services and Power BI

This session will tie together the components of the modern data warehouse stack including Azure Data Factory, Azure Data Lake Storage Gen2, Azure Databricks, Azure SQL Data Warehouse, Azure Analysis Services and Power BI. Learn how to operationalize end-to-end BI architectures covering everything from data ingestion, preparation to reporting and analytics. Join us and learn…

Comparing Predictive Mining Models from R, Python, SSAS, and Azure ML

There is a lot of overlapping in Microsoft BI suite. For advanced analytics, like data mining, you can use SQL Server Analysis Services (SSAS), or R, or Python, or Azure ML. The question arises which tool to use. The answer is simple, through another question. Why not all of them? In data mining, you typically…

Complex Azure Orchestration with Dynamic Data Factory Pipelines

If you have already mastered the basics of Azure Data Factory (ADF) and are now looking to advance your knowledge of the tool this is the session for you. Yes, Data Factory can handle the orchestration of our ETL pipelines. But what about our wider Azure environment? In this session we’ll go beyond the basics…

CosmosDB for (scary) developers

TBD

Creating Custom Visuals in Power BI with TypeScript and D3.js

This presentation is about how to create custom visuals (components) for your PowerBI reports. Power BI reporting features could be extended with custom components, that developers can implement and BI specialist can include in their dashboards. Many visuals are also availabe in the Power BI Visuals Gallery. Power BI is flexible with which graphical API…

Data Driven Decision Making with Azure Machine Learning

Azure Machine Learning [ML] is a great tool for providing deep analytical data analysis and can provide a great learning environment to those people who are just getting started with learning machine learning concepts as well as those who want to deploy complex models created in R or Python. This session will introduce how to…

Data Lake praktycznie, czyli nie ważne jak zaczynasz, ważne jak kończysz

Wraz z upływem czasu rośnie wolumen danych w systemach sprzedażowych, a nie każda hurtownia danych jest gotowa dziesiątek terabajtów danych. Z pomocą przychodzi Data Lake, który jest w stanie przetworzyć takie wolumeny dzięki “nieograniczonej” możliwości skalowania. Jak podejść do tematu od A do Z, od źródeł danych po pierwsze analizy? Pokażemy jak w łatwy sposób…

Data lakehouse od demo do produkcji

Koncepcje takie jak data lake, modern data warehouse czy data lakehouse coraz częściej  stają się podstawową architektury dla systemów analizy danych. Kilka miesięcy temu zaprezentowaliśmy krótkie demo prezentujące, w jaki sposób można zbudować rozwiązanie data lakehouse na platformie Azure (https://github.com/FP-DataSolutions/SQLDay2020). Jednak droga od działającego demo czy PoC do produkcji jest długa i pełna wyzwań. W trakcie sesji zaprezentujemy, jak wyglądało budowanie rozwiązania analizy danych opartego…

Data Overview and Manipulation – T-SQL, R, Python

In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how…

Data Science in Power BI Desktop

Two of the most popular modern topics are data science and Power BI. The nice thing is that you can easily combine both of them by including data science analyses in Power BI. You can do this in numerous ways. Many Power BI visualizations already include the Analytics tab with plethora of intermediate-level analytical functions…

Data Science in practice

Always wondering: What is data science? How can you apply its concepts, methods and tools to particular business cases? How does the implementation process look in practice? Our experts will try to answer all those questions during this session. Łukasz Grala Krzysztof Odasz Jakub Wawrzyniak

Data Time Travel with SQL Server Temporal Tables

Many times developers have to support users by answering the “What happened to the data?” The task of retrieving data from a specific point in time is not an easy one. Often this involves retrieving a backup and restoring the data in question (hopefully!). SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve…

Database as a Service offering in Azure – Architect Perspective

Cloud offers number of database options – starting from simple Tables within Azure Storage, through number of PaaS offerings, finishing with complicated IaaS clusters based on Casandra, SQL Server oraz Oracle with RAC option. Choosing between them is not easy and I often see customers struggling to decide which option is the best for them.…

dbachecks – The PowerShell Module to validate your SQL Estate

As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method to set this up using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule. Details such as…

Debugging without debugger: investigating SQL Server’s internal structures

Have you ever wanted to know exactly how SQL Server stores data for temporary structures, such as for instance the spooled data in a Table Spool or Index Spool operator? No? I don’t blame you. It’s a bit like wanting to know who wattered the rubber tree that produced the rubber your tires are made…

Deploying and Managing SQL Server with dbatools

The dbatools project brings automation to the forefront of the SQL Server configuration, operations, and deployment tasks. In this session we will look at how to install and configure multiple SQL Servers quickly and consistently using dbatools deployment tools. Once those systems are up and running we will look at how to configure and manage…

Design Myths

Prepare for a surprising, intriguing, and even controversial session. 45 years after Codd defined the Relational Model, there are still so many parts misunderstood. For sure there are points where you will be surprised and change your view, even though you might have been convinced for years that your view is the correct one, and…

Designing impactful visualisations for your data

As Data is key, visualising said data is even more important. We want our message to be understood with ease, and merely with a couple of glances. Hence making sure the receiving party can do so with ease will be vital to our success. During this session, we’ll go through some steps on how to…

Do You Speak English? Localized Reports with Power BI

Even when we live in a global world your end-users might expect to get their reports in their own local language. This talk is guiding you through the available options and necessary steps to give the report user control over the language: • Content of textual columns • Headlines • Currency • Model (names of…

Docker dla amatora danych

Docker nie jest niczym nowym, ale wydaje się, że właśnie teraz bije rekordy popularności. Jakiś czas temu postanowiłem, że ja również poznam tę technologię i sprawdzę w jaki sposób może pomóc komuś takiemu jak ja. Mimo, iż póki co w bieżących projektach nie mogę korzystać z kontenerów, to okazuje się, że jego znajomość już jest…

Does This Look Weird to You? An Introduction to Anomaly Detection

Discovering anomalies is a critical part of systems monitoring, financial auditing, and more. In this session, we will gain an understanding of what constitutes an anomaly, starting with a general concept of anomalies and then moving into technical definitions. We will review techniques for detecting anomalies for both time series and non-series data and implement…

Dont’t Use Cursors – or Why You Maybe Should Use a Cursor After All

You might have heard “don’t use cursors, they are slow!”. In this presentation, you will learn that normally you should write set-based statements instead, and I will explain why they generally are faster. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn…

Droga od klasycznej hurtowni danych po lakehouse. Implementacja lakehouse na wybranym przykładzie

Nie tak dawno temu hurtownie danych zdominowały rynek komercyjny jako fundament rozwiązań business intelligence. Niemniej jednak, koncepcje takie jak data lake, modern data warehouse i lakehouse coraz głośniej manifestują swoją wartość. Wyjaśnimy cechy nowych produktów, wskażemy kluczowe różnice między nimi i co najważniejsze – zademosntrujemy implementację lakehouse na wybranym przykładzie.

End to end AI Platform Designing in Azure

Azure platform is providing end to end support for data loading, data hosting, data management, data visualization, data ingestion, model training, model exploring, model monitoring. In this session we will give a complete overview of desining AI platform in Azure platform and will show hands of demo along with complete architecture with best practices.

Ethereum proof-of-authority consortium on Azure cloud platform

Omówiona zostanie zaawansowana koncepcja proof-of-authority w rozwiązaniu blockchain Ethereum. Przedstawiona zostanie idea węzła walidatora. Podstawy wydobycia (mining) oraz metoda generowania kosztów i zużycia energii (PoW) w komputerach oraz generowania transakcji będą omówione zarówno z zaletami, jak i wadami. Opowiem o przykładzie użycia prywatnych bloków w przemyśle. Całe wdrożenie sieci prywatnej/konsorcjum Ethereum będzie prezentowane na platformie…

Examples of using Spark in Azure for data processing

Spark is a great technology for parallel computing and processing data. It was designed to be fast! And Azure could be a great way to try it. In this session we will look through the capabilities of Spark using a couple of real-world examples to ensure, that it is a great technology and really worth…

Failure prediction for manufacturing industry with SQL Server & R

Working in manufacturing industry means that you must deal with product failures. As a BI and/or Data Scientist developer, your task is not only monitor and report product’s health state during its lifecycle, but also predict the likelihood of a fail in the production phase or when product has been delivered to the customer. Machine…

Fast & Furious – czyli sesja o tych najbardziej wydajnych bazach danych w chmurze

Niezależnie od tego czy wdrażasz aplikację web, planujesz budowę hurtowni danych, czy eksperymentujesz ze strumieniami danych – baza danych to podstawa Twojej architektury. W trakcie tej sesji omówimy i pokażemy jak funkcjonują najbardziej wydajne silniki bazodanowe…oczywiście w chmurze.

Financial Modelling with Power BI

Bob has been involved in taking Financial Models from paper based to highly dynamic analytics models in Microsoft BI for many large enterprises in Ireland. Building Successful Financial Models based of a Chart of Accounts and General Ledger can be difficult for a number of reasons: – Dynamic/Growing Chart of Accounts – Many to Many…

From Big Data to the knowledge contained in the data, 2h live demo – part 1

Huge amounts of diverse data surround us on each side. However, both, this magnitude and variety are primarily a source of confusion, not benefits. Only proper data processing allows to reveal valuable information and knowledge contained in the data. And only this digested knowledge can bring real business benefits. During the session, our team of…

From Big Data to the knowledge contained in the data, 2h live demo – part 2

Huge amounts of diverse data surround us on each side. However, both, this magnitude and variety are primarily a source of confusion, not benefits. Only proper data processing allows to reveal valuable information and knowledge contained in the data. And only this digested knowledge can bring real business benefits. During the session, our team of…

From Docker to Big Data Clusters: a new era for SQL server

Starting with version 2017, SQL server was supported on Docker and Linux. With SQL Server 2019, you will be able to run a container, or a whole AlwaysOn Availability Group on Kubernetes. This session will drive DBAs on their path to modernize their skills. Starting with a single container on a Docker host, the session…

From failure to international conference speaker

Life really is like a box of chocolates. You never know what you’re going to get. In only a handful of years, my life has changed drastically in a very positive way. I used to be almost out of a job, now I’m a consultant working for a firm that has over 2500 employees. I…

Get data insights faster with Data Wrangling

Self-Service Data Preparation aka Data Wrangling is becoming more and more popular in BigData and Enterprise world. Data Lake stores tons of different data and it is not easy to get value from it. Traditional approach doesn’t work here, data analysts and data scientists have to wait until IT guys gather requirements and prepare a…

Getting Started with Azure Databricks

Azure Databricks provides the ability to use massive scale to read and stream data to create machine learning solutions to provide insight for large data stores. In this session you will learn how to get started in Databricks, and when it is the right tool for your data science project. We will also walk through…

Getting Started with Linux for the SQL Server DBA

With the introduction of SQL Server 2017 for Linux, there is no escaping the fact that SQL Server DBAs need to be familiar with the Linux operating system. So, how do you start? In this session, you will learn the most important fundamentals and commands that are important to the DBA when managing a database…

GitHub DevOps Duet – SQLDay Edition

Kevin Chant Sander Stad Welcome to GitHub DevOps Duet, a scenario where two teams (dev and ops) are going to start using GitHub Actions for Data Platform deployments. They need to figure out how to implement their processes within GitHub and make it work for all parties. We will discuss: – the challenges of implementing…

Going to Azure SQL: Admin differences no one told you before

Many companies believe administering a SQL Server in the cloud is the same as administering a SQL Server on premises and that is a big mistake. Optimizing, Monitoring, Security, there are many differences on the administration you will learn during this session, allowing you to become a better cloud DBA.

Hacking SQL Server

You have been working with SQL Server for several years and you feel quite comfortable with most of the available features. Even you have a checklist for installation/configuration of SQL Server to be compliant with corporate standards. However, somewhere on the back of the head you have a feeling that there is something more that…

How to do advanced analytics on graph data in Azure Cosmos DB

Azure Cosmos DB is Microsoft’s multi-model database which supports the Gremlin query language to store and operate on graph data. It enables you to build highly responsive applications worldwide. As part of Cosmos DB, Graph/Gremlin API is supported for graph databases. Since Cosmos DB is optimized for fast processing (OLTP), traversal limits may apply for…

Identity, Sequence i ROW_NUMBER

TBD

Image classification with Microsoft Cognitive Toolkit

Artificial intelligence is called electricity of the 21st century. One hundred years ago the popularization of electricity changed the ways in which we work, travel and rest – invention of electricity changed our whole world. Today, thanks to artificial intelligence, we are facing a revolution on a similar scale. The breakthrough was possible due to…

Inside the Memory of SQL

In this session I’ll describe how SQL Server memory management works including architecture, limits, and how you can configure and monitor memory usage. I’ll also describe differences in memory management for SQL Server on Linux and Azure SQL.

Integration of multi-source heterogeneous data using Python

Analyst often needs information from multiple sources with structured and unstructured data, often facing the data inconsistency and contradiction. The goal of the presentation is to give an overview of tools provided by Python environment to access, transform and combine data from multiple sources to obtain consistent information.

Intelligent Query Processing w SQL Server 2019

TBA

Jak BIML ułatwił moje życie

W swojej codziennej pracy często spotykałem się z niechęcią do tworzenia powtarzalnych pakietów SSIS. Sposoby rozwiązań tego problemu były różne: od zatrudniania osób, które będą to robiły do automatyzacji swojej pracy. Tu z pomocą przyszedł BIML, który pozwolił znacznie ułatwić swoją pracę. W czasie sesji opowiem o możliwościach BIML, jak zidentyfikować idealne pakiety do przeniesienia…

Jak się nie bać failovera?

Mechanizm SQL Server Always on Availability Groups oferuje wysoką dostęność dla baz użytkownika, jednak zupełnie nie jest pomocny dla baz systemowych. Te zawierają sporo danych niezbędnych dla prawidłowego funkcjonowania instancji SQL Serwera jako całości. Na sesji opowiem, jak w StepStone Services wraz z moim zespołem poradziliśmy sobie z problemem, aby po failover nie lądować w…

Jak z sukcesem wdrożyć Power BI w dużej firmie? – perspektywa architekta i eksperta BI

W trakcie sesji opowiemy o doświadczeniach zebranych podczas realizacji projektów i szkoleń w obszarze Power BI, skupiając się na wyzwaniach z jakimi wiążą się wdrożenia Power BI na duża skalę. Przedstawimy jak ewoluowało postrzeganie i użytkowanie platformy Power BI z perspektyw analityka danych, eksperta BI oraz architekta rozwiązań. Wskażemy jak nowe funkcjonalności Power BI przekładają…

Kilka uwag o projektowaniu baz danych

Zebrane doświadczenia związane z projektowaniem baz danych.

Kubernetes 101

SQL Server 2019 zaczyna wykorzystywać Kubernetes, Spark może być uruchamiany na Kubernetes, Kubernetes to naturalne środowisko dla tensorflow. Jeśli zajmujesz się tak zwaną Modern Data to istnieje duże prawdopodobieństwo, że w ciągu najbliższych miesięcy spotkasz się z Kubernetes. Przyjdź na sesję i dowiedz się czym jest Pod, Node, Container, Deployment, Service, Job czy Persistent Volumes…

Kubernetes for data scientist

TBD

Lambda Architecture with Azure Data Services

Podczas sesji zaprezentowane zostaną komponenty Azure dedykowane do odpowiednich warstw architektury Lambda. Sesja będzie miała charakter warsztatowy podczas której zostanie zbudowana architektura pozwalająca na strumieniową analizę danych. Będą opisane komponenty takie jak Azure Databricks, CosmosDB, Power BI, Azure Time Series Insight oraz inne..

Laying the Foundations for GDPR Compliance

GDPR, no matter where you are if you are handling data on European data subjects. Laying a solid foundation of data security practices is vital to avoid the potential fines and damage to reputation that being non-compliant can bring. Practicing good data hygiene is vital to meeting compliance requirements, whether it is GDPR, PCI-DSS, HIPAA…