Loading…
Techorama 2017 has ended

Log in to bookmark your favorites and sync them to your phone or calendar.

Data [clear filter]
Tuesday, May 23
 

10:00

Trump vs Clinton: Data Visualisation Lies & how to spot them
During the acrimonious US election, both sides used a combination of cherry-picked polls and misleading data visualization to paint different pictures with data. In this session, we will use a range of Microsoft Power BI and SSRS technologies in order to examine how people can mislead with data and how to fix it. We will also look at best practices with data visualisation. We will examine the data with Microsoft SSRS and Power BI so that you can see the differences and similarities in these reporting tools when selecting your own Data Visualisation toolkit. Whether you are a Trump supporter, a Clinton supporter or you don't really care, join this session to spot data lies better in order to make up your own mind.

Speakers
avatar for Jen Stirrup

Jen Stirrup

Speaker, Techorama
Jen Stirrup, recently named as one of the top 9 female Business Intelligence experts globally, is a well-known Business Intelligence & Data Visualization expert, MVP, PASS Director, author, data strategist, & worldwide technical community leader.


Tuesday May 23, 2017 10:00 - 11:00
Room 14

11:30

Cardinality Estimates in SQL Server
SQL Server 2014 introduced a new cardinality estimator (CE). This feature allows for statistics to be calculated differently than previous versions of SQL Server, often (but not always) resulting in better query performance.

Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance. We will discuss the differences between the legacy and new CE, discuss examples, see the CE in action, and discuss tips and tricks for you to deploy in order to make certain your queries are getting the best execution plans.

Speakers
avatar for Thomas LaRock

Thomas LaRock

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, SQL Server MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator. LaRock... Read More →


Tuesday May 23, 2017 11:30 - 12:30
Room 11

11:30

PowerShell ❤️ SQL Server: Modern Database Administration with dbatools and dbareports
Join PowerShell MVP & DBA Chrissy LeMaire and PowerShell Expert & DBA Rob Sewell to learn how you can take advantage of some amazing community modules to improve your work/bacon life balance.

We will show you how to perform many DBA tasks easily and simply using PowerShell. Need to properly configure tempdb? We've got you covered. Not sure if all of the SQL Servers in your estate are set to the proper power plan? A single PowerShell command can help. Want to alter the schedule for an Agent Job on dozens, hundreds or even thousands of servers? We will teach you how easy that is, along with many other solutions as well as showing you how to easily gather information about your estate and display it in SSRS or PowerBI.

Our session is aimed at DBAs, from junior to senior, who want to embrace the latest methods and increase their toolset.

Speakers
avatar for Chrissy Lemaire

Chrissy Lemaire

Chrissy LeMaire is a PowerShell MVP and creator of dbatools, the SQL Server migration and best practices module. She is also lead for the Belgian PowerShell User Group and co-lead for the PASS PowerShell Virtual Chapter. Chrissy is currently pursuing an MS in Systems Engineering at... Read More →
avatar for Rob Sewell

Rob Sewell

Rob is a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). He is an officer for the PASS PowerShell Virtual Chapter and has spoken at and volunteered at many events. He is a member of the committee that organises SQL Saturday Exeter and also... Read More →


Tuesday May 23, 2017 11:30 - 12:30
Room 10

13:45

Democratizing Data Science
In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.
Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure.
These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data? Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.

Speakers
avatar for Kimberly Hermans

Kimberly Hermans

Kimberly Hermans is one of the resident data scientist at Ordina. She helps companies in industries like banking, telco and utilities to a more data-driven set-up with a focus on customer excellence in their journey.   Her main expertise lies with customer experience and customer... Read More →
avatar for Jan Mulkens

Jan Mulkens

Jan Mulkens is a Microsoft Data Platform & BI Consultant and the Competence Center Lead for Microsoft Advanced Analytics at Ordina Belgium. In his spare time, he is a co-founder of the Global Power BI virtual user group, speaker at conferences and usergroup meetups. You can follow... Read More →


Tuesday May 23, 2017 13:45 - 14:45
Room 9

13:45

UNIQUEIDENTIFIERs as Primary Keys in SQL Server
UNIQUEIDENTIFIERs as Primary Keys in SQL Server - a good or bad best practice? They have a lot of pros for DEVs, but DBAs just cry when they see them enforced by default as unique Clustered Indexes. In this session we will cover the basics about UNIQUEIDENTIFIERs, why they bad and sometimes even good, and how you can find out if they affect the performance of your performance critical database. If they are affecting your database negatively, you will also learn some best practices how you can resolve those performance limitations without changing your underlying application.

Speakers
avatar for Klaus Aschenbrenner

Klaus Aschenbrenner

Klaus Aschenbrenner provides with his company SQLpassion SQL Server consulting & training services across Europe. Klaus works with SQL Server for more than 16 years. Klaus has also written the book Pro SQL Server 2008. Further information about Klaus you can find on his homepage at... Read More →


Tuesday May 23, 2017 13:45 - 14:45
Room 2

15:00

From Zero to Power BI Superhero
In this session you will learn about Power BI, starting from zero. By the end of the session you’ll have a clear understanding on how to ingest, visualize data, build dashboards, share and collaborate and understand how to integrate Power BI with SQL Server Reporting Services, Embed in applications, and websites and analyze data on any device.

Speakers
avatar for Dandy Weyn

Dandy Weyn

As worldwide technical lead for Data Insights and IoT, Dandy works with the largest customers on digital transformation in the enterprise. He supports our teams of deep technical global blackbelts and solutions architects on SQL Server, Azure Data Services, Machine Learning and IoT... Read More →


Tuesday May 23, 2017 15:00 - 16:00
Room 14

15:00

Indexes - The Unsung Heroes of SQL Server 2014/2016
Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Speakers
avatar for Pinal Dave

Pinal Dave

SQL Server Expert, SQL Authority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4100 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years... Read More →


Tuesday May 23, 2017 15:00 - 16:00
Room 9

16:30

Big Data technology choices
The "Big Data Technology Landscape" looks like a typical century old but modern metropolis: chaos and hectic movement. New trendy districts are being build while other are degrading into slums. As an independent applied research lab ("Sizing Servers"), we participated in many innovative big data projects of several Flemish small businesses. So while the big data landscape is still a chaotic mess to us, we have learned the advantages and disadvantages of quite a few big data technologies the hard way. Join us as we discuss building a data pipeline for different use cases, using open source technology within the budget constraints of a typical SME.

Speakers
avatar for Johan De Gelas

Johan De Gelas

Johan started his career at the Fortis Bank in 1995, first as an IT-analyst, later as member of the SAP ERP-implementation team. Since 1998 he was active as a technical writer about server technology for ZDNet, ITProfessional and Anandtech.com. Since 2001, he has been combining this... Read More →


Tuesday May 23, 2017 16:30 - 17:30
Room 4

16:30

Performance Tuning and Monitoring for Virtualized Database Servers
Successful virtualization of database platforms such as SQL Server requires a different approach than other servers in your enterprise. Maintaining reliable database performance after the database has been virtualized is dependent upon providing a clear view of performance metrics beyond traditional SQL Server metrics. DBAs need insight into these performance metrics at the virtual layer in order to apply effective performance tuning methods.
 Attend this session to discover key virtual performance tips and tricks, which metrics matter the most, and the architectural design choices that will help you prepare and validate your VMware environment for your database workloads.

Speakers
avatar for Thomas LaRock

Thomas LaRock

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, SQL Server MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator. LaRock... Read More →


Tuesday May 23, 2017 16:30 - 17:30
Room 12

17:45

Database Development with SQL Server Data Tools
SQL Server Data Tools (SSDT) is a powerful integrated development environment for designing, testing, and deploying SQL Server databases — whether you’re working locally or remotely, connected or offline, or in the cloud on Microsoft Azure — all from right inside of Visual Studio. While SQL Server Management Studio (SSMS) continues to serve as the primary tool for database administrators, SSDT plugs in to Visual Studio as a special database project type designed specifically for the application developer.

In this session, Lenni describes the various difficulties that developers face, and demonstrates how SSDT can be used to remedy those pain points. You will learn how to use features such as code navigation, IntelliSense, and refactoring with your database model — indispensable tools traditionally available only for application development in Visual Studio. We’ll also cover the declarative model that allows you to design databases offline and under source control right from within solution in Visual Studio, as well as how to deploy to SQL Database on Microsoft Azure. Don’t miss out on this demo-centric information-packed session on the current generation of database tools for application developers!

Speakers
avatar for Leonard Lobel

Leonard Lobel

Leonard Lobel is the chief technology officer (CTO) and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies that services organizations ranging from small shops to high-profile clients. He is also a principal... Read More →


Tuesday May 23, 2017 17:45 - 18:45
Room 7
 
Wednesday, May 24
 

08:45

Azure Data Warehouse: Why, What and How
If your regular SQL Server becomes too slow for running your data warehouse queries, or uploading the new data takes too long, you might benefit from the Azure Data Warehouse. Via its divide and conquer approach it provides significant performance improvements, yet most client applications can connect to it as if it is a regular SQL Server.

But to benefit from these performance improvements we need to implement our Azure Data Warehouse in the right way. In this session - through a lot of demos - you will learn how to setup your Azure Data Warehouse (ADW), review indexing in the context of ADW and see that monitoring is done slightly different from what you are used to.

Speakers
avatar for Nico Jacobs

Nico Jacobs

Trainer, u2u
Dr. Nico Jacobs is a Microsoft Business Intelligence and SQL Server trainer and consultant at U2U since 2004. Before that, he was a machine learning (data mining) researcher at the computer science department of the University of Leuven where he obtained a PhD in machine learning... Read More →


Wednesday May 24, 2017 08:45 - 09:45
Room 13

10:00

No Schema, No Problem! Introduction to Azure DocumentDB
This session presents an overview of Azure DocumentDB, a new massively-scalable and fully managed NoSQL database platform that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, DocumentDB supports a schema-free data model, utilizes replicas for fast write performance, and scales easily. But DocumentDB also offers several unique features that make it a compelling candidate for NoSQL scenarios.

We begin by explaining NoSQL and document databases in general, and how they compare with traditional relational database platforms. Then we tour the many features of DocumentDB, including rich querying with SQL (that’s right, you query this NoSQL database using SQL!), and client development using the REST API and the many available DocumentDB SDKs. You will also learn about the server-side programming model that lets you write fully transactional stored procedures, triggers, and user-defined functions. We’ll also explore tunable consistency, scale-out partitioning, custom indexing, attachments, and more. Attend this session, and get up to speed on DocumentDB today!

Speakers
avatar for Leonard Lobel

Leonard Lobel

Leonard Lobel is the chief technology officer (CTO) and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies that services organizations ranging from small shops to high-profile clients. He is also a principal... Read More →


Wednesday May 24, 2017 10:00 - 11:00
Room 4

10:00

Secrets of SQL Server - Database Worst Practices
“Oh my God! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Speakers
avatar for Pinal Dave

Pinal Dave

SQL Server Expert, SQL Authority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4100 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years... Read More →


Wednesday May 24, 2017 10:00 - 11:00
Room 6

11:30

Operational Analytics: Doing an OLAP workload on your OLTP system
This session will be a deepdive into the Operational Analytics for SQL Server 2016. We will show you how it became possible and what possible problems you might face implementing it yourself.

Operational analytics is based on the allready existing Columnstore Indexes for (2012 & 2014), this means we will also be handling some of the Columnstore internals in order to understand how Operational Analytics works.

Speakers
avatar for Stijn Wynants

Stijn Wynants

A SQL Server DBA Consultant & Belgian SQL User Group core member. My SQL Server career started with some work I did with the SQL Server DWH ferrari aka the APS (formerly known as the PDW), and after this I got bitten by the SQL Server bug. I then started working on various SQL Server... Read More →


Wednesday May 24, 2017 11:30 - 12:30
Room 11

15:00

BigchainDB: Big Data meets Blockchain
The Internet of Value allows people take control over their assets and personal data. Decentralized technologies such as blockchain enable peer-to-peer trust but they still miss out on scale.

Rather than trying to scale up blockchain technology, BigchainDB starts with a big data distributed database and then adds blockchain characteristics - decentralized control, immutability and the transfer of digital assets.

BigchainDB is also the driving technology behind IPDB - the InterPlanetary DataBase - a decentralized database to serve creators and public commons at planetary scale.

Speakers
avatar for Dimitri De Jonghe

Dimitri De Jonghe

Co-Founder, Head of Research, BigchainDB and Ocean Protocol
Dr. Dimitri De Jonghe is a cross-domain protocol researcher. After finishing his PhD on micro-electronics and machine learning, he co-founded a series of blockchain startups: ascribe [power to creators] and BigchainDB [a blockchain database], and Ocean Protocol [a public network for... Read More →


Wednesday May 24, 2017 15:00 - 16:00
Room 11

15:00

Hands on Power BI - Creating our own demo
There are lots of flashy Power BI demos everywhere. But most of the time, you don't see the internal mechanics. In this session, we're going to build a Power BI demo from scratch. If you have a laptop with an Internet connection, you can follow along using Power BI Desktop (free download). You'll find out how easy it is to mash-up data and to create stunning visualizations.

Speakers
avatar for Koen Verbeeck

Koen Verbeeck

Senior Consultant & MVP, AE
Koen Verbeeck is a Business Intelligence professional working at AE. He helps client to get insight in their data and to improve their business intelligence solutions. Koen has over 9 years of experience in developing data warehouses, cubes and reports using the Microsoft data platform... Read More →



Wednesday May 24, 2017 15:00 - 16:00
Room 4

16:30

Hybrid Configurations with SQL Server 2016
SQL Server 2016 has several new integration points with Microsoft Azure. Are you curious about how this might give your organization benefits? In this session, you will learn how you can use SQL Server 2016 to create a hybrid environment. We will see an overview of all the new Microsoft Azure features that are available in SQL Server 2016, like Striped Backups to Microsoft Azure Blob Storage, Stretchdb, Replication to SQL Azure DB and many more. The session is bulk loaded with demos and it will give you a good idea what features can be helpful in your environment.

Speakers
avatar for Pieter Vanhove

Pieter Vanhove

Pieter Vanhove is a SQL Server Premier Field Engineer at Microsoft Belgium and has been working with SQL Server since 2000. Performance tuning, SQL audits, migrations and training are part of the job. Pieter has also a profound knowledge in implementing high availability and disaster... Read More →


Wednesday May 24, 2017 16:30 - 17:30
Room 14

17:45

An overview of the Cortana Intelligence Suite
In this session you will learn how to use Cortana Intelligence Suite to build advanced analytics and machine learning based solutions. You’ll learn about Machine Learning and IoT scenarios, as well as Cognitive Service such as text / speech integration, image recognition and how to leverage APIs to build out solutions at the speed of light.

Speakers
avatar for Dandy Weyn

Dandy Weyn

As worldwide technical lead for Data Insights and IoT, Dandy works with the largest customers on digital transformation in the enterprise. He supports our teams of deep technical global blackbelts and solutions architects on SQL Server, Azure Data Services, Machine Learning and IoT... Read More →


Wednesday May 24, 2017 17:45 - 18:45
Room 12

17:45

Securing PAAS Databases
One of the most prominent questions when working with PAAS databases is how to secure them. Let’s talk about limiting access to objects, protecting your data and auditing. Also, I’ll add some extra resources for people looking for a complete overview of the available security features on an Azure SQL Database.

Speakers
avatar for Karel Coenye

Karel Coenye

Karel Coenye a senior Database trainer and Consultant at Kohera, has been working with SQL Server in different roles since 1999. Currently working on different database projects as SQL architect while coaching and training other DBAs and developers. Experienced in both cloud-environments... Read More →


Wednesday May 24, 2017 17:45 - 18:45
Room 2