Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 39
The client has some burning business questions and you have the client's data. So which tools will help you to understand that data and tell your client something they did not know already?  In this session, I'll take you through my personal choice, demo each of them and explain their value.  These include Excel; Tableau; R and RStudio and my favourite packages; Power BI and especially the fabulous Query Editor; SQL; cubes and Azure Machine Learning.  

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Data Science

Level: Beginner

Session Code:

Date: July 15

Time: 4:00 PM - 5:00 PM

Room: Theatre 2

Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

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
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Development

Level: Beginner

Session Code:

Date: July 15

Time: 1:30 PM - 2:30 PM

Room: Theatre 5

Building robust and resilient Data Platform solutions can be complex and costly, building out for both High Availability and Disaster Recovery. The Always On technologies incorporated in the Microsoft SQL Server stack help Data Platform Engineers to do just this. Creating solutions that span multiple locations, in an effort to protect the data that we are tasked to manage on a daily basis.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Development

Level: Advanced

Session Code:

Date: July 15

Time: 4:00 PM - 5:00 PM

Room: Theatre 1

PowERBI goes Bananas

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
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Data Science

Level: Beginner

Session Code:

Date: July 15

Time: 8:30 AM - 9:30 AM

Room: Theatre 3

Sponsor Session with Christian Bolton from COEO.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Talk (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: July 15

Time: 12:10 PM - 12:40 PM

Room: Theatre 5

How do we implement Azure Data Lake?
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure Data Services

Level: Intermedia

Session Code:

Date: July 15

Time: 1:30 PM - 2:30 PM

Room: Theatre 2

In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure Data Services

Level: Advanced

Session Code:

Date: July 15

Time: 2:45 PM - 3:45 PM

Room: Theatre 2

Come round to talk about Application Lifecycle Management (ALM) and deployment/delivery of Business Intelligence (BI) Applications! You will learn how to manage and deploy a full stack BI solution with Team Foundation Server (TFS). I will share my view of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit, with specific examples for every MS BI project type. The presentation will also compare features of Release Manager and Octopus Deploy for your deployment needs will show a demo of continuous deployment for a typical BI project using TFS. The material does not assume prior knowledge of TFS administration, but some experience using Visual Studio database projects and general TFS terminology will be helpful.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Continuous Integration

Level: Intermedia

Session Code:

Date: July 15

Time: 8:30 AM - 9:30 AM

Room: Theatre 4

Azure offers many great tools and services, but how to they fit together and what are your options when trying to architect an end to end Azure BI platform?
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure Data Services

Level: Beginner

Session Code:

Date: July 15

Time: 9:45 AM - 10:45 AM

Room: Theatre 2

Sponsor Session with Ian Macdonald from Pyramid Analytics.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Talk (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: July 15

Time: 12:10 PM - 12:40 PM

Room: Theatre 4

For the last few years Microsoft have been promoting declarative, model-based database development with tools like SSDT. For many this is the way forward – gone are the days of managing endless upgrade scripts and manual deployments. 

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Continuous Integration

Level: Intermedia

Session Code:

Date: July 15

Time: 1:30 PM - 2:30 PM

Room: Theatre 4

There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline.

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Continuous Integration

Level: Intermedia

Session Code:

Date: July 15

Time: 2:45 PM - 3:45 PM

Room: Theatre 4

Analysing highly connected data using SQL is hard! Relational databases were simply not designed  to handle this,  but graph databases were.  Built from the ground up to understand interconnectivity, graph databases enable a flexible performant way to analyse relationships, and one has just landed in SQL Server 2017! SQL  Server supports two new table types NODE and EDGE and a new function MATCH, which enables deeper exploration of the relationships in your data than ever before. 

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Data Science

Level: Beginner

Session Code:

Date: July 15

Time: 9:45 AM - 10:45 AM

Room: Theatre 3

Start your journey into the world of predictive analytics that will see you building a predictive model within the hour. The first 30 minutes will explore the role of the Cortana Intelligence Suite in the world of Data Science. We will then explore Machine Learning and how it is helping businesses to gain new insights on their data. You will source data, pre-process the data and then feed that data into a machine learning model to train. We will then look at how we can score and evaluate a model to see which algorithm is the best fit for your workload.  Finally, we will wrap up and look at how the model can be deployed into production.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure Data Services

Level: Beginner

Session Code:

Date: July 15

Time: 8:30 AM - 9:30 AM

Room: Theatre 2

With the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data.
     
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence & Data Science

Level: Intermedia

Session Code:

Date: July 15

Time: 1:30 PM - 2:30 PM

Room: Theatre 3

Have you heard about the SQL Tiger Team? Do you know they provide a free set of SQL scripts to help you administer your SQL Server? 
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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Development

Level: Beginner

Session Code:

Date: July 15

Time: 9:45 AM - 10:45 AM

Room: Theatre 1

Sponsor Session with Aidan King from Profisee
The presentation will cover 
Current MDS functionality 
Making MDS Enterprise Grade
Applications of Enterprise Grade MDS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Talk (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: July 15

Time: 12:10 PM - 12:40 PM

Room: Theatre 2

Do you spend your day running the same routine tasks?  Does it irk you when you do the same thing more than once?  I (sadly) still have to answer yes to one of those questions.  However, whilst I do still carry out some of the same routine tasks, learning Powershell has enabled me to automate the majority.
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Development

Level: Beginner

Session Code:

Date: July 15

Time: 8:30 AM - 9:30 AM

Room: Theatre 5

The JavaScript Object Notation format, known simply as JSON, has now become a standard in data interchange between client-server applications, it is also used to store information in non-relational databases and the SQL Server 2016 engine handles it natively . However, today, not everyone has passed to the latest version of SQL Server, however, it is possible to process the JSON format even with earlier versions: in this session, it is confident with this format and illustrates the non-native mode that allows you to be ready in the moment of the upgrade to 2016 (or later) with a few simple moves. Finally, with a few simple examples, you will find some tips on how to use JSON in an advanced way with SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Development

Level: Beginner

Session Code:

Date: July 15

Time: 9:45 AM - 10:45 AM

Room: Theatre 5

Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Development

Level: Intermedia

Session Code:

Date: July 15

Time: 11:00 AM - 12:00 PM

Room: Theatre 1

Sessions Found: 39
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids