SQLSaturday #857 - Kyiv 2019

Event Date: 05/18/2019 00:00:00

Event Location:

  • Hotel President
  • 12 Hospitalna street
  • , , Ukraine

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: Move your database to the Cloud: Understand, Design, Migrate, Man

Abstract: This Azure SQL Database pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts. It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment. After attending this pre-con, you will be able to: • Understand how Azure SQL Database works • Know the newest and most important features to manage your Azure SQL Database • Design scalable architectures • Design Disaster Recovery plans • Manage security on your Azure SQL Database • Monitor and troubleshoot Azure SQL Database • Face a migration project

Speaker(s):

  • Jose Manuel Jurado Diaz

Track and Room: Cloud Application Development Deployment - RoomB


Title: What is CI/CD for databases or how to automate DB changes

Abstract: In the world of agile software development, the database development process introduces some challenges to the application development process. The delivery of changes at database level tends to be a different and separated process of the application delivery process or even an entirely manual process. This contributes to the perspective that the database is a bottleneck in the agile process. In this session, I will show how to build a deployment pipeline capable of delivering database and application changes. The pipeline includes the following steps: source control, continuous integration and continuous delivery. I will share methods and strategies that allow bringing together databases and applications in the delivery process reducing the delivery pain. The main goal is to understand that applications and databases can and should share the same deployment pipeline and that this pipeline will allow you not be afraid of making database changes.

Speaker(s):

  • Taras Kloba

Track and Room: Enterprise Database Administration Deployment - Predslava1


Title: DevOPS for DBAs - Where is your magic wand?

Abstract: DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!

Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . In this session let us overview where exactly DBAs can make miracles with their magic wand, let’s talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices. Also review what Azure DevOps is offering to manage your cloud deployments.

Take away best practices associated in DEVOPS and DBA world.

Speaker(s):

  • Satya Jayanty

Track and Room: Enterprise Database Administration Deployment - Conference-Hall


Title: Plan Caching

Abstract: With a few exceptions, SQL Server stores the execution plan for a query in the internal plan cache. In most cases, subsequent execution of a similar query will greatly benefit from this mechanism, but not in all cases. In this session, you will learn why and under what circumstances SQL Server caches execution plans. We will analyze the plan cache to identify performance issues, such as plan pollution, and how to avoid this. You’ll see the benefits and drawbacks of parameter sniffing for procedures and functions, and the differences between native compiled and interpreted stored procedures. Furthermore, we will analyse how the settings ‘optimize for adhoc workloads’ and ‘forced parameterization’ influence query execution and the re-use of cached plans.

Speaker(s):

  • Torsten Strauss

Track and Room: Enterprise Database Administration Deployment - Congress-Hall


Title: Hadoop in AWS - You can already use it without knowing about it

Abstract: This is story about we tried to do some data analysis for S3 logs, and found that AWS Athena allows to do it easy and fast using SQL queries. But for data analysis we need to have more powerful visualization tools - and Amazon Elastic Map Reduce (Hadoop as a Service) in fact are closely integrated with S3, Athena and other AWS services.
Deployed in 2 clicks, Apache Zeppelin can query your data directly from S3 file storage and works with data using SQL or Spark (Scala) if You are brave enough. We used all this stuff only for one reason - delete unused packages from Artifactory, which grows up to 3 Tb and became a little bit expensive to host in Cloud. But the issue was - ‘unused’ definition was little bit unclear, and some deep analysis need to be made to make a proper decision. Golang application helps us to retrieve data from Artifactory, and Zeppelin and Spark SQL queries allowed to filter and visualize corresponding data.

Speaker(s):

  • Sergey Dzyuban

Track and Room: Analytics and Visualization - Predslava2


Title: Hacking SQL Server

Abstract: 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 can be done to secure your SQL Server. If you are willing to see how small reconfiguration can lead to compromise of your SQL Server join this session. There will be demos on live system showing how to leverage misconfiguration and how to prevent them from happening in the future. After the session you will have a set of checks that can be implemented on your system.

Speaker(s):

  • Michal Sadowski

Track and Room: Enterprise Database Administration Deployment - Predslava1


Title: Power BI Premium vs Power BI Embedded for Modern BI Solutions

Abstract: Power BI Premium introduces a new developer layer for embedding Power BI in custom applications, and a new on-premises deployment option as well. Microsoft Power BI Embedded applications enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. It helps Independent Software Vendors to use Power BI data experiences within their applications. This talk is abou the best practices designing and implementing in business solutions Power BI Embeded and Power Bi Premium: which version to use and how to take the best advantage from different version and tier of Power BI, offered from Microsoft.

Speaker(s):

  • Mihail Mateev

Track and Room: BI Platform Architecture, Development Administration - Conference-Hall


Title: Securing, maintaining and troubleshooting your Azure SQL in production.

Abstract: Azure SQL usage seems to be easy and straightforward, but there are set of steps to make it truly reliable and properly secured. This talk is about following three important topics.

Are you ready for disaster, are your team take a proper drill? I`m sure you do, but in case you need a few tips and check list - you will obtain it. Usually, proper monitoring(including network impact), profiling and alerts are introduced after the first production issue, so this will be first point.

Security seems to be hot topic these days and there are few steps to secure your Elastic cluster proper way, plain Azure SQL Server firewall might be not enough. Security measures overview with best practices, vNet, user roles isolation, encryption at rest, secret maintenance with KeyVault, Security center and other tips.

Infrastructure as code is essential part of Azure and proper set of the environment crud scripts can really save your day at some point in future, also you can do useful stuff with T-SQL in

Speaker(s):

  • Stanislav Lebedenko

Track and Room: Cloud Application Development Deployment - Predslava1


Title: The SQL Server DBA’s Guide to Docker Containers

Abstract: Your role as a SQL Server DBA is evolving and you are now responsible for automating deployment, scaling and management of containerized applications – not just SQL Server databases. You don’t have a clue where and how to start. You are confused about this whole DevOps buzzword being thrown around and you are wasting a lot of time figuring things out on your own. What’s worse, you end up being a stressed, overworked engineer who wished you could focus on the “cool stuff”, but are instead stuck in firefighting mode while juggling the additional workload.

This session is specifically for you. This whole-day workshop is specifically designed for senior SQL Server database administrators and systems engineers responsible for automating deployment, scaling and management of containerized applications.

Learning Objectives: 1) Introduce SQL Server DBAs to the world of Docker Containers 2) Leverage Docker Containers for deploying SQL Server 3) Introduce SQL Server DBAs to Container Or

Speaker(s):

  • Edwin M Sarmiento

Track and Room: Enterprise Database Administration Deployment - RoomA


Title: The databases in SSDT - a work with project and best practices

Abstract: A task seems to be easy. Maintenance a project of a database in the code repository, treat as master-version and do deployment evenly and frequently. Simple? Seemingly. The things become more complex as fast as a number of objects in database growing. While instead of one database, we have over a dozen. When databases have got the references to each other. And how about dictionary tables? Where to keep them and how to script? Additional issues are coming whilst we would like to control instance-level objects. All these topics I will explain in the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.

Speaker(s):

  • Kamil Nowinski

Track and Room: Application Database Development - Room AC


Title: The future of serverless computing

Abstract: Are you still planning your servers capacity in CPU and RAM? Do you enjoy answering questions like “what amount of servers we need to buy to serve 10K and 10M users”? Do you enjoy paying for those servers while they are sitting idle?

In my session I will talk about the current state and the future of serverless computing. I will show several demos that show how to start using serverless computing, what are the application scenarios for it, how it can scale, what it will cost, etc.

This session will be useful for developers and architects who are seeking a way to create an app utilizing all your previous skills, but make it scalable, reliable, fast and cost efficient.

Speaker(s):

  • Anton Boyko

Track and Room: Cloud Application Development Deployment - Predslava1


Title: How to win Kaggle competition and get familiar with machine learning ?

Abstract: Have you heard that knowing machine learning is the easiest way to get rich quickly? Let’s test this statement. Kaggle is the place to do data science projects, why not to start there? During this session we will solve simple Kaggle competition. Actually, we will submit two solutions. The first made with super-duper deep neural network (black-box approach). Then we will follow proven ML methodologies and solve the problem methodically. All that using SQL Server Machine Learning Services. Minimum slides and maximum fun guaranteed.

Speaker(s):

  • Marcin Szeliga

Track and Room: Advanced Analysis Techniques - Congress-Hall


Title: Power BI. Evaluation context in DAX.

Abstract: В докладе Я попытаюсь раскрыть тему контекста в DAX, объяснить сложности и преимущества использования этого языка.

Speaker(s):

  • Artur Konstantynov

Track and Room: Analytics and Visualization - Predslava2


Title: Streaming Big Data in Azure with Kafka and Event Hubs

Abstract: Before having Big data, you must collect the data. During this session, we will see how to stream the data using Kafka and Azure Event hub, how they work together, and when to use Kafka better or Event hub.

Speaker(s):

  • Sergii Bielskyi

Track and Room: Cloud Application Development Deployment - Room AC


Title: Tuning SQL Server for mere mortals (українською)

Abstract: Are you new begining database developer ? Are you .Net developer and often work with database? I think this session special for you! In this session I would like to show common mistakes, connected with DB development which I saw in my projects and tell audience how we could avoid it . How we can improve performance of SQL Server.

Speaker(s):

  • Mykola Pobyivovk

Track and Room: Application Database Development - Predslava2


Title: MS SQLServer 2019 Intelligent Query Processing

Abstract: The Intelligent query processing feature family includes features with broad impact that improve the performance of existing workloads with minimal implementation effort.

Speaker(s):

  • Andrii Zrobok

Track and Room: Application Database Development - Congress-Hall


Title: Building BI solution with AWS vs Google Cloud

Abstract: Building a BI solution for a travel platform using AWS … Or Google Cloud … Or both .. Or custom services? Will share the experience of using different infrastructures and the overview of the tools for both

Speaker(s):

  • Maryna Popova

Track and Room: BI Platform Architecture, Development Administration - Congress-Hall


Title: SQL Server PowerShell. How to become a true senior DBA (на русском)

Abstract: В этом докладе я расскажу об автоматизации административных задач с помощью PowerShell. Затрону некоторые community решения и их имплементацию.

Speaker(s):

  • Andriy Pogorelov

Track and Room: Enterprise Database Administration Deployment - Conference-Hall


Title: Blockchain as service - Azure Blockchain Workbench

Abstract: What is Blockchain as Service? This session is more about Blockchain basics and the technical details of the Azure Workbench. With Blockchain Workbench, you can define blockchain applications using configuration and writing smart contract code. You can jumpstart blockchain application development and focus on defining your contract and writing business logic instead of building scaffolding and setting up supporting services.

Speaker(s):

  • Senthamil V

Track and Room: Cloud Application Development Deployment - Room AC


Title: Oracle APEX

Abstract: This presentation provides a general overview of Oracle APEX. What is Oracle APEX? Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. Are you an existing Oracle Database customer? Then you have everything you need to start building useful, scalable apps now using Oracle APEX. If you know even a little bit of SQL, you can become wonderfully productive and start producing apps that you would have thought required a full-stack developer.

Speaker(s):

  • Oleksii Vykhristiyk

Track and Room: Application Database Development - Predslava2


Title: Working in Batches

Abstract: Early in your career you learnt that loops are bad and that you should use set-based statements. However, there are situations when trying to processing all at once takes you into problems. In this session we will learn what these situations are and how we can address them by splitting up the work in batches. We will learn techniques for batching and pitfalls to watch out for so that we don’t introduce new performance issues.

We will also look at batching from a different angle: problems that requires a loop for, say, a single customer, but where we can process all customers abreast for better performance.

Speaker(s):

  • Erland Sommarskog

Track and Room: Application Database Development - Congress-Hall


Title: Be a dynamic SQL dynamo!

Abstract: This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.

Speaker(s):

  • Joanna Wolthuis

Track and Room: Application Database Development - Conference-Hall


Title: Introduction to Polybase

Abstract: Polybase started as a technology which allows you to query data stored in Hadoop or Azure Blob Storage as if it were just another table within SQL Server. In SQL ‘Aris’ (2019), Polybase will grow further and add additional connectivity and querying potential.

Come to this Beginner talk to learn how you can get started using Polybase in SQL Server right away, and learn about the 3 core EXTERNAL objects used in Polybase. We will compare and contrast the differences and similarities between Polybase and Linked Servers.

Speaker(s):

  • Paul Wehland

Track and Room: Enterprise Database Administration Deployment - Room AC


Title: “SQL-like” or query languages in Azure IoT

Abstract: If you are reading Azure IoT documentation you will stumble a lot on the “SQL-like query language” or “SQL-like language” syntagms. In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero. We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle. So, we will leave no SQL query unturned in Azure IoT Hub, Stream Analytics, Power Bi to name a few.

Speaker(s):

  • Catalin Gheorghiu

Track and Room: Cloud Application Development Deployment - Conference-Hall


Title: SQL Server 2019 Kubernetes: Cloud Native Development for Enterp

Abstract: We will start from understanding what is Cloud Native development and why it is actual for Enterprise Digital Transformation Strategy. Will cover different aspects of using Relational Databases on Kubernetes platform and deployments to Public Clouds. Then dive into details of using SQL Server as a containerized application orchestrated by Kubernetes and discuss proc and cons for such solutions. The session contains results of researches, live demos and experience gained from numbers of projects.

Speaker(s):

  • Vitalii Bondarenko

Track and Room: Strategy and Architecture - Predslava1


Title: Hacking SQL Server Is Not Enough

Abstract: You already know how easy it is to hack SQL Server… But how do you protect your local and cloud servers against enemy agent attacks? This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.

Speaker(s):

  • André Melancia

Track and Room: Enterprise Database Administration Deployment - Congress-Hall


Title: Attention Contention!!!

Abstract: 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 and in Azure Managed Instance: - Theoretical, to understand what and why it occurs. - Practical, with examples causing it, offering alternatives to solve it and to prevent it.

Speaker(s):

  • Jose Manuel Jurado Diaz

Track and Room: Enterprise Database Administration Deployment - Room AC


Title: Anomaly Detection in Predictive Maintenance for Sql Server

Abstract: 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 is, provides common use cases and gives practical examples that help to avoid costly Sql Server disruptions and eliminate firefighting. Presented solution addresses limitations of Query Store and automates the identification and resolution of common performance issues.

Speaker(s):

  • Janusz Rokicki

Track and Room: Enterprise Database Administration Deployment - Room AC


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

Vitalii Bondarenko

I’ve been designing data-centric systems for last 20 years and have gained huge experience in developing BI, AI and Big Data solutions. For the last 5 years I’ve mostly been focused on enterprise platform designing and implementing different innovative approaches for Fast Data Processing. At the moment I’m responsible for building Processional Services in Cloud Solutions for Enterprise Customers.

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

Edwin M Sarmiento

Twitter: - EdwinMSarmiento

LinkedIn: Edwin M Sarmiento

Contact: http://www.EdwinMSarmiento.com

Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

Paul Wehland

Twitter: - @pwehland1433

LinkedIn: Paul Wehland

Paul Wehland has worked with SQL Server for a VERY long time and has supported customers on every version all the way back to v1 (16 bit). Paul is one of only 130 SQL Server Certified Masters (SQL-MCM) worldwide. He is a Director in the Data Analytics service line at Avanade (joint venture between Microsoft and Accenture) supporting customers running very large and complex Data Estates. Before Avanade, Paul worked at Microsoft in the SQL Server Product Group on many teams (QA-Performance, SQLCAT, SQL Clustering to name a few). Prior to the SQL Product Group, Paul started in SQL-Product Support (PSS), where he co-founded the SQL Server MVP program, which he never imagined it would grow so large! Paul is based in Germany, but originally from the United States.

Erland Sommarskog

Contact: http://www.sommarskog.se

Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

Michal Sadowski

Twitter: - SadowskiMichal

LinkedIn: Michal Sadowski

Contact: https://sqlplayer.net/michal-sadowski

Senior Database Platform Engineer, leader of Krakow chapter of Data Community Krakow (former Polish SQL Server User Group) - PASS Chapter. With more than 10 years of experience in Microsoft technology, helps in advisory for performance optimization on database and application levels. Active speaker on SQL Server related events like SQLSaturday, SQLDay, MCT Global Summit etc. Holds many Microsoft certificates including MCSE: Data Platform, MCSA: SQL Server 2012/2014/2016, MCSA: Windows Server 2008/2012/2016 and MCT.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

Anton Boyko

Twitter: - https://twitter.com/BoykoAnt

LinkedIn: Anton Boyko

Founder and main speaker at Ukrainian Microsoft Azure Community. 15+ years in application development. Builds apps based on Microsoft Azure platform since 2011. Microsoft Azure technical expert. Microsoft Azure MVP since 2014. Owner and one of the organizers of the most popular Microsoft Azure conferences in Ukraine: Azure Day and Global Azure Bootcamp.

Taras Kloba

Twitter: - klioba

LinkedIn: Taras Kloba

Contact: http://sql.ua

✅ Senior DBA and developer; ✅ Senior database architect; ✅ Business solutions expert; ✅ 9+ years of experience.

Senior database administrator and programmer. Consultant and certified database administrator and developer with 9+ years of experience working with SQL Server 2016, 2014, 2012, 2008, 2005, 2000 and SQL Azure. MySQL, PostgreSQL and MS SQL database performance tuning expert. Business solutions consultant and implementer. With many years of extensive experience in the IT and other business industries in a variety of roles. My objective is to use my experience to bring creative and top-level solutions to businesses that require SQL Databases.

Janusz Rokicki

Twitter: - DataSic

LinkedIn: Janusz Rokicki

Contact: https://www.datasic.com/

Microsoft Data Platform Expert and certified Azure Solutions Architect with over 12 years’ experience working in the City of London in the Financial Services Industry (retail and investment banking, multi-asset class trading systems). He has passion for secure, high-performance, maintainable data-driven applications that can be deployed with confidence on-premises and in-cloud. With educational background in intelligent sensor networks and machine learning he is always in search of automation and optimisation opportunities.

Has presented at SqlBits, PASS Summit, SqlDay and multiple SQLSaturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.

Stanislav Lebedenko

LinkedIn: Stanislav Lebedenko

I have overall 11+ years of experience working as software developer. Broad experience with .NET Back-end projects and Databases, Azure expertise with wide variety of services, security and optimization of existing infrastructure.

Oleksii Vykhristiyk

Twitter: - https://twitter.com/avhrst

LinkedIn: Oleksii Vykhristiyk

Founder and CEO of APEXREST, which for more than 10 years has been successfully implementing solutions for enterprises and businesses. We have strong skills and extensive experience in developing ERP and CRM systems.

Such brands as Megasport, Letyshops, Kernel use the services of our company.

I am an Oracle APEX developer with over 10 years experience in this field. I take the main part in the development of Oracle APEX community in Ukraine..

Author of several training courses and seminars. I participated in the international projects of Oracle APEX in the world. Personally acquainted with the major developers of Oracle APEX in the world and senior director of software development at Oracle APEX at Oracle America, Inc.

Maryna Popova

I am a Big Data Engineer in a BI team. I have around 4 years of professional expertise in the Information Technologies industry, mainly all around data Engineering and Data Warehousing. I am working on my 3rd BI Project now. All of them are in different business areas and are using different technologies. What is common between them is the willingness to find the most proper development methodology as it is not a canonical development team and no development methodology works “out of the box” . In my talk I would like to share my experience in this area.

Mykola Pobyivovk

Contact: https://www.facebook.com/nick.pobiyvovk

Mykola Pobyivovk is a senior Database developer, Tech Lead at Ciklum. He has about 10 years experience in IT industry. He has been working with SQL Server since 2010. He is co-orginizer of events SQLSaturday Kyiv 2016, 2017, 2018 and Ukraine Data Community Kyiv. In his talk he would like to share his experience connected with develpment of DataBase.

Andriy Pogorelov

LinkedIn: Andriy Pogorelov

I have been dealing with database administration and development for more than 16 years. Started from SQL Server 2000

  • Active member of Data Platform community
  • Organizer of SQLSaturday Kharkiv
  • Speaker at various Data Platform related events
  • I possess Microsoft certificates: MCDBA, MCITP, MCSA.

Andrii Zrobok

LinkedIn: Andrii Zrobok

25+ years of experience in database development: development data-centric applications from scratch, support of legacy databases/applications, data migration tasks, performance tuning, consulting, database trainer. I have experience with wide range of databases such as FoxPro for DOS (Fox Software), MS SQL Server (started from version 6.5) , Oracle, Sybase ASE, MySQL, PostgreSQL. Co-Leader of PASS Local Chapter in Lviv. Speaker at PASS SQLSaturday conferences (since 2013); PASS Lviv/Vinnitsa/Virtual SQL Server User Group, EPAM IT Week (2015-2017), AIBig Data Day 2019.

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

Catalin Gheorghiu

Twitter: - MrSmersh

LinkedIn: Catalin Gheorghiu

Contact: http://ronua.ro/author/catalin/

Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.

Joanna Wolthuis

Twitter: - ochthenoodle

LinkedIn: Joanna Wolthuis

Joanna Wolthuis is an independent contractor specialising in T-SQL database development and reporting using SSRS and Excel based solutions for the last 8 years. She is passionate about data and learning everything about anything. Aside from SQL Joanna enjoys traveling, nice food and attempting to be an acrobat (not at the same time!).

Jose Manuel Jurado Diaz

Twitter: - jmjuradodiaz

LinkedIn: Jose Manuel Jurado Diaz

José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 20+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events such as SQLSaturday, SQL Nexus, SQLBits, Pass Summit, SQL Server Konferenze, TechReady, DotNetConference, and Azure BootCamp. In the past, he worked as Project Manager for large global retail company for more than 10 years developing projects using different Microsoft Technologies.

Senthamil V

Twitter: - @altfo

Contact: https://msisgreat.net

Microsoft MVP on Windows Development. SharePoint is my profession and Windows Dev is my Passion

Kamil Nowinski

Twitter: - @NowinskiK

LinkedIn: Kamil Nowinski

Contact: https://sqlplayer.net

Blogger, speaker, #sqlfamily member. Microsoft Data Platform MVP. Data passionate, Data engineer and Architect. Over 13 years of programming and experience with SQL Server databases, he worked both as developer and administrator big databases designing systems from the scratch. Passionate about tuning database engines, code transparency and maximising performance database engine. Currently, he is expanding new horizons as a contractor in the UK market, making troubleshooting, prototyping BI and Big Data solutions, enhancing existing processes among Microsoft stuff environments, popularizing the DevOps approach and efficient solutions in the cloud. An originator of the “Ask SQL Family” podcast and founder of SQLPlayer blog.

Marcin Szeliga

LinkedIn: Marcin Szeliga

Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.

Jose Manuel Jurado Diaz

Twitter: - jmjuradodiaz

LinkedIn: Jose Manuel Jurado Diaz

José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 20+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events such as SQLSaturday, SQL Nexus, SQLBits, Pass Summit, SQL Server Konferenze, TechReady, DotNetConference, and Azure BootCamp. In the past, he worked as Project Manager for large global retail company for more than 10 years developing projects using different Microsoft Technologies.

Artur Konstantynov

Power BI developer

Torsten Strauss

Torsten Strauß (MVP, MCSE Data Platform, MCSE Data Management and Analytics, MCT) has been working with Microsoft SQL Server since the turn of the millennium. He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as Principal Consultant for Sarpedon Quality Lab. Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups in recent years.

Sergey Dzyuban

LinkedIn: Sergey Dzyuban

Having more than 10 years of .NET Framework experience, building cloud solutions on AWS and Azure platforms. Perhaps was involved in cloud development, move focus from .Net and Windows to Unix and Java. For some time worked as DevOps Technical lead and build DevOps team from the scratch. Now works as DevOps Engineer in AWS and Google Cloud platforms.

Sergii Bielskyi

Twitter: - https://twitter.com/sergey_belskiy

LinkedIn: Sergii Bielskyi

Contact: https://medium.com/@sergiibielskyi

A multi-skilled expert with comprehensive experience of designing, developing and deploying Cloud and Hybrid architectures and infrastructure for software applications. Having over 10 years of IT experience Azure and SharePoint infrastructures. Possessing a proven ability to lead project teams to successfully deliver agreed upon solutions of the highest quality, often in complex and challenging customer environments. He has managed SharePoint Competence Center working in MS partner company. He organizes events in the community group, writes articles in the blog, participates in the conference as a speaker. He leads of Ukrainian IoT and SharePoint Community. He was a speaker at such conferences as TechEd Russia, Local community, SQLSaturday

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page