sqlsathistory

Nr: 643

SQLSaturday #643 - Louisville 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Kevin Feasel	Analytics and Visualization	Data Cleansing With SQL And R
08:30:00	Drew Furgiuele	Application Database Development	SQL Server and PowerShell: Let's Get Serious
08:30:00	Tracy Boggiano	Enterprise Database Administration Deployment	Query Store Primer
08:30:00	Jes Schultz	Enterprise Database Administration Deployment	Everyday Extended Events
08:30:00	Lance Tidwell	Enterprise Database Administration Deployment	Parameter Sniffing the Good, the Bad, and the Ugly
08:30:00	Daniel Glenn	Cloud Application Development Deployment	Using Your On-prem Data in a Cloud World
09:45:00	Josh Luedeman	Analytics and Visualization	Show me whatcha workin' with: Big Data Edition
09:45:00	Rie Irish	Professional Development	Let Her Finish: Supporting Women's Voices from meetings to the board room
09:45:00	Tim Chapman	Enterprise Database Administration Deployment	Choose Your Own Adventure: Troubleshooting
09:45:00	Meagan Longoria	BI Platform Architecture, Development Administration	Transitioning from Integration Services to Azure Data Factory
09:45:00	Jason Brimhall	Enterprise Database Administration Deployment	Bare Naked Skinny on SQL Server
09:45:00	Allen White	Enterprise Database Administration Deployment	Emergency! Are You Ready for Disaster to Strike?
11:00:00	Andy Mallon	Application Database Development	Demystifying Data Compression
11:00:00	Louis Davidson	Application Database Development	Let Me Finish... Isolating Write Operations
11:00:00	Grant Fritchey	Application Database Development	Extending DevOps To SQL Server
11:00:00	Jonathan Stewart	Analytics and Visualization	Data Visualization: How to truly tell a great story!
11:00:00	Justin Randall	Enterprise Database Administration Deployment	Sorcerer's Apprentice Guide to SQL Server Configuration Options
11:00:00	Elizabeth Noble	Application Database Development	Measure Twice, cut once: Intro to unit testing with tSQLt
13:00:00	Monica Rathbun	Enterprise Database Administration Deployment	Making your existing hardware work for you
13:00:00	Warren Sifre	Cloud Application Development Deployment	Introduction to Azure Streaming Analytics
13:00:00	Jim Donahoe	Enterprise Database Administration Deployment	New Instance, Now what?
13:00:00	David Maxwell	Other	Wait Statistics - The Top 5 Waits You Should Know
13:00:00	Jason Brimhall	Application Database Development	The Anatomy of Select
14:15:00	John Deardurff	Application Database Development	The Basics of Manipulating Data
14:15:00	Andrew Loree	Enterprise Database Administration Deployment	Stretch Database and Managed Backups: Cloud Services for your SQL Servers
14:15:00	Aaron Cutshall	BI Platform Architecture, Development Administration	Battle Scars: Porting a SQL Server app to an MPP system
14:15:00	Lori Edwards	Enterprise Database Administration Deployment	DBA 101 – Let’s Get It Started
14:15:00	Kellyn Pot'Vin-Gorman	Enterprise Database Administration Deployment	Oracle vs. SQL Server Indexing- The Good, the Bad and the Ugly
14:15:00	Brian Carrig	Enterprise Database Administration Deployment	Managing Very Large Databases with SQL Server
15:30:00	Ameena Lalani	Enterprise Database Administration Deployment	Learn History from Temporal Tables
15:30:00	Vladimir Oselsky	Application Database Development	Crash Course on Better SQL Development
15:30:00	Matt Gordon	Enterprise Database Administration Deployment	How to Keep Your Database Servers Out of the News
15:30:00	Rob Volk	Application Database Development	Tame Your Unruly Data With Constraints
15:30:00	Kat Edrington	Enterprise Database Administration Deployment	Medicating Tempdb Headaches

SessionID: 62697

Data Cleansing With SQL And R

Back to calendar

Event Date: 05-08-2017 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Data Cleansing With SQL And R

Abstract:

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.

SessionID: 62713

SQL Server and PowerShell: Let's Get Serious

Back to calendar

Event Date: 05-08-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.

SessionID: 63943

Query Store Primer

Back to calendar

Event Date: 05-08-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Query Store Primer

Abstract:

This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.

SessionID: 64231

Everyday Extended Events

Back to calendar

Event Date: 05-08-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jes Schultz

Title: Everyday Extended Events

Abstract:

As a DBA or developer, you want to know what is happening inside SQL Server. Extended Events are the modern framework for finding and interpreting SQL Server's actions. In this session, you'll see practical examples to solve everyday problems. Many useful features will be shown, such as the depth of events, filtering, and multiple target types!

SessionID: 64342

Parameter Sniffing the Good, the Bad, and the Ugly

Back to calendar

Event Date: 05-08-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good, the Bad, and the Ugly

Abstract:

Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

SessionID: 65483

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 05-08-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Daniel Glenn

Title: Using Your On-prem Data in a Cloud World

Abstract:

Microsoft Power BI, Flow, and PowerApps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.

In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Office 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Office 365 and SharePoint Server 2016.

SessionID: 63147

Show me whatcha workin' with: Big Data Edition

Back to calendar

Event Date: 05-08-2017 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Josh Luedeman

Title: Show me whatcha workin' with: Big Data Edition

Abstract:

Congratulations. You've setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.

SessionID: 63157

Let Her Finish: Supporting Women's Voices from meetings to the board room

Back to calendar

Event Date: 05-08-2017 - Session time: 09:45:00 - Track: Professional Development

Speaker: Rie Irish

Title: Let Her Finish: Supporting Women's Voices from meetings to the board room

Abstract:

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.

This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 64286

Choose Your Own Adventure: Troubleshooting

Back to calendar

Event Date: 05-08-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Chapman

Title: Choose Your Own Adventure: Troubleshooting

Abstract:

In this 100% interactive session, Microsoft engineer and MCM Tim Chapman will present you with a problem workload on a SQL Server instance and it will be up to you, the audience, to solve the problem. You'll be guided along the way in what will be a great, and fun, SQL Server troubleshooting session. Come prepared to learn and take notes as there will only be slides that detail the problem symptoms.

SessionID: 65962

Transitioning from Integration Services to Azure Data Factory

Back to calendar

Event Date: 05-08-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Meagan Longoria

Title: Transitioning from Integration Services to Azure Data Factory

Abstract:

SessionID: 66211

Bare Naked Skinny on SQL Server

Back to calendar

Event Date: 05-08-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Bare Naked Skinny on SQL Server

Abstract:

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

SessionID: 66518

Emergency! Are You Ready for Disaster to Strike?

Back to calendar

Event Date: 05-08-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: Emergency! Are You Ready for Disaster to Strike?

Abstract:

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.

SessionID: 63879

Demystifying Data Compression

Back to calendar

Event Date: 05-08-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Andy Mallon

Title: Demystifying Data Compression

Abstract:

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

SessionID: 63952

Let Me Finish... Isolating Write Operations

Back to calendar

Event Date: 05-08-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Let Me Finish... Isolating Write Operations

Abstract:

OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

SessionID: 64124

Extending DevOps To SQL Server

Back to calendar

Event Date: 05-08-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Extending DevOps To SQL Server

Abstract:

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.

SessionID: 64248

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 05-08-2017 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 65103

Sorcerer's Apprentice Guide to SQL Server Configuration Options

Back to calendar

Event Date: 05-08-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

Title: Sorcerer's Apprentice Guide to SQL Server Configuration Options

Abstract:

From it's early beginnings SQL Server has been touted as "self-tuning, yet you've heard there are a variety of knobs and switches available to impact performance. Are you curious to know what they are, what they do, and when to use them? In this session you will learn about server and database configuration options that can impact performance and ease administration, including new options in SQL Server 2016.

SessionID: 68482

Measure Twice, cut once: Intro to unit testing with tSQLt

Back to calendar

Event Date: 05-08-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Measure Twice, cut once: Intro to unit testing with tSQLt

Abstract:

Unit testing allows database code to be consistently tested during the development process, but it can be challenging to get unit testing setup for database development. This session will give an overview on the purpose of unit testing, the installation of the tSQLt framework, and the design of unit tests. I will use general concepts of test driven design to create and run unit tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement unit testing in a development environment and create and run your own units tests

SessionID: 63204

Making your existing hardware work for you

Back to calendar

Event Date: 05-08-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: Making your existing hardware work for you

Abstract:

Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.

SessionID: 63286

Introduction to Azure Streaming Analytics

Back to calendar

Event Date: 05-08-2017 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Warren Sifre

Title: Introduction to Azure Streaming Analytics

Abstract:

This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.

SessionID: 64233

New Instance, Now what?

Back to calendar

Event Date: 05-08-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 64298

Wait Statistics - The Top 5 Waits You Should Know

Back to calendar

Event Date: 05-08-2017 - Session time: 13:00:00 - Track: Other

Speaker: David Maxwell

Title: Wait Statistics - The Top 5 Waits You Should Know

Abstract:

Wait statistics are a great tool for troubleshooting performance problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don't know where to look next. In this session, we'll examine 5 of the most frequently seen wait types in SQL Server and how to troubleshoot each of them. You'll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with wait statistics.

SessionID: 66212

The Anatomy of Select

Back to calendar

Event Date: 05-08-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Jason Brimhall

Title: The Anatomy of Select

Abstract:

TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.

When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.

This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.

SessionID: 62652

The Basics of Manipulating Data

Back to calendar

Event Date: 05-08-2017 - Session time: 14:15:00 - Track: Application Database Development

Speaker: John Deardurff

Title: The Basics of Manipulating Data

Abstract:

This session is an introduction into writing INSERT, UPDATE, and DELETE statements. We will also discuss how to work with IDENTITY columns and exactly what is the difference between DELETE, DROP, and TRUNCATE. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.

SessionID: 62726

Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Back to calendar

Event Date: 05-08-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Loree

Title: Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Abstract:

Utilizing Azure cloud services does not mean moving all of your data or control away from your on-premises SQL Servers. In this session we will cover the new SQL 2016 Stretch Database and the SQL 2014 Managed Backups to Azure features. We will look at use-cases and limitations of both features to illustrate how these cloud services may fit into your current SQL Server environment.

SessionID: 63320

Battle Scars: Porting a SQL Server app to an MPP system

Back to calendar

Event Date: 05-08-2017 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Aaron Cutshall

Title: Battle Scars: Porting a SQL Server app to an MPP system

Abstract:

Battle scars are proof of the struggles endured and won. Find out about one particular battle in porting a SQL Server application to Netezza. In this session, we’ll review Big Data platform options and the differences between them. We’ll see how Massively Parallel Processor (MPP) systems (like Netezza) are different from Symmetric Multi-Processor (SMP) systems (like SQL Server) and witness the lessons learned in the struggle.

SessionID: 63718

DBA 101 – Let’s Get It Started

Back to calendar

Event Date: 05-08-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Lori Edwards

Title: DBA 101 – Let’s Get It Started

Abstract:

We've all installed SQL Server and, most of the times, the default settings work just fine. This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server. We'll also go through unattended installs, both with and without a config file. This can really help to standardize your SQL Server installations and save you some precious keystrokes.

SessionID: 64887

Oracle vs. SQL Server Indexing- The Good, the Bad and the Ugly

Back to calendar

Event Date: 05-08-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Oracle vs. SQL Server Indexing- The Good, the Bad and the Ugly

Abstract:

This session is based off research performed on objects, design and code built to be as similar as possible to see how Oracle and SQL Server compare in performance, usage and storage of indices. Based off trusted measurements in each platform, we’ll dig into how the use case was built, the similarities and the differences in each. What we can admire about how each product has matured in the way of managing index data, statistics and how the optimizer hinders and enhances index availability.

Takeaways are:

Receive a strong education on platform differences between Oracle and SQL Server.
Discover hidden insight on index storage and costs.
Learn about great tips on maintaining index health and how one platform may perform better than the other and how.
Translation of common features in both platforms

SessionID: 65933

Managing Very Large Databases with SQL Server

Back to calendar

Event Date: 05-08-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Carrig

Title: Managing Very Large Databases with SQL Server

Abstract:

If some of your databases have grown to over 1TB and it has become a challenge to maintain them - or if you are anticipating what to do in the future when they do - then this talk is for you! In this session, I will provide some practical advice on managing VLDBs with SQL server, focusing on common problem areas for new and experienced DBAs alike, including index maintenance, integrity checks, archival, backups and restores. New features available in SQL 2016 and SQL 2017 to make managing large databases easier will be highlighted.

SessionID: 63367

Learn History from Temporal Tables

Back to calendar

Event Date: 05-08-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ameena Lalani

Title: Learn History from Temporal Tables

Abstract:

SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. They are basically history tables of the normal tables; that allow us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code and without using any behind the scene triggers. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. This session is full of demos.

SessionID: 64011

Crash Course on Better SQL Development

Back to calendar

Event Date: 05-08-2017 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 65423

How to Keep Your Database Servers Out of the News

Back to calendar

Event Date: 05-08-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: How to Keep Your Database Servers Out of the News

Abstract:

Every few months the headlines are filled with news of yet another system outage inconveniencing customers and users. As data platform professionals, the systems and servers for which we are responsible generally form the foundation of our companies’ customer-facing applications. In this fast-paced session, we’ll discuss the differences between high availability and disaster recovery as well as the tools and technologies Microsoft provides us within SQL Server to keep our databases up, our users happy, and our DBAs well rested.

SessionID: 65427

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 05-08-2017 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.

SessionID: 66526

Medicating Tempdb Headaches

Back to calendar

Event Date: 05-08-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kat Edrington

Title: Medicating Tempdb Headaches

Abstract:

Tempdb can be a mystery to some and it can be one of the biggest performance pains in an environment. Knowing how to configure and troubleshoot tempdb is critical. In this session, we will walk through best practices for its configuration, techniques on how to identify specific tempdb performance bottlenecks and ways to resolve them.

This site is open source. Improve this page.