SQLSaturday #599 - Plovdiv 2017

Event Date: 05/27/2017 00:00:00

Event Location:

  • Culture Centre “Boris Hristov”
  • 15 Gladston Str., 4000 Plovdiv, Bulgaria
  • Plovdiv, Plovdiv, Bulgaria

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: Continuous Integration and the Data Warehouse [EN]

Abstract: Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects. In particular, the session will cover:

  • Setting up SQL Server Data Tools for automated deployments: DAC Publish profiles SQLPackage.exe

  • Automating your build and deployments with PowerShell and psake

  • Guide to configuring TeamCity as your build server

  • Automated Integration and Regression testing of your Data Warehouse using various test frameworks

  • Overcoming issues with cube and tabular model deployment

Speaker(s):

  • John Tunnicliffe

Track and Room: BI Platform Architecture, Development Administration - Room C


Title: A Game of Hierarchies: Mastering Recursive Queries

Abstract: Hierarchies are the bread and butter of most business applications and you find them almost everywhere:

  • Product Categories
  • Sales Territories
  • Calendar and Time Even when there is a big need from a business perspective, the solutions in relational databases are still sort of awkward. The most flexible hierarchies are 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. You will learn how to master both and will learn how make them fast. 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

Track and Room: Application Database Development - Room B


Title: Enabling Citizen Data Science with Microsoft

Abstract: In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.

Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure.

These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about fools-with-tools or should we embrace the democratization of data science as the golden age of data?

Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.

Speaker(s):

  • Jan Mulkens

Track and Room: BI Platform Architecture, Development Administration - Room B


Title: Azure SQL Datawarehouse: 0-100 DWUs

Abstract: So, with much fanfare and cheering, Azure DataWarehouse is now live, but what does that mean to you? Reflecting on a large-scale Azure DW project, this session gathers together learnings, successes, failures and general opinions into a crash course in using Azure DataWarehouse “properly”.

We’ll start by quickly putting the technology in context, so you know WHEN to use it, WHERE it’s appropriate and WHY it works the way it does.

  • Introducing the ADW technology
  • Explaining distributions performance
  • Explaining polybase

We will then dive into HOW to use it, looking at some real-life design patterns, best practice and some “tales from the trenches” from a recent large Azure DW project.

  • Performance tips tricks (designing for minimal data movement, managing distribution skew, CTAS, Resource classes and more)
  • ETL Patterns (Surrogate keys Orchestration)
  • Common Mistakes Pitfalls
  • Conclusions Recommendations

Speaker(s):

  • Simon Whiteley

Track and Room: BI Platform Architecture, Development Administration - Room D


Title: SSIS Common Design Patterns, Tips Tricks

Abstract: SSIS is a fantastic tool and now well established as the go-to tool for performing on premise ETL and data movement within the Data Warehouse environment. Whether you’re an experienced developer or starting your career as a data professional the fundamentals of a good ETL design are an essential building block of the data warehouse environment which cannot be overlooked.

In this talk Jon provides an introduction to common design patterns used in SSIS to tackle typical ETL scenarios as well as providing insight and tips on how you can use SSIS to realise it’s full potential.

The talk will focus on the following patterns:

  • How to orchestrate a successful ETL loading routine using SSIS
  • Applying effective logging during loads
  • Flat file loading
  • Incremental loading patterns
  • Dimension loading
  • Fact table loading

Speaker(s):

  • Jonathon Eve-O’Connor

Track and Room: BI Platform Architecture, Development Administration - Room D


Title: Problem Solving With The In-Memory Engine

Abstract: There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:

  • Staging data as fast as possible
  • Turbo charging scalar aggregate functions
  • Implementing a scalable sequence
  • Overcoming the performance limitations of temporary tables
  • Making the critical path in your code base run faster

Speaker(s):

  • Christopher Adkin

Track and Room: Enterprise Database Administration Deployment - Room C


Title: Exploring Dark Data with SQL Server 2016 and R

Abstract: With the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data.

In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016.

This session is for anyone who is new to R and is interested in expanding their skill set beyond their comfort zone in SQL Server.

Speaker(s):

  • Oliver Frost

Track and Room: Application Database Development - Room A


Title: Hacking SQL Server

Abstract: How easy is it to hack a SQL Server? In this session we’ll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We’ll start by gaining access to a SQL Server (using some “creative” ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. Most importantly, we’ll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants.

Speaker(s):

  • André Melancia

Track and Room: Enterprise Database Administration Deployment - Room A


Title: Azure SQL Database - the cloud awakens

Abstract: There has been an awakening. SQL Database in Azure is no longer merely useful tool, but essential for your continued innovation. This session outlines the offerings available in SQL Database in Azure and how to move your database loads away from virtual machines and towards SQL Database, as well as gives a glimpse of the astounding force multipliers inherent in the Azure cloud. May the cloud be with you – always.

Speaker(s):

  • Alexander Arvidsson

Track and Room: Enterprise Database Administration Deployment - Room D


Title: Creating Custom BI Solutions with Power BI Embedded

Abstract: Microsoft Power BI Embedded is a Microsoft Azure that 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. Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded don’t need to have a Power BI account or to know anything about this Azure service. This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.

Speaker(s):

  • Mihail Mateev

Track and Room: Cloud Application Development Deployment - Room C


Title: Geocoding with SQL Server, Bing and Google Maps API

Abstract: Geocoding is the process of converting addresses into geographic coordinates (latitude and longitude). Geographic coordinates can then be converted into SQL Server spatial data type and stored in a database. In this session we will learn:

  • how to retrieve coordinates from an address, using Google Maps API and Bing API;
  • how to get a free license from API services;
  • how to automate the process and convert coordinates into a geography data type using SQL Server Integration Services;
  • how to store the data into a database;
  • how to perform calculation on spatial data;
  • how to represent data on a map using Reporting Services and Power BI.

Speaker(s):

  • Andrea Martorana Tusa

Track and Room: Analytics and Visualization - Room A


Title: Embrace the future: Running SQL Server in containers

Abstract: Well, the future is now. Join me in demo heavy session covering SQL server running in containers. Starting from scratch we will go through a complete container implementation.

Speaker(s):

  • Kaloyan Kosev

Track and Room: Enterprise Database Administration Deployment - Room C


Title: SQL Server 2016: New and improved features in SQL Server Integration Services

Abstract: At last SQL Server Integration Services (SSIS) introduces new capabilities so that you can add SSISDB to an AlwaysOn Availability Group; The Incremental Package Deployment feature allows you to deploy one or more packages to an existing or new project without deploying the whole project; Upgrading SSIS projects from previous to the current version, the project-level connection managers will continue to work as usual and the package layout/annotations are retained. In this session we will explore these new/improved features of SSIS to evaluate new benefits.

Speaker(s):

  • Gilberto Zampatti

Track and Room: BI Platform Architecture, Development Administration - Room B


Title: Azure Data Factory. Ingest,prepare, transform and publish your data

Abstract: Data Factory is a cloud-based data integration service that orchestrates and automates the movement and transformation of data. You can create data integration solutions using the Data Factory service that can ingest data from various data stores, transform/process the data, and publish result data to the data stores. Cool. What is it? It is cloudy ETL? Really? Why can’t I used SSIS? What is the difference between SSIS and Azure DataFactory? So come to my session and I can answer all question about Azure Data Factory.

Speaker(s):

  • Eugene Polonichko

Track and Room: BI Platform Architecture, Development Administration - Room D


Title: Running MSSQL on Mac OS - Mission Possible

Abstract: Recently Microsoft has released SQL Server 2016 for Linux. It features another option option to run MSSQL on Mac OS using Docker. Probably, you would never choose this option for your production environment but it is a good opportunity for all Mac fans to have a working database running on their MacBooks. In this session we will go through all options to run SQL Server on Mac OS and what development tools are available to connect and use your database. The session will include a live demo, so you will be able to see step by step the installation process and how you can connect and use the database.

Speaker(s):

  • Miroslav Lessev

Track and Room: Enterprise Database Administration Deployment - Room C


Title: CSI: Database

Abstract: An elite team of forensic experts investigates a series of crimes against a set of databases. Join the team to help them to uncover the mysteries. Follow the clues to find these ruthless criminals and save innocent databases from being murdered.

Speaker(s):

  • Andrey Nikolov

Track and Room: Application Database Development - Room A


Title: SQL Server 2016: Improvements to In-Memory OLTP

Abstract: In-Memory OLTP has been significantly improved, so that this technology enable scaling to larger databases and higher throughput in order to support bigger workloads. Moreover, a number of limitations concerning tables and stored procedures have been removed to make it easier to migrate your applications to and leverage their benefits. In this session we will explore the new and enhanced features (like altering Memory-optimized Tables and Natively Compiled Stored Procedures, using Scalar UDF, supporting subqueries in Natively Complied Stored Procedures and more).

Speaker(s):

  • Gilberto Zampatti

Track and Room: Application Database Development - Room B


Title: SQL Server Collation: A small leak will sink a great ship

Abstract: The collation is one of the most misunderstood settings in SQL Server. But if you underestimate it, you could get into a lot of troubles. Attend this session to understand what the collation is. How could the collation impact the performance of your queries, linked servers or cross database queries. What are the good practices and how to cope with different collations? What kind of issues can be caused by unequal collations, what to be taken into account?

Speaker(s):

  • Iva Velkova

Track and Room: Application Database Development - Room C


Title: SQL Server Myths and Misconceptions

Abstract: SQL Server is full of misunderstood features and misnomers that could affect how it is operating and respectively our applications. If you do not want to be surprised in a bad way by some intended, but not widely known SQL functionalities, join me in this session where we will, in an entertaining way, examine some of the most common behaviors that you probably have not expected.

Speaker(s):

  • Miroslav Dimitrov

Track and Room: BI Platform Architecture, Development Administration - Room B


Title: Why TSQL was the language of the year!

Abstract: TSQL was voted best programming language in 2013, let’s explore why! In this session we will explore what make SQL such a fascinating language. We will do this by looking at a few real life problems and common design challenges.  What in particular will we look at? Well… Tally tables, CURSORS, hidden CURSORS, CTEs, Recursive CTE, Manual Pivot, TSQL Pivot, CROSS JOIN, CROSS APPLY, CORRELATED QUERIES, STUFF(), RANK(),GO, DENSE_RANK(),LAG(), LEAD(), ROW_NUMBER(), XML PATH, MOD %, STRING_AGG(), DBCC DROPCLEANBUFFERS, DBCC FREEPROCCACHE, STATISTICS IO TIME. (A bit of TSQL)

Speaker(s):

  • Terry McCann

Track and Room: Application Database Development - Room C


Title: Are your SQL Server indexes effective?

Abstract: Indexes are important! They can make your life easy, but they can be a huge performance killer. No matter your role - DBA or DEV, you need to design effective indexing strategy and most importantly - know if those indexes are really effective. SQL Server gives you number of possibilities to track the use of your indexes and suggest you new ones. But what else we need to be careful for? How to keep our SQL Server in proper index shape? Join me for this one-hour session where we will have real fun on indexes and I promise you, you will leave with plenty of ideas for improving your index environment!

Speaker(s):

  • Ivan Donev

Track and Room: Application Database Development - Room A


Title: Meta-Data Driven Tabular Modeling with TOM in SSAS

Abstract: Analysis Services 2016 uses JSON as a format to store the metadata of a model and you can change it with C# using TOM (Tabular Object Model). The new object model has a one-to-one mapping between physical entities in the database and objects in the model. This is very usefull if you need to add or change measures without redeploying the whole project to server. For example, you need to generate set of new measures every year or end users want to add measures themselves and so on. Using TOM and meta-data table you can automate this process and save tons of time. Join this session for learning how to implement this.

Speaker(s):

  • Sergiy Lunyakin

Track and Room: BI Platform Architecture, Development Administration - Room D


Title: Integrating schema-free data into the relational world

Abstract: Here, at SB-Tech we were able to combine both of the schema-free data into our main relation business production database. We do so by collaborating the technologies of all worlds together, using SQL Server, MongoDB and even MySQL all together. In this presentation I will share our topology and details on what we are doing in SB-Tech.

Speaker(s):

  • Ezra Levi

Track and Room: Strategy and Architecture - Room A


Title: SQL 2 Go

Abstract: Take your SQL server in a nicely packed container and scale at will. “Cloud” it up and enjoy the taste of freedom

Speaker(s):

  • Valio Bonev

Track and Room: Cloud Application Development Deployment - Room B


Title: From the start to the end of a Performance battle (a story from real life)

Abstract: Performance problems are most often than not happen in SQL Server. Come to this session to hear real stories from the field and to see where to start when a problem occurs and how to achieve a great win in the SQL Server performance battle.

Speaker(s):

  • Margarita Naumova

Track and Room: Enterprise Database Administration Deployment - Room A


Title: I am a DBA! “What is the next”?

Abstract: In this session, we will discuss where to start when you get your job as a DBA. What are the first steps you need to do to discover and arrange the environment for which you are responsible. How to answer questions like: How many databases do you have on each server? How big are they? What they are used for and how many of them are critical? Do you need backups and do you have such, Etc. There are many questions you got from the day 1, but where to start is always the key to not get panicked. The goal of this session is to help you perform your first steps in a DBA job, especially when you get into a situation with only one Excel spreadsheet containing your servers’ list.

Speaker(s):

  • Rozalina Zaharieva

Track and Room: Enterprise Database Administration Deployment - Room D


Speakers

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

Markus Ehrenmueller-Jensen

Twitter: - MEhrenmueller

LinkedIn: Markus Ehrenmueller-Jensen

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.

Miroslav Dimitrov

Twitter: - @miro_dd

LinkedIn: Miroslav Dimitrov

Contact: http://www.sqlshack.com/author/miroslav-dimitrov/

Miroslav Dimitrov is a Senior Big Data and Analytics Engineer at DXC Technology, regular speaker at various events and Microsoft Certified Trainer. He is MCSE: Data Platform for SQL Server and MCITP on SQL 2008. In the last years he had worked on great variety of customers’ environments and involved in complex transitions and transformation projects as well as developing private and public cloud solutions. Miroslav is also leading database courses at Sofia University.

Ezra Levi

LinkedIn: Ezra Levi

A senior DBA, working in the data field for the last 12 years. An experienced and professional DBA in SQL Server, MySQL, MongoDB, Hadoop and other big data technologies.

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.

Jan Mulkens

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

LinkedIn: Jan Mulkens

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).

Eugene Polonichko

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

LinkedIn: Eugene Polonichko

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.

Simon Whiteley

Twitter: - MrSiWhiteley

LinkedIn: Simon Whiteley

Contact: http://blogs.adatis.co.uk/blogs/simonwhiteley/

Simon Whiteley is the Director of Engineering for Advancing Analytics Ltd and a Microsoft Data Platform MVP. Simon is a seasoned solution architect and technical lead with well over a decade of Microsoft Analytics experience. A deep techie with a focus on emerging cloud technologies and applying “big data” thinking to traditional analytics problems, Simon also has a passion for bringing it back to the high level and making sense of the bigger picture. When not tinkering with tech, Simon is a death-dodging London cyclist, a sampler of craft beers, an avid chef, and a generally nerdy person.

Iva Velkova

Iva Velkova is a SQL Server trainer in SQL Master Academy. She has nearly 4 years’ experience with SQL Server. Focusing on querying SQL Server, SQL Server development, performance tuning and optimization, and SQL Server patterns and practices. Iva Velkova has successfully completed the requirements to be recognized as a Microsoft Certified Professional.

Terry McCann

Twitter: - @SQLShark

LinkedIn: Terry McCann

Contact: https://www.advancinganalytics.co.uk/blog

Microsoft MVP. Principal Consultant and Owner of Advancing Analytics Limited, an Advanced Analytics consultancy in the UK. Advancing Analytics helps businesses advance their analytical capabilities. Our focus is on Data Science, Data Engineering, DataOps and applied AI. Terry holds a Master’s degree in Data Science - with a focus on DataOps for Machine Learning. Speaker at conferences across the world and the host of the Data Science in Production Podcast.

Gilberto Zampatti

Time ago (a lot of time ago…) an excellent IT pro brought me with him and became my Mentor in the IT wonderland…it was a world full of mainframes… I met the Relational theory when there were no commercial RDBMS, and I was spellbound by that “magic”. When Microsoft appeared in the IT market, I felt finally which trek I had to follow. I’m still walking on such road, and in my rucksack I’ve ben putting some other stuff (like SharePoint, for example). My sole regret: I’ve left the College to consecrate all my time to my job; curiously, since then, I’ve never stop learning…

Miroslav Lessev

LinkedIn: Miroslav Lessev

I am a PhD candidate at Faculty of Economics and Business Administration, University of Sofia quot;St. Kliment Ohridskiquot; in Implementation of modern computer engineering in economic studies at. I have study on cloud computing and its effect on economics and people. I have more than 20 years of experience in designing, developing, implementing and supporting databases. At the moment I#39;m a Big Data Developer in DataCore Software.

Ivan Donev

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

LinkedIn: Ivan Donev

I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).

Kaloyan Kosev

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

LinkedIn: Kaloyan Kosev

Kaloyan Kosev is a SQL Server expert working with enterprise companies for the last 9 years. His daily work routine is a mixture of troubleshooting bugs and issues, consulting and advising clients and presenting to students. Within his free time he is trying to balance between SQL and x-sports.

Valio Bonev

IT enthusiast keen to explore new avenues for solving real business challenges. Не has a vast experience in bringing solutions to some of the most interesting e-commerce and financial organizations. He is a Solution Architect at BULPROS.

Alexander Arvidsson

Twitter: - arcticdba

LinkedIn: Alexander Arvidsson

Contact: http://www.arcticdba.se

Alexander is a principal solutions architect at Atea in Linköping, Sweden. Nobody really knows what it means to be a principal solutions architect, but he spends his days helping clients of all shapes and sizes to take better care of their data.

He has spent the last 23 years toying with databases and related infrastructure services such as storage, networking and virtualization, occasionally emerging from the technical darkness to attend a Star Wars convention somewhere in the world.

He is a frequent international speaker, a Data Platform MVP, podcaster, blogger and a Microsoft Certified Trainer, focusing on SQL Server, the Azure data stack and Power BI.

Margarita Naumova

LinkedIn: Margarita Naumova

Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/

Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.

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…

John Tunnicliffe

Twitter: - Dr_John_T

LinkedIn: John Tunnicliffe

Contact: https://devops-your-dwh.com/

Dr John Tunnicliffe is a well-respected designer and architect of business intelligence solutions who likes nothing more than getting his hands dirty with real life coding problems. John is a recognised expert in applying continuous integration techniques to data warehouse projects, thereby ensuring code is automatically built, deployed and tested as changes are made by the development team. As a regular speaker at the SQLBits conference and PASS SQLSaturday events, John has covered topics such as building an infrastructure to support real-time OLAP and continuous integration and the data warehouse.

Jonathon Eve-O’Connor

Contact: http://blogs.adatis.co.uk/jonathoneveoconnor/

Jon is a director of Adatis Bulgaria, located in Sofia. He has over 8 years experience developing and managing BI projects across a wide range of industries and the full Microsoft BI Stack, he is passionate about Business Intelligence and the wider SQL community.

Rozalina Zaharieva

Twitter: - RozenceZ

LinkedIn: Rozalina Zaharieva

SQL expert in Microsoft’s Data Platform Solution. Enthusiast with more than 10 years of experience in support, implementation, design and architecture of small and large projects for SQL Core – Consolidations and Migrations. Passionate speaker in SQL Master Academy and events like SQLSaturday and community events. Experience in Financial Sector Data platform Operations.

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.

Oliver Frost

Twitter: - @ConsolidataLtd

LinkedIn: Oliver Frost

I am currently working as a Data Engineer, improving the company data platform and providing the necessary resources for our data consultants. I am extremely fortunate to dabble with a number of tools including those from the Microsoft BI stack and NoSQL tech like Neo4j, R and Python. My strengths lie in integrating multiple technologies for a specific business problem.

I aim to present material that BI consultants and developers can all take away something new to apply to their own work processes. I try to apply knowledge and skills from my previous life as a neuroscientist and as a blindfolded Rubik’s Cube world record holder. I am of the belief that, one day, neuroscience and big data will come together in a big way.

Gilberto Zampatti

Time ago (a lot of time ago…) an excellent IT pro brought me with him and became my Mentor in the IT wonderland…it was a world full of mainframes… I met the Relational theory when there were no commercial RDBMS, and I was spellbound by that “magic”. When Microsoft appeared in the IT market, I felt finally which trek I had to follow. I’m still walking on such road, and in my rucksack I’ve ben putting some other stuff (like SharePoint, for example). My sole regret: I’ve left the College to consecrate all my time to my job; curiously, since then, I’ve never stop learning…

Andrea Martorana Tusa

Twitter: - bruco441

Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category

Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups.

Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).

Andrey Nikolov

Andrey is MCSA for SQL Server 2012/2014 with almost 20 years of experience in designing and implementing applications for Windows. He is working with various database platforms, but SQL Server is his favorite. He is also a leader of Plovdiv Power BI User Group and active member of local .NET, Power BI and SQL Server communities.

Sergiy Lunyakin

Twitter: - slunyakin

LinkedIn: Sergiy Lunyakin

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.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page