| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Dmytro Andriychenko | Database Development, Continuous Integration | BI Application Lifecycle Management with TFS |
| 08:30:00 | Pete Moore | Business Intelligence Data Science | An Artistic Dimwit Learns Data Visualisation |
| 08:30:00 | Matthew Darwin | Database Administration Development | Getting started with Powershell for the DBA |
| 08:30:00 | Lord Richard Douglas | Database Administration Development | Understand the Transaction Log, Unlock Greater Throughput |
| 08:30:00 | n/a n/a | Azure Data Services | Session Details not available |
| 09:45:00 | Alex Whittles | Azure Data Services | BI in Azure |
| 09:45:00 | Mark Pryce-Maher | Database Administration Development | Exploring the Tiger toolbox |
| 09:45:00 | Terry McCann | Business Intelligence Data Science | Enhancing relational models with graph processing In SQL Server 2017. |
| 09:45:00 | Emanuele Zanchettin | Database Administration Development | JSON before and after SQL Server 2016 |
| 09:45:00 | Simon Sabin | Database Development, Continuous Integration | What is DevOps? |
| 09:45:00 | Neil Hambly | Database Administration Development | SAy our Security Right (or Not) |
| 11:00:00 | Mark Broadbent | Database Administration Development | Lockless in Seattle: Using In-Memory OLTP Transaction Processing |
| 11:00:00 | David Postlethwaite | Azure Data Services | Microsoft Azure for the DBA |
| 11:00:00 | Craig Ottley-Thistlethwaite | Database Development, Continuous Integration | Through the looking glass on Agile Database Development |
| 11:00:00 | André Kamman | Database Administration Development | SQL Server and Docker. What, How and Why |
| 11:00:00 | Stephanie Locke | Business Intelligence Data Science | Solving Power BI pain points with R |
| 12:10:00 | Sponsor Session | Other | An introduction to SQL Server Parallelism |
| 12:10:00 | Sponsor Session | Other | Collaborative BI with Governance and Security |
| 12:10:00 | Sponsor Session | Other | Overview of the IT market and emerging recruitment salary trends |
| 12:10:00 | Sponsor Session | Other | Extending SQL Server Master Data Services |
| 12:40:00 | Sponsor Session | Other | PowerBI your way to understand your SQL Server Estate |
| 12:40:00 | Sponsor Session | Other | Sponsor Session |
| 12:40:00 | Sponsor Session | Other | Modern Data Warehousing: Analytics in Azure |
| 13:30:00 | Paul Andrew | Azure Data Services | Azure Data Lake - The Services. The SQL. The Sharp. |
| 13:30:00 | Rob Sewell | Database Administration Development | Administrating SQL Server with PowerShell dbatools |
| 13:30:00 | Oliver Frost | Business Intelligence Data Science | Exploring Dark Data with SQL Server 2016 and R [EN] |
| 13:30:00 | Alex Yates | Database Development, Continuous Integration | Database version control and deployment: model or migration scripts? |
| 13:30:00 | David Williams | Database Administration Development | SQL Server 2017 New Features (Not Linux support!) |
| 13:30:00 | Simon Whiteley | Azure Data Services | Logic Apps: SSIS for Azure? |
| 14:45:00 | Dr. Subramani Paramasivam | Business Intelligence Data Science | Revolution R models in SQL 2016 Reporting Services |
| 14:45:00 | Robin Lester | Azure Data Services | Azure SQL Data Warehouse – Performance, Optimizing and Maintaining |
| 14:45:00 | Gavin Campbell | Database Development, Continuous Integration | Effective Unit Testing for SQL Server |
| 14:45:00 | Dejan Dular | Database Administration Development | Window functions are your friends |
| 14:45:00 | Ewald Cress | Database Administration Development | SQLOS Scheduling From the Inside |
| 16:00:00 | Mark Wilcock | Business Intelligence Data Science | A lazy data scientist's toolkit |
| 16:00:00 | David Morrison | Database Administration Development | Query Plans Deep Dive |
| 16:00:00 | Bent Pedersen | Business Intelligence Data Science | What to do before your Power BI report starts getting slow |
| 16:00:00 | John Martin | Database Administration Development | Always On Multi-Site Patterns |
| 16:00:00 | Ryan Yates | Database Development, Continuous Integration | Teaching the IT Pro how to Dev - PowerShell, Source Control Unit Testing |
Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Database Development, Continuous Integration
Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Business Intelligence Data Science
I'm scared of visualisations and I wanted to fix it. This is a talk by an artistic dimwit who is quite good at data.
With a Trello-based Kanban board* as my muse and PowerBI as my canvass, I built a series of progressively less bad visualisations until I felt like an artist.
As with all art, you be the judge.
Tags: Power BI, Data Viz, Data Visualisation
Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Database Administration Development
The potential for automation that Powershell brings, can have a huge impact on regaining precious time for a busy DBA. The ability to create a codebase of cmdlets that sits outside your SQL Server instances allows you to introduce easy frameworks for standardisation, inventory collection and access to external processes that would be clunky in SSIS or require using the dreaded xp_cmdshell. In this presentation, I’m going to demonstrate some of the features I use to make my life easier, from the basics of creating a Powershell profile and how different objects and inbuilt cmdlets work, to creating my own cmdlets and modules.
Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Database Administration Development
There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log, however, is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session, you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Azure Data Services
Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Azure Data Services
We'll take a high level look at the available Azure services, discussing what their capabilities are and how they fit together. Covering Azure Data Factory, Data Lake, Table Storage, Blob Storage, U-SQL, HDInsight, SQL Data Warehouse, Machine Learning, Power BI, Event Hub, Stream Analytics and more.
Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Database Administration Development
In this session we explore the scripts in Tiger Team Toolbox. Can't wait for the session? Download the scripts from here. https://github.com/Microsoft/tigertoolbox
Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Business Intelligence Data Science
In this session, we seek to explore, what is a graph database, why you should be interested, what query patterns does they solve and how does SQL Server compare with competitors. We will explore each of these based on real data shredded from IMDB.
Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Database Administration Development
Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Database Development, Continuous Integration
DevOps is one of those terms that has transcended its initial use. You still see people talk about being DevOps Engineer or do DevOps for SQL, but you also hear about a company being a DevOps company, having a DevOps Culture. What does it all mean? In this talk we will discuss and probably argue what DevOps is and isn't. I'll put forward what we consider a DevOps culture, what are the core elements, who does what and importantly what breaks it.
You will gain an understanding of why companies with such a culture can get solutions to market quicker and can respond to changes better than their competition.
Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Database Administration Development
We will be covering SQL Server’s security hierarchy and terminology, identify security risks (know your security responsibilities), determine when SA usage is appropriate and not and more.
Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Database Administration Development
In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Azure Data Services
Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Database Development, Continuous Integration
Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Database Administration Development
Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Business Intelligence Data Science
By the end of this session, you’ll know how you can use R to connect to more data sources, do sophisticated data transformation easily, avoid spatial data point limitations, and build custom graphics.
Event Date: 15-07-2017 - Session time: 12:10:00 - Track: Other
In this session you'll learn what parallelism is and how it affects your servers and your queries as well as how to troubleshoot and optimise your queries for parallelism. The technical content is very accessible and aimed at beginner level.
Event Date: 15-07-2017 - Session time: 12:10:00 - Track: Other
We will show you how easy it is to collaborate, integrate, share and publish content on-premises or in the cloud, and to unlock insights that might otherwise be trapped on individual computers.
We will discuss how by using BI Office and Power BI Desktop together, you get a governed, secure, enterprise platform that can demonstrate personal productivity gains. Come and see for yourself!
Ian Macdonald - Principal Technologist, Pyramid Analytics Bio: A ‘hands-on’, product oriented technical marketing professional with extensive experience of the international software market. Primary focus has been on the database, development and query tools, data mining, business intelligence applications and IT infrastructure management solutions, setting product strategy, marketing, partnering and selling to senior positions within Fortune 2000 companies.
Event Date: 15-07-2017 - Session time: 12:10:00 - Track: Other
This will be an overview of the IT market and emerging recruitment salary trends within IT delivered by Robert Walters.
Event Date: 15-07-2017 - Session time: 12:10:00 - Track: Other
The presentation will cover Current MDS functionality Making MDS Enterprise Grade Applications of Enterprise Grade MDS
Event Date: 15-07-2017 - Session time: 12:40:00 - Track: Other
Would having a good understanding of all the different versions, editions, OS Builds, CPU Memory and database details in a single reporting place be useful? Many of my previous clients have found that just to be the case…. Well now you can too and it’s totally FREE
· Come Discover what really exists in your environments
Visualise valuable details about your SQL Servers [Do you even know about all of them]
· Claim your FREE PowerBI SQL Server Estate Report
Every Attendee can sign-up for their free report
· Useful for Capacity Planning, Migrations, Consolidations and Licensing and more.
· Extend the report to add additional reports and information
In this session, we showcase a sample report, giving you a flavour of what we can report on. This is just the beginning of the journey, if you want to know more then ask us about our SQL Server BI Health-Checks that expand on these reports.
Event Date: 15-07-2017 - Session time: 12:40:00 - Track: Other
Event Date: 15-07-2017 - Session time: 12:40:00 - Track: Other
Technology changes quickly – patterns and approaches less so. As people move towards the cloud, there are clear benefits of adopting a distributed cloud architecture employing a range of disparate tools.
This session will attempt to help you understand 5 of the key technologies underpinning the Modern Data Warehouse. We'll run through:
We'll then briefly show you how they all fit together into a coherent reference pattern for performing data analytics in Azure. This session is aimed as a primer for people considering moving to the cloud or for anyone looking to understand the current data analytics architecture.
Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Azure Data Services
How does a lake fit into our data platform architecture? Is Data Lake going to run in isolation or be part of a larger pipeline? How do we use and work with USQL? Does size matter?!
The answers to all these questions and more in this session as we immerse ourselves in the lake, that’s in a cloud.
We'll take an end to end look at the components and understand why the compute and storage are separate services.
For the developers, what tools should we be using and where should we deploy our USQL scripts. Also, what options are available for handling our C# code behind and supporting assemblies.
We’ll cover everything you need to know to get started developing data solutions with Azure Data Lake.
Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Database Administration Development
Afraid of PowerShell? Worried its too complicated? Don't want to go through the learning curve?
Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday
Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session
Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Business Intelligence Data Science
In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016.
This session is for anyone who is new to R and is interesting expanding their skill set beyond their comfort zone in SQL Server.
Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Database Development, Continuous Integration
At the same time, leaders and shakers of our industry including Jez Humble, Pramod Sadalge and Paul Stovell promote an iterative, migration script driven approach asserting that deployment scripts should be tested early and not generated by a tool.
I'm irritated whenever I go to a “how to do database continuous delivery” session and the speaker presents one way as good and the other as bad. Like most things, it depends.
I’ll illustrate the limitations of each approach with a simple scenario. I’ll describe which projects are better suited to a model or a migrations approach, and whether it’s possible to get the best of both worlds.
Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Database Administration Development
Using Query Store for automatic tuning of querys which have bad plans (multiple plans with regressions)
Additional information stored in actual execution plans
New DMVs e.g. log information, statistics histograms
Interleaved Execution for multi-statement T-SQL TVFs
Adapative joins for queries
Resumable online index rebuild
Faster non-cluster index builds on memory optimized tables.
Additional in-memory SQL Surface Area e.g. Computed columns, JSON, CROSS APPLY,sp_spaceused,sp_rename,CASE,TOP N with TIES
Parallel Redo for memory optimized tables, increases throughput for Always On Availability Groups
DTC support for Always On Availability Groups
Cluster-less Availability Groups
Minimum Replica Commit Availability Groups
New CLR strict security
Graph database queries
Running Python scripts in SQL Server
BULK INSERT directly from CSV files
Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Azure Data Services
Logic Apps provides control-flow style functionality and can orchestrate data from a huge range of common sources. Want to scrape twitter, perform sentiment analysis and write to PowerBI? Its now possible with zero coding.
This session will introduce Logic Apps how it fits into the Modern Azure Warehouse then demonstrate building a twitter scraper step by step.
Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Business Intelligence Data Science
Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Azure Data Services
We will look at distribution types, index considerations, execution plans, workload management and loading patterns.
At the end of this talk you will understand the common pitfalls and be empowered to either construct a highly performant Azure SQL Data Warehouse or address performance issues in an existing deployment.
Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Database Development, Continuous Integration
This session isn't about any of those tools, but is an attempt to get back to basics - with the open source tSQLt framework - and address questions such as
Why is database unit testing difficult? What do I need to test? What do I not need to test? What does a "good" unit test look like? What tests should I be writing anwyay?
This session will incorporate real-life experiences with tSQLt, as well as lessons that can be learned from other testing framworks and other programming languages.
Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Database Administration Development
Window functions are great! They open a whole new world of elegant data analysis. Their only problem is that they seem complicated at first glance. In this session we will get OVER() them and see how can we use them together with aggregation, analytic and ranking functions. After this session creating queries with things like running totals will be a piece of cake!
Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Database Administration Development
We'll pay particular attention to synchronisation: the need to synchronise, the balancing act between busy waiting and context switching, and examples of internal SQLOS synchronisation primitives. All of this will complement your existing mental model of SQL Server waits.
It is a deep session, but not a broad one. As long as you have an interest in either SQL Server or operating system internals, no specific background knowledge is assumed - we will build from the ground up.
Event Date: 15-07-2017 - Session time: 16:00:00 - Track: Business Intelligence Data Science
I will also demo the tools I expect to be using soon as my projects propel me into the new world of Azure cloud and big data, of Spark and Hadoop. I hope to show "plus ça change, plus c'est la même chose" and that old friends such as R and SQL are also useful in this new world.
Event Date: 15-07-2017 - Session time: 16:00:00 - Track: Database Administration Development
We will also take a look at various operators, how they work, why they are chosen and how to avoid them being used in the wrong place / context,. Attendees of this session will walk away with a greater understanding of query plans and the operators, which will enable them to both better interpret their query plans and also write more efficient SQL code
Event Date: 15-07-2017 - Session time: 16:00:00 - Track: Business Intelligence Data Science
Working with IT there is nothing worse when the business starts complaining. During this session I will show you how to approach the situation when the business already started complaining, what the most common pains appear and where you should be looking before the performance starts degrading.
We will be looking into measuring different timings, what is important when building reports, investigating logs and what options you have to this in a structured fashion.
Event Date: 15-07-2017 - Session time: 16:00:00 - Track: Database Administration Development
Together we will walk through the architecture patterns, technology requirements, and configuration options that you need to know in order to build a solid Data Platform. Understanding the implementation differences between on-premises and cloud based deployments is important. Especially as there are specific requirements that need to be met for up-time SLAs to be applicable, as well as mitigating for region failures.
All of these elements mean that it is more than just simple wizards to follow in order to have a solid, reliable, and robust SQL Server Data Platform.
Event Date: 15-07-2017 - Session time: 16:00:00 - Track: Database Development, Continuous Integration
This is a session where there will be chance to follow along (if you bring your own laptop) and learn in real time from the co-ordinator of the UK PowerShell User Groups - however you will also be lead to further community resources if you require further time after the session to get this built into your current day to day workflow.
As this session will be focused towards SQL Professionals we will take a look at SQL Specifics that can be used within PowerShell Scripts Unit Testing.