Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 31
R is one of the fastest growing programming languages, useful for data analysis and visualization. You've been able to connect to SQL databases to work with large data sets before using R packages. But now, with the upcoming SQL 2016 release, R will be included as an Advanced Analytics Extension. You'll be able to run the same R scripts right in your database. 

In this beginner session we will look at how to set up R on your SQL instance. We'll work with some sample data to show how R works with SQL inside and outside the database with some basic R commands. And we'll create some graphs and charts for use in some SSRS reports. 

Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 11

Time: 9:40 AM - 10:55 AM

Room: 2520D

Users want Data Warehouses built, but no one ever builds one for the DBA. Let's fix that!

Get information from Active Directory, your Windows Servers, SQL Servers and other sources that mean something and will help you to keep the databases running smoothly. Be able to see which disks/machines are low on disk, what databases are on which SQL Servers, when backups happened and if any jobs failed.

This is targeted at the DBA who is responsible for multiple SQL Servers, in multiple places, and doesn't have time to "point and click" their way to a comfortable understanding of the moving pieces on all of the systems that they need to monitor!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Automation and Monitoring

Level: Beginner

Session Code:

Date: June 11

Time: 1:50 PM - 3:05 PM

Room: 2520C

Learn how to easily capture information about data changes – inserts, deletes and updates using SQL Server's Change Data Capture feature. Change Data Capture tracks INSERTs, UPDATEs, and DELETEs applied to your SQL Server tables, and  then informs you of what changed and when it changed. In this presentation we'll walk through the steps needed to activate Change Data Capture on your database tables and then explore how you can use Change Data Capture to understand how and why your data changed. Every SQL DBA and Developer utilizing SQL Server 2008/2012/2014 will benefit from this presentation. 
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 11

Time: 12:25 PM - 1:40 PM

Room: 2520B

As DBAs, we are asked all sorts of impossible questions.  Who dropped that important table last month?  Why was everything slow last week?  Who made that user a sysadmin?  You’d have to be a mind reader to know the answers to some of those, right?  Not necessarily!  SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide.  In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Automation and Monitoring

Level: Beginner

Session Code:

Date: June 11

Time: 9:40 AM - 10:55 AM

Room: 2390

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 11

Time: 8:15 AM - 9:30 AM

Room: 2520D

Microsoft purchased DataZen last year. With the upcoming release of MS SQL 2016 the DataZen Business Intelligence dashboards are integrating into SSRS. The SSRS 2016 web portal has some significant changes. This session will cover the how DataZen enterprise has changed from a standalone web service to part of SSRS. I'll also do a walkthrough of migrating existing DataZen dashboards to a SSRS 2016 instance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 11

Time: 8:15 AM - 9:30 AM

Room: 2523

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 (75 minutes)

Track:
Automation and Monitoring

Level: Beginner

Session Code:

Date: June 11

Time: 9:40 AM - 10:55 AM

Room: 2520C

Since Extended Events are replacing Profiler, every DBA should know what they are and how to use them.  This session will cover what Extended Events are and how to use them.  
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Automation and Monitoring

Level: Beginner

Session Code:

Date: June 11

Time: 3:15 PM - 4:30 PM

Room: 2520B

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated?  In this session, we will examine details the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient.  Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos?  We'll do just that, and then take it a step further with a unique visualization tool that I have created.  With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: June 11

Time: 12:25 PM - 1:40 PM

Room: 2520C

Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions.  With a few free quires and some SSIS magic you can capture a Baseline of your systems.  With this you will be able to know exactly where to look and what might be amiss.  Before you can say what is wrong with your system you need to know how it reacts under normal circumstances.  This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Automation and Monitoring

Level: Intermedia

Session Code:

Date: June 11

Time: 8:15 AM - 9:30 AM

Room: 2390

Before handing over a new SQL Server to DevOps or a Dev team, there are several things you should do to follow best practices and ensure optimal performance. In this session, Jared will go through his build checklist and explain why he is doing things like setting Cost Threshold for Parallelism, verifying Kerberos, and checking disk drive settings. When you leave this session, you will have the knowledge and tools to successfully implement a new SQL Server instance – and a copy of his checklist!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 11

Time: 1:50 PM - 3:05 PM

Room: 2523

Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath the data is your performance bottleneck, the time spent tuning at the database layer is usually in vain. Server hardware, operating system parameters, storage, interconnects, and networking will all be discussed in depth in terms that DBAs can relate to. Practical architecture guidelines and troubleshooting techniques will be presented so you can analyze your environments and see if your performance bottlenecks are where you think they are.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 11

Time: 3:15 PM - 4:30 PM

Room: 2523

Kerberos delegation is often needed for SQL Server Reporting Services security. Many DBAs avoid Kerberos because of the complexity and come up with workarounds that may violate security policies in their shops. They also may not understand why Kerberos delegation is even required. 
Configuring Kerberos for SSRS can be broken down into three simple steps: SPN registration, setting delegation properties, and application configuration. It’s really not so difficult, and there are a number of tools that can help you troubleshoot when things don’t go as planned.
Attend this session to learn why Kerberos is necessary and how to configure and troubleshoot it.

Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 11

Time: 3:15 PM - 4:30 PM

Room: 2520D

Have you ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions & views?  Did you know that object-oriented code reuse can come at a significant penalty?  

Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 11

Time: 8:15 AM - 9:30 AM

Room: 2520B

Think of all the tools you use in managing your SQL Servers. All those SQL Servers being managed by tools and man that is a lot of clicks. We will show practical scripts and techniques to help you get a handle on all those clicks. Whether you are gathering data or statistics from your SQL Servers or deploying an object to all of them. Configuration items are not excluded from the need for good tools. PowerShell is that tool that will let you get away from all those clicks. Reusable scripts that let you manage all those instances with ease. This session will give you a great start on how to think about admin tasks using PowerShell scripts or modules. Many items are already out there to help you and we will take a good look.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
PowerShell

Level: Beginner

Session Code:

Date: June 11

Time: 1:50 PM - 3:05 PM

Room: 2390

This no demo class will follow along the lines of an IT professional being handed the role of DBA. It will also be valuable for the would-be DBA. I’ll go over some of the resources that I used to prepare myself for the DBA job I landed. 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:
Mini Session (30 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 11

Time: 11:45 AM - 12:15 PM

Room: 2520B

Everyone is talking about Power BI. People are starting to use and interact with Power BI. That is a good thing, Power BI is fun! As an organization however, what do I do now and how do I handle a periodically changing beast? Here is what to consider...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 11

Time: 12:25 PM - 1:40 PM

Room: 2523

SQL Server 2016 is a new and shiny tool that we all know is coming. What exactly does it mean for BI though? What upgrades and new features are there that we actually care about? Well, we have a lot to talk about.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 11

Time: 9:40 AM - 10:55 AM

Room: 2523

This session will provide you with high level overview of several of the new features in SQL Server 2016. 
It will cover Always Encrypted, PolyBase, StretchDB and more. This is level 101 session so we will not be going 
deep into any one technology but will cover topics at the high level.The idea is to give you the taste of the 
new features of SQL Server 2016 and whatever spikes your interest, you can then go learn and test those features
in your Dev environment.
Speaker:

Session Type:
Mini Session (30 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 11

Time: 11:05 AM - 11:35 AM

Room: 2520C

Every organization has their own ways of dealing with SQL data protection, typically including a mix of SQL scripts, local disk, NAS, snapshots and backup software.  What strategy is right for your environment?  Two focus topics in this educational session-

1 - How other Iowa customers are protecting SQL data with EMC Technology
2 - How EMC is simplifying and streamlining data protection for Microsoft SQL, while keeping control in the hands of the DBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Mini Session (30 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 11

Time: 11:45 AM - 12:15 PM

Room: 2523

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