Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 51
By now you have probably seen many Power BI demos and likely love what you see in the product.  However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try.  So what do you do when your data is not perfect or your business problem is more complex?  In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work.  This session will give you many tips on how to solve real world problems with Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: November 12

Time: 9:00 AM - 10:00 AM

Room: Business Intelligence - Rm 4105

In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: November 12

Time: 4:30 PM - 5:30 PM

Room: DBA/Professional Development - Rm 3205

While the web portal makes it easy to deploy SQL Server on Azure Virtual Machines, there are a number of benefits to using PowerShell to do the job. This session will introduce Azure PowerShell command-lets and how to create a basic Azure infrastructure to support a SQL Server VM. We'll include the Azure Resource Manager, how to use ARM VM templates and Custom Script Extension, and how users can modify an existing Azure Gallery template. Desired State Configuration (DSC) will be covered to complete the Azure Powershell automation toolkit, allowing attendees to automate the deployment of dozens or more SQL Server virtual machines. Finally, we will configure Availability Groups and explain their eccentricities in the Azure environment as well as how to make them work effectively.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 12

Time: 10:15 AM - 11:15 AM

Room: Analytics & Viz - Rm 3207

This session provides case studies in rewriting bad SQL, with a lot of discussion on what makes sql code "bad"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 12

Time: 11:30 AM - 12:30 PM

Room: DBA Admin - Rm 4208

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.  
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: November 12

Time: 9:00 AM - 10:00 AM

Room: Analytics & Viz - Rm 3207

SQL Server 2016 now includes a feature called SQL Server R Services. This feature allows for direct integration between database and the R statistical language. In this session we'll look at some of the R and SQL integration features, then we will build a machine learning model and then use that model for scoring and predictive analytics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: November 12

Time: 2:00 PM - 3:00 PM

Room: Analytics & Viz - Rm 3207

The Cortana Intelligence suite is evolving every day. What began as data blob stores, no-sql providers, and SQL VMs, has grown into a full suite of offerings from Microsoft. Today you can build your entire data platform with ala carte purchases from Microsoft. In this session, I’d like to give you an overview of the services available as of the date of this presentation.  I’ll also share with you some ways the different offerings have been used in products I’ve worked on in the past, as well as some insights into how it will be used in the future.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: November 12

Time: 9:00 AM - 10:00 AM

Room: Analytics & Viz - Rm 3207

This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization.  It will also touch a little on why you might choose Power BI over Power Pivot and why you might not.  It will also look at how to create drill down detail screens to expose the details behind your visualizations.  Finally, we will touch on how to publish your Power BI results for others in your organization to share.  A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: November 12

Time: 2:00 PM - 3:00 PM

Room: Cloud/Security/Misc - Rm 3206

Data partitioning is an essential technique that simplifies database administration tasks, improves system availability and reduces the cost of the solution. Contrary to popular belief, data partitioning is not limited to partitioned tables and the Enterprise Edition of SQL Server.

This session demonstrates the data partitioning techniques available in the various editions of SQL Server. It discusses benefits, downsides and the best use-cases for partition tables, local and distributed partitioned views and stretch databases. The session will also demonstrate how data partitioning helps boost performance of systems handling a mixed workload, improves cardinality estimations with large tables, and reduces the system’s storage cost. 

Finally, the session provides a set of guidelines on how to split the data between relational and non-relational storages in OLTP and IoT systems hosted in the Cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 12

Time: 9:00 AM - 10:00 AM

Room: DBA Admin 2 - Rm 4106

This session will take you through some of the basics of setting up DQS and how to get started. Beyond the technical work required to setup DQS, there is the Data Steward and their role in the day to day interactions with DQS. This session will explain how to integrate the Data Steward into the process to approve and correct data, in addition to how to integrated those corrections back into your data warehouse loads.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: November 12

Time: 10:15 AM - 11:15 AM

Room: DBA/Professional Development - Rm 3205

A dive into database project details. This demo heavy presentation will look at configuring database projects, building and publishing, deployment scripts, using SqlCmd variables, and (time permitting) creating unit tests.  This session will also look at composite projects to logically break apart a database solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 12

Time: 3:15 PM - 4:15 PM

Room: Business Intelligence - Rm 4105

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about: 

Asking the right questions to set yourself up for success
Making the case for stored procedures over ad hoc code and other objects
Pro tips for standardization and cross-version compliance
Reevaluating and expanding on your solution
Limiting inputs to reduce unexpected behaviors and errors
Choosing between alternate solutions
Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: November 12

Time: 4:30 PM - 5:30 PM

Room: DBA Performance - Rm 4103

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

 1. Quickly fine tune a SQL statement
 2.  Identify performance inhibitors to help avoid future performance issues
 3.  Recognize and understand how new SQL Server features can help improve query    
      performance
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 12

Time: 2:00 PM - 3:00 PM

Room: DBA Performance - Rm 4103

Minion Backup is a stand-alone backup solution that can be deployed on any number of servers, for free. Once installed, Minion Backup (or just, MB) automatically backs up all online databases on the SQL Server instance, and will incorporate databases as they are added or removed. 
 
While the solution is designed to be as simple as possible to get up and running, MB is deeply configurable for every backup scenario. In this session, attendees will learn about:
 
* Live Insight, which displays the status and progress of backups as they're running
* Backing up to Azure
* Striping, mirroring, copying, and/or moving backups to various destinations
* Flexible backup delete and archiving options
* Dynamic Backup Tuning, which changes tuning settings based on your custom thresholds
* Backing up certificates and passwords
* High Availability and Disaster Recovery features, including compatibility with Availability Groups
* Shrink log file on log backup, and some of the associated considerations
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 12

Time: 10:15 AM - 11:15 AM

Room: DBA Performance - Rm 4103

No budget?  That's OK!  Need Tools?  We've get them!  Don't know where to go?  We'll show you!  The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out.  In this session we will show you several great tools, scripts, blogs and other resources to help you out.  Best of all, it's all free!  But wait, there's more.  Order now and we'll include an extra two tips at no additional cost!  
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 12

Time: 2:00 PM - 3:00 PM

Room: DBA Admin 2 - Rm 4106

U-SQL is the query language for big data analytics on the Azure Data Lake platform. This session will explore the unification of SQL and C# in this new query language, examples of combining data from external sources such as Azure SQL Database and Blob storage with Azure Data Lake Store, creating and referencing assemblies, job submission and tools. The ADL platform will also be compared and contrasted to the HDInsight/Hadoop platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: November 12

Time: 3:15 PM - 4:15 PM

Room: Analytics & Viz - Rm 3207

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: November 12

Time: 3:15 PM - 4:15 PM

Room: Cloud/Security/Misc - Rm 3206

This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: November 12

Time: 9:00 AM - 10:00 AM

Room: Cloud/Security/Misc - Rm 3206

This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: November 12

Time: 2:00 PM - 3:00 PM

Room: Business Intelligence - Rm 4105

You are a DBA, not a psychic.  If you want to know who is making changes, trying to access confidential data, or unsuccessfully attempting to login as the Web service account on any or all of the SQL Server instances you manage; you don’t need a crystal ball to gain the power of insight. However, if you follow along in this presentation you will be able to use the magic of SQL Server Audit to peer into the past with Power View and tell the professional future of the unwary soul who crossed your path. None shall PASS!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analytics Techniques

Level: Beginner

Session Code:

Date: November 12

Time: 11:30 AM - 12:30 PM

Room: Analytics & Viz - Rm 3207

Sessions Found: 51
Back to Top