SQLSaturday #267 - Lisbon 2014
Event Date: 04/12/2014 00:00:00
Event Location:
- Microsoft Portugal (Parque das Nações, (junto ao Oceanário))
- Rua do Fogo de Santelmo, Lote 2.07.02
- Lisbon, , Portugal
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: Power View from the Data Visualisation Perspective
Abstract: Power View is Microsoft’s Data Visualisation tool. Where does it get it right, and where does it get it wrong? Using demos, we learn about Power View whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will:
- investigate Power View based on current cognitive research around Data Visualisation principles
- look at the features of Power View
- look at where Power View is supplemented by other parts of the Microsoft Business Intelligence stack
Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View.
Speaker(s):
- Jen Stirrup
Track and Room: 5 - Mixed Data - N/A
Title: Optimising a dot.net solution on the SQL platform
Abstract: In this case study we will take a sample dot.net ecommerce application running in a load test harness and show common performance worst practices, how to correct them and the impact on performance. During a series of live demos we aim to test just how far we can optimise transactional processing.This session is aimed to help developers and DBA’s understand the performance impact of choices made within a dot.net application and its interaction with SQL Server.
Speaker(s):
- Bob Duffy
Track and Room: 4 - Super Development - N/A
Title: Olde Cluster Curiosity Shoppe - A Miscellany of top tips from the field
Abstract: Welcome to the strange and mysterious world of SQL Failover Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from the nearly two decades of installing and troubleshooting SQL Clusters.
Speaker(s):
- Mark Broadbent
Track and Room: 6 - Clustered Data - N/A
Title: Entity Framework 6 New Features
Abstract: TThis talk is about new features in Microsoft Entity Framework 6 - the new major release of EF. In December 2012 Entity Framework 6 beta was announced and made publicly available. In October 2013 were released EF 6.00 (major release) and EF 6.01. This is the first new version of EF since the announcement in 2012 that the product would be Open Sourced. Entity Framework is hosted on CodePlex. This presentation is about the new features, included in EF 6: Async Query and Save, Custom Code First Conventions, Multi-Tenant Migrations, Configurable Migrations History Table, Code-Based Configuration, Dependency Resolution, Updated Provider Model, Enums, Spatial and Better Performance on .NET 4.x, Stored Procedures Functions in Code First, Connect
Speaker(s):
- Mihail Mateev
Track and Room: 2 - Developers - N/A
Title: SQL Server and XML Query
Abstract: XML was added to the collection of SQL Server native data types in SQL Server 2005. Being a complex data type, not only is XML accompanied by a set of dedicated T-SQL functions, but also with a complete querying language. In this session you will learn about the Microsoft SQL Server 2008 implementation of the World Wide Web Consortium’s XML Query Recommendation, and learn how to compose XML data – from existing SQL Server data or simply “from scratch”, how to retrieve (relational) data from XML Documents to be used in a SQL Server database, and how to manipulate XML data using Transact-SQL and the XML Data Manipulation Language (XML DML). You’ve already mastered all the primitive SQL Server data types, why would XML be an exception?
Speaker(s):
- Matija Lah
Track and Room: 4 - Super Development - N/A
Title: How to Think Like the Engine
Abstract: You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this session with Microsoft Certified Master Brent Ozar, you’ll role play as the database engine while Brent gives you queries. You’ll learn first-hand about clustered indexes, nonclustered indexes, execution plans, sargability, statistics, TempDB spills, and T-SQL anti-patterns.
Speaker(s):
- Brent Ozar
Track and Room: 1 - DBA - N/A
Title: Analytical Data Mining - Using Data Mining to Understand Data
Abstract: Data mining is a technique used to derive previously unknown information from large amounts of data. The process of this knowledge discovery can help uncover new patterns within data and help analysts better understand the large datasets. Additionally, once these patterns have been defined, you can use them as part of predictive modelling estimating the likelihood of some event occurring.
SQL Server Analysis Services includes a data mining engine that can be used at various levels within an organization, from analyst to developer. This session will look at data mining as tool for data investigation by the business analyst. We examine the business case, requirements and outcomes of data mining so that it can enhance our understanding of datasets. We will look at both simple and complex implementations of data mining that allow new information to be extracted from data and used in novel ways within the MS Stack.
Speaker(s):
- Paul te Braak
Track and Room: 7 - Free Data - N/A
Title: Real-Life SQL 2012 and 2014 Availability Group Deployments
Abstract: You want to deploy AlwaysOn, but you’re concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 and SQL 2014 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he’s found in real-life deployments of AlwaysOn.
Speaker(s):
- Brent Ozar
Track and Room: 1 - DBA - N/A
Title: Data auditing
Abstract: This presentation’s want to demonstrate some features of Data Auditing in SQL Server 2012. What are the advantages and disadvantages of its use, where and in what environments to apply. The three approaches used were : • DML Triggers • Change Tracking • Change Data Capture
Speaker(s):
- Quilson Antunes
Track and Room: 2 - Developers - N/A
Title: SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive
Abstract: You have heard about Hekaton, respectively the new Acronym XTP (eXtreme Transactional Processing) and you want to know how it works under the cover? In this session we will take a closer look at the architecture, where the performance benefits come from and how it works in detail. What kind of files is SQL Server using for transactional consistency, what happens when you delete data inside the log and inside the data files. We will see the Merge-Process and the Garbage collector in action, see how memory management works for XTP enabled databases, and thereby get an in-depth understanding of how this completely new storage engine works and how to optimize for it.
Speaker(s):
- Andreas Wolter
Track and Room: 1 - DBA - N/A
Title: Powershell: The DBA as a consumer
Abstract: Focus for this session is demonstrating some quick benefits Powershell brings to day-to-day operations for a DBA and some gotchas experienced during the learning curve.
Speaker(s):
- Johan Bijnens
Track and Room: 1 - DBA - N/A
Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive
Abstract: Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine.
Speaker(s):
- Scott Klein
Track and Room: 4 - Super Development - N/A
Title: Project Sienna - The gist
Abstract: Let’s get to know Project Sienna and build simple apps for Windows 8.
Speaker(s):
- Paulo Matos
Track and Room: 6 - Clustered Data - N/A
Title: Clustered Columnstore Deep Dive
Abstract: When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.
Speaker(s):
- Niko Neugebauer
Track and Room: 1 - DBA - N/A
Title: Integrating Big Data with SharePoint 2013
Abstract: Are you currently working with Big Data? Do you wish it were easy to share that information with key stakeholders in your organization? In this demo-driven session, you will learn how to take the analysis you’ve done and share it with the entire organization via SharePoint 2013.
We will look at surfacing Big Data via Excel with PowerView and eventually publishing it in a SharePoint 2013 farm. We will also look at the security and performance implications of integrating Big Data with SharePoint 2013, so you will be able to properly design your Business Intelligence infrastructure.
Speaker(s):
- Edwin M Sarmiento
Track and Room: 5 - Mixed Data - N/A
Title: Securing SQL Server
Abstract: Protecting our data from unwanted access is extremely important, wouldn’t you agree? In this session, using lots of demos to ilustrate each situation, I’ll cover some pretty relevant topics such as: Authentication; SQL Injection; Encryption (source code/sensitive data/entire database/comunications/encrypted backups (new in SQL 2014)); Proper use of permissions over database objects (using intermediate layer, execution context, users without login, etc.); Proxy accounts; alerts for potencial security risks when using clr integration or database cross ownership; Auditing and more…
Speaker(s):
- Etienne Lopes
Track and Room: 4 - Super Development - N/A
Title: DBAs are from Mars, SharePoint admins are from Venus
Abstract: SharePoint databases are considered a black box - touch them and you lose support. Furthermore, SharePoint leaves an unintelligible track of database names and GUIDs on your server. They are supposed to scale, but how and how much? Here are some techniques DBAs should be aware of to optimize SharePoint performance and scalability. This demo-packed session, based on real-life experiences, will show you how to tune your SQL Server for SharePoint and how to customize your SharePoint installation so that it fits your IT conventions, not the other way around.
Speaker(s):
- Regis Baccaro
Track and Room: 5 - Mixed Data - N/A
Title: The Transaction Log and How It Affects HA/DR
Abstract: When choosing the appropriate SQL Server HA/DR solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you choose. In this session, we will look at transaction log basics, how logging and recovery works and how it affects all of the HA/DR solutions available in SQL Server. You’ll be surprised to know that the transaction log is the most important part of your database.
Speaker(s):
- Edwin M Sarmiento
Track and Room: 1 - DBA - N/A
Title: Handling Errors and Data Anomalies in SSIS
Abstract: Even in the most reliable ETL system, it’s eventually going to happen: A package will fail, an output row count won’t match what is expected, a data anomaly will force a forensic search of the package infrastructure… In this session, we’ll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we’ll cover various ways to keep your ETL flowing when problems arise.
Speaker(s):
- Tim Mitchell
Track and Room: 3 - Business Intelligence - N/A
Title: Happy as a Pig in Muck
Abstract: This session will take a look at Pig. Pig is a platform for analysing large datasets using a high level language in Hadoop. It is easy to use, intuitive and embarrassingly parallel. It was developed in order to avoid the complexities of Map Reduce. It is useful for ad-hoc analysis and of course ETL. During this session we will see it being used to manipulate structured and unstructured data.
Speaker(s):
- Allan Mitchell
Track and Room: 6 - Clustered Data - N/A
Title: 15 Quick Tips for SSIS Performance
Abstract: When reviewing your ETL processes, the No. 1 question is always, “Does it work as expected?” Closely following that question is the ubiquitous, “How fast does it run?” This session’s tips are targeted at improve the latter.
In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
Speaker(s):
- Tim Mitchell
Track and Room: 3 - Business Intelligence - N/A
Title: MDX, it is not that hard!
Abstract: My first experience with MDX was: good, it looks like SQL: SELECT .. FROM .. WHERE. On my second glance it turned out to be completely different than SQL. But after a while SQL and MDX started to feel similar. In this session I bring you to the point of seeing the similarities instead of the differences. We will use your SQL experience to give you a head start with MDX. The session is also good for those with a bit of experience who want to know a bit more about the background. Of course all theory is backed by demo’s.
Speaker(s):
- Peter ter Braake
Track and Room: 7 - Free Data - N/A
Title: SQL Server 2014 - New Cardinality Estimator
Abstract: In SQL Server 2014 query processing has been improved. What we can expect from new cardinality estimator? Does it really estimate better? Will our execution plans be better after migration to 2014? All of them? Is the key ascending column statistics problem solved in new version? Do we finally can have more than 200 steps in the statistics histogram per table? What about column correlation and cardinality estimates - are the predicates still completely independent?
This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.
Speaker(s):
- Miloš Radivojević
Track and Room: 2 - Developers - N/A
Title: SQL Server Data Tools - The IDE for database developers
Abstract: Since March 2012, SQL Server Data Tools (SSDT) are available for database developers as a project-based development environment within Visual Studio.
Although SSDT is installed automatically with Visual Studio 2012, this method of database development and the functions provided are completely new to many developers.
This session aims to change that and to provide an overview of the advantages and potentials of SSDT. You will see how you can develop, debug, refactor, deploy and maintain SQL Server and Azure databases from a single IDE.
Speaker(s):
- Constantin Klein
Track and Room: 4 - Super Development - N/A
Title: Smart SSIS with BIML
Abstract: In this presentation we will show you the power that lies in BIML for SSIS – the power to subtract a significant amount of time from repetitive tasks and add that to tasks that bring real value. Join us for a session where we will show hands-on how to use BIML to generate an SSIS BI framework. This session will be co-presented with João Lopes.
Speaker(s):
- Fernando Marçal
Track and Room: 6 - Clustered Data - N/A
Title: Analyzing Query Plans Deep Dive
Abstract: Query plan shows how your query is physically executed and without a doubt, it is the best way to analyze most of the performance problems. We will delve into the internals of query plan operators, investigate how they work and where to look into query plan to find any problems.
Speaker(s):
- Sergey Olontsev
Track and Room: 4 - Super Development - N/A
Title: Visualization Choices: What, When, and How?
Abstract: When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models.
Speaker(s):
- Paul Turley
Track and Room: 3 - Business Intelligence - N/A
Title: Tabular Models: Easier Faster Than Cubes; Really?
Abstract: The future of data analysis is the new, in-memory xVelocity Tabular analytic engine but is this new product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012? Maybe… It depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.
Speaker(s):
- Paul Turley
Track and Room: 3 - Business Intelligence - N/A
Title: Data in, Information out
Abstract: Get a look through the tools that enable us to get information from data. In the last years BI became something that we all can get! Experience some of the patterns, tools and visualizations that are enablers of that change. SQL Tools through Excel is one of the keys…
Speaker(s):
- Bruno Basto
Track and Room: 5 - Mixed Data - N/A
Title: Top 10 Performance Tips for SQL Server Developers
Abstract: Performance of a SQL Server depends on many factors and due to the nature of development SQL Server developers sometimes miss basic performance tips. Easily implemented tips such as using an appropriate index or solving a data mismatch problem on where conditions could affect the application performance significantly. In this session, we will cover the top 10 tips to improve the performance of your SQL Server with real life examples.
Speaker(s):
- Turgay Sahtiyan
Track and Room: 2 - Developers - N/A
Title: Good fellows: System Center and SQL Server
Abstract: Let’s meet these two friends that can help us in our daily lives. The System Center Operations Manager can greatly help us to manage our SQL Server. Let’s see what is the SCOM and meet some tips for monitoring our server SQL-server.
Speaker(s):
- Pedro Simoes
Track and Room: 7 - Free Data - N/A
Title: Hekaton challenges from Database Development point of view
Abstract: This session covers the Hekaton challenges for the developers at the 300-400 level including native compiled SPs but also some concerns about hekaton constraints etc.
Speaker(s):
- Miloš Radivojević
Track and Room: 2 - Developers - N/A
Title: Introduction to NoSQL
Abstract: Understanding when and how to use NoSQL is already becoming essential, even for database professionals currently focusing only on the RDBMS world. This session will explain NoSQL for the SQL Server professional, discussing the history and needs that led to NoSQL solutions and the strengths and weaknesses in comparison with RDBMSs. We’ll also explore the several NoSQL data models available in the market today (Key-Value, Column-Family, Document, and Graph) and cover the current solutions that implement them (Cassandra, MongoDB, Redis, Neo4j, etc.).
Speaker(s):
- Nabeel Derhem
Track and Room: 7 - Free Data - N/A
Title: Power BI - The self service BI Lifecycle in the cloud
Abstract: With the new Power BI Preview Microsoft brings more Self-service BI functionality to the users. In this session we will look from a different perspective to the offering: What about Governance, Application LifeCycle, Enterprise Integration? We will review what is currently possible in the preview for sharong querys, integrating the cloud offering with your enterprise data sources, monitoring datasources and gateways and what is possible to use it on Windows Mobile devices. This session is complete demo driven.
Speaker(s):
- Oliver Engels
Track and Room: 3 - Business Intelligence - N/A
Title: Clustered Instance - Storage Introduction
Abstract: With the evolution of SQL Server new possibilities are being opened, and today we have a vast range of possibilities to achieve our objectives. For a clustered instance is not different, as nowadays a shared storage living in a SAN is not the only possibility.
On this session I will introduce all the available ways to store database files in a clustered SQL Server instance, including the news of SQL Server 2014. If you never installed or even worked with a clustered instance, this is not an issue! A quick introduction about the role of clustered instance will be made.
I’ll wait for you there!
Speaker(s):
- Murilo Miranda
Track and Room: 6 - Clustered Data - N/A
Title: High Performance Statistical Queries
Abstract: SQL Server 2012 database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient statistical queries that use the new Window functions and are optimized through proper indexing, including columnstore indices. We will also explain the formulas and usage of those statistical procedures. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.
Speaker(s):
- Dejan Sarka
Track and Room: 2 - Developers - N/A
Title: Improving our BI solutions with Geolocated data
Abstract: The Business Intelligence capabilities are with us several years. Nowadays,the needs of analysis have changed and the geolocation of data is essential - not only qualitative information. We need to see our data on maps. We need to integrate it with external services to add value to our insights. In this session you will learn to improve our BI solutions with geolocation and take advantage with the SharePoint tools to share and publish this information. Custom DLLs, Excel Apps, Tabular/Multidimensional techniques and the new Power BI capabilities will be shown in different examples using a mapping tool already developed by SolidQ.
Speaker(s):
- Ruben Pertusa Lopez
Track and Room: 6 - Clustered Data - N/A
Title: M versus P versus R - Languages for Data Exploration
Abstract: Power Query the new Excel Add In is a great data exploration toolset combined with other add ons like Power Pivot, Power View and Power Map This session will take a deep dive into the language behind the Power Query: “M”. We will take the language concepts and possibilities and try to compare them with another cool kids in town: “R” and “P” aka Python. What possibilities do these languages offer, where can you use them best and how good is the integration to the Microsoft stack. The session is driven by demos and you will take away a good starting point how to work with these three languages.
Speaker(s):
- Oliver Engels
Track and Room: 3 - Business Intelligence - N/A
Title: Create Your Own Aggregate
Abstract: Have you ever flipped the pages of Books Online, only to find that the aggregate function you need is simply not there? So why not add it? Ever since SQL Server 2005, you can easily create your own aggregate functions. All it takes is a bit of .NET code. This session will show you exactly how to create a CLR user-defined aggregate function, and how to use it in your queries. But it will also show you many workarounds to avoid having to do this for many commonly requested aggregates.
Speaker(s):
- Hugo Kornelis
Track and Room: 5 - Mixed Data - N/A
Title: SQL PDW vs SQL Server, let’s see the big differences
Abstract: In this session we will present a live comparison between the SMP and MPP versions of SQL Server, with a special attention to architecture and Performance, and the spirit of the session will be “Forget the slides… let’s just do Demos”
Speaker(s):
- Artur Vieira
Track and Room: 5 - Mixed Data - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Sergey Olontsev
Twitter: - SergeyOlontsev
LinkedIn: Sergey Olontsev
Contact: http://SergeyOlontsev.com/
I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions . I’m a regular speaker at SQL Server user group meetings, SQLSaturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.
Edwin M Sarmiento
Twitter: - EdwinMSarmiento
LinkedIn: Edwin M Sarmiento
Contact: http://www.EdwinMSarmiento.com
Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Paul te Braak
Twitter: - @paultebraak
LinkedIn: Paul te Braak
Contact: http://www.paultebraak.wordpress.com
Paul te Braak is the principle consultant of abaX Data and has over a decade of experience in delivering reporting and business intelligence solutions across a variety of verticals. This experience includes systems auditing, planning and business simulation models that predict activity through heuristic rules imbedded into the model. He holds several qualifications including MCT, CA, MIT, MComm.
Oliver Engels
Twitter: - @oengels
Contact: http://www.ssis-components.net
Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.
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.
Paulo Matos
Twitter: - @pjtmatos
LinkedIn: Paulo Matos
Contact: http://www.paulomatos.com
From the dawn of 1977 he came; moving silently down through the years; living a not so secret life, struggling to reach the time of another SQLSaturday Portugal when the few who remain will be speaking to the last. No one has ever known or care that he was among you… not even now!
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.
Oliver Engels
Twitter: - @oengels
Contact: http://www.ssis-components.net
Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.
Jen Stirrup
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
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.
Nabeel Derhem
Twitter: - @NabeelDerhem
LinkedIn: Nabeel Derhem
Nabeel is a data culture passionate who works at Microsoft as a Data Platform Architect. His +15 years of experience with data platform technologies moved him through OLTP, DW, BI, ML, and cloud. As an ex SQL Server MVP (until joining Microsoft), Nabeel is still a regular speaker on international events.
Etienne Lopes
Contact: https://sqland.wordpress.com
Etienne Lopes currently works as a SQL Server DBA at Celfinet. Working with SQL Server since 1997, member of sqlport community (www.sqlport.com), regular speaker since 2012 at SQL Server events such as: SQLSaturday and 24 Hours of Pass. Blog: http://sqland.wordpress.com/
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
Bob Duffy
Twitter: - @bob_duffy
LinkedIn: Bob Duffy
Contact: http://blogs.prodata.ie/author/bob.aspx
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.
Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.
Mark Broadbent
Twitter: - @retracement
LinkedIn: Mark Broadbent
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
Pedro Simoes
Twitter: - @pedro_mg_simoes
LinkedIn: Pedro Simoes
Contact: http://pedromsimoes.wordpress.com
Works in Glintt - Global Intelligent Technologies (http://www.glintt.com) as a systems administrator and DBA in some specific situations; has about 20 years experience and has some certifications which can highlight the following: MCP, MCSA 2003 MCDBA, MCSE 2003, MCTS, MCITP (Windows 2008 + SQL2008). It is one of the oldest and most active members of the Portuguese community SQLPORT.com
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Quilson Antunes
LinkedIn: Quilson Antunes
Quilson Antunes #233; DBA na hmR - Health Market Research, licenciado em Inform#225;tica de Gest#227;o pelo SLA Campus Lisboa - Laureate International Universities. No decurso do seu percurso profissional adquiriu experi#234;ncia na coordena#231;#227;o de recursos e compet#234;ncias em infra-estrutura e desenvolvimento de processos ETL. Cumulativamente possui s#243;lidos conhecimentos em administra#231;#227;o, desenho e desenvolvimento de bases de dados em SQL server desde a vers#227;o 7
Artur Vieira
Artur Vieira, has a degree in Computer Engineering awarded by the ISIG and a Post-Graduation in Business Intelligence at Instituto de Ciências do Trabalho e da Empresa. With several years of experience in Development and Support to BI platforms. In 2011 joined the PFE SQL/BI Team at Microsoft Portugal where we provides strategic and operational support on the MS Business Intelligence Stack, working with SSAS, SSIS, SQL Parallel Data Warehousing, Development and Workshop delivery on BI Stack.
Turgay Sahtiyan
Twitter: - https://twitter.com/turgaysahtiyan
LinkedIn: Turgay Sahtiyan
Contact: http://www.turgaysahtiyan.com/
Turgay Sahtiyan has been working in IT industry over a decade and he currently works as a PMC (Premier Mission Critical) Solution Engineer at Microsoft.He is based in Turkey and primarily giving proactive and reactive services with solution based approach to top enterprise customer in the MEA region.Before joined to Microsoft, he was one of the SQL Server MVP in Turkey,in addition he is founder and former president of SQLPass Turkey Chapter.(Detailed BIO http://www.turgaysahtiyan.com/about.aspx)
Edwin M Sarmiento
Twitter: - EdwinMSarmiento
LinkedIn: Edwin M Sarmiento
Contact: http://www.EdwinMSarmiento.com
Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
Scott Klein
Twitter: - SQLScott
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
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.
Ruben Pertusa Lopez
Twitter: - @rpertusa
LinkedIn: Ruben Pertusa Lopez
Contact: http://www.sqlpass.es
Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.
Allan Mitchell
Twitter: - @allanSQLIS
Contact: https://onlysearch.wordpress.com/
Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Murilo Miranda
Twitter: - murilocmiranda
LinkedIn: Murilo Miranda
Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Johan Bijnens
Twitter: - @alzdba
LinkedIn: Johan Bijnens
Johan Bijnens is a database firefighter, involved with SQLserver since 2000, who works at Aperam Genk as member of the Industrial IT support department. Involved in designing architectural solutions based on the Microsoft SQL Server Platform. Performing operational performance and troubleshooting support in co-operation with the dev teams.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Andreas Wolter
Twitter: - AndreasWolter
LinkedIn: Andreas Wolter
Contact: http://www.andreas-wolter.com/blog/
Andreas Wolter is a Program Manager for SQL Server- and Azure Security at Microsoft. In this role he is working on Security features of SQL Server, Azure SQL Database and Managed Instance. He is currently focusing on “Separation of Duties”-concepts and RBAC-Integration. He has 18 years of experience with SQL Server before joining Microsoft and is the founder of Sarpedon Quality Lab, the Germany-based company specialized on SQL Server HA, Performance and Security. He is Microsoft Certified Master (MCM) for SQL Server and Microsoft Certified Solutions Master for the Data Platform (MCSM) and was recognized as MVP for multiple years in row.
Bruno Basto
Bruno Basto, senior consultant #160;and senior trainer #160;at Rumos. SQL certified since 6.5 version (1998). Work with MSFT tools and infrastructure since 1992 in the financial, banking and insurance areas. Responsible for several training projects for software solutions with MSFT infrastructure. Speaker at several MSFT and SQLPass events.
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
Constantin Klein
Twitter: - KostjaKlein
Contact: http://kostjaklein.wordpress.com
Constantin is working at Syntax Systems GmbH Co. KG. He mainly deals with the design and development of solutions based on Microsoft products and technologies. Since 2010 he was each year designated Most Valuable Professional (MVP) for the Microsoft Data Platform. In addition he is member of the board of Just Community e.V. (http://www.justcommunity.de) and PASS Deutschland e.V. (http://www.sqlpass.de). He also leads the .NET User Group Frankfurt/Germany (http://dnug-frankfurt.de). Find his blog at: http://kostjaklein.wordpress.com
Peter ter Braake
Twitter: - @pbraake
LinkedIn: Peter ter Braake
Peter ter Braake, SQL Server MVP, co-founder of the Dutch PASS Chapter and organizer of the Dutch SQLSaturday, teaches SQL Server since 2002. Teaching is for Peter the perfect opportunity to share his SQL Server knowledge and his enthusiasm for the product. Since 2008 he works as an independent contractor giving him the opportunity to use his classroom experience in the real world and use his real world experience in the classroom.
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.
Fernando Marçal
Twitter: - @darthsql
LinkedIn: Fernando Marçal
Contact: http://sqlargonauts.com/
Fernando Mar#231;al is a father to two wonderful boys and husband to a lovely wife. Has been living and breathing Microsoft SQL Server Business Intelligence for the last 11 years (since version 8.0) and, as a paradigm of a good Portuguese, tries to be a specialist in every component of the stack. Works as an PFE at Microsoft and really enjoys everything that is business analytics related.
Sponsors
The following is a list of sponsors that helped fund the event: