Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 26
One of the new features announced for SQL Server 2017 is Adaptive Query Plans, query plans that can change after the query starts executing.

This session will show why this is a radical departure from the way that things have worked until now and how it can improve the performance of some query forms. We’ll look at the places where adaptive query plans work and compare the performance of queries using adaptive query plans to see just what kind of improvement it can make.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 09

Time: 2:00 PM - 3:00 PM

Room: Khai

Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Khai

Maybe you need a JumpStart? Reduction in migration friction between these platforms has lowered the barrier to entry, nevertheless, select fit for purpose technologies matching your scaling demand for storage and compute (and ambition), while you are at it, bridge the gap to Hadoop, Azure Blob Storage and Azure Data Lake Store with PolyBase.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 09

Time: 3:00 PM - 4:00 PM

Room: Congo

There are a lot of buzzwords being through around the last few years in the development space... Things like "containers", "Docker", "Service Fabric" and the sorts.

In this session we will look at what these various pieces of software are, what they are are good at and how work really well with SQL Server v.Next (2017) to give you exceptional availability for your data store.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 09

Time: 1:00 PM - 2:00 PM

Room: Orange

Data does not become information until decision makers are able to view it and make those decisions that affect the enterprise as a whole. Stored procedures are one means of getting the data from the database tables to the reports in an effective and efficient manner.
In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 09

Time: 1:00 PM - 2:00 PM

Room: Zambezi

Social Media data can be very powerful in growing your business, however this is BigData and not many companies know how to consume it and get the most benefit out of it. PowerBI has great features that allow you to use their templates to explore the data and get the most value out of it to make your marketing decisions. There will be a demo on how to set up a PowerBI Twitter Campaign, Facebook and Google Analytics dashboards and how to get value out of them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Zambezi

Learn why extended events are the preferred over SQL profiler. Come and see how to migrate to Extended events. Some practical info will be shared with a lot of demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: September 09

Time: 2:00 PM - 3:00 PM

Room: Orange

This session will walk through getting started with Microsoft Open R and Visual Studio.
We'll cover reading data into R, accessing R packages, writing R functions, and organizing and commenting R code.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Tugela

PowerBI is a powerful business analytics platform created to support both self-service and enterprise class reporting.

In this session, you will see how easily great looking reports can be created using multiple data sources and easily shared within your organisation. We will also discuss licensing options available ranging from free through to Premium licencing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 09

Time: 9:00 AM - 10:00 AM

Room: Zambezi

In this session we will review the differences between deploying Microsoft SQL Server 2016 in Microsoft Azure and on-premises from a Security, Reliability and Scalability perspective.  

We'll review the common mistakes which people make when deploying SQL Server Virtual Machines to Azure which can lead to security problems including data breaches.

We'll review the common performance problems which people encounter, and how to resolve them.

We'll review the common scalability misunderstandings of Azure and SQL Server Virtual Machines.

Join us for this fun session and learn how to improve the security, reliability and scalability of your Azure deployments of SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 09

Time: 3:00 PM - 4:00 PM

Room: Congo

Far too few database developers in this day and age get the opportunity to learn how to design relation databases.  In most cases, they will on occasion be asked to add a few objects to an existing system while following the standards of the organisation. These relatively infrequent changes do not hone the skills needed for effective design.

This session will go through the fundamentals of database design.  Topics such as normalization, Understanding Data Relationships as well as the Language of  Data Modeling and Design will be discussed. The Database Design Sequence Phases of Conceptual, Logical and Physical will be introduced as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 09

Time: 9:00 AM - 10:00 AM

Room: Congo

Do you believe the myths that “Third Normal Form is good enough”, or that “Higher Normal Forms are hard to understand”?
Do you believe the people who claim that these statements are myths?
Or do you prefer to form your own opinion?
If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: September 09

Time: 1:00 PM - 2:00 PM

Room: Congo

The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into things like connection pools, transaction scopes, batch inserting, async data access and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 09

Time: 3:00 PM - 4:00 PM

Room: Zambezi

When starting out with PowerShell and SQL Server, it is hard to escape from the detail to work out the best strategy for creating scripts. IN In this session I will  explains how, when and why it pays to think in terms of versatile functions to meet varying demands.
How would you improve a PowerShell script in order to make it more versatile? How can you ensure that it is adaptable to the many similar tasks for which you are likely to need a script? In a nutshell, you turn into functions those common component tasks that you’ve written as scripts, and from these simple functions develop advanced functions. In doing so, you make the leap from PowerShell Zero to PowerShell Hero.   In this session , I’ll walk you through a practical example and demonstrate the steps along the way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Orange

In this session we look at how R in SQL Server can be used in a production environment to automatically run models against data coming into SQL Server, as well as update the model with no interference from the data scientist.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 09

Time: 2:00 PM - 3:00 PM

Room: Tugela

In today's fast-paced world, businesses require up to the minute information to support critical decisions. Traditional business intelligence solutions, however, are not able to keep up with this demand and a new approach is required. Azure Stream Analytics is a real-time event processing engine capable of analysing millions of events every second. During the session, you will learn key concepts needed when working with streaming data in Azure before stepping through an end-to-end streaming data demonstration integrating Azure Event Hubs and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 09

Time: 1:00 PM - 2:00 PM

Room: Khai

In this session I will show how to deploy Docker on Windows Server 2016 and Docker for Windows, and then build and deploy Docker images with SQL Server 2017 for Windows and Linux. We will cover how to use Powershell to interact with Docker. We will also demonstrate how to interact with SQL Server running in Docker containers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: September 09

Time: 2:00 PM - 3:00 PM

Room: Congo

Master Data Services can be readily be employed for Rapid Application Development. We shall be looking at important development, data security and data maintenance aspects, all based upon a recent client implementation.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 09

Time: 9:00 AM - 10:00 AM

Room: Tugela

A lot of companies have a philosophy of "ship early with as many features as possible.” Security is an afterthought since it isn't fun to do and no one will attack them anyway. However, the dark side never sleeps, and security breaches have always happened, often leaving companies severely exposed or even bankrupt.
In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 09

Time: 9:00 AM - 10:00 AM

Room: Orange

Are you a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it?  I've got some of the answers here in this session for you.  During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: September 09

Time: 9:00 AM - 10:00 AM

Room: Khai

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