Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


Sessions Found: 29
With the multitude of isolation levels, concurrency models, and specialist technologies available in SQL Server, it is no surprise that transaction throughput and correctness can be directly correlated to the ability and knowledge of the person that wrote the code.

In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios.

We will cover SQL Server’s traditional locking model, In-Memory OLTP, Columnstore, Delayed Durability, and many other technologies and techniques you can use to make your transactions more robust.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 29

Time: 3:45 PM - 4:45 PM

Room: Room4

- SSIS gave you a graphical user interface for building your Extract, Transform and Load processes hosted in SQL Server
- Azure Data Factory v1 gave you a UI for more scalable Extracting and Loading of data, but the Transformation plug-in was left up to you
- Azure Data Factory v2 gave you more control over how your processes were triggered and the path through your steps (like the Control Flow in SSIS)
- Now coming to ADF is Mapping Data Flows, a UI for building in Transformations into your ETLs, still taking full advantage of scalability in the cloud
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud

Level: Beginner

Session Code:

Date: June 29

Time: 9:30 AM - 10:30 AM

Room: Room1

With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.

In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:

1)  Defining what questions we want answered and how to go about this in an effective and efficient manner.

2)  Creating the data model.

3)  How to gather the necessary data, discussing the training and testing aspect.

4)  Processing the model.

5)  Extracting information from our finished model, discussing the implications of this information.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: Room1

Mission critical SQL Servers require right architecture to satisfy SLAs, high availability, and disaster recovery requirements for your critical IT operational data environment. The ability to scale up these environments, to provide the level of performance required by OLTP and provide adequate resources is a significant operational challenge.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: Room4

If you have already mastered the basics of Azure Data Factory (ADF) and are now looking to advance your knowledge of the tool this is the session for you. Yes, Data Factory can handle the orchestration of our ETL pipelines. But what about our wider Azure environment? In this session we’ll go beyond the basics looking at how we build custom activities, metadata driven dynamic design patterns for Data Factory. Plus, considerations for optimising compute costs by controlling other service scaling as part of normal data processing. Once we can hit a REST API with an ADF web activity anything is possible, extending our Data Factory and orchestrating everything.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: June 29

Time: 2:30 PM - 4:00 PM

Room: Room1

Hype as it is, a valid business case currently is the most critical point for a Blockchain project. So better check it out with a PoC and best with a fast PoC before you start burning money. But getting even a simple PoC for a Blockchain project running still is hard. Connecting Blockchain data to classical databases, making them available to analytics or standard applications is worse (ever queried LevelDB?). Microsofts new "Azure Blockchain Workbench" let you do this in hours, not months. So (besides wondering why one needs this hype stuff at all) we will see how to

- Deploy a Blockchain on Azure in a breeze
- Start coding with Solidity
- Generate templates for smart contracts
- Connect them to IoT devices
- Get a PoC Web UI for free
- Push all the data into a "real" database automatically

Last but not least, we can look at some real world projects.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 29

Time: 10:45 AM - 11:45 AM

Room: Room1

In addition to the Data Vault approach being touted as the next generation data warehouse modelling technique, with the arrival of Data Vault 2.0 comes a complete data modelling, methodology and architectural offering. 
This talk will introduce you to the core Data Vault concepts including support for an agile data warehouse, how it can contribute to faster sprints, how it lends itself to automated data model creation, how the Hub, Link and Satellite design is a perfect fit for massively parallel data load and how to virtualize a Data Mart over a Data Vault. It will also cover how a single version of the facts edges out a single version of the truth. 
Demo: Using a SQL 2017 data source, we will orchestrate the extraction, transformation and load to a Data Vault data warehouse including an example virtualized Data Mart layer. The orchestration will take place using Azure Data Factory v2.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 29

Time: 11:45 AM - 12:45 PM

Room: Room2

Aimed mostly at administration and based on real life scenarios, in this audience interactive session we will go through some scenarios DBA's might encounter whilst dealing with SQL Server databases and you will be provided with some options about what to do. Members of the audience will then select from these options what to do and we will follow that path and see what the outcome is from there.

Each selection will have a different outcome, and along the way you will probably learn some new things.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 29

Time: 1:30 PM - 2:30 PM

Room: Room3

Implementing CI/CD on a database platform is never going to be straightforward! During this session, I will provide a high level overview of our pipeline, the tools we use, and some of the lessons we've learned along the way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 29

Time: 10:45 AM - 11:45 AM

Room: Room2

A case study of how a monthly data load has evolved, from just loading data into a table, through some indexes being disabled before loading and enabled after data is loaded, to partitioning the table and loading into a staging table. The last Changes to the solution has taken loading time from eight hours down to 20 minutes, saving a whole day of work for the staff checking and refining the data.
The presentation also includes some reflections on how partitioning the table has changed how both T-SQL and Entity Framework code is being written, to take advantage of partition elimination.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 29

Time: 3:45 PM - 4:45 PM

Room: Room3

Have you heard that knowing machine learning is the easiest way to get rich quickly? Let’s test this statement. Kaggle is the place to do data science projects, why not to start there?
During this session we will solve simple Kaggle competition. Actually, we will submit two solutions. The first made with super-duper deep neural network (black-box approach). Then we will follow proven ML methodologies and solve the problem methodically. All that using SQL Server Machine Learning Services.
Minimum slides and maximum fun guaranteed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: June 29

Time: 1:30 PM - 2:30 PM

Room: Room4

Artificial Intelligence (AI) is bringing big changes in the way people and businesses relate to technology.
As well as the arrival of the personal computer, the cloud computing and smartphones, the AI is the artificial technology that takes you to where you're going so much faster, intuitive and smart.
In this session we will discuss the basics of IA and how we can apply it in our business using the Azure Cognitive Services.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: June 29

Time: 3:45 PM - 4:45 PM

Room: Room2

Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes.  

In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 29

Time: 9:30 AM - 10:30 AM

Room: Room3

Imagine that you have been hard working in that amazing project, your SQL code has been tuned and contains new features and followed the standard that will be crucial for the success of this project. The deploy date has arrived and you have deployed early in the morning but some minutes after the deploy, the users started to call for reporting several issues in the different systems which are using the Databases that were part of your deployment, after stressful minutes, you realized some SQL code deployed were not the same that were tested and you must rollback your code. 

In this session, I'm going to show you how to avoid problems derived of mistakes during the development process through the proper use of source control code strategy which can combine the potential of GIT and SQL Server Data Tools (SSDT) for managing latest version, detecting changes, code review and deploying through environment without stress.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 29

Time: 11:45 AM - 1:15 PM

Room: Room1

There's an old adage in software development: Garbage In, Garbage Out. This adage certainly applies to data science projects: if you simply throw raw data at models, you will end up with garbage results. In this session, we will build an understanding of just what it takes to implement a data science project whose results are not garbage. We will use the Microsoft Team Data Science Process as our model for project implementation, learning what each step of the process entails. To motivate this walkthrough, we will see what we can learn from a survey of data professionals' salaries.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: June 29

Time: 9:30 AM - 10:30 AM

Room: Room4

Short (5-10 mins.) talks on a variety of technical topics. 

All welcome - feel free to turn up and speak on the day!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Azure / Cloud

Level: Beginner

Session Code:

Date: June 29

Time: 10:45 AM - 12:15 PM

Room: Room3

This session looks at the reporting technologies that are available from Microsoft for BI reporting. We will look at how Microsoft BI technologies can be used to meet a wide range of user needs, from personal BI to Enterprise-wide reporting. We will demo of various technologies can be used to meet your reporting needs and the similarities and differences between them.

Topics: Excel, Power BI, SQL Reporting Services 2017, Power BI Server, Data Models, Self Service Reporting

In this session we will see cover;
- Organisational Information Needs
- Data Modeling
- Microsoft Reporting technologies overview
- Demo on Key Reporting Technologies
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 29

Time: 2:30 PM - 3:30 PM

Room: Room2

Technology changes quickly - patterns and approaches less so. As we move towards distributed cloud architectures we will employ a range of disparate tools, the patterns that were designed for single box solutions may not be appropriate any more.
 
We will first review the patterns and processes that underpin the Lambda architecture, providing advice and guidance on the tool sets and integration points between them.

This intense, demo-packed session implements real-time reporting using the Lambda Architecture in Azure, demonstrating Azure Data Lake Store, Azure Databricks, Data Factory, SQL Datawarehouse and Stream Analytics. Time permitting, we will compare and contrast against an alternative pattern using Cosmos DB & Spark Structured Streaming.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: Room3

“Performance Dreams started at SQL Server 2014 and came true now at SQL Server 2016,2017 “, it is just like this because you there are unbelievable performance reads and substantial improvements that can drive your DB environment to a distinct level of stability and Performance to be a leading environment in a very short time ..! It looks like apparently a myth or legend to see those new SQL Server 2016 features how they could flipped up SQL Server Powers from the old generation to the new generation of in-advanced analytics using In-memory and CCI (Colmnstore indexes) where no longer need for any DWH solutions at all but just reading data directly from production DBs with ZERO performance impacts on end users  ..! come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 & 2016 regarding performance particularly like  Microsoft project “Hekaton” for In-memory built in for OLTP , CCI( columnstore index) ,Resource Governor for IO
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 29

Time: 3:45 PM - 4:45 PM

Room: Room1

Power BI is the shiny new tech for processing and visualizing data in the Microsoft Data Platform. However, the plumbing in the background does need managing (even if it is cloud-based and supposedly automagic).

In this session we will take a look at how to manage your datasets, security, monitor licensing and more, all through the ultimate administration interface: PowerShell!

You'll leave the session with an overview of the management capabilities of Power BI and couple that knowledge with the awesome power (and automation possibilities) of PowerShell
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
PowerBI

Level: Intermedia

Session Code:

Date: June 29

Time: 11:45 AM - 12:45 PM

Room: Room3

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