sqlsathistory

Nr: 523

SQLSaturday #523 - Iowa City 2016

Start Time (24h)	Speaker	Track	Title
08:15:00	Jim Dorame	Automation and Monitoring	How to collect a baseline on all your servers and still get a good night's sleep.
08:15:00	Mike Hays	Enterprise Database Administration Deployment	Taming the Transaction Log
08:15:00	James Borland	BI Platform Architecture, Development Administration	DataZen and MS SQL 2016 Mobile BI now
08:15:00	Andy Yun	Application Database Development	Performance Pitfalls from Code Reuse
08:15:00	Pat Phelan	Application Database Development	Data Architecture 101
09:40:00	George Bryant	BI Information Delivery	SQL Server 2016 for BI
09:40:00	Andy Galbraith	Automation and Monitoring	Does it Hurt When I Do This? Performing a SQL Server Health Check
09:40:00	Ed Leighton-Dick	Automation and Monitoring	Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)
09:40:00	John Pertell	Analytics and Visualization	"R" You Ready For SQL 2016?
09:40:00	Andy Yun	Application Database Development	Uncovering Duplicate, Redundant, and Missing Indexes
11:05:00	Ameena Lalani	Enterprise Database Administration Deployment	SQL Server 2016: What's new?
11:05:00	Samantha Fahrmann	Application Database Development	SQL Server may let you do it, but it doesn't mean you should.
11:05:00	Andrea Mascher	Professional Development	Women in Technology Lunch: Energizing the Next Generation
11:05:00	Brandon Grieve	Strategy and Architecture	The Flash-Enhanced Database [Sponsored]
11:45:00	Klas Wiberg	Strategy and Architecture	SQL Server Data Protection with EMC Technology [Sponsored]
12:25:00	George Bryant	BI Platform Architecture, Development Administration	So this is Power BI. What now?
12:25:00	David Klee	Enterprise Database Administration Deployment	Virtual SQL Servers. Actual Performance.
12:25:00	Brian Hansen	Enterprise Database Administration Deployment	Get Your Optimizer to Give up All Its Secrets
12:25:00	Frank Gill	PowerShell	Using Powershell to Automate Your Restore Strategy
12:25:00	Wylie Blanchard	Application Database Development	Capture Changes with SQL Server's Change Data Capture
13:50:00	Jared Karney	Enterprise Database Administration Deployment	I Installed SQL Server... Now What?
13:50:00	Paul Timmerman	Cloud Application Development Deployment	SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud
13:50:00	Ed Leighton-Dick	Application Database Development	Understanding SQL Server 2016 Always Encrypted
13:50:00	Pat Phelan	Automation and Monitoring	Building a Data Warehouse for the DBA
13:50:00	Ben Miller	PowerShell	PoShDBA: Practical PowerShell for the DBA
15:15:00	Dave Bland	Automation and Monitoring	Extended Events: What are they and How do I use them
15:15:00	Mike Hays	Professional Development	Tackling Technical Blogging
15:15:00	David Klee	Enterprise Database Administration Deployment	Infrastructure Tuning for SQL Server Performance
15:15:00	Kathi Kellenberger	Enterprise Database Administration Deployment	Kerberos Delegation Made Simple
15:15:00	James Borland	Application Database Development	Wibbly-Wobbly, Timey-Wimey Tables

SessionID: 46182

How to collect a baseline on all your servers and still get a good night's sleep.

Back to calendar

Event Date: 11-06-2016 - Session time: 08:15:00 - Track: Automation and Monitoring

Speaker: Jim Dorame

Title: How to collect a baseline on all your servers and still get a good night's sleep.

Abstract:

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.

SessionID: 48156

Taming the Transaction Log

Back to calendar

Event Date: 11-06-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hays

Title: Taming the Transaction Log

Abstract:

Wonder why the transaction log keep filling up the hard-drive? Wonder why a full backup does not backup the transaction log? Wonder how often to back up the transaction log? Wonder if the transaction log can be backed up in parallel? This interactive session will help to you to find answers to those questions and more.

SessionID: 49545

DataZen and MS SQL 2016 Mobile BI now

Back to calendar

Event Date: 11-06-2016 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: James Borland

Title: DataZen and MS SQL 2016 Mobile BI now

Abstract:

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.

SessionID: 49572

Performance Pitfalls from Code Reuse

Back to calendar

Event Date: 11-06-2016 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Performance Pitfalls from Code Reuse

Abstract:

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.

SessionID: 52277

Data Architecture 101

Back to calendar

Event Date: 11-06-2016 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Data Architecture 101

Abstract:

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.

SessionID: 48564

SQL Server 2016 for BI

Back to calendar

Event Date: 11-06-2016 - Session time: 09:40:00 - Track: BI Information Delivery

Speaker: George Bryant

Title: SQL Server 2016 for BI

Abstract:

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.

SessionID: 49225

Does it Hurt When I Do This? Performing a SQL Server Health Check

Back to calendar

Event Date: 11-06-2016 - Session time: 09:40:00 - Track: Automation and Monitoring

Speaker: Andy Galbraith

Title: Does it Hurt When I Do This? Performing a SQL Server Health Check

Abstract:

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!

SessionID: 49489

Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Back to calendar

Event Date: 11-06-2016 - Session time: 09:40:00 - Track: Automation and Monitoring

Speaker: Ed Leighton-Dick

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Abstract:

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.

SessionID: 49565

"R" You Ready For SQL 2016?

Back to calendar

Event Date: 11-06-2016 - Session time: 09:40:00 - Track: Analytics and Visualization

Speaker: John Pertell

Title: "R" You Ready For SQL 2016?

Abstract:

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.

SessionID: 49571

Uncovering Duplicate, Redundant, and Missing Indexes

Back to calendar

Event Date: 11-06-2016 - Session time: 09:40:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Uncovering Duplicate, Redundant, and Missing Indexes

Abstract:

Do you know if your database's indexes are really being used to their fullest potential? And do you know if SQL Server needs other indexes to improve performance?

Attend this session and learn how SQL Server tracks actual index usage, and how you can make use of that information to improve the state of indexes in your database. We will use this data to identify wasteful, unused, redundant indexes, and explore performance penalties you pay for not addressing these inefficient indexes. Finally, we will dive into the Missing Index DMV and explore the art of evaluating its recommendations to make proper indexing decisions.

SessionID: 49292

SQL Server 2016: What's new?

Back to calendar

Event Date: 11-06-2016 - Session time: 11:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Ameena Lalani

Title: SQL Server 2016: What's new?

Abstract:

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.

SessionID: 49665

SQL Server may let you do it, but it doesn't mean you should.

Back to calendar

Event Date: 11-06-2016 - Session time: 11:05:00 - Track: Application Database Development

Speaker: Samantha Fahrmann

Title: SQL Server may let you do it, but it doesn't mean you should.

Abstract:

SQL Server comes packed with functionality, options, settings and features. Some of these are old, some brand new. Some features and functionality have been declared deprecated, others might be in the next cut (or maybe should be). This session will cover all the items that I've found or have seen in my research that may not be the best approach at using what SQL Server has to offer.

SessionID: 49679

Women in Technology Lunch: Energizing the Next Generation

Back to calendar

Event Date: 11-06-2016 - Session time: 11:05:00 - Track: Professional Development

Speaker: Andrea Mascher

Title: Women in Technology Lunch: Energizing the Next Generation

Abstract:

SessionID: 51138

The Flash-Enhanced Database [Sponsored]

Back to calendar

Event Date: 11-06-2016 - Session time: 11:05:00 - Track: Strategy and Architecture

Speaker: Brandon Grieve

Title: The Flash-Enhanced Database [Sponsored]

Abstract:

SessionID: 52242

SQL Server Data Protection with EMC Technology [Sponsored]

Back to calendar

Event Date: 11-06-2016 - Session time: 11:45:00 - Track: Strategy and Architecture

Speaker: Klas Wiberg

Title: SQL Server Data Protection with EMC Technology [Sponsored]

Abstract:

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

SessionID: 47703

So this is Power BI. What now?

Back to calendar

Event Date: 11-06-2016 - Session time: 12:25:00 - Track: BI Platform Architecture, Development Administration

Speaker: George Bryant

Title: So this is Power BI. What now?

Abstract:

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...

SessionID: 48278

Virtual SQL Servers. Actual Performance.

Back to calendar

Event Date: 11-06-2016 - Session time: 12:25:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Virtual SQL Servers. Actual Performance.

Abstract:

Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

SessionID: 49602

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 11-06-2016 - Session time: 12:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

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.

SessionID: 49656

Using Powershell to Automate Your Restore Strategy

Back to calendar

Event Date: 11-06-2016 - Session time: 12:25:00 - Track: PowerShell

Speaker: Frank Gill

Title: Using Powershell to Automate Your Restore Strategy

Abstract:

As DBAs, our most important job is protecting the data. Making sure our backups are running successfully gets us halfway there, but those backups are useless if we can’t restore them. Join me for this session to learn how to use Powershell to automate a restore process for backup validation.

SessionID: 51081

Capture Changes with SQL Server's Change Data Capture

Back to calendar

Event Date: 11-06-2016 - Session time: 12:25:00 - Track: Application Database Development

Speaker: Wylie Blanchard

Title: Capture Changes with SQL Server's Change Data Capture

Abstract:

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.

SessionID: 48212

I Installed SQL Server... Now What?

Back to calendar

Event Date: 11-06-2016 - Session time: 13:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Jared Karney

Title: I Installed SQL Server... Now What?

Abstract:

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!

SessionID: 48781

SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Back to calendar

Event Date: 11-06-2016 - Session time: 13:50:00 - Track: Cloud Application Development Deployment

Speaker: Paul Timmerman

Title: SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Abstract:

For years it seemed that the only message SQL Server professionals were hearing was "to the Cloud.... you must get to the Cloud!". However, if you work in a highly regulated industry, or one simply averse to change, this likely was not an option for you. The good news is, Microsoft heard your feedback and has been busy incorporating Cloud connectivity, compatibility, and functionality into the box product.

Come spend the hour with me and you’ll learn how to leverage the power of the Cloud with your on-premises SQL Server install. We’ll cover backup and restore options with Windows Azure Storage, using Windows Azure VMs for high availability, how to store your data files in Windows Azure Storage, and more. We’ll start with SQL Server 2012 and work our way up to the most recently released bits for SQL Server 2016. You can have the best of both worlds with a SQL Server Hybrid Cloud strategy!

SessionID: 49490

Understanding SQL Server 2016 Always Encrypted

Back to calendar

Event Date: 11-06-2016 - Session time: 13:50:00 - Track: Application Database Development

Speaker: Ed Leighton-Dick

Title: Understanding SQL Server 2016 Always Encrypted

Abstract:

Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

SessionID: 49680

Building a Data Warehouse for the DBA

Back to calendar

Event Date: 11-06-2016 - Session time: 13:50:00 - Track: Automation and Monitoring

Speaker: Pat Phelan

Title: Building a Data Warehouse for the DBA

Abstract:

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!

SessionID: 49991

PoShDBA: Practical PowerShell for the DBA

Back to calendar

Event Date: 11-06-2016 - Session time: 13:50:00 - Track: PowerShell

Speaker: Ben Miller

Title: PoShDBA: Practical PowerShell for the DBA

Abstract:

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.

SessionID: 45564

Extended Events: What are they and How do I use them

Back to calendar

Event Date: 11-06-2016 - Session time: 15:15:00 - Track: Automation and Monitoring

Speaker: Dave Bland

Title: Extended Events: What are they and How do I use them

Abstract:

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.

SessionID: 48155

Tackling Technical Blogging

Back to calendar

Event Date: 11-06-2016 - Session time: 15:15:00 - Track: Professional Development

Speaker: Mike Hays

Title: Tackling Technical Blogging

Abstract:

Ever thought of writing a technical blog? This session will cover the Ws (who, what, when, where, why, how) of getting a technical blog started. Answer the question of how it can be done for free. Discuss why pay for your own domain name. Explain how to be on the first page of a search engine. Learn how to determine the time commitment. And finally determine topics to write about.

SessionID: 48280

Infrastructure Tuning for SQL Server Performance

Back to calendar

Event Date: 11-06-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Infrastructure Tuning for SQL Server Performance

Abstract:

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.

SessionID: 49097

Kerberos Delegation Made Simple

Back to calendar

Event Date: 11-06-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kathi Kellenberger

Title: Kerberos Delegation Made Simple

Abstract:

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.

SessionID: 49544

Wibbly-Wobbly, Timey-Wimey Tables

Back to calendar

Event Date: 11-06-2016 - Session time: 15:15:00 - Track: Application Database Development

Speaker: James Borland

Title: Wibbly-Wobbly, Timey-Wimey Tables

Abstract:

The temporal table type is introduced with SQL 2016. It has practical applications as a background auditing replacement and even dimensional tables in DataMart. This session will look at creating temporal tables, modifying data, and querying enhancements. The temporal table type allows time travelling in widowed views without the need to write complicated joins to multiple historic/audit tables.

This site is open source. Improve this page.