SQLSaturday #460 - Slovenia 2015
Event Date: 12/12/2015 00:00:00
Event Location:
- Faculty of Economics
- Kardeljeva ploščad 17
- Ljubljana, Ljubljana, Slovenia
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: Daily problems with indexing and its - possible - solution
Abstract: Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!
- Why performance degradation in spite of maintenance jobs?
- just one more database in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part bad…
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
Speaker(s):
- Uwe Ricken
Track and Room: DBA - P-007: DBA
Title: You don’t need Enterprise Edition to do that!
Abstract: The most coveted features of SQL Server are made available in Enterprise Edition and are sometimes released into Standard Edition a few years later. This often leaves a vast group of users who “window shop” the latest and greatest features and return to the office wishing they never saw those features presented. This session will show you how you can achieve the same, or at least a similar, outcome to some of those features without having to fork out for Enterprise Edition licenses or breaking any license agreements. You will leave the session with a set of solution concepts covering Partitioning, Data Compression and High Availability that you can build upon or extend and maybe save you and your company a nice pile of cash.
Speaker(s):
- William Durkin
Track and Room: DBA - P-007: DBA
Title: Beginners Guide to MDX
Abstract: Give your queries a multidimensional makeover. In this session we’ll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes.
MDX can seem a very daunting language, but when it’s broken down into the basics it’s easier than you think.
We’ll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session!
We’ll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or a (), and we’ll look at some of the awesome power that MDX can provide to our reporting.
Speaker(s):
- Alex Whittles
Track and Room: BI - P-005: BI
Title: Real Time Power BI - API, Hubs and Streams
Abstract: Power BI - I bet you already know what it is - also offers a nice API set that allows you to program it directly from you application so that you can push data directly to Power BI Dashboards and have them updated in real time. Or, even better, you can create a little bit more complex solution that will live in the cloud and uses Azure Event Hubs to ingest data, Stream Analytics to do some streaming query and finally Power BI to visualize it. And you can even put Azure DW in the game (and probably you should) In this session we’ll all this stuff, how it works together and how it can help us to create a very cool and useful Cloud Modern BI solution.
Speaker(s):
- Davide Mauri
Track and Room: BI/DEV - P-006: BI/DEV
Title: 0x010D88DDB7DFE19AAD36D - Always Encrypted in SQL Server 2016
Abstract: As a principal consultant for one of the major provider of medicinal and patient data worldwide I am daily confronted with the problems encountered when dealing with patient data and sensitive information. Apart from the European legislation there are many hurdles in using and analyzing data containing information such as social security numbers, names and addresses, diagnosis and medicinal informations. SQL Server 2016 introduces Always Encrypted which provides a clean separation between those who own the data (and can view it) and those who manage the data (but should have no access). In this session we will have a look at different setups for Always Encrypted (Hybrid solutions, pure on-premises and 100% cloud based) as well as how to get started with it and what kind of encryption to apply. At the end of this session you will know about the Driver Process of Always Encrypted, how to set it up and how to deploy it and maintain it in on-premises, hybrids and cloud solutions.
Speaker(s):
- Regis Baccaro
Track and Room: DEV - P-217: DEV
Title: Business Analytics 101: Agile Analytics using Azure Machine Learning
Abstract: Business analytics platforms have always been tools built for statisticians and data scientists. However, these tools are increasingly being directed at business analysts, and Gartner’s rankings on its well-known “completeness of vision” and “ability to execute” axes now ride as much on “ease of use” as they do on offering advanced analytical algorithms. How does this change in landscape affect businesses? Are you new to the world of business analytics? Are you taking over an existing analytics program, or starting one from scratch? This session will help you to understand how to craft a strategy, provision the right business analytical capabilities, and move towards actionable results. We’ll identify common pitfalls to avoid as you start or reinvigorate your business analytics program. In particular, we’ll explore how companies are using self-service and data discovery techniques to deliver more agile analytics using Azure Machine Learning.
Speaker(s):
- Jen Stirrup
Track and Room: BI - P-005: BI
Title: Database Administration for the non-DBA
Abstract: So you are a developer or a systems admin and you’ve just been handed a SQL Server database and you’ve got no idea what to do with it. I’ve got some of the answers here in this session for you. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.
While this session won’t teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
Speaker(s):
- Denny Cherry
Track and Room: DBA/DEV - P-215: DBA/DEV
Title: Microsoft Azure Machine Learning Algorithms
Abstract: Focus of this session will be explanation of algorithms available for predictive analytics in Azure Machine Learning service. Algorithms will be grouped by learning style (Supervised, semi-supervised and unsupervised) and will take a look into 1) regression algorithms, 2) Regularization algorithms, 3) Decision trees algorithms, 4) Naive Bayes algorithms, 5) Dimension reduction algorithms, 6) Associated learning (not Kernel) Algorithms and 7) Clustering algorithms. With theory explained we will look into data samples and later examples in ML for these algorithms. Within this session we will explore, which algorithm is used and useful for what kind of empirical problem and which is suitable for particular data-set.
Speaker(s):
- Tomaž Kaštrun
Track and Room: BI - P-005: BI
Title: Easy ETL with Biml
Abstract: Can ETL be fun? Unfortunately, very often creation of ETL layer is time-consuming, tedious, error-prone task. What’s more, any change in requirement needs most of the work to be redone. In our session we’ll present new approach to creating BI solutions using Biml language and Mist programming environment. They greatly simplify the process, allowing for amazing flexibility, and make the ETL work more pleasant. We will show real examples of how Biml and C# generates hundreds of usable SSIS packages in just couple of minutes. We will also cover integration of ETL with TFS and CI for ETL. Everything with 100% compatibility with unmodified SQL Server. Join us and see how BI just became fun again
Speaker(s):
- Marcin Szeliga
Track and Room: BI/DEV - P-006: BI/DEV
Title: SQL Server 2016 Query Store
Abstract: Have you ever experienced to have your system slowed down or completely down? What happens? Have you ever upgraded an application to the latest version of SQL Server and facing an issue with plan change that slows your application down? Query Plan choice change can cause these issues. SQL Server 2016, through a new feature called Query Store, let’s make these problems easier to fix. Query Store retains all the execution plans used for each query; it captures the performance metrics for each plan over the time and allows you to force an execution plan easily. In this session, you will learn how the Query Store works and how it can help you to fix performance problems.
Speaker(s):
- Sergio Govoni
Track and Room: DBA - P-007: DBA
Title: Temporal Tables in SQL Server 2016
Abstract: Temporal tables are defined in the SQL 2011 standard and now transactional (system-versioned) temporary tables are included in Azure SQL Database and SQL Server 2016 CTP2.
In this session we’ll explain why we need them, how system-time tables work and demonstraint how to design and implement solutions for common use cases that involve temporal tables…
Speaker(s):
- Miloš Radivojević
Track and Room: DEV - P-217: DEV
Title: Analysing application performance with pattern searching using RML Utilitie
Abstract: RML Utilities is a tool that will allow you to normalise the queries that your application sends to the database and do some deep analysis on them. We will find out how you can find patterns like finding all queries that touch a specific table. We will use read trace and automate getting the estimated query plan against a test database for the whole trace. We can even go through the list of parameters for one query and find the selectivity based no the statistics. (this all takes place on a test db, not on production). Do you use an ORM and can’t tune individual queries because you have a lot of them and they’re all fast? Use my technique to find patterns and tune your application in a way you’ve probably not thought of before.
Speaker(s):
- André Kamman
Track and Room: DEV - P-217: DEV
Title: SQL Server 2016 AlwaysOn Availability Groups - New Features Enhancements
Abstract: SQL Server 2016 CTP2 has been released, with it come a number of big enhancements and new features for the Availability Group feature. In this session we will look at a number of these changes and how they now mean you can build more resilient systems and also the new options available for your Data Platform design. I will walk you through some of these and demonstrate some of the configuration options and how they impact the behaviour of your applications.
Speaker(s):
- John Martin
Track and Room: DBA - P-007: DBA
Title: Building mobile BI dashboards with Datazen
Abstract: Join this session to learn how you can build your own mobile BI dashboards with Datazen, the new visualization tool complementing your existing Microsoft BI stack. Datazen enables you to deliver mobile solutions rapidly: it allows you to develop KPIs and dashboards targeted for mobile devices like tablets and phones in a quick and easy way. The dashboards render in native applications for all flavors of phone or tablet operating systems, but also can be viewed in browsers and/or embedded into applications. Join this session to see how simple it is to build a Datazen dashboard and publish it to the Datazen server. During the demo, you’ll be able to follow how the dashboards change - on your own device!
Speaker(s):
- Zoltán Horváth
Track and Room: BI - P-005: BI
Title: Performance Tuning for the Transaction Log
Abstract: SQL Server transaction log is one of the most critical components of the database and in the same time one of the most misunderstood. While being neglected it can easily become a bottleneck for our system. Are you interested in learning how to avoid issues with the transaction log and streamline its work? In these sessions we will explore how to optimize it, configure it and keep it under control.
Speaker(s):
- Miroslav Dimitrov
Track and Room: DBA - P-007: DBA
Title: SQL Server Security In An Insecure World
Abstract: One of your first responsibilities of a SQL Server DBA is to safeguard the data and protect it from unauthorized access. Over and over we hear about hacker attacks and data leaks: if you don’t want to be the next Sony, you have to take action and activate all the available protection measures. In this session you’ll learn how attackers take advantage of weaknesses in your infrastructure and how to secure it using SQL Server security features and best practices.
Speaker(s):
- Gianluca Sartori
Track and Room: DBA/DEV - P-215: DBA/DEV
Title: Flying Through the Clouds–Performance Tuning in Azure
Abstract: So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:
• Optimizing TempDB in an Azure VM • Reducing latency between application VMs and database VMs • Right sizing Azure VMs for performance and cost • Striping I/O across devices in Azure VMs • Performance Tuning in Azure DB
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.
Speaker(s):
- Joseph D’Antoni
Track and Room: DBA - P-007: DBA
Title: Stream Analytics on premise and on the Cloud with SQL
Abstract: Modern business is fast and needs to take decisions immediatly. It cannot wait that a traditional BI task that snapshots data at some time. Social data, Internet of Things, Just in Time don’t undestand “snapshot” and needs working on streaming, live data. Microsoft offers two solutions, one on premise with SQL Server (Stream Insight), one on the Cloud with Azure (Stream Analytics). Let’s see how they work.
Speaker(s):
- Marco Parenzan
Track and Room: BI/DEV - P-006: BI/DEV
Title: What’s new in SQL Server 2016 for BI Developer
Abstract: Finally, the wait is almost over. After few years of silence, Microsoft has finally made exciting announcements about SQL Server on premises enhancements.
In this session, I will cover top new features in SQL Server 2016 from a BI professional perspective. You will get an up to date overview of key improvements of MDS, SSIS, SSRS and SSAS
Speaker(s):
- Prathy Kamasani
Track and Room: BI/DEV - P-006: BI/DEV
Title: Shiny: dashboards in R
Abstract: R, the open source stats and data analysis language, has a new(ish) reporting engine called Shiny. It’s a free tool that allows for realtime, interactive dashboards with a minimum of fuss. This session takes you through the key functionality, development practices and infrastructure required to implement it.
Speaker(s):
- Stephanie Locke
Track and Room: BI - P-005: BI
Title: Making PowerShell useful for your team
Abstract: Making PowerShell useful for your team
You have heard about PowerShell and may be spent a little bit of time exploring some of the ways in which it will benefit you at work. You want to be able to perform tasks more specific to your organisation and need to share them with your team. I will show you how you can achieve this by demonstrating An easy way to learn the syntax How to explore SQL Server with Powershell How to turn your one off scripts into shareable functions How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions Where else to go for help
Speaker(s):
- Rob Sewell
Track and Room: DBA/DEV - P-215: DBA/DEV
Title: Anatomy of the DAX Query Plan
Abstract: When queries against your tabular model run slowly, you need deeper insight into the problem to come up with the correct solution. Your first step should be to review the DAX query plan, but what exactly are you looking for? In this session you’ll learn how to access the query plan and what types of information the logical and physical plans contain. You’ll also learn which elements in the query plan are most important in your troubleshooting process and, just importantly, what type of information you cannot glean from the query plan.
Speaker(s):
- Stacia Varga
Track and Room: BI - P-005: BI
Title: Automatic sharding in SQL - Reality or Myth?
Abstract: Have you ever started developing a product and found out that none of the available databases aren’t suitable for your use case?
What was your next step? In our case we were crazy enough to create our own database engine. In this session I will present our problem and what led us to the creation of new database engine. We will have a quick overview of how database engine is working and why it is the most suitable database for our case. Maybe you will find out that it may suit also for your needs. A closer look will also explain how our database engine handles automatic shading.
Speaker(s):
- Gregor Spagnolo
Track and Room: DBA/DEV - P-215: DBA/DEV
Title: T-SQL : Bad Habits Best Practices
Abstract: Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
Speaker(s):
- Aaron Bertrand
Track and Room: DEV - P-217: DEV
Title: Continuous Integration and the Data Warehouse
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:
- Automating your build and deployments with SQL Server Data Tools
- Auto-code generation within SSDT using T4 templates and DacFx
- Harnessing the power of BIML
- Automated Integration and Regression testing of your Data Warehouse
- Deploying and on-going management of OLAP databases using the SSAS Partition Manager
Speaker(s):
- John Tunnicliffe
Track and Room: BI/DEV - P-006: BI/DEV
Title: The Ticking Timebombs in Your Databases
Abstract: You’ve worked hard to build the best systems you can, and then one night you get called in to resolve a production incident. As you peer into your database, you see it: something so bad it sends shivers down your spine. How did that get in there? Who did that? Why? And how do you fix it?
In this session, we look at the workarounds, technical debt and clever designs that can cause you grief when you least expect it. We will also include perfectly fine features that can haunt you later. We will discuss how these things happen and give you tools to identify the ones that cause the most pain.
Join us: you’ll keep your job, have happier users and get more rest.
Speaker(s):
- Karen Lopez
Track and Room: DEV - P-217: DEV
Title: Databases on mobile devices
Abstract: You are a Windows Phone developer or just a mobile developer and you need a database locally, on the device, a database, what are your options? And really how do you sync you data with the big database? What you can do, what you cannot do, and how? How cloud is changing this story? These are a few of the questions this presentation will try to answer, the focus be on Windows Phone (the easiest to demo, but not ignoring the “others”). The actual industrial devices will be also covered. And of course all with as much demoes and code as possible.
Speaker(s):
- Catalin Gheorghiu
Track and Room: DEV - P-215: DBA/DEV
Title: Micro ORM - a petite beauty or a poison in a small flask?
Abstract: For developers with good knowledge of SQL using a micro ORM seems like an obvious choice. But is it? In the session we will discover the features of the micro ORM called Dapper and how can it simplify your way of communicating with the database. Then we will compare it to the Entity Framework and analyze when you should use one or the other - or neither. But wait! There is more! At the end you will see how easy it is to write a Dapper extension where the classes in your code will magically receive super SQL querying powers.
Speaker(s):
- Dejan Dular
Track and Room: DEV - P-217: DEV
Title: Ask the Expert Panel - Your Questions, Our Answers, and Fun
Abstract: Ask a panel of internationally known experts any question on SQL Server and related topics. Questions will be answered, debates will be had, general awesomenest will ensue.
This is a popular interactive session format on many conferences. With you attending we can make it really great. Don’t miss out.
Speaker(s):
- Mladen Prajdić
Track and Room: BI/DEV - P-006: BI/DEV
Title: Effective Index Partitioning, Compression Strategy
Abstract: We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning Compression, we can often see substantial gains.
Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.
Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
Speaker(s):
- Neil Hambly
Track and Room: DBA/DEV - P-215: DBA/DEV
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Tomaž Kaštrun
Twitter: - @tomaz_tsql
LinkedIn: Tomaž Kaštrun
Contact: http://www.tomaztsql.wordpress.com
Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.
Uwe Ricken
Twitter: - https://twitter.com/dbBerater
LinkedIn: Uwe Ricken
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”.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
Sergio Govoni
Twitter: - @segovoni
LinkedIn: Sergio Govoni
Contact: https://mvp.microsoft.com/it-it/PublicProfile/4029181?fullName=Sergio%20Govoni
Since 1999 Sergio Govoni has been a software developer; in 2000 he got a degree in Computer Science at “Università degli Studi” in Ferrara (Italy). He has worked for over 18 years in Centro Software, a software house that produces the best ERP for manufacturing companies that are export oriented. Now, he manages the development product team and he is constantly involved on several team projects, where he focues his attention on the architecture and the mission-critical technical details. Since 2016 he is the vice president of the UGISS (www.ugiss.org). For the provided help to technical communities and for sharing his own experience, since 2010 he has received the Microsoft Data Platform MVP award.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Dejan Dular
Twitter: - @dejandular
LinkedIn: Dejan Dular
Dejan is an independent .NET and SQL developer. During his career he developed applications mainly in the area of Customer Management Systems and Supply Chain Management. In the last years he specialized as a back-end developer and data specialist. He is also a Microsoft Dynamics CRM expert.
In his free time he is working with IoT and calls himself a DIY freak.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Alex Whittles
Twitter: - @PurpleFrogSys
LinkedIn: Alex Whittles
Contact: http://www.PurpleFrogSystems.com/blog
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence.
He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK.
Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQLSaturdays as well as numerous SQL Pass chapters around Europe
Aaron Bertrand
Twitter: - @AaronBertrand
Contact: https://blogs.sentryone.com/author/AaronBertrand
Aaron, Product Manager at SentryOne, produces performance and optimization tools for the entire Microsoft data platform, as well as Plan Explorer, a free tool for SQL Server execution plan analysis. In his spare time, he is either playing volleyball, curling, blogging at sqlperformance.com and blogs.sentryone.com, or contributing to SQL Server conversations on Twitter and dba.stackexchange.com. He has worked with SQL Server since 6.5 and has been an MVP since 1997.
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.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
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.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
Marco Parenzan
Twitter: - @marco_parenzan
LinkedIn: Marco Parenzan
Contact: https://www.linkedin.com/in/marcoparenzan/
Marco Parenzan is an independent Cloud and IoT Architect and .NET Developer. He has been awarded as a MVP on Microsoft Azure since 2014. He is a speaker in major community events in Italy about Azure and .NET development. He is a community lead for 1nn0va, an official Microsoft community in Pordenone, Italy. He has written a book on Azure in 2016. He loves developing retrogames and reading comix.
Marco Parenzan è professionista per le architetture Cloud e IoT e lo sviluppo in .NET. Ha ricevuto il titolo di MVP su Microsoft Azure dal 2014. È uno speaker in Italia su Azure e lo sviluppo di .NET. E’ un community lead per 1nn0va, una community ufficiale Microsoft a Pordenone, in Italia. Ha scritto un libro su Azure nel 2016.
Zoltán Horváth
Twitter: - @zoltanhorvath
LinkedIn: Zoltán Horváth
Contact: http://addictivemeasures.blogspot.com
Zolt#225;n is a BI specialist with more than a decade of expertise. He leads the Hungarian User Group of Microsoft SQL Server (HUG-MSSQL), the Hungarian Chapter of PASS. MCSE: BI and MCSE: Data Platform. SQL Server MVP since 2015.
William Durkin
Twitter: - @sql_williamd
LinkedIn: William Durkin
Contact: http://williamdurkin.com
William Durkin is a DBA, Data Platform MVP, and Data Platform Architect for Data Masterminds (http://datamasterminds.io). He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents, using a range of high availability solutions. William is a regular speaker at conferences around the globe, organizes the popular event SQLGrillen (http://sqlgrillen.com).
Prathy Kamasani
Twitter: - @pkamasani
LinkedIn: Prathy Kamasani
Contact: http://prathy.com/
Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London. She specialises in Power BI, SSIS, SSAS and SSRS. Prathy organisers London Power BI user group and co-organizes the London PASS Local Group. She is a regular speaker at events like SQLSaturday and local user groups.
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.
Regis Baccaro
Twitter: - @regbac
LinkedIn: Regis Baccaro
Contact: http://theblobfarm.wordpress.com
Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.
Stacia Varga
Twitter: - @StaciaV
LinkedIn: Stacia Varga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.
Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
Mladen Prajdić
Twitter: - @MladenPrajdic
LinkedIn: Mladen Prajdić
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
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.
Stephanie Locke
Twitter: - @stefflocke
LinkedIn: Stephanie Locke
Contact: https://itsalocke.com
Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.
Gregor Spagnolo
Twitter: - https://twitter.com/gregorspagnolo
LinkedIn: Gregor Spagnolo
Bio
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.
Davide Mauri
Twitter: - mauridb
LinkedIn: Davide Mauri
Contact: https://medium.com/@mauridb
Data Platform MVP for almost 12 years, I love Data and Database in all their forms. Developer for passion (C# and Python), I’ve been working in the IT field since 1997. My focus has been databases and performance tuning since the start, focusing both on transactional and analytical workloads. I worked for more than 10 years on Business Intelligence and Data Warehousing, then moved to IoT and Big Data for a while. Now back to database space, injecting passion and innovation into Azure SQL as Microsoft Program Manager for Azure SQL Hyperscale, helping developers to re-discover SQL, which is now almost everywhere, and take advantage of all its amazing power!
André Kamman
Twitter: - @andrekamman
Contact: http://andrekamman.com
André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.
John Martin
Twitter: - SQLDiplomat
LinkedIn: John Martin
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
Rob Sewell
Twitter: - sqldbawithbeard
LinkedIn: Rob Sewell
Contact: http://sqldbawithabeard.com
Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.
Jen Stirrup
Twitter: - @jenstirrup
LinkedIn: Jen Stirrup
Contact: http://www.jenstirrup.com
Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.
Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012
Sponsors
The following is a list of sponsors that helped fund the event: