SQLSaturday #642 - Sofia 2017
Event Date: 10/14/2017 00:00:00
Event Location:
- Sofia Tech Park
- Boulevard “Tsarigradsko shose” 111B
- Sofia, Sofiya, Bulgaria
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: 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 - A
Title: Exploring Dark Data with SQL Server 2016 and R [EN]
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 interesting expanding their skill set beyond their comfort zone in SQL Server.
Speaker(s):
- Oliver Frost
Track and Room: BI Information Delivery - B
Title: Introduction to SQL Server v.Next for Linux
Abstract: Microsoft surprised a lot of people with the announcement that SQL Server is going to be released for Linux. And there we have it - preview releases available in public are regularly delivered, working great and fast. On my session I’ll show details of solution that allowed this idea to come true. We’ll see how to install, use and administer Linux version of SQL Server. We’ll see it working as a service and in Docker containers. I’ll give you details of why the second option is really interesting, or to say it more clearly - groundbreaking. In addition to slides you’re going to see lots of terminal windows, tools that are familiar to you and new stuff as well.
Speaker(s):
- Andrzej Kukula
Track and Room: Enterprise Database Administration Deployment - 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 creating 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: Advanced Analysis Techniques - E
Title: Machine Learning for IoT - Unpacking the blackbox
Abstract: Devices from the IoT realm generate data in a rate and magnitude that make it practically impossible to retrieve valuable information without support of adequate AI engines. Although being one among many solutions available, Azure ML has proved to be a great balance between flexibility, usability and affordable price. But how does Azure ML compare with the other ML providers? How to choose the appropriate algorithm? Do you understand the key performance indicators and how to improve the quality of your models? This session is about managing and understanding IoT data. Check this out and see how Azure Machine Learning could support real life problems in building IoT solutions.
Speaker(s):
- Ivelin Andreev
Track and Room: Analytics and Visualization - B
Title: Logic Apps - Data Orchestration in Azure
Abstract: For a long time we’ve dreamed of full-functioned SSIS in the cloud. If you’ve wrestled with Data Factory, well… It’s not quite there yet. Logic Apps fills a huge gap in the Azure story and if you’ve not tried it yet - you should.
Logic Apps provides control-flow style functionality and can orchestrate data from a huge range of common sources. Want to scrape twitter, perform sentiment analysis and write to PowerBI? Its now possible with zero coding.
This session will introduce Logic Apps how it fits into the Modern Azure Warehouse then demonstrate building a twitter scraper step by step, demonstrating the process of building, deploying and debugging an app.
Speaker(s):
- Simon Whiteley
Track and Room: BI Platform Architecture, Development Administration - D
Title: Creating data-driven serverless apps with Azure Functions
Abstract: We already know that cloud provides us with a way to control the amount of resources provisioned based on app load, scale them up and down. But what if I will say that there is a way to create your app, host it in the cloud and make it ready to respond at your call, but if you will have zero load during a month it will cost you nothing? Try to imagine that you will pay not for fixed amount of CPU and RAM, but for a number of function calls and amount of CPU time consumed to execute them. In this scenario you do not have a dedicated virtual machine, but you have an abstract web farm, which consists of 100500 servers and each of them is able to execute your code. In this case we do not have a server, neither physical nor virtual, we have a platform which can scale from zero to infinite in a few seconds. On top of that you can use your favorite language - C#, F#, Java, PHP, Python, Node.JS, PowerShell, Bash, etc.
Speaker(s):
- Anton Boyko
Track and Room: Cloud Application Development Deployment - C
Title: State-of-the-Art Machine Learning Algorithms in R from Microsoft
Abstract: Do you fancy learning regression and classification in one hour? We will start with linear regression, simple but powerful machine learning algorithm. With it you will learn about correlation coefficient, loss function, optimization algorithms and regularization. At the end of this section we will built a ML model using Fast linear model with Stochastic Dual Coordinate Ascent (SDCA) optimization. Next step is get to know artificial neural networks, their architecture, activation functions and backpropagation algorithm. This allows us to build a (better?) model using rxNeuralNet and N#. Evaluation metrics for regression models will conclude first part of the session. In the second part we will use almost the same ML algorithms for classification — the difference is that Logistic regression will replace Linear regression. Finally we will learn about Evaluation metrics for classification models, which allows us to pick the very best model for problems we are going to solve together.
Speaker(s):
- Marcin Szeliga
Track and Room: Advanced Analysis Techniques - A
Title: From SQL to R – Leverage Your T-SQL Knowledge to Learn R
Abstract: You are already familiar with T-SQL and are eager to learn R but do not know, where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Advanced Analysis Techniques - B
Title: Database Continuous Delivery on the Microsoft Platform
Abstract: A look at the state of the art in database continuous delivery using SQL Server Data Tools (SSDT), Visual Studio Team Services(VSTS), and VSTS Release Management.
The features provided by platforms such as TFS and VSTS have been widely adopted by application developers in support of modern software development practices such as continuous delivery.
In the world of database development, adoption has been much slower, due to a number of organisational and technical considerations.
This session will discuss some of the challenges associated with database continuous delivery, and the ways in which Visual Studio, SQL Server Data Tools and Visual Studio Team Services can help to improve delivery of SQL Server databases.
Speaker(s):
- Gavin Campbell
Track and Room: Application Database Development - D
Title: Anomaly Detection
Abstract: Anomaly detection is one of the most advanced data mining and machine learning tasks. There are many statistical procedures and data mining algorithms that can be used for it, including Expectation-Maximization Clustering, and Principal Component Analysis. In this session, you will learn through presentation and demos how to detect the low quality data areas with some basic statistics and with advanced algorithms. You will see how you can use T-SQL queries, R code in SQL Server, SSAS Data Mining, and Azure ML for this complex task.
Speaker(s):
- Dejan Sarka
Track and Room: BI Platform Architecture, Development Administration - A
Title: Data replication - who with whom, for whom, why and for what?
Abstract: During this session we will review all types of replications in SQL Server and find out principal differences between them and when should be applied. Besides examples of practical scenarios, we will consider what we have as alternatives and why the AlwaysOn is not one of them. As always on my sessions quite a lot of demonstrations and T-SQL code.
Speaker(s):
- Kamil Nowinski
Track and Room: Enterprise Database Administration Deployment - C
Title: GDPR compliant by design
Abstract: From 25 May 2018, the EU General Data Protection Regulation (GDPR) will affect every organisation that processes EU residents’ personally identifiable information (PII). The GDPR contains requirements that systems and processes must consider compliance with the principles of data protection. The essence of privacy by design is that privacy in a service or product is taken into account not only at the point of delivery, but from the inception of the product concept. There is also a requirement that controllers should only collect data necessary to fulfil specific purposes, discarding it when it is no longer required, to protect data subject rights.
This presentation provides a breakdown of the key provisions introduced by the new law, which every organisation must be aware of
Speaker(s):
- Miroslav Lessev
Track and Room: Advanced Analysis Techniques - C
Title: Adaptive Query Processing in SQL Server 2017
Abstract: An improvement of cardinality estimation is something we try to find in every next version of SQL Server. Even with all the improvements the SQL Server 2014 Query Processor gained, we still need to deal with Hash and Sort Warnings, extremely high or low Memory grants, or the well-known User Defined Functions performance issues. That’s why we are so existed to find the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance. Find out how the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance.
Speaker(s):
- Margarita Naumova
Track and Room: Enterprise Database Administration Deployment - A
Title: Dealing with CosmosDB
Abstract: CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema. In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.
Speaker(s):
- Mihail Mateev
Track and Room: Cloud Application Development Deployment - C
Title: Power BI: Performance Tips Tricks
Abstract: Thanks to the rapid, community-driven release cycle, Microsoft Power BI has caught and overtaken many visualisation tools and now sits alongside Tableau at the top of the Gartner Magic Quadrant for 2017. It is fast becoming the first-choice reporting tool for both small and large organisations.
However, as with all reporting tools, if the underlying data model is badly designed or custom measures/calculations are poorly written, performance can really suffer. Whether you are designing the front-end for a carefully crafted warehouse, or performing an ad-hoc analysis exercise, you can follow some best practice advice to ensure you’re getting the best out of your reports.
This 1 hour session will range from quick development wins to more strategic, enterprise considerations. The session also aims to explain ad-hoc transformations within the Query Editor and demonstrates best practices for encouraging Query Folding. Designed for all levels of Power BI expertise.
Speaker(s):
- Callum Green
Track and Room: BI Information Delivery - D
Title: How GDPR affect most common DBA maintenance tasks
Abstract: The European General Data Protection Regulation (GDPR) suggests penalties for those companies and organizations which do not comply with the directive. Fines can go as high as 4% of annual global revenue or 20 million Euros, whichever is greater. That’s why everybody from C-level management to regular DBA is crucial to enforce compliance with the new data protection rules and for this very reason data maintenance tasks become absolutely obligatory and if a legal entity has skipped them, from now on it is not going to be possible. In this session, based on our experience, we will speak about the most important DBA maintenance tasks you need to perform to keep your databases GDPR compliant. Session is suitable for beginner DBAs and Developers.
Speaker(s):
- Tsvetozar Ivanov
Track and Room: Enterprise Database Administration Deployment - E
Title: I am a DBA! “What’s 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 - D
Title: Real world DevOps - challenges, tools and solutions
Abstract: So you want to use AlwaysEncrypted, but your app is not using driver level parameters? Or you want to parameterize ad-hoc queries, without rewriting your application? Or you just want to pretty print your t-sql code? SQLDOM is here to help. Not very popular but extremely useful utility/library that can help anyone to intercept and rewrite queries during runtime so they meet feature requirements or just fix performance.
Speaker(s):
- Ivan Donev
Track and Room: Application Database Development - A
Title: In-database Predictive Analytics with SQL Server 2017
Abstract: In this session we will look at SQL Server Machine Learning Services and, in particular, the new MicrosoftML package available in SQL Server 2017 and how it can be used to build an in-database Predictive Analytics Model, that can scale.
The session will initially provide a primer to supervised Machine Learning before applying that to a real world scenario, taking you through each of the steps required to build an in-database predictive analytics model using R and SQL Server 2017.
Speaker(s):
- Sacha Tomey
Track and Room: Analytics and Visualization - B
Title: How Indexes and Statistics can improve performance of our databases
Abstract: This session covers the internals of statistics and indexes in Microsoft® SQL Server®. Creating and maintaining statistics and indexes is a core element in enhancing the performance of the SQL Server Database Engine. Both statistics and indexes are used to select suitable query execution plans; indexes also speed up the retrieval of data. To understand and influence query performance, you should have a good understanding of queries and indexes.
Speaker(s):
- Gilberto Zampatti
Track and Room: Professional Development - D
Title: Is Power BI Enterprise ready?
Abstract: Best practices and recommendations for leveraging/deploying Power BI within a large scale Enterprise environment, utilising new features and a look at the road map.
Speaker(s):
- Scott Hudson
Track and Room: BI Platform Architecture, Development Administration - E
Title: Cloud BI with Azure Analysis Services
Abstract: With Azure Analysis Services (Azure AS) we have full set of PAAS and SAAS services like Azure SQL DWH, Azure SQL DB, Azure AS and Power BI for creating our BI solutions in the cloud. In this session I will introduce Azure AS and how we can use it together with other Azure services for creating complete BI solution in the cloud.
Speaker(s):
- Sergiy Lunyakin
Track and Room: BI Platform Architecture, Development Administration - C
Title: Creating “Always Encrypted” applications
Abstract: End-to-end encryption deserves end-to-end demo :) In this session you will see not only what Always Encrypted is and how it works, but also how it looks like from developer’s perspective. It is a demo-heavy session and we will spend more time in Visual Studio and SSMS than in PowerPoint. I will show how to read encrypted columns in SSMS and how to do this in the application. You will also learn how to manage certificates in Windows Certificate Store and Azure Key Vault and why we need a separate security officer. This session is intended for both developers and database administrators.
Speaker(s):
- Andrey Nikolov
Track and Room: Application Database Development - B
Title: USE CASE: LOCALDB
Abstract: In our new POS application intended for chains of markets we use Azure SQL Database, for many reasons we decide to store part of data also locally. We decide to use localDB as our local cache of data. In this presentation we will show:
- what we considered for local storage
- what is localDB
- versioning and differences
- what you need to install
- tools for working locally
- SqlLocalDB functionality
- SqlCmd functionality
- tips tricks
Speaker(s):
- Daniel Joskovski
Track and Room: Cloud Application Development Deployment - D
Title: Dynamic Search Conditions
Abstract: A common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker(s):
- Erland Sommarskog
Track and Room: Application Database Development - A
Title: SQL database on IoT devices, could you? should you? would you?
Abstract: The current IoT devices are pretty powerful, so could very well run a version of SQL engine. It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Speaker(s):
- Catalin Gheorghiu
Track and Room: Application Database Development - E
Title: PowerBI for Rookies
Abstract: Join me in a session where we will explore PowerBI strength for beginners and what can be achieved with it in about several clicks. We will go through PowerBI Desktop, PowerBI Webservice, different visualizations and a shallow look at Power Query.
Speaker(s):
- Miroslav Dimitrov
Track and Room: BI Platform Architecture, Development Administration - C
Title: Discover the new graph features of SQL Server 2017
Abstract: In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.
Speaker(s):
- Rudi Bruchez
Track and Room: Application Database Development - E
Title: Master your Data in the Cloud with Power Apps and Logic Apps
Abstract: As data warehouses become more advanced and move to the cloud, Master Data Management is often bottom of the list. Being tied to an IAAS server solely for MDS feels like a big step in the wrong direction! In this session, I will show you the secret of ‘app-iness with a cloud alternative which leverages Power Apps and Logic Apps. We will step through a number of real world scenarios, demonstrating how easy it is to deliver a mobile friendly, no-server, no-code Master Data Management solution.
Speaker(s):
- Matt How
Track and Room: BI Platform Architecture, Development Administration - E
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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).
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.
Daniel Joskovski
Daniel Joskovski work in IT since 1985, he is a database-centric application developer and architect, instructor, course author, user group leader. Over the Past 17 Years as MCT he#39;s been teaching Microsoft SQL Server and .NET Development courses to premier customers in Macedonia, Serbia, Norway, Kosovo and Albania. From 2009 He is being awarded with Microsoft MVP award for SQL Server 8 times in a row. At the moment Daniel works for CloudCoder DOOEL Skopje.
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.
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.
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.
Stephane Haby
Contact: http://www.dbi-services.com/index.php/blog/dbi-bloggers/blogger/listings/sth
St#233;phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is MVP as well as MCSA and MCSE for SQL Server 2012 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals amp; Pharmaceuticals, Banking / Financial Services and many other industries.
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.
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.
Bjoern H Rapp
Twitter: - @bjoern_rapp
LinkedIn: Bjoern H Rapp
Bjoern is an experienced Cloud and Big Data architect with great enthusiasm for Machine Learning and Advanced Analysis He has a background from .NET, SharePoint and Office 365 and is a current Office Servers and Services MVP. He is also an MCT Regional Lead for his native country Norway and delivers classroom and virtual courses all over the world
Gavin Campbell
LinkedIn: Gavin Campbell
Contact: http://arapaima.uk
Gavin Campbell is a recovering Business Intelligence developer specialised in improving working practices in database delivery through the use of tools such as SQL Server Data Tools, tSQLt, Visual Studio Team Services, Git and Jenkins, on platforms such as AWS and Microsoft Azure, and methodologies such as Continuous Delivery and Agile.
Sacha Tomey
Twitter: - https://twitter.com/sachtomey
LinkedIn: Sacha Tomey
Contact: http://blogs.adatis.co.uk/sachatomey
Sacha Tomey is Technical Director and co-founder of Adatis, a Microsoft Gold Partner for Data Analytics. He has an extensive background in technology, data in particular having delivered strategic enterprise solutions into a variety of industries across a broad selection of organisations.
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.
Ivelin Andreev
LinkedIn: Ivelin Andreev
Contact: https://www.slideshare.net/ivoandreev
Ivelin is a Microsoft Azure MVP and software architect in one of the leading and highly innovative Bulgarian IT brands - Interconsult Bulgaria Ltd. He is an external ICT expert in the European Commission, Eurostars-Eureka programme and Innovation Fund Denmark, Microsoft professional developer, senior project manager and Data Platform specialist. With 17+ years of strong experience in design and development of web systems, SOA, enterprise integration, machine learning, web security and data management, he is a practical man who always tries to balance between risk and flexibility. Never scared of work he has turned the weighing of pros and cons into own marked style that urges to make conscious decisions.
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).
Oliver Frost
Twitter: - @OFrost
LinkedIn: Oliver Frost
I currently work predominantly as a Data Engineer for Consolidata Ltd with side roles in Engagement, Marketing and Sales. My background is in Neuroscience and so I would like to cover cross-over topics in the future (machine learning, deep learning and developing algorithms).
My tool set includes: SQL Server, R, Microsoft R Server and Azure. I have a good knowledge of other NoSQL technologies including Hadoop, Spark and Neo4j.
I also have an unconventiona background - I am also a current world record holder for solving the 4x4x4 blindfolded Rubik’sCube blindfolded!
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.
Dejan Sarka
Twitter: - DejanSarka
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.
Stijn Wynants
Twitter: - SQLStijn
LinkedIn: Stijn Wynants
Contact: http://swyssql.wordpress.com
Stijn is a Microsoft Premier Field Engineer on Data AI and a DataMinds core member. He is also one of the organizers of the local user group sessions the yearly event called DataMinds Connect (SQL Server Days). He is a speaker at various international events (SQLSaturday,PASS Summit,Difinity,…). He spends his days tuning SQL Servers solving problems with the full data platform. His focus is primarily on sql server core, but has also done various BI ETL projects. He gets his kicks out of Columnstore indexes tuning queries but shivers at the sight of an SSAS cube.
When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine local beers or enjoying time with his wife and his dog.
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.
Callum Green
Twitter: - https://twitter.com/CallumGAdatis
LinkedIn: Callum Green
Contact: http://blogs.adatis.co.uk/callumgreen/
Callum is a Senior BI Consultant with Adatis Consulting, passionate about improving presentation layer architecture and finding new ways to exploit traditional warehouse structures. He has worked on many BI projects over a 9 year period, deviating from the typical Microsoft Stack and more into the Azure domain. Callum has written a number of blogs on subjects like Power BI, Power Query and the M programming language.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Tsvetozar Ivanov
MSSQL Server 2012/2008/2005 administration:
- Installation and configuration
- design and implement backup solutions
- design and implement disaster recovery solution (mirroring, transaction log shipping, always on availability groups)
- design and implement high availability solution (clustering, replication)
- security management
- troubleshooting
- capacity planning
- Performance and health monitoring, performance tuning
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.
Just Blindbaek
Twitter: - justblindbaek
LinkedIn: Just Blindbaek
Contact: http://blog.justb.dk
Independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk). Is a Microsoft Certified Trainer at Orange Man.
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…
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).
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.
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
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, Cloud development and course content development. Iva Velkova has successfully completed the requirements to be recognized as a Microsoft Certified Solution Associate: SQL Server 2016 Database Development.
Rudi Bruchez
Twitter: - nepasderanger
LinkedIn: Rudi Bruchez
Contact: http://www.babaluga.com/
(same as before)
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.
Scott Hudson
Consulting in Microsoft BI for over 5 years Working in a host of different industries:
- Education
- Government
- Finance
- Retail
- Media
- Subscription services
Skills include:
- Power BI
- Azure Data Factory
- Cosmos DB
- Data Lake
- Azure Data Warehouse
- Warehouse design
- SQL Server Integration Services
- SQL Server Analysis Services Multidimensional/Tabular
- SQL Server Reporting Services
- Master Data services
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.
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.
Matt How
LinkedIn: Matt How
Contact: http://blogs.adatis.co.uk/matthow/
Matt is a Business Intelligence specialist with a commitment to staying up to date with the latest tech and delivering solutions that clients want to use. With a strong knowledge of both the traditional SQL BI Stack and modern data warehouse architecture, Matt strives to pass on his learning to the community where possible.
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.
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.
Andrzej Kukula
Twitter: - @andrzejkukula
LinkedIn: Andrzej Kukula
Consultant and trainer in SQLExpert.pl with more than 20 years of IT experience. Architect of HA/DR solutions, BI solutions, Data Platform solutions, cloud solutions. Solves SQL Server related problems, including performance tuning. Passionate about SQL Server and programming. Speaker at various conferences including SQLSaturday, SQLDay, SQLNexus, AzureDay, Global Azure Bootcamp and local user groups.
Dean Savović
Twitter: - https://twitter.com/dsavovic
LinkedIn: Dean Savović
Contact: http://www.savovic.com.hr
Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. He speaks at Microsoft Windays Croatia, ATD Croatia, SSWUG, KulenDayz Croatia, SQLSaturday events, etc… Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in SPAN which is specialized in data management field on Microsoft SQL Server.
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…
Sponsors
The following is a list of sponsors that helped fund the event: