Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type


Sessions Found: 27
Whenever we have two independently updatable copies of a piece of data, we live with the spectre of merge conflicts. This problem has existed for ages, but with so much distributed architecture in the cloud era, more of us get exposed to the pain.

Conflict-free replicated data types (CRDTs) evolved as a way to accept updates at multiple replicas with automatic conflict resolution, and to remove such concerns from application development. Inevitably though, you have to apply a different mindset to data design.

In this talk, I'll cover the basic premise of what CRDTs are, a few example CRDTs, the kind of programming interface they expose, and a glimpse into their internal workings. While the literature in this area tends to be a bit academic, we'll be taking a commonsense approach, giving you a useful toehold into the subject for further exploration.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Developer

Level: Beginner

Session Code:

Date: September 08

Time: 1:45 PM - 2:45 PM

Room: Trinobantes

Any database change is a good candidate for breaking the proper behavior of the system. How to avoid this?
Unit tests at database level can help avoiding breaking the contract with the applications that consume data from the database, and also can help ensuring database correct behavior (for example: a stored procedure do what’s supposed to do, or a specific table indeed exists).
In this talk I will address the basic steps to introduce unit tests at databases using tSQLt. tSQLt is a unit testing framework the allow to write, execute and diagnose tests for T-SQL code. After writing the tests, I will explore how can tests execution be include in the deployment pipeline.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Developer

Level: Intermedia

Session Code:

Date: September 08

Time: 11:25 AM - 12:25 PM

Room: Durotriges

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise/ Administration

Level: Intermedia

Session Code:

Date: September 08

Time: 10:10 AM - 11:10 AM

Room: Regnenses

Discover the Advanced Analytics and Data Lake pattern in Azure Data Platform through a complete demo : how to get insights from text, photos and videos ? 
From different media files and raw data, we will analyze sentiment of characters and get valuable information in a Power BI dashboard, using Cognitive Services, CNTK, .NET and U-SQL.
This session will mainly showcase Azure Data Lake and U-SQL language. But demos will involve different tools like Azure Data Factory for data supply chain and orchestration, Azure SQL Database for corporate data or even Machine Learning technics.
Even if this session is demo-driven, concepts and features of Azure Data technologies will be discussed
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/ Analytics/ Data Scientist

Level: Intermedia

Session Code:

Date: September 08

Time: 4:15 PM - 5:15 PM

Room: Regnenses

Azure Data Factory version 2 (ADFv2) arrived in Sept17 with a bunch of new concepts and features to support our Azure data integration pipelines. In this session, we’ll update your ADFv1 knowledge and start to understand the true nature of scale out control flows and data flows. What’s the integration runtime? Can we easily lift and shift our beloved SSIS packages into the cloud? How do we embed expressions to achieve dynamic activity executions? Do we still need SSIS with the ADF platform as a service? The answers to all these questions and more in this demo packed session. An awareness of Azure Data Factory v1 is recommended before attending this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/ Analytics/ Data Scientist

Level: Intermedia

Session Code:

Date: September 08

Time: 3:00 PM - 4:00 PM

Room: Trinobantes

You have probably heard the buzz about Azure Machine Learning, aka Azure ML,  over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI/ Analytics/ Data Scientist

Level: Beginner

Session Code:

Date: September 08

Time: 1:45 PM - 2:45 PM

Room: Regnenses

Many organizations would like to take advantage of the benefits of using a platform as a service database like Azure SQL Database. Automated backups, patching, and costs are just some of the benefits. However, Azure SQL Database is not a 100% feature compatible with SQL Server—features like SQL Agent, CLR and Filestream are not supported. Migration to Azure SQL Database is also a challenge, as backup and restore and log shipping are not supported methods. 

Microsoft recently introduced Managed Instances—a new option that provides a bridge between on-premises or Azure VM implementations of SQL Server and Azure SQL Database. Managed Instances provide full SQL Server surface compatibility and support database sizes up to 35 TB.

In this session, you will learn about migrating your databases to Managed Instances, developing applications for managed instances. You will also learn about the underlying high availability and disaster recovery options for the solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise/ Administration

Level: Beginner

Session Code:

Date: September 08

Time: 8:30 AM - 9:30 AM

Room: Durotriges

ALL receipts (minus Eventbrite booking fee) goes directly and immediately to Children's Cancer Charity Edie's Butterfly Appeal -giving hope through research for all children fighting ependymoma

Only 8 slots available for this special intimate charity 2-hour mini-con session on SQL Server migration to Azure by two of Microsoft Espana's top escalation engineers!
https://www.eventbrite.co.uk/e/migrating-our-sql-server-onpremise-database-to-azure-tickets-48645214145

This session will cover the main aspects required to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise.

In this workshop we will cover:

What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse.
Best Practices and best tools for our migration process depending on the platform chosen.

After the migration, we will address several outstandin
Speaker:

Accompanying Materials:

No material found.

Session Type:
Charity Mini-con (120 minutes)

Track:
Charity Mini-Con

Level: Intermedia

Session Code:

Date: September 08

Time: 1:45 PM - 3:45 PM

Room: Cornovii

Popularized by Bitcoin, now with Ethereum & Co already at least in version 2.x. 
What is technically behind the ominous blockchain, what does it have to do with databases and data warehousing? Are smart contracts only interesting for the financiers? And why should you program contracts? In the first part of this session, we deliver the background, and not just technically.

In the second part we take a closer look at the bitcoin blockchain as a "database". Starting point here: How anonymous really is the whole thing, when everything must be visible to everyone? After a brief introduction to its structure, we load the blockchain of bitcoin (that is, all the transactions that have been done so far) into Neo4J, a graph database and look what analyzes are possible (and why does a Graph DB work better here? And why aren’t we using the new exciting Graph stuff of SQL Server 2017???) Visualization and further analysis we do with Power BI, directly connected to Neo4j.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise/ Administration

Level: Beginner

Session Code:

Date: September 08

Time: 10:10 AM - 11:10 AM

Room: Belgae

Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it's important to raise your profile in today's highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business/ End user

Level: Beginner

Session Code:

Date: September 08

Time: 4:15 PM - 5:15 PM

Room: Trinobantes

SQL Server® has many performance WOMs (Word of Mouth), especially concerning indexes to include:
•	keep clustered index width small
•	unique indexes perform better 
•	keep non-clustered index width small
•	compressed indexes have fewer logical reads
This session dives down and looks at important items within index pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command to factually document index WOMs.  The effect of row data compression on clustered and non-clustered indexes are also investigated.  The demos will ascertain how the SQL Server® optimizer might use them and strive to gain some insight from a performance advantage.
The session is 80% demos. This presentation will propel the layman to a new level of index understanding.
Performance! That’s what we are all looking for. Blast off with this presentation.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise/ Administration

Level: Intermedia

Session Code:

Date: September 08

Time: 1:45 PM - 2:45 PM

Room: Durotriges

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at
	Container Fundamentals with Docker
	Common Container Scenarios
	Automation with Kubernetes
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise/ Administration

Level: Beginner

Session Code:

Date: September 08

Time: 4:15 PM - 5:15 PM

Room: Iceni

In this session to look at the functionality built into SQL Server Management Studio (SSMS) and in Azure SQL Database to classify your database.
I run through the need for data classification in general and why its important for GDPR. We will run though classifying your data and how to report on it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise/ Administration

Level: Intermedia

Session Code:

Date: September 08

Time: 8:30 AM - 9:30 AM

Room: Iceni

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI/ Analytics/ Data Scientist

Level: Beginner

Session Code:

Date: September 08

Time: 8:30 AM - 9:30 AM

Room: Regnenses

I play a vital role in building and test run the modules that is developed for DSKA (Data Science Kids Academy) and also I deliver few lessons. In this session, I am going to share my experience in what I have learnt about Data Science and also will do a demo in Program R.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/ Analytics/ Data Scientist

Level: Beginner

Session Code:

Date: September 08

Time: 3:00 PM - 4:00 PM

Room: Regnenses

Until SQL Server 2016, the Query Optimizer and the Execution Engine were strictly separated. The Query Optimizer produces an execution plan that, based on statistics and estimates, should be fast. That execution plan is then faithfully executed by the Execution Engine, even if reality turns out to be different from expectations.

SQL Server 2017 changes this! Three new features now allow execution plans to adapt to reality. Memory Grant Feedback increases or decreases assigned memory based on past experience. The Adaptive Join operator allows the optimizer to create two alternative plans, the best of which will be decided at execution time. And with Interleaved Execution, parts of the plan are even completely recompiled mid-execution, with much better cardinality estimates.

If you are more interested in how all this ACTUALLY works than in shiny marketing slides, come to this session. We will spend the full 60 minutes knee-deep in execution plan internals!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Developer

Level: Advanced

Session Code:

Date: September 08

Time: 10:10 AM - 11:10 AM

Room: Iceni

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?
In this demo heavy session we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/ Analytics/ Data Scientist

Level: Beginner

Session Code:

Date: September 08

Time: 10:10 AM - 11:10 AM

Room: Trinobantes

When your development team is up to a certain size, and often no matter what size it is, you want to start following best development practices. 
These include things like source control, multiple environments, deployment processes, and governance. As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are, these things can get tricky. In this session we will look at what Power BI has to offer when it comes to development lifecycle. 
We will look at the different options available to the developer when it comes to source control, multiple environments, deployment and distribution of Power BI content. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI. 
For all these topics we will look at the capabilities Power BI offers and how we, in the company where I work, decided to implement it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI/ Analytics/ Data Scientist

Level: Intermedia

Session Code:

Date: September 08

Time: 8:30 AM - 9:30 AM

Room: Belgae

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise/ Administration

Level: Advanced

Session Code:

Date: September 08

Time: 11:25 AM - 12:25 PM

Room: Trinobantes

Security is unquestionably a major priority for Microsoft. Join me in this session and see what security features Microsoft has released since SQL Server 2016. In this session you will see how Dynamic Data Masking and Row-Level Security works in on-perm and Azure environments and how to use Always Encrypted.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Developer

Level: Intermedia

Session Code:

Date: September 08

Time: 10:10 AM - 11:10 AM

Room: Durotriges

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