Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 31
You have probably heard the buzz about Azure Machine Learning, aka Azure ML,  over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 07

Time: 12:45 PM - 2:00 PM

Room: ARP 212

Learn how Cohesity can help tame your data sprawl
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 07

Time: 12:15 PM - 12:30 PM

Room: ARP 210

Many of us feel pressure to deploy changes to our database more often and more reliably. SSDT gives us a number of options to set up continuous integration and eventually, continuous deployment. Learn how to create and customize DACPACs, Published Profiles, and SQLPackage.exe to automate your deployment process. Whether you want to update QA or smoothly get changes to production, this session will give you the tips and tricks you need to get started.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 07

Time: 2:15 PM - 3:30 PM

Room: ARP 116

One the unique challenges Data Science teams face is provisioning compute resources.  High core counts are required for only short bursts and sit idle for long periods thereafter.  A demonstration will show how one can overcome this using Azure Batch Services. After attending the session one will be familiar with the data mining workflow, data mining packages in R, as well as how to configure and use Azure VMs directly from an R session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 07

Time: 2:15 PM - 3:30 PM

Room: ARP 212

This session is theoretical with a focus on the many ways that we can model data. We will discuss why we select one modeling technique over the other in different user scenarios. These different scenarios will vary by industry and company, two main scenarios include: purchasing a product and storing the data related to the sales transaction, or visualizing the total sales for a product, month over month, for the calendar year 2016. Diagrams will be used to explain these different models and try to bring a more tangible aspect to the theoretical aspects of the discussion. Demos using IDERA ER/Studio Data Architect will be used to conclude the presentation.

Why Model Data
•	Business Benefits and Value

Different Model Types
•	Enterprise Model 
•	Conceptual Model 
•	Logical Model 
•	Physical Model 
•	Dimensional Model

Different Modeling Techniques
•	Normal Form Modeling
•	Star & Snow Flake Schema
•	Slowly Changing Dimensions
•	Many to Many Relationships
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 07

Time: 8:45 AM - 10:00 AM

Room: ARP 218

Learn more about how Datrium is revolutionizing data storage
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 07

Time: 12:15 PM - 12:30 PM

Room: ARP 212

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
 - Source to Target mapping documents can be used to generate the code to effect the mapping.
 - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
 - Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
 - Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 07

Time: 12:45 PM - 2:00 PM

Room: ARP 210

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed.  Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL.  From parameter based searches to building dynamic SELECT statements at run time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 07

Time: 2:15 PM - 3:30 PM

Room: ARP 210

Service Broker is a robust asynchronous programming model that provides reliable messaging between SQL Server instances. Making life easier for developers creating sophisticated applications to communicate between databases and servers. 

With focusing on your basic database to database asynchronous messaging to more advance messaging across multiple servers, we are positive you will walk away with new knowledge about Service Broker. And just as positive we will learn something new with you. As some of you may know, Service Broker never ceases to surprise.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: October 07

Time: 8:45 AM - 10:00 AM

Room: ARP 210

You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database... right?

Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.

In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 3:45 PM - 5:00 PM

Room: ARP 218

We all want to improve the speed of our databases to make sure they run optimally.  In this session we will explore relational and full-text indexes, their internals and uses.  We’ll take a look at some alternatives to full-text indexes and their pitfalls.  We’ll also explore turbo-charging the performance of your text-based search criteria using full-text indexes.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 07

Time: 2:15 PM - 3:30 PM

Room: ARP 218

You will learn R data structures such as vectors, matrices, lists and data frames; how to work with variables; common data transformations; and lastly how to leverage R's graphical capabilities.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 07

Time: 8:45 AM - 10:00 AM

Room: ARP 212

Full LIVE buildout of an 2-node SQL Server 2017 CTP 2 Availability Group, on Linux! We're going to start from scratch, and cover allocating VMs in Hyper-V, loading the OS, general configuration of the operating system, installing SQL Server, and finish with an controlled failover of SQL Server using native Linux utilities. We'll talk about each step along the way
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 8:45 AM - 10:00 AM

Room: ARP 116

Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 3:45 PM - 5:00 PM

Room: ARP 210

Talk to any DBA about ORMs and you'll quickly find out all the things you like about ORMs are what DBAs don't like. Interestingly enough, most developers I've talked to have issues with their ORMs, too. In this session, we'll explore why ORMs cause such trouble, some strategies for mitigating those troubles, and I'll introduce some tools (and even yet another ORM) that help solve some of the worst of the problems we see in the database when using ORMs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 07

Time: 12:45 PM - 2:00 PM

Room: ARP 224

Have you deployed Availability Groups in your data center? Are you monitoring your Availability Groups to ensure you can meet your recovery objectives? If you haven’t this is the session for you. We will discuss the importance of monitoring and trending Availability Group Replication, how AGs move data between replicas and the impact replication latency can have on the availability of your systems. We’ll also give you the tools and techniques to go back to the office and get started monitoring and trending right away!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 10:15 AM - 11:30 AM

Room: ARP 116

They are going to get in.  This session talks briefly about how they get in.  But they are going to get in.  It talks a little about security best practices.  But one little mistake by anyone and they are in.  How will you know they’re in?  How will you know how they got in?  What do they want?  How will you know what they’re doing?  How will you know if you’ve kicked them out?  This session will focus on the type of logging and tripwires you’ll need to respond to a breach of your SQL Servers.   It includes a mix of technical solution and process recommendations based on actual incidents.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 07

Time: 10:15 AM - 11:30 AM

Room: ARP 218

Quest Software Update
 
* Commitment to SQL Server Market
* Solutions Overview
-          Monitoring and Workload Analysis
-          Historical Trending
-          Ensure Coordination From DEV to TEST to PROD
-          Backup, Compression, and Recovery
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 07

Time: 12:15 PM - 12:30 PM

Room: ARP 218

We have over 3500 remote installations of SQL Server and only 3 DBAs to find and resolve issues. While some installations need daily examination others operate for months without any attention at all.
We needed a system to keep a light, revolving set of data that we could quickly pull back and analyze when issues were escalated to us.
This system also had to be modular so we could add or remove  queries, as needed, while always keeping the data fresh.
In this session I'll use Glenn Berry's diagnostic queries and SSIS to show how we collect and store data on our remote systems. When problems arise we download the data and use Powershell to digest it into a simple report.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 07

Time: 10:15 AM - 11:30 AM

Room: ARP 224

This no demo class will follow along the lines of an IT professional deciding to become a DBA or being handed the role of DBA.  I’ll go over some of the resources that I used to prepare myself for the DBA job I landed. And I’ll also go over the resources that I use to prepare for the various tasks I’ve needed to accomplish since taking on my new role.

I’ll give a list of these resources including links, downloads, and in many cases how to get access to them for free even if they’re normally paid training sites.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 07

Time: 8:45 AM - 10:00 AM

Room: ARP 224

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