Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 30
An improvement of cardinality estimation is something we try to find in every next version of SQL Server. Even with all the improvements the SQL Server 2014 Query Processor gained, we still need to deal with Hash and Sort Warnings, extremely high or low Memory grants, or the well-known User Defined Functions performance issues. That’s why we are so existed to find the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance. Find out how the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 14

Time: 10:00 AM - 11:00 AM

Room: A

Anomaly detection is one of the most advanced data mining and machine learning tasks. There are many statistical procedures and data mining algorithms that can be used for it, including Expectation-Maximization Clustering, and Principal Component Analysis. In this session, you will learn through presentation and demos how to detect the low quality data areas with some basic statistics and with advanced algorithms. You will see how you can use T-SQL queries, R code in SQL Server, SSAS Data Mining, and Azure ML for this complex task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: October 14

Time: 1:15 PM - 2:15 PM

Room: A

With Azure Analysis Services (Azure AS) we have full set of PAAS and SAAS services like Azure SQL DWH, Azure SQL DB, Azure AS and Power BI for creating our BI solutions in the cloud. In this session I will introduce Azure AS and how we can use it together with other Azure services for creating complete BI solution in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 14

Time: 11:15 AM - 12:15 PM

Room: C

End-to-end encryption deserves end-to-end demo :)
In this session you will see not only what Always Encrypted is and how it works, but also how it looks like from developer’s perspective. It is a demo-heavy session and we will spend more time in Visual Studio and SSMS than in PowerPoint. I will show how to read encrypted columns in SSMS and how to do this in the application. You will also learn how to manage certificates in Windows Certificate Store and Azure Key Vault and why we need a separate security officer.
This session is intended for both developers and database administrators.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 14

Time: 1:15 PM - 2:15 PM

Room: B

We already know that cloud provides us with a way to control the amount of resources provisioned based on app load, scale them up and down. But what if I will say that there is a way to create your app, host it in the cloud and make it ready to respond at your call, but if you will have zero load during a month it will cost you nothing? Try to imagine that you will pay not for fixed amount of CPU and RAM, but for a number of function calls and amount of CPU time consumed to execute them. In this scenario you do not have a dedicated virtual machine, but you have an abstract web farm, which consists of 100500 servers and each of them is able to execute your code. In this case we do not have a server, neither physical nor virtual, we have a platform which can scale from zero to infinite in a few seconds. On top of that you can use your favorite language - C#, F#, Java, PHP, Python, Node.JS, PowerShell, Bash, etc.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: October 14

Time: 10:00 AM - 11:00 AM

Room: C

During this session we will review all types of replications in SQL Server and find out principal differences between them and when should be applied. Besides examples of practical scenarios, we will consider what we have as alternatives and why the AlwaysOn is not one of them. As always on my sessions quite a lot of demonstrations and T-SQL code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 14

Time: 1:15 PM - 2:15 PM

Room: C

A look at the state of the art in database continuous delivery using SQL Server Data Tools (SSDT), Visual Studio Team Services(VSTS), and VSTS Release Management.

The features provided by platforms such as TFS and VSTS have been widely adopted by application developers in support of modern software development practices such as continuous delivery.

In the world of database development, adoption has been much slower, due to a number of organisational and technical considerations.

This session will discuss some of the challenges associated with database continuous delivery, and the ways in which Visual Studio, SQL Server Data Tools and Visual Studio Team Services can help to improve delivery of SQL Server databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 14

Time: 10:00 AM - 11:00 AM

Room: D

CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema.
In this presentation, you will learn:
•	How to get started with DocumentDB you provision a new database account. 
•	How to index documents 
•	How to create applications using CosmosDb (using REST API or programming libraries for several popular language) 
•	Best practices designing applications with CosmosDB
•	Best practices creating queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: October 14

Time: 5:00 PM - 6:00 PM

Room: C

In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 14

Time: 5:00 PM - 6:00 PM

Room: E

A common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 14

Time: 5:00 PM - 6:00 PM

Room: A

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

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 14

Time: 11:15 AM - 12:15 PM

Room: E

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:
BI Information Delivery

Level: Intermedia

Session Code:

Date: October 14

Time: 3:45 PM - 4:45 PM

Room: B

You are already familiar with T-SQL and are eager to learn R but do not know, where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 14

Time: 5:00 PM - 6:00 PM

Room: B

From 25 May 2018, the EU General Data Protection Regulation (GDPR) will affect every organisation that processes EU residents’ personally identifiable information (PII). The GDPR contains requirements that systems and processes must consider compliance with the principles of data protection.
The essence of privacy by design is that privacy in a service or product is taken into account not only at the point of delivery, but from the inception of the product concept.
There is also a requirement that controllers should only collect data necessary to fulfil specific purposes, discarding it when it is no longer required, to protect data subject rights.

This presentation provides a breakdown of the key provisions introduced by the new law, which every organisation must be aware of
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 14

Time: 3:45 PM - 4:45 PM

Room: C

How easy is it to hack a SQL Server? 
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. 
Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 14

Time: 3:45 PM - 4:45 PM

Room: A

The European General Data Protection Regulation (GDPR) suggests penalties for those companies and organizations which do not comply with the directive. Fines can go as high as 4% of annual global revenue or 20 million Euros, whichever is greater. That's why everybody from C-level management to regular DBA is crucial to enforce compliance with the new data protection rules and for this very reason data maintenance tasks become absolutely obligatory and if a legal entity has skipped them, from now on it is not going to be possible.
In this session, based on our experience, we will speak about the most important DBA maintenance tasks you need to perform to keep your databases GDPR compliant.
Session is suitable for beginner DBAs and Developers.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 14

Time: 2:30 PM - 3:30 PM

Room: E

This session covers the internals of statistics and indexes in Microsoft® SQL Server®. Creating and maintaining statistics and indexes is a core element in enhancing the performance of the SQL Server Database Engine. Both statistics and indexes are used to select suitable query execution plans; indexes also speed up the retrieval of data. To understand and influence query performance, you should have a good understanding of queries and indexes.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: October 14

Time: 1:15 PM - 2:15 PM

Room: D

In this session, we will discuss where to start when you get your job as a DBA. What are the first steps you need to do to discover and arrange the environment for which you are responsible. How to answer questions like: How many databases do you have on each server? How big are they? What they are used for and how many of them are critical? Do you need backups and do you have such, Etc. There are many questions you got from the day 1, but where to start is always the key to not get panicked. The goal of this session is to help you perform your first steps in a DBA job, especially when you get into a situation with only one Excel spreadsheet containing your servers’ list.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 14

Time: 3:45 PM - 4:45 PM

Room: D

In this session we will look at SQL Server Machine Learning Services and, in particular, the new MicrosoftML package available in SQL Server 2017 and how it can be used to build an in-database Predictive Analytics Model, that can scale. 

The session will initially provide a primer to supervised Machine Learning before applying that to a real world scenario, taking you through each of the steps required to build an in-database predictive analytics model using R and SQL Server 2017.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 14

Time: 11:15 AM - 12:15 PM

Room: B

Microsoft surprised a lot of people with the announcement that SQL Server is going to be released for Linux. And there we have it - preview releases available in public are regularly delivered, working great and fast.
On my session I'll show details of solution that allowed this idea to come true. We'll see how to install, use and administer Linux version of SQL Server. We'll see it working as a service and in Docker containers. I'll give you details of why the second option is really interesting, or to say it more clearly - groundbreaking.
In addition to slides you're going to see lots of terminal windows, tools that are familiar to you and new stuff as well.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 14

Time: 10:00 AM - 11:00 AM

Room: B

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