Event Location:
ISEP
Rua Dr. António Bernardino de Almeida, 431
Porto, Porto, Portugal
Abstract:
In this session Peter Willmot (who has developed embedded/IoT and similar applications with SQL back-ends for many years) will help you to understand some of the opportunities that SQL (and, to a lesser extent, .Net) offer when you need to design and build effective, scalable and secure IoT back-end platforms with SQL Server. The session content covers various aspects of a typical SQL IoT back-end notably including: - working work binary-opaque data streams using SQL CLR - leveraging SQL Service Broker and Queues for CQRS and deferred aggregation scenarios - consistent JSON handling across SQL versions - selecting optimal data types and indexes for IoT-typical data structures
Speaker(s): Peter Willmot,
Abstract:
The modern connected world requires connected solutions, beyond basic relational engine - think about web pages connections, social media network communications or map path finding. Even though one can implement eventually everything with a relational engine, the bigger amount of analysed data is involved, the less probable is that your analysis will be done on time and with acceptable ease for the developers. Graph databases do exist in the wild since 1960s, but only in the last 2 decades - with the advances of the internet, started to conquer wider recognition and usage. Let's dive into this diverse world of graph databases and discover the new kid on the block - the GraphDB in SQL Server 2017 Azure SQL Database, which promises to allow you to expand and convert your workloads for solving modern connected world problems.
Speaker(s): Niko Neugebauer,
Abstract:
DevOps and continuous integration provide huge benefits to data warehouse development. However, most BI professionals have little exposure to the tools and techniques involved. John will be showing how you can use Visual Studio Team Services (VSTS) to build and test your data warehouse code and how to use Octopus Deploy to deploy everything to UAT and production. This is a demo heavy session which will introduce you to exactly how powerful DevOps can be in practice and will cover: * Setting up Visual Studio Team Services to act as your build server * How to use Octopus Deploy to deploy your entire data warehouse * Developing a build-centric PowerShell script with psake * Building and deploying SQL Server Data Tools projects with DAC Publish profiles * Writing and running automated unit tests * The many problems of automating tabular model deployments Please visit John's blog for practical tips on how to apply DevOps techniques to your Data Warehouse: https://devops-your-dwh.
Speaker(s): John Tunnicliffe,
Abstract:
dbachecks is a framework created by and for SQL Server pros who need to validate their environments. It is a free, open source module (created by dbatools team) that allows data pros to crowdsource our checklists using PowerShell's open source testing framework, Pester. We all share similar checklists and mostly just the server names and RPO/RTO/etc change. We offer over 80 built-in checks. Imagine being able to easily ensure that: - Backups are being performed within your policy - Identity columns are not about to max out - Database integrity checks are being performed and corruption does not exist - Disk space is not about to run out - SQL Servers are compliant with DISA, CIS, and more Do you already run your Pester checks? No problem, we can run your tests too. And to top it off, we make it easy to email yourself or view the results of your tests in a gorgeous Power BI Dashboard. Join us to see how easy (and beautiful) it can be validate all of your SQL Server environments!
Speaker(s): Cláudio Silva,
Abstract:
Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.
Speaker(s): Christopher Adkin,
Abstract:
Many of Open Knowledge International's projects are technical in nature. Its most prominent project, CKAN, is used by many of the world's governments to host open catalogues of data that their countries possess. CKAN is a tool for making open data websites. (Think of a content management system like WordPress – but for data, instead of pages and blog posts.) It helps you manage and publish collections of data. It is used by national and local governments, research institutions, and other organizations who collect a lot of data. In this talk I'll go over some use-cases of Open Knowledge Platform implementations by the Portuguese Government, the architectural features, the difficulties and different approaches to solve them.
Speaker(s): Pedro Sousa,
Abstract:
Can you use GEOGRAPHY data types to calculate and display celestial phenomena and does it make sense? It needs some math and the willingness to use SQL objects for purposes, they haven’t been designed for. This session is a (hopefully) entertaining exercise to combine scarcely used data types with a bit of astronomy and math to calculate and visualize the relationship between sun and wind turbines (i.e. moving shadows that may annoy the neighbors) solely by using SQL Management Studio. Only GEOGRAPHY data type will be used to show the richness and beauty of its functionality. Apart from 2-3 formulas everything will be handled in SQL.
Speaker(s): Arne Bartels,
Abstract:
By PASS Summit there will be enough news about vNext of the SQL Server and the already publicly announced improvements for the Columnstore Indexes such as Online Rebuild for the Clustered Columnstore Indexes Batch Mode for the Rowstore Indexes will be available for everyone to test and who knows, maybe even put into production. Join me in discovering all documented and non-documented features and how they will affect your On-Premises and Cloud Instances.
Speaker(s): Niko Neugebauer,
Abstract:
Azure Cosmos DB is Microsoft's globally distributed, multi-model database. This is NoSQL in the cloud. In this session, you'll see how to use it to create columnar tables, JSON documents and graphs, you'll understand what that means, see what's the difference with relational tables, and how it can be useful for you.
Speaker(s): Rudi Bruchez,
Abstract:
Agile BI promises to deliver value much quicker to its end users. But how do you keep track of versions and prioritize all the demands users have? With Visual Studio Online (cloud version of Team Foundation Server) it is possible to start for free with 5 users, with Version Control, Work Item management and much more. In my session you will get the directions to a quick start with Visual Studio Online. You will learn the possibilities of Version Control and in which way to implement Scrum work item management with all available tools.
Speaker(s): Sander van der hoeff,
Abstract:
In-Memory OLTP has come a long way since it was first introduced in SQL Server 2014. Many of the early restrictions have been lifted, but still fear and uncertainty of adoption into Production environments exists. In this session, we will explain and demonstrate when, how, and where you should use In-Memory OLTP to improve your SQL Server performance. We will discuss using it in real-world production scenarios, highlighting administrator best practices, and developer use cases and considerations.
Speaker(s): Mark Broadbent,
Abstract:
This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.
Speaker(s): Joanna Wolthuis,
Abstract:
Power BI is an amazing BI platform out of the box, but there' is a lot of things that you can do with Power BI that probably you dont even imagine! Come to my session to find out....
Speaker(s): Rui Romano,
Abstract:
The concurrency model of most Relational Database Systems are defined by the ACID properties but as they aim for ever increasing transactional throughput, those rules are bent, ignored, or even broken. In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things. Attend this session and you will be assimilated!
Speaker(s): Mark Broadbent,
Abstract:
I find performance tuning to be one of the most challenging and interesting tasks as a DBA. In a session based on demonstrations, I'll show some real live performance issues and give tips that will boost performance from 4 to 100 times! Examples will cover both application queries and maintenance tasks and I'm sure you'll like it :-)
Speaker(s): Etienne Lopes,
Abstract:
Stream Analytics is the solution from Microsoft for event based data processing on Azure. The objective of this session is to show the value of real-time data insights with a fictional Car Racing Simulator, detailing the steps from the events source, until the analysis of the race telemetry.
Speaker(s): Murilo Miranda,
Abstract:
Service Broker is one of that features that every DBA knows that exists but just few of them uses, and these feature is awesome for some use cases. In this session I will show you where Service Broker can be very useful, how to configure and to solve the common errors.
Speaker(s): Ivan Campos,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://pt.linkedin.com/in/idcampos
Contact: http://wizarddba.com/
Ivan Campos is currently a database administrator in 3C Payment a fin-tech in Luxembourg. (3CPayment.com). He is Microsoft Most Valuable Professional, active speaker at local community meetings in Portugal and outside Portugal. He is the leader and one of the founders of the community based in the north of Portugal Porto.Data (www.portodata.net) and the organizer of SQLSaturday in Porto Portugal.
LinkedIn: https://pt.linkedin.com/in/claudioessilva
Contact: http://claudioessilva.eu
Cláudio works as SQL Server DBA and he is an former PowerShell MVP who loves to automate any process that needs to be done more than a couple of times. He is an active member on the PowerShell and SQL communities. He contributes to dbatools project (https://dbatools.io) and is always available to help. You can find him on slack and twitter platforms. He also helps on some Portuguese in-person events such as SQLSaturday Lisbon and TugaIT. He is also a regular speaker on these and other events.
LinkedIn: http://www.linkedin.com/in/drjohntunnicliffe
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 SQL Saturday events, John has covered topics such as building an infrastructure to support real-time OLAP and continuous integration and the data warehouse.
LinkedIn: https://pt.linkedin.com/in/pmsousa
Contact: http://www.devscope.net
Pedro Sousa lives in Porto, Portugal and he currently works as a Senior IT Operations Analyst at Basecone. Started working with SQL Server at version 6.5 and although DBA is not his primary role, always had a particular interest for it. Nowadays one of his main focus is Microsoft Azure and integration with on-premises networks, working from the copper wire to the Cloud.
LinkedIn: http://www.linkedin.com/in/retracement
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.
LinkedIn: https://fr.linkedin.com/in/rudibruchez
Contact: http://www.babaluga.com/
(same as before)
LinkedIn: http://pt.linkedin.com/in/murilomiranda/
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.
LinkedIn: http://nl.linkedin.com/in/shoeff
Contact: http://www.du-sabot.nl
With over 20 years of experience in automation Sander van der Hoeff knows his way around in the ICT business. Since 2000 Sander is Specialized in business intelligence and data warehousing using the full SQLServer Stack. In 2012 Sander founded his own BI-company: Du Sabot. Nowadays Sander spends his time on several BI- and DWH-projects as an independent professional. Sander combines deep technical knowledge with the capability to explain difficult BI- and DWH-concepts to the non-technical people
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: SQL Saturday and 24 Hours of Pass. Blog: http://sqland.wordpress.com/
Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms. Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.
LinkedIn: https://pt.linkedin.com/in/ruiromano
Contact: http://ruiromanoblog.wordpress.com/
Rui Romano lives in Portugal and he leads the Business Intelligence team at DevScope. He has been Developing amp; Architecting software solutions since 2003 always focused in the Business Intelligence area.
LinkedIn: https://www.linkedin.com/in/joannawolthuis/
Joanna Wolthuis is an independent contractor specialising in T-SQL database development and reporting using SSRS and Excel based solutions for the last 8 years. She is passionate about data and learning everything about anything. Aside from SQL Joanna enjoys traveling, nice food and attempting to be an acrobat (not at the same time!).
LinkedIn: http://pt.linkedin.com/in/webcaravela/
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.
LinkedIn: https://www.linkedin.com/profile/view?id=207669359amp;trk=nav_responsive_tab_profile
Master of physic in Germany 2000, worked as MS Flightsimulator Expert on the side. Employed at OLTEC Windamp;Solar as C++/Web/PHP/MySQL -Programmer. Company bought by Vestas 2004 shifting to MS-SQL,SSIS until now.
LinkedIn: http://pt.linkedin.com/in/webcaravela/
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.
LinkedIn: http://www.linkedin.com/in/retracement
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.
LinkedIn: https://www.linkedin.com/in/wollatondba
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.
The following is a list of sponsors that helped fund the event.