Event Location:
Hotel President
12 Hospitalna street
, , Ukraine
Abstract:
Hierarchies are the bread and butter of most business applications and you find them almost everywhere: * Product Categories * Sales Territories * Bill of Material * Calendar and Time Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 comes now with a different approach: Graph Database. Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker(s): Markus Ehrenmueller-Jensen,
Abstract:
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 right dataset for them. Time from raw data to insights is too long. In this session, I invite you together look closer at Self-Service Data Prep and show how it would help to get insights and make decisions faster, onboard new data sources without IT, and increase efficiency for data analysts and data scientists.
Speaker(s): Sergiy Lunyakin,
Abstract:
So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements. You will learn: - Common design patterns and guidelines that you need to consider when building your architecture - Proper selection of quorum configuration - Network configuration for local and geographically dispersed replicas - Combining SQL Server Failover Clustering with AlwaysOn Availability Groups
Speaker(s): Edwin M Sarmiento,
Abstract:
Or how to visualize your data and find insights for beginner IoT developer If you create an IoT solution today, you have a variety of components available to mix and match to make your solution, akin LEGO. You get your hardware and firmware right and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast, and of course you would like to learn something from that data easy and fast. And it would be nice to have the results available on mobile devices, yes, yes easy and fast. Now enter our two titan technologies in a match to the death oops data trying to achieve these goals, you guess it easy fast (and cheap). And we will see them clash, from real hardware, to the big Azure cloud, to mobile devices, trying to outmatch each other.
Speaker(s): Catalin Gheorghiu,
Abstract:
Clustered Index zombies come out of their graves to make the peace loving Heaps to one of them in your databases. Try to attack them or find a fair way to make them living together in peaceful harmony. If you ask experts about using a clustered index you will in most cases hear the following statements: Yes, you need a narrow and contiguous clustered index for your table for good performance. Last but not least Microsoft Azure Databases requires clustered indexes but there might be situations when workloads and queries will suffer from wrong implemented clustered indexes. Watch the demos which show in an impressive way that clustered indexes are not always the best choice. Build your clustered indexes wise or - as the demos will show - forgo for it for a better scaling. Become aware of the pros and cons of Clustered Indexes and make a wise decision when to use clustered indexes and the correct key attributes for it.
Speaker(s): Uwe Ricken,
Abstract:
What is DevOps and why should you rub it on anything? In this session we'll explore, through demo's, how a DevOps mindset changed my personal way of working and development of database and BI solutions. We'll shortly discuss what this actually means and in the demo's you'll see how to automate the deployment of your own databases, SSIS, SSRS and SSAS projects. On top of that, you'll experience the simple patterns and how to overcome blockers so you too can finally start to automate the deployment of just about anything.
Speaker(s): Jan Mulkens,
Abstract:
We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise. This session consists of: -> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. -> Best Practices and best tools for our migration process depending on the platform chosen. -> After the migration, we have several outstanding questions: Can I keep both environments synchronized? How is the performance of my database?
Speaker(s): Jose Manuel Jurado Diaz,
Abstract:
Microsoft SQL Server is running in Windows Server Operating system, however, most of the OS Administrators treats SQL Server just like another basic application. On the session, I will show how steps taken before actual installation of SQL Server can impact performance. The session is a walk through on all of the layers starting on hardware, virtualization (if used), Operating System and finally SQL Server. After the session, you will have set of best practices that can be applied to your environment.
Speaker(s): Michal Sadowski,
Abstract:
In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker(s): Satya Jayanty,
Abstract:
Solving problem with performance for SSRS using internal and external tools. SSRS logs, HTTP logs, Performance counters. impact of the solution design on SSRS performance. The best practice and recommendations for the SSRS deployment
Speaker(s): Alexander Kalenik,
Abstract:
We will start with understanding of several typical architectures of migration to Cloud Enterprise Infrastructure. Than go deeper to internal of Cosmos DB and Spark on HDInsight as main components of Fast Data Processing and Big Data Analytic. We will also cover several approaches for building scalable BI solutions in Azure Cloud using Hadoop and Kafka. The presentation has lots of demos and samples from real projects.
Speaker(s): Vitalii Bondarenko,
Abstract:
How to design secure solutions that use Azure Sql Database, Datawarehouse and Cosmos DB. Session covers security assessment and risk management of public cloud and specifically focuses on Azure Sql PaaS. That includes common network topologies with their strengths and weaknesses, blueprints and recommendations for hybrid and cloud-only solutions. In addition it talks about cloud-first, and in some cases cloud-only, tools like Vulnerability Assessment, Threat Detection, Log Analytics and OMS.
Speaker(s): Janusz Rokicki,
Abstract:
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 making the right choices? In this talk we will discuss how we can go about choosing the right database models for your application. We will also look at how the choice of data models can help determine which technologies to include in your data tier.
Speaker(s): Mihail Mateev,
Abstract:
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 even if you learned this at a university. Please note that this is theoretical session, using a bit of logic and a bit of mathematics.
Speaker(s): Dejan Sarka,
Abstract:
This session is Intro to AWS Redshift. Will give the overview of the architecture and important details
Speaker(s): Maryna Popova,
Abstract:
The backups are kind of an insurance policy for an administrators around the World. In case of the database administrator's work it is even more important as they take care of really important data. In this session we will see a different kinds of backups available in the Microsoft SQL Server and multiple ways to configure an automated tasks. In the end we will see how to restore the backups we have taken in different scenarios (point in time restores, partial restores, etc).
Speaker(s): Michał Bronowski,
Abstract:
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 that the best way to run a loop in most cases is exactly a cursor, provided that it is implemented properly. I will also gives some tips how you can troubleshoot performance problems with loops and what pitfalls you need to avoid.
Speaker(s): Erland Sommarskog,
Abstract:
Everything in life can be hacked… Even SQL Server… Don't believe me? See for yourself… 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,
Abstract:
Подробно рассмотрим важнейший компонент базы данных - лог транзакций. Для чего он нужен, в каких процессах участвует. Облако затрагиваемых терминов: Backup, Recovery, Shrink, VLF, Replication, AlwaysOn, CDC, Best Practices.
Speaker(s): Andriy Pogorelov,
Abstract:
Understanding SQL Server Memory Grant. All about memory grant. How it works, where comes from, why is so important to look at this part of SQL Server.
Speaker(s): Alexander Bereznev,
Abstract:
This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal Tables and building views.
Speaker(s): Reinhard Flügel,
Abstract:
До 2016 версії Microsoft практично не вносив кардинальних змін в оптимізатор запитів. Таким чином движок з 7 версії (1988 рік) використовувавя з косметичними змінами без малого 20 років. В 2016 версії були анансовані певні напрямки змін, котрі повноцінно запрацювали в 2017 версії. Це Batch Mode Adaptive Query Processing, Query Store Automatic Query Tunig. Ці зміни і будуть розглянуті в презентації.
Speaker(s): Andrii Zrobok,
Abstract:
Moving your data warehouse to the cloud? In this session we will go through the consideration and components for data warehousing in the cloud and how these are used and integrated - and when to use which services when looking at: - Data movement/migration - Data storage - Transformation - Scheduling - Deployment approach and methods Second part of the session will focus on the differences and benefits of different approaches ( On-premises, IaaS, PaaS) the following perspectives to undertand and consider the right approach: - Pricing - Scalability - Flexibility - Strategic considerations
Speaker(s): Bent Pedersen,
Abstract:
Migrating existing BI workloads to Cloud is not an easy task. IaaS, PaaS, networking, security - this can be overwhelming. During the session I will describe some of learnings from own real-world experiences, design mistakes and how to avoid them. Hopefully they will be helpful in your own journey from on-prem servers to Azure Analysis Services and Data Factory world!
Speaker(s): Wlodek Bielski,
Abstract:
Azure Data Factory v2 is the new version of ADF. This version has the power of the first version and is more flexibility and new opportunities. First, we can use SSIS packages in our data factory, second, we have more opportunities for security our data and etc. If you want to know more just come to my session and I'll speak you about it
Speaker(s): Eugene Polonichko,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/alexander-bereznev-84ab18128/
Contact: https://www.youtube.com/channel/UCDO8HyTKkg5zPiLsMEfeCMA/videos
I am working at Microsoft more that 7 years. My main focus is SQL Server tuning, query performance and disaster recovery.
LinkedIn: https://www.linkedin.com/in/jrokicki/
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 Sql Saturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.
LinkedIn: https://www.linkedin.com/in/markus-ehrenmueller/
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
LinkedIn: http://ca.linkedin.com/in/edwinmsarmiento
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.
LinkedIn: https://www.linkedin.com/in/wlodekbielski
Wlodek Bielski is an experienced BI architect and consultant, based in Warsaw. He gained most of his experience in data warehousing and BI while working for large international customers, mainly in FMCG and E-Commerce sectors. Wlodek closely follows the latest developments in Advanced Analytics, including Cloud-based BI and Data Science. Wlodek holds his Master’s degree in Computer Science from University of Wroclaw.
LinkedIn: https://dk.linkedin.com/in/bentnissenpedersen
Contact: http://www.biblog.eu
Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.
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.
LinkedIn: http://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1
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.
LinkedIn: ?https://ro.linkedin.com/in/catalingheorghiu?
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.
LinkedIn: https://www.linkedin.com/in/slunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
Started as an application developer in the early 90’s using C++, Access and SQL-Server. Since around 2010 focusing on Database Development mainly SQL-Server. Holding several Microsoft certifications such as: MCSE Data Platform, Business Intelligence and Data Management and Analytics (Charter).
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.
LinkedIn: https://uk.linkedin.com/sqlmaster
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
LinkedIn: https://www.linkedin.com/in/azrobok/
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.
Contact: http://leopard.in.ua
Ruby on Rails разработчик и Linux администратор в компании Railsware. Является автором таких продуктов как: PopCornUA, MongodbLogger, SmtRails, PIRO, Webp-ffi, Zopfli-ffi и многих других. Алексей является автором открытого учебного пособия по PostgreSQL на русском языке и по Chef на английском языке. Активный докладчик в различных IT конференциях.
LinkedIn: https://pl.linkedin.com/mikeybronowski
Data enthusiast with mathematics background in relation with SQL Server for over 10 years. Works as a database administrator (Microsoft SQL Server) responsible for environments upgrades and migrations. Holds certificates MCP, MCSE Data Platform. The Data Community (polish chapter of PASS Chapter) active member and attendee of various data conferences. Sometimes teaches math and Microsoft Excel. When not working or teaching learns new things. Italian calcio fan and traveler.
LinkedIn: http://LinkedIn.COM/in/AndreMelancia
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...
LinkedIn: https://www.linkedin.com/in/jose-manuel-jurado-diaz-5a586014/
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.
LinkedIn: https://ua.linkedin.com/in/pogorelovandrey
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.
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
LinkedIn: https://www.linkedin.com/in/janmulkens
Contact: http://www.janmulkens.be
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
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.
LinkedIn: https://www.linkedin.com/in/alexander-kalenik-898714128/
Contact: http://www.datainternals.ru
Senior field engineer in Microsoft. Working 12 years.
LinkedIn: https://www.linkedin.com/in/eugenepolonichko/
Contact: https://msolapblog.wordpress.com/
Leader of PASS Local Chapter in Donetsk (Ukraine). I work as DWH/BI architect. Responsible for designing and developing Data Warehouse and BI solutions with using Microsoft BI Stack products.
LinkedIn: http://www.linkedin.com/profile/view?id=270775013amp;trk=tab_pro
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
LinkedIn: https://pl.linkedin.com/pub/michal-sadowski/4/b33/717
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.
The following is a list of sponsors that helped fund the event.