Build Schedule

Advanced Filters:
  • Track

    clear all



















  • Speaker


  • Level


  • Session Type


Sessions Found: 51
Do you have a solid social media marketing plan for 2019-2020?  Are you sitting on the sidelines paralyzed at the thought of creating engaging content every day for Podcasts, Blog Posts, Twitter, Instagram, Instagram Stories, Instagram TV, Facebook, Linkedin, Twitch, YouTube and SnapChat?
   
In this session, you will learn the 7.5 steps to create a never-ending fountain of meaningful and engaging content across all social media channels.  You will gain actionable insight on how to connect with your community as we analyze how RedBull, Buffer, Virgin and Charity Water connect with their communities. 

At the end of the session, you will be equipped with the tools, resources, and energy-efficient shortcuts to create a custom and scalable marketing strategy.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Career

Level: Beginner

Session Code:

Date: July 13

Time: 1:30 PM - 2:30 PM

Room: 214

Do you know what makes a great data model?  What does it mean to be Third Normal Form or a Star Schema?  When would you use one over the other and why?  How can you identify bad designs?  In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: July 13

Time: 8:30 AM - 9:30 AM

Room: 214

How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties.  Seems like that is all I have done for last many years.  But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios.  In some scenarios a well-defined clustered index may out perform a covering non-clustered index.  Results are very interesting and may surprise you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Performance Tuning

Level: Intermedia

Session Code:

Date: July 13

Time: 11:00 AM - 12:00 PM

Room: 214

Ever wonder how to select what columns need to be in an index definition and what columns should be in the INCLUDE clause.  This session will take a deep dive in looking at two SELECT queries on the AdventureWorks2017 database and what indexes give the best, adequate, and poor performance and their relation to disk space utilization.  Sometime what you have heard (word of mouth) is not always the overall best solution.  This session is about 60% demos and yields some surprising results.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Performance Tuning

Level: Intermedia

Session Code: Closed Cap

Date: July 13

Time: 3:50 PM - 4:50 PM

Room: 203 Closed Caption

Presented by Redgate 

DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX.  We’ll discuss the techniques used to include the data
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: July 13

Time: 1:30 PM - 2:30 PM

Room: 116

In the last releases,  SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Dev

Level: Intermedia

Session Code:

Date: July 13

Time: 10:50 AM - 11:50 AM

Room: 116

Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you'll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: July 13

Time: 3:50 PM - 4:50 PM

Room: 215

You’ve looked at query plans and done some tuning, but you’re not sure what’s going on underneath. Hash Match? Merge Join? Watch both come to life in animations, and more! See (not just hear) the inner workings of a plan, and learn about the details that matter for performance. When plans make sense, tuning will become easier, and maybe even fun!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Performance Tuning

Level: Intermedia

Session Code:

Date: July 13

Time: 11:00 AM - 12:00 PM

Room: 215

This session is for you if you’ve ever built an amazing data set that was everything you needed, but then you went to create a dashboard, you got annoyed by any of the following:

-Your boss won’t approve the costs to get PowerBI Desktop.
-You’re not a coder, so learning R or Python sounds super scary
-You add a whole bunch of columns to your data set and now your file size is gargantuan 
-You add a field to a pivot table and the grand total row makes no reasonable sense
-Your average between two dates is 2.6166666667; how many hours and minutes is that?
-You add a date field to a pivot table and the month names get sorted alphabetically
-You add a graph to your dashboard, but have to add a table that will be hidden from a user later
-The two new pivot tables make your dashboard looks out of whack

Providing an overview of the above, the demos will give an insight into how powerful PowerPivot, PowerBI, and DAX can be.  I'll provide cool tricks and new ideas on what to search
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: July 13

Time: 8:30 AM - 9:30 AM

Room: 215

As more data services come online in Microsoft Azure, DBAs are being tasked with bringing these services into their organizations.  Azure Databricks is one such service that has the appeal of combining scalable compute resources with collaborative development and analytic tools in Notebooks and workspaces.  To the traditional DBA, however, many of the concepts and language support may be foreign. What the heck is Scala anyway?  This session is designed to introduce the DBA to the Azure Databricks workspace and show how to easily integrate it with upstream and downstream services like Azure Data Factory and Machine Learning.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: July 13

Time: 11:00 AM - 12:00 PM

Room: 216 Closed Caption

You can't wait to move your databases to an Azure PaaS offering so you don't have to patch and maintain an operating system and SQL Server.  You looked at Azure SQL DB, but there are some limitations that prevent you from migrating to this service. Don't worry, you're not stranded.  There is a new option designed to "Lift and Shift" your workload to Azure PaaS.  It's a brand new offering that just came out of private preview and into public preview.  We'll discuss this new offering, its advantages, and how you can migrate with ease.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Intermedia

Session Code: Closed Cap

Date: July 13

Time: 8:30 AM - 9:30 AM

Room: 104 Closed Caption

A few years back virtualization changed the way to work with SQL and infrastructure. Now the next chapter is opening and it’s all about containers. Containers can make the DBA’s job of creating and deploying servers much easier freeing them up for other tasks such as performance tuning and security. 

In this session, we will go over the concepts of containers, their general capabilities, and then build, connect and configure a SQL Server in a container for use as a private lab.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: July 13

Time: 9:40 AM - 10:40 AM

Room: 214

Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to accelerate the learning curve in Microsoft Data Platform, based on my knowledge and experience,  the proven strategies and techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Career

Level: Beginner

Session Code:

Date: July 13

Time: 3:50 PM - 4:50 PM

Room: 211

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.  
  
Come to this session to get an introduction to the R language including: 

  - installing and Configuring R and RStudio 
  - RStudio Overview and Debugging
  - how to Access and Manipulate Data 
  - install and Manage Packages 
  - create and Use Variables 
  - control Flows 
  - functions 
  - basic Graphing and Statistical Analysis. 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.  
  
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: July 13

Time: 2:40 PM - 3:40 PM

Room: 214

You have been hearing about Azure CosmosDB but you haven't had a chance to explore it. In this session, you will learn the key concepts of Azure Cosmos DB. I will use many analogies to explain advantages and limitations of Azure CosmosDB. By the end of this session, you will be able to setup CosmosDB and know its available tools.

I will cover the following topics in this session 
Why do we need another database system?
How to setup Azure CosmosDB
How to create database and containers.
How much does it cost?
Multi-Model Apis
CosmosDB vs SQL Server
How to Import Data into CosmosDB
How to use Cosmos DB Emulator
CosmosDB Limitations
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Beginner

Session Code: Closed Cap

Date: July 13

Time: 9:40 AM - 10:40 AM

Room: 216 Closed Caption

Dynamic SQL for the Developer & DBA.  In this class we will learn how to use Dynamic SQL on a day to day basis.  Building Dynamic Tables from a wide variety of parameters passed into your query; Building Dynamic Column headers for those tables and using Pivot to display the results into a grid format.  We will also explore passing parameters into and out of your SQL Query, creating dynamic search strings, and creating multiple databases, table structures using cross database scripting and Dynamic SQL.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Dev

Level: Intermedia

Session Code:

Date: July 13

Time: 3:50 PM - 4:50 PM

Room: 116

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts. 

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: July 13

Time: 2:40 PM - 3:40 PM

Room: 211

Most are talking about it, some have migrated to it and others are just overwhelmed.  If you thought Azure was the color of the sky and you are wanting to learn about MS Azure then this is the session for you. 

Join me for a fun journey to learn the very basics of Azure.  Some how-tos, some whys, and some demos. 

This is a level 0 session, #N00b, #Imabeginner
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Beginner

Session Code: Closed Cap

Date: July 13

Time: 2:40 PM - 3:40 PM

Room: 216 Closed Caption

Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement.  Our discussion will provide context for what, why, and how of Data Governance.  You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: July 13

Time: 8:30 AM - 9:30 AM

Room: 211

SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: July 13

Time: 2:40 PM - 3:40 PM

Room: 117

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