Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 29
Have you ever wanted to add slick visualizations to your application? Did you fight with 3rd party chart controls or try and host SQL Server Reporting Services reports in that application? Have you ever seen a cool dashboard in Power BI and thought "this is great, but its ANOTHER place that my users need to go for insights they should be able to see in the application? 

The Power BI Embedded services allows you to host interactive visualizations inside of your website or application. This session will walk through the process of embedding a Power BI Report into an application!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: Room C

SQL Server originally shipped in 1989. A full 20 years later, in 2009, Microsoft announced SQL Azure, currently known as Azure SQL Database. What is it? Is Azure SQL Database a hosted version of SQL Server? A subset? A superset? Actually, none of those simple explanations really capture it. Come join cloud computing veteran Bill Wilder to dig into the topic and go over the key differences between them, understand your cloud options, with a focus on how you would put Azure SQL Database to work today, including deploying, managing, securing, scaling, and DR enabling.

By the end of this session you should have a feel for how your SQL Server skills transfer to Azure SQL Database, which aspects of management & control Microsoft takes on, and how to use the toolbox of goodies for encryption, threat detection, DR, and global scale.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: Room F

You know about the cloud but you’re not there yet. Is it hard? Is it easy? How do you get started? Come to this session and see for yourself. We’ll start with nothing and end up with a deployed Azure SQL Database. We’ll even run a quick PowerBI report and enable Geo-Redundant Disaster Recovery with a few clicks.

The goal is to take the mystery out, to show the capabilities and get you thinking about what going to the cloud could look like and what it can do for you and your company. I believe the future belongs to those who have this knowledge and know where to apply it.

This will be nearly PowerPoint free and we’ll log into my Azure Portal and build out an environment from scratch and learn as we go. We’ll migrate data from an “on-premises” database into our SQL DB and we’ll query it. You’ll leave with an understanding of the capabilities, some resource links outlining what we did and hopefully some curiosity to see what else is up there in the cloud as you start exploring.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: December 09

Time: 10:15 AM - 11:15 AM

Room: Room E

Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together. 

This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 09

Time: 1:30 PM - 2:30 PM

Room: Room F

Has your company been building data warehouses for years using SQL Server?  And are you now tasked with creating or moving your data warehouse to the cloud and modernizing it to support “Big Data”?  What technologies and tools should use?  That is what this presentation will help you answer.  First we will level-set what big data is and other definitions, cover questions to ask to help decide which technologies to use, go over the new technologies to choose from, and then compare the pros and cons of the technologies.  Finally we will show you common big data architecture solutions and help you to answer questions such as: Where do I store the data?  Should I use a data lake?  Do I still need a cube?  Do I need the power of MPP?  Should I build a "logical data warehouse"?  And we'll close with showing some architectures of real-world customer big data solutions.  Come to this session to get started down the path to making the proper technology choices in moving to the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: December 09

Time: 10:15 AM - 11:15 AM

Room: Room B

Anyone who has worked with SSIS has dealt with the frustration of poor data quality and cryptic error messages. Microsoft has gotten better at providing better error messages within the Data Flow task, but still falls short in some areas.  In this session we will discover how to get the real error message in a data flow task and how to isolate the rows causing the errors.  We will start by reviewing a solution developed using a script component and progress to a method used to identify data quality issues before an error occurs.  We will also discuss other options to handling data quality and errors.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: Room B

How often do you review your SQL Servers for basic security, maintenance, and performance issues?  Many of the servers I "inherit" as a managed services provider have quite a few gaping holes. It is not unusual to find databases that are never backed up, servers with constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that even have too much!) 

Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: Room E

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?

This presentation will review the following techniques to fix your woes.

Coverage:

1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: Room B

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: December 09

Time: 9:00 AM - 10:00 AM

Room: Room F

Are you stuck in your existing job for years? Do you feel you need to get out, try either a new company or a new role; or even a new boss? This a very entertaining and highly interactive session is perfect for you. I promise, you'll walk out of it totally reassured and enlightened.

In this session I'll share my and other people's real stories and the techniques about keeping abreast the job market and finding new opportunities. 

We'll also talk about normal mistakes that people make when they are cozy in a job. 
But, what do we do once we get that rare opportunity to interview. 

We must take care of :
1. Overall appearance
2. Food habits on the eve of the interview
3. Postures
4. Arrival
5. During the interview
6, Closing
7. Follow up
8. Maintaining interview logs

Keep going at it. Never stop looking!!!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 09

Time: 1:30 PM - 2:30 PM

Room: Room E

There are many tools available to successfully migrate your on-premises relational database to Microsoft Azure SQL V12 database.  Do you know what tools are available for migration? How do you choose the best tool for you?  How do you analyze what objects are not compatible for migrating to Azure? It depends on the type, size and complexity of the database being migrated. In this demo based session I will show you 4 different tools, that you can use to analyze/migrate your on-premises SQL Database to Microsoft Azure SQL V12.  We will migrate a single database using 4 different tools so you know what options are available for you. I will also talk about where you can download and how you can set up these tools. Briefly talk about pros and cons of each tool. At the end of this session you will be aware of the various techniques available to analyze and migrate SQL Database to Azure V12 and chose the best fitting one for your database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: Room A

You've just been told by HR that you are no longer a part of their organization.  You've been kicked to the curb.  You are now living in the no-man's land called unemployment.

Unemployment is a scary situation.  You're dealing with emotions and uncertainty.  You don't know if you'll be out of work for days, weeks, or months.

Fortunately, unemployment is survivable.  In this session, I'll share my own experiences (and perhaps we'll talk about some of yours) with unemployment, and how I managed to get through the tough times.  We'll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time.  Hopefully, you'll land on your feet once again before long!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: Room E

The Enterprise Edition of SQL Server 2016 contains 2 powerful features for database and data warehouse developers to improve performance and scalability. One is columnstore indexes and the other is in-memory optimized tables. In this presentation I'll show several examples with large databases on how you can get the most out of these 2 great features. I'll cover the scenarios and contexts where columnstore indexes and in-memory optimizes tables work best.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 09

Time: 10:15 AM - 11:15 AM

Room: Room F

Data, data, everywhere - how do you keep track of what data you have and let your consumers know?  In the library, the card catalog has been replaced with an online searches.  In this talk, we will show how Azure Data Catalog tops Dewey when searching for your data sources, and how this is a component of your Data Governance strategy.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: Room E

Do you like making things easy for yourself? Are you a database professional who has yet to feel comfortable with PowerShell? Then this session is for you. 
In this demo heavy session I will go over how a DBA can use PowerShell to make life easier when dealing with common, and not so common, issues and tasks. I will show you real world examples of how PowerShell and SQL Server work together, like peanut butter and jelly, to help you solve problems. We'll go on a magical journey from brief overview and simple scripts to advanced functions and modules. Leveraging the power of PowerShell we'll iterate over instances, audit servers, migrate instances, manipulate SSRS subscriptions and much more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 09

Time: 1:30 PM - 2:30 PM

Room: Room D

Deleting, mapping, updating, or otherwise manipulating data in a highly relational environment can be a big challenge!  This is a dive into how we can effectively map out these relationships and use that information to make carefully planned changes to that data.

We will build from the ground up a script that will allow you to gain complete insight into the structure of a relational database.  Not only will this provide a complete map of relationships given a specific SELECT statement, but the TSQL can then be used to generate DELETE and UPDATE statements given that information.  Optimization techniques will be applied to this script to ensure that it executes efficiently, even on a large database.

Can gaining insight into relational structure and design be educational and fun?  YES!!!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: December 09

Time: 1:30 PM - 2:30 PM

Room: Room B

Master Data Management is a discipline, Master Data Services and Data Quality Services are tools for implementation.  In this presentation you will learn the different types of data mastering.  Assuming you have the services installed and configured, the demonstration will walk you through a mastering implementation that requires DQS and MDS integration.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: Room C

Queries are tuned after the fact and the first performance trick that any developer / DBA uses is to slap on an index. Knowing how to re-write the query before adding an additional Index and coding with performance in mind sets a good developer apart.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: Room C

You need to deal with more security requirements in your role.  How can SQL Server features help you comply?  We will delve into Audit, Compliance, and Encryption.  New 2016 features like Always Encrypted will be detailed at the end.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: Room B

Wonder how to get into "Power BI"? Architecture of Power BI confusing you? Listen to George Walters discuss the architecture of Power BI from rich desktop authoring, to dashboards in the cloud.  We will finish with an interactive dashboard of data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: December 09

Time: 1:30 PM - 2:30 PM

Room: Room A

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