SQLSaturday #620 - Dublin 2017
Event Date: 06/17/2017 00:00:00
Event Location:
- Trinity College
- College Green, Dublin 2
- Dublin, County Dublin, Ireland
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: Taming the Open Source Beast with Azure for Business Intelligence
Abstract: Today, CIOs and other business decision-makers are increasingly recognizing the value of open source software and Azure cloud computing for the enterprise, as a way of driving down costs whilst delivering enterprise capabilities.
For the Business Intelligence professional, how can you introduce Open Source into the Enterprise in a robust way, whilst also creating an architecture that accommodates cloud, on-premise and hybrid architectures?
We will examine strategies for using open source technologies to improve existing common Business Intelligence issues, using Azure as our backdrop. These include:
- incorporating Apache projects, such as Apache Tika, for your BI solution
- using Redis Cache in Azure in as a engine as part of your SSIS toolkit
Join this session to learn more about open source in Azure for Business Intelligence. Open Source does not mean on premise. Demos will provide practical takeaways in your Business Intelligence Enterprise architecture.
Speaker(s):
- Jen Stirrup
Track and Room: Cloud - Room2
Title: The Query Store and Query Tuning in SQL Server
Abstract: For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store.
This session will explore how the Query Store works and how it’s going to change the methods you use to tune and troubleshoot query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server 2016 tuning efforts, as well as your Azure SQL Databases.
Speaker(s):
- Grant Fritchey
Track and Room: DBA - Room4
Title: Revenge: The SQL!
Abstract: Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You’re on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to “correct” all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker(s):
- Rob Volk
Track and Room: DBA - Room5
Title: Reports on the Run: Mobile Reporting with SQL Server 2016
Abstract: Based on the acquisition of Datazen, Reporting Services now includes a new engine enabling the delivery of mobile reports. In this session you will learn about this new capability delivered with SQL Server 2016, including the architecture of the engine and the development of reports.
This session will describe and demonstrate how to prepare data for mobile reporting, and also how to develop and publish mobile reports. In addition, it will describe the architecture of the engine, and how to manage mobile reports.
This session will be of interest to a full range of professionals, including analysts, report developers, IT managers, and data architects.
Speaker(s):
- Peter Myers
Track and Room: BI - Room1
Title: Plan Cache Pollution: Dealing with Ad Hoc Madness
Abstract: How you execute your data requests can have a profound effect on performance and plan reuse. Did you ever wonder where that estimate (in the showplan) comes from? Is it correct or, is it way off? Why? You’ve probably heard that many of your problems are related to statistics. Potentially, you’ve even rebuilt statistics only to find that it fixes the problem. However, what you might be seeing is a false positive. And, it doesn’t always work. Come to this session to find out how you should be executing your statements for the best performance, caching, and reuse! We’ll look at ad hoc statements, dynamically constructed statements, and sp_executesql (e.g. forced statement caching) and I’ll debunk the mysteries around estimates so that you can solve performance problems the RIGHT way! If you want to demystify SQL Server’s decisions used for statement execution, query plans, and plan caching – this is the place to be!
Speaker(s):
- Kimberly Tripp
Track and Room: Dev - Room1
Title: Use Biml to Automate SSIS Design Patterns
Abstract: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.
In this session, you will learn:
- How to rapidly build multiple SSIS packages using Biml
- How to apply different SSIS Design Patterns using Biml
- How to automate SSIS Design Patterns using Biml
Speaker(s):
- Andy Leonard
Track and Room: BI - Room3
Title: Microsoft R Server 9.1 Update: Delivering Innovation in Data AI
Abstract: This presentation will give an update on all the new features in Microsoft R Server 9.1. We will see how we can do advanced Text mining (n-grams sentiment) and run deep learning networks for image recognition with a few lines of R code. Spark is the new in-memory frame-work for Machine Learning and we will see examples on how we easy it is to work in Spark compute context and utilize Spark for improving performance. Many customers have requirement for running “many models” e.g. Churn model per segment etc. Microsoft have develop new functions that enables the data scientist to apply these many models scenarios. This release includes significant innovations such as:
• New machine learning enhancements and inclusion of pre-trained cognitive models such as sentiment analysis image featurizers • SQL Server Machine Learning Services with integrated Python in Preview • Interoperability between Microsoft R Server and sparklyr. • New machine learning models in Hadoop and Spark.
Speaker(s):
- Soren Johansen
Track and Room: Big Data and Analytics - Room4
Title: Investigate TempDB like Sherlock Holmes
Abstract: The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session, you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affects everybody on that instance.
You will leave this session prepared to create better architecture decisions and better code to improve the performance for all of your users.
Speaker(s):
- Lord Richard Douglas
Track and Room: DBA - Room4
Title: PowerShell ❤ SQL Server: Modern Database Administration with dbat
Abstract: Join PowerShell MVP DBA Chrissy LeMaire and PowerShell Expert DBA Rob Sewell to learn how PowerShell can help improve your work/bacon life balance.
We will show you how to perform many DBA tasks easily and simply using PowerShell, from instance migrations to automated backup testing and more. Our session is aimed at DBAs, from junior to senior, who want to embrace the ease of automation and increase their toolset.
Speaker(s):
- Chrissy LeMaire
Track and Room: DBA - Room5
Title: An introduction to SQL Server Containers
Abstract: This session aims to give attendees an introduction into containers running SQL Server on Windows Server 2016. Attendees will be taken through the following: -
Defining what containers are (benefits and limitations) Configuring Windows Server 2016 to run containers Installing the docker engine Pulling SQL images from the docker respository Running SQL Server containers Committing new SQL Server images Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)
This sessions assumes that attendees have a good background in SQL Server administration and a basic knowledge of Windows Server administration
Speaker(s):
- Andrew Pruski
Track and Room: DBA - Room3
Title: Azure IoT, Windows 10 Core Raspberry PI (DIY)
Abstract: This session will begin, with a high level introduction to Azure Internet of Things, Windows 10 Core and Raspberry PI. Once we have established the basics about the technology, we will be connecting the dots with a live demo on some of the parts. The focus during the demo, will mainly be on Azure IoT Hub, Windows 10 Core and the Raspberry PI and how to DIY. As visualization we will be using Power BI to present the data. This session is not for the Enterprise rather has a more DIY approach.
Speaker(s):
- Jens Vestergaard
Track and Room: Cloud - Room2
Title: Introduction to U-SQL and Data Lake
Abstract: U-SQL is the new kid on the SQL language block. In this session we’ll look at the what, where, why and how of the language. Is it a query language? Is it a data transformation language? Will it replace T-SQL? Should you learn it? Where is it? What is Data Lake? We’ll discuss all this and more.
Speaker(s):
- Alex Whittles
Track and Room: Big Data and Analytics - Room3
Title: Query Plan Deep Dive
Abstract: Another in TheSQLGuru’s Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. TONs of information for the asute SQL Server user. Lets dig into them and see what we can learn from and about them and also talk about how they can be used to aid our query tuning efforts.
Speaker(s):
- Kevin Boles
Track and Room: Dev - Room4
Title: Infrastructure as Code in Azure for Data Platform People
Abstract: Anything and everything in Cloud platforms like Azure can be completely automated. Infrastructure people and Developers have embraced this methodology already, time for us Data Platform professionals to learn how to fully automate deploying our infrastructure. In this session we will learn how to deploy Azure resources with (partial) Azure Resource Manager (ARM) templates and Powershell. There will be a very strong emphasis on the Data Platform. Learn how to create reusable templates so you can create Production/UAT/Test/Development environments, or create Proof of Concept environments with automated tests quickly.
Speaker(s):
- André Kamman
Track and Room: Cloud - Room2
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: Dev - Room4
Title: Introduction to PESTER - TDD for PowerShell
Abstract: An introduction session for using Pester to test your PowerShell code
Pester provides a framework for running unit tests to execute and validate PowerShell commands from within PowerShell.
I will show you can get started using Test Driven Development for your PowerShell scripting.
We will examine Pester, the syntax and show plenty of demos and build a function that uses the Microsoft Cognitive Services Faces API to analyse Beards
Speaker(s):
- Rob Sewell
Track and Room: Dev - Room2
Title: Responding to Extended Events in near real-time
Abstract: Extended Events provide deep insight into SQL Server’s behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, a way to react to the events as soon as they happen seems to be lacking.
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions.
Speaker(s):
- Gianluca Sartori
Track and Room: DBA - Room4
Title: Lightning Talks
Abstract: Come along for some banter from celebrity judges award best lightning speaker and best new speaker.
The format is fast paces five minute lightning talks with anything goes topics across SQL Server and Data Platform
Speaker(s):
- SqlSatDublin .
Track and Room: Professional Development - Room1
Title: Using M for data access in Analysis Services Tabular v.next
Abstract: The most exciting feature of the next version of Analysis Services Tabular is the ability to use the M language for data loading. In this session you’ll learn the basics of M and see how it can be used to connect SSAS to a wide variety of new data sources, transform data before loading, and also how to use it when partitioning a table in your model.
Speaker(s):
- Chris Webb
Track and Room: BI - Room3
Title: The 2017 Expert Panel
Abstract: Discuss what’s moving and shaking in the Data World with our Expert Panel.
If you want to join in the expert panel discussion come along to the session at 14PM in Room 1 (Davis). Buck Woody is hosting the session along with a selection of his friends including Paul Randal, Kimberly Tripp, Chris Webb and Jen Stirrup.
Bring along any tough questions or some thing to start a discussion.
Submit your questions live on twitter via #SqlSatDublin or just come along.
Speaker(s):
- SqlSatDublin .
Track and Room: Professional Development - Room1
Title: Performance tips for faster SQL queries – DEV2DEV
Abstract: When you need to extract data from the database you are writing, more or less complex, T-SQL code. Often simplistic and procedural approach reflects what you have in your mind, however this could have a negatively impact about performance because the database engine might think otherwise. Fortunately T-SQL, as a declarative language, allows us to ask the “what” and delegate to the engine the “how”. Everything works best as long as you respect a few simple rules and you may use special constructs. In this session, with few slides and a lot of real-case scenarios, you can see the advantages of writing the query for high performance, even when they are written by that “someone else” called ORM.
Speaker(s):
- Emanuele Zanchettin
Track and Room: Dev - Room5
Title: Social Engineering: Hacking People
Abstract: “It is much easier to trick someone into giving a password for a system than to spend the effort to crack into the system.” This is a common line of thought in today’s world of increased cyber-security dangers. In this interactive session we’ll take a look at how social engineering works, the psychology behind it and why is it still the most effective way to gain access to your company’s secrets. The best attacks happen when people don’t even realize they are being attacked and in this session we’re going to try to fix that and educate you on how to realize when someone is trying to hack you.
Speaker(s):
- Mladen Prajdić
Track and Room: Professional Development - Room5
Title: New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database
Abstract: Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS / DECOMPRESS, from AT TIME ZONE to DATEDIFF_BIG(), and from SESSION_CONTEXT() to new query hints like NO_PERFORMANCE_SPOOL and MIN / MAX_GRANT_PERCENT, as well as some other surprises, you’ll walk away with a long list of reasons to consider upgrading to the latest version or finally trying out Azure SQL Database.
Speaker(s):
- Aaron Bertrand
Track and Room: DBA - Room5
Title: Advanced Data Recovery Techniques
Abstract: Disasters happen – plain and simple. When disaster strikes a database you’re responsible for, and backups and repair fail, how can you salvage data, and possibly your company and your job? This is where advanced data recovery techniques come in. Using undocumented tools and deep knowledge of database structures, you can manually patch up the database enough to extract critical data. This demo-heavy session will show you never-seen-before methods I’ve used extensively in the last year to salvage data for real-life clients after catastrophic corruption. You won’t believe what it’s possible to do!
Speaker(s):
- Paul Randal
Track and Room: DBA - Room1
Title: Azure SQL Data Warehouse 101
Abstract: What is Azure SQL Data Warehouse, why and how should I use it? Here we will look at the fundamental basics to answer these questions and more, giving you the foundation knowledge to get started. This session will arm you with the core knowledge of how the DW engine differs to the traditional SQL Server database. Helping you understand key concepts such as Distributions and the Control/Compute structure, along with many others. Allowing you to be confident as you start to asses and use Azure SQL Data Warehouse.
Speaker(s):
- John Martin
Track and Room: Cloud - Room2
Title: Scaling out SQL Server in Azure – Canadian Music Industry Case St
Abstract: This session will showcase a real world solution that scales out on premise SQL Server to Azure SQL dynamically based on peak workload.
The solution processes hundreds of millions of sales transactions from popular online music services such as iTunes, Spotify and YouTube.
Key processes that previously would have taken a number of weeks can now be completed in under a day.
Speaker(s):
- John Corley
Track and Room: BI - Room1
Title: Introduction to Microsoft AI and Azure Bot Framework
Abstract: This session will provide an overview of Microsoft’s approach to Artificial Intelligence and will show you how you can quickly create a bot using the Azure Bot Framework with limited coding. From there you’ll learn how you can gain deep insights using Application Insights and Power BI
Speaker(s):
- Emma Reid
Track and Room: Big Data and Analytics - Room2
Title: The RDBMS is Dead, Long Live the RDBMS!
Abstract: In the last 40 years, the “death” of the Relational Database Management System has been predicted over and over – and yet the platform survives. It has adapted, grown, improved and thrived. As a data professional, how does your career change as the platform changes? Which buzzwords are “real” – what do you need to learn, and what skills do you need to pursue? Come join Buck Woody, Microsoft’s “Real world DBA” and explore the history - and future - of the RDBMS.
Speaker(s):
- Buck Woody
Track and Room: DBA - Room1
Title: Think work like a Data Scientist with SQL 2016 R
Abstract: What are these DATA Scientists up to? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Big Data and Analytics - Room3
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Lord Richard Douglas
Twitter: - SQLRich
LinkedIn: Lord Richard Douglas
Contact: http://SQL.RichardDouglas.co.uk
Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
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
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.
Paul Randal
Twitter: - @paulrandal
Contact: http://www.SQLskills.com/blogs/paul
Paul’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and has been a SQL Server MVP ever since. When he’s not tweeting, blogging, or helping someone recover from a disaster, he’s likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp. Full bio at http://www.sqlskills.com/about/paul-s-randal/
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.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
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.
Buck Woody
Twitter: - BuckWoodyMSFT
LinkedIn: Buck Woody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
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.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
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.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Emma Reid
Twitter: - https://twitter.com/transponstergrl
LinkedIn: Emma Reid
Emma Reid is part of the Developer Experience team in Microsoft Ireland helping ISVs to build reliable and scalable solutions on Azure to delight their customers. She has over 15 years of experience in IT consultancy working for various local and multinational companies including Dell and Accenture delivering solutions for customers across Ireland.
Emma is passionate about technology and has a keen interest in AI and the Bot Framework. She is a strong advocate for diversity and inclusion with a focus on encouraging young women into STEM and as such delivers the “IT is not just for Geeks” program to teenage students in Dublin.
Chris Webb
Twitter: - @cwebb_bi
LinkedIn: Chris Webb
Contact: https://blog.crossjoin.co.uk/
Chris Webb is a member of the Power BI CAT team. He is the author of “Power Query for Power BI and Excel” and a co-author of “SQL Server Analysis Services 2012: The BISM Tabular Model”, “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”.
Andrew Pruski
Twitter: - https://twitter.com/DBAFromTheCold
LinkedIn: Andrew Pruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year’s experience. Originally from Wales but now living in Ireland
John Corley
Twitter: - johncorley
LinkedIn: John Corley
John Corley is CTO and co-founder of Spanish Point Technologies, an award winning software company working with Microsoft technologies to provide business systems which remove complexity, increase productivity and connect users to critical business information. John has been at the forefront of delivering large scale SQL Server based solutions in Azure in the North America and Europe.
Jens Vestergaard
Twitter: - @vestergaardj
LinkedIn: Jens Vestergaard
Contact: http://www.t-sql.dk
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).
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
Kimberly Tripp
Twitter: - @KimberlyLTripp
LinkedIn: Kimberly Tripp
Contact: http://www.SQLskills.com/blogs/Kimberly
Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!
SqlSatDublin .
SqlSatDublin
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.
Chrissy LeMaire
Twitter: - @cl
LinkedIn: Chrissy LeMaire
Contact: https://netnerds.net
Chrissy LeMaire is a Data Platform and PowerShell MVP who has worked in IT for over 20 years. She works for General Dynamics and serves as the SQL Server DBA at NATO Special Ops HQ in Belgium. She is also an avid scripter, and has used PowerShell since it was introduced in 2005 at the Microsoft Professional Conference in Los Angeles. Chrissy is the creator of the popular dbatools PowerShell module for SQL Server.
Chrissy recently achieved her MS in Systems Engineering at Regis University
Andy Leonard
Twitter: - AndyLeonard
LinkedIn: Andy Leonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
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.
Soren Johansen
LinkedIn: Soren Johansen
Soren has over 20 years of experience in analytics and worked for customers in Finance, Telco and Shipping / Transport industry. He is a frequent presenter at Universities and Conference on topics within Machine Learning and Big Data.
Soren has a keen interest in how Machine Learning is helping customers in solving business challenges and transform their business. He is very inspired by how AirBnB, Uber, Spotify and Netflix use Machine Learning and Big Data.
SqlSatDublin .
SqlSatDublin
Emanuele Zanchettin
Twitter: - @thinkIT
LinkedIn: Emanuele Zanchettin
Emanuele Zanchettin, after studying in Computer Engineering, began his career with DB2 in the banking sector in 1998. After a few years and a change of scope of application, he encountered Access and Oracle with which he subsequently worked for several years in data access tuning and database design for new application features. Since 2007 he has also launched into the SQLServer world 2K, 2005, 2008* and 201* and more importantly, since 2011, into Azure SQL Database (SQL Azure). In order to have a greater capacity for assessment and familiarity with the various technologies that the market offers, he has deepened his knowledge to include MySQL and DocumentDB. Today Emanuele is mainly involved in IT projects and database management.
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).
SqlSatDublin .
SqlSatDublin
Sponsors
The following is a list of sponsors that helped fund the event: