Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 49
Dell EMC’s unique integrated copy data management (iCDM) offering combines performance & scalability with reduced operational risk through automation and self-services. Maximize the value of your company’s storage deployment by simplifying MS SQL database & application workflows and reducing development timelines. In this session, we will discuss how application admins and DBAs can repurpose different copies SQL Server DBs instantaneously and become more agile.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: February 24

Time: 12:15 PM - 1:15 PM

Room: 115

It’s no surprise that embarking upon a job search can be a high-anxiety time.  However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels (including 4 current key resume truths), working with Recruiters, always attempting the "referral route," leveraging alerts and other strategies, etc. can help reduce frustrations and make it better.  In this session, we’ll highlight our top 13 strategies to help you go from "I'm not finding jobs I'm interested in" and/or "I'm not hearing back on my resume or from Recruiters" to "it's time to prepare for my interview!"
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: February 24

Time: 9:40 AM - 10:40 AM

Room: 120

Are you new to Power BI Server? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations?  This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: February 24

Time: 11:00 AM - 12:00 PM

Room: 120

Indexes can be a boon or detriment for database performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE).  This session will focus on a deep dive into clustered indexes, Primary Keys, and nonclustered indexes (including B-tree traversal), their syntax and utilization, and their effect on performance in transaction and data warehouse databases.  Covering nonclustered indexes will also be examined in detail.  There will be many live query demos illustrating index utilization and performance using statistics and query plans. Some knowledge of Management Studio and TSQL is recommended.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 24

Time: 2:45 PM - 3:45 PM

Room: 123

Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: February 24

Time: 11:00 AM - 12:00 PM

Room: 124

So you're using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how do you do restore? Where are the backup files? When are service packs applied? Can service packs be rolled up thru dev to production? What's a service level and how does it impact database design? How do we encrypt, authorize, query tune, restore...?  We'll go over these questions and any others that you may have.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: February 24

Time: 8:30 AM - 9:30 AM

Room: 1102

The world is changing rapidly and the big data ecosystem is enriching their capabilities even more, now there are a set of scalable languages that you can use in the Microsoft Azure environment to tackle and solve different problems, in this session you will learn the best practices, common scenarios and use cases for Hive, Pig, PolyBase, Scala, Python, Spark-SQL and U-SQL, in the end you will be able to understand the best fit for each one of those scalable languages.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 24

Time: 4:00 PM - 5:00 PM

Room: 120

SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.  

In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics.    Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 24

Time: 8:30 AM - 9:30 AM

Room: 115

Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or whether or not a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? The answer is baseline metrics.

Only if you have baseline performance information can you answer these questions and form a plan to address the issues at hand. In this session, we will be discussing several open source tools you can combine into an inexpensive baselining system you can use to troubleshoot issues and answer important questions.

Attendees in this session will learn how to collect important metric data, what data to collect, and how to interpret that data and develop a plan of action to address any issues.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 24

Time: 4:00 PM - 5:00 PM

Room: 1102

How to set up a Requirements Analysis to develop successful databases
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 24

Time: 11:00 AM - 12:00 PM

Room: 123

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 24

Time: 8:30 AM - 9:30 AM

Room: 124

Today's modern global business environment necessitates information being available in the end user's native language. In the past this challenge has been met in a variety of ways with mixed results. Often companies maintain multiple sets of reports and data per language or implement solutions which perform poorly and are difficult to manage. The solution presented here is scalable,  easily managed and performs better than commonly used solutions.
This session will highlight how to create a pivoted dataset for the translated text, use native SSRS functions and change translations based on the user's browser locale information. At the end of this session you will have a dynamic and robust method to handle multiple languages for reporting.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 24

Time: 2:45 PM - 3:45 PM

Room: 124

One of the highly touted features of SQL 2016 is Dynamic Data Masking (DDM).  In this session, we will take an in-depth deep dive into implementing DDM and discover its good, bad, and indifferent features.  We will discuss use cases where DDM can help and where it may hinder development, QA, or auditing use cases.  Attendees will leave the session with the knowledge needed to deploy a comprehensive DDM solution in their environments should DDM be a match for their use cases.  High level data protection and auditing topics will be discussed as well.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 24

Time: 8:30 AM - 9:30 AM

Room: 112

You know they are there, those small issues that affect performance and are easy to fix, but finding them can be a challenge. This session will show you how to find the low hanging fruit in your environment, explain why the problem exists, and step through how you can make the necessary changes to boost your SQL Server’s performance with a minimal amount of effort.  With over 15 years experience, Jonathan will show you how to find common schema and code design problems, to help you get the most bang for your buck when performance tuning SQL Server. By focusing on real-world examples with reproducible workloads, you will easily be able to see the impact of common problems and learn how to fix them quickly for improved performance from the least amount of effort.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 24

Time: 8:30 AM - 9:30 AM

Room: 1101

In its origin, Hadoop was created as an open source distributed computing system designed to process massive amounts of data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. The Stinger initiative accomplished just that! In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 24

Time: 9:40 AM - 10:40 AM

Room: 124

PowerShell is the robust automation language for Windows. When extended Azure modules, you get a robust Azure automation platform.  In this presentation, we’ll explain how to create, inquire about, and manage Azure resources from the client-side using PowerShell.  Then we’ll look at how to create PowerShell automation jobs called Runbooks within Azure and the features of using this approach.   Finally, we’ll see how we can get the best of both approaches by using the Azure Automation Authoring Toolkit, a PowerShell ISE Add-On that seamlessly integrates local PowerShell development and testing with cloud based Azure Runbooks.  If you plan to use Azure, you need PowerShell, the Azure automation language so come to this presentation to get started.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 24

Time: 4:00 PM - 5:00 PM

Room: 123

Do you have complex operations that have already been tuned for optimum performance, but still run too long for a good end user application experience? If you do, Service Broker may be the solution. 

This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required. Even in SQL Server 2014, Service Broker lacks a UI integration, which is sometimes a road block for implementations. Not to worry, this session will show you how to configure Service Broker correctly the first time so you can develop easy, foolproof deployments to solve complicated problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 24

Time: 1:30 PM - 3:00 PM

Room: 115

In this session, I'll show you how to hack SQL Server using a simple C# console application and other tools. Most importantly, I'll show you how to protect these vectors that perhaps you're trying to use to safeguard sensitive data for GDPR compliance.

1. Tabular Data Stream (TDS) Protocol
2. Dynamic Data Masking
3. Row Level Security (Yep...)
4. Database Source Control

Perhaps, you've seen these exploits before but do you really know how to reproduce them? Or, how to even protect yourself against them?

No worries, I'll show you the way along with a load test.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: February 24

Time: 8:30 AM - 9:30 AM

Room: 118

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 24

Time: 1:30 PM - 2:30 PM

Room: 124

This session will cover how to successfully market yourself by attending UserGroups, SQL Saturdays (You are off to a good start) and utilizing Social Media. I will be using real life examples on how I got to where I am today. This session is a motivational topic and will help individuals getting into the field or students.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 24

Time: 4:00 PM - 5:00 PM

Room: 112

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