Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 11
Interested in being able to manage, monitor and document your SQL Environment from a single location? Want to be able to produce modern interactive reports and dashboards that can be viewed on both desktop and mobile devices? 

By adding a little "Power" to your DBA toolkit you can!

By combining PowerShell and PowerBi with the more traditional DBA tools I will show how to query and document your entire environment and produce rich interactive reports that can be consumed by all levels of your organisation.

This is a constantly evolving Presentation based around latest features in PowerBI and PowerShell
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 29

Time: 1:00 PM - 2:00 PM

Room: Room A

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 29

Time: 3:30 PM - 4:30 PM

Room: Room B

You have an on-premise instance of SQL 2016 but what-if performance sucks every now and again
Have you looked in the plan cache?
What to look for in saved plans
Keep you plan cache trim
Are your indexes being used as you expect?
Do you have table/index hot-spots?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 29

Time: 2:15 PM - 3:15 PM

Room: Room A

Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 29

Time: 1:00 PM - 2:00 PM

Room: Room B

You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive pièce de ré·sis·tance on the visual design surface!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 29

Time: 3:30 PM - 4:30 PM

Room: Room A

In this session, we will first learn how to expose organizational data using the data management gateway to Power BI. We will then look at how to use PowerQuery to acquire and cleanse data from organizational and external sources. As part of the session, we will also look at some tips and tricks to facilitate data acquisition and cleansing.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: April 29

Time: 9:30 AM - 10:30 AM

Room: Room B

“OMG! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 29

Time: 9:30 AM - 10:30 AM

Room: Room A

How to leverage in-flight recorder (Query Data Store) to tune workloads that are performing poorly?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 29

Time: 2:15 PM - 3:15 PM

Room: Room B

In this Demo Heavy Session we will explore the recently released SQL Server on Linux

Join me as we try to understand questions like?
How do we install and run SQL Server on Linux?
What is different, what is the same?
What may be better? What might be worse?
Why would it be useful? 
What new skills will you need?

The presentation will be based around experience gained in evaluating the Public CTP and will help introduce you into the brave new world of SQL Server on Linux
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 29

Time: 10:45 AM - 11:45 AM

Room: Room A

Microsoft SQL Server 2016 introduced multiple new security enhancements that can help make your environment more secure.  In this session we will cover these options and brief demo on how they are implemented.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 29

Time: 10:45 AM - 12:15 PM

Room: Room B

Data governance is becoming increasingly important to corporations who must demonstrate compliance to industry and corporate regulations. This is occurring against a backdrop of continuously evolving technology, an explosion of diverse data sources, and exponential growth in volume. Data professionals are tasked with ensuring data quality, enforcing data security, tracking model changes, and complying with audits. We will discuss a practical, model-based approach to enterprise data governance, with a focus on Master Data Management (MDM).
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 29

Time: 12:00 PM - 1:00 PM

Room: Room A

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