sqlsathistory

Nr: 473

Back to Main list

SQLSaturday #473 - Cleveland 2016

Start Time (24h) Speaker Track Title
08:30:00 Aaron Cutshall Application Database Development The Lost Science of Set Theory
08:30:00 Matt Nelson BI Platform Architecture, Development Administration Building dynamic SSIS packages for more flexibility
08:30:00 Kevin Feasel Enterprise Database Administration Deployment Peanut Butter Chocolate: Integrating Hadoop with SQL Server
08:30:00 Ben Miller Enterprise Database Administration Deployment SQL Server Database Encryption
08:30:00 Justin Randall Professional Development Building Your Yellow Brick Road: Directing Your Path to a Successful Career
08:30:00 Erin Stellato Enterprise Database Administration Deployment Answering the question, "What happened?" with Query Store
09:45:00 Wayne Sheffield Enterprise Database Administration Deployment SSMS Tips and Tricks
09:45:00 Delora Bradish BI Platform Architecture, Development Administration Your BI Blueprint Does Matter: Modeling for MS BI
09:45:00 Cassandra Faris Professional Development It's OK to Talk to Strangers
09:45:00 Chris Bell Enterprise Database Administration Deployment Hacking Expos#233; - Using SSL to Secure SQL Server Connections
09:45:00 Julie Smith Cloud Application Development Deployment Azure Data Factory: My Data Wandered Lonely as a CLOUD.
09:45:00 Jim Arko Enterprise Database Administration Deployment Troubleshooting SQL Server Performance Using Wait Stats
11:00:00 Eugene Meidinger Application Database Development Execution Plans 101
11:00:00 Deji Akomolafe Analytics and Visualization Successfully Virtualizing SQL Server on vSphere - Straight from t
11:00:00 Joseph D'Antoni Cloud Application Development Deployment Flying Through the Clouds--Performance Tuning in Azure
11:00:00 Colleen Morrow Enterprise Database Administration Deployment Inside the Black Box - Making Sense of Service Broker
11:00:00 Evelyn Maxwell Professional Development Improving Your PowerPoint Skills
11:00:00 Jonathan Kehayias Enterprise Database Administration Deployment Diagnosing SQL Amnesia: Where is Your Memory Going?
12:00:00 Adam Belebczuk Sponsor Session Database Career Opportunities at Hyland
12:00:00 Adam Belebczuk Sponsor Session SQL Sentry / UpSearch - A case study in SQL monitoring and perfor
12:00:00 Adam Belebczuk Sponsor Session Pyramid Analytics - Power BI On Prem
12:00:00 Adam Belebczuk Sponsor Session Pure Storage
12:00:00 Adam Belebczuk Sponsor Session TMW Systems - TMW Awakens
12:00:00 Adam Belebczuk Sponsor Session EMC - Transform Database Agility with XtremeIO
13:30:00 David Maxwell Enterprise Database Administration Deployment Turbo-Charged Transaction Logs
13:30:00 Warren Sifre Advanced Analysis Techniques Introduction to Azure Machine Learning
13:30:00 Mindy Curnutt Application Database Development TSQL Coding Techniques - Are You Playing with Fire?
13:30:00 Dave Mattingly Analytics and Visualization The Next Dimension of Data
13:30:00 Wendy Pastrick Enterprise Database Administration Deployment Demystifying AlwaysOn
13:30:00 Paul Hiles Cloud Application Development Deployment The SSIS Catalog - What is it and Why should I use it.
14:45:00 David Eldersveld Analytics and Visualization Exploring R Services and Advanced Analytics in SQL Server 2016
14:45:00 Peter Shore Enterprise Database Administration Deployment DBA 102: Now What
14:45:00 Michael John Application Database Development Top Development and Design Mistakes
14:45:00 Michael J Swart Application Database Development Something Stinks: Avoiding Parameter Sniffing Issues
14:45:00 Andy Yun Application Database Development Every Byte Counts: Why Your Data Type Choices Matter
14:45:00 Amy Herold Enterprise Database Administration Deployment Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
16:15:00 Pat Phelan Application Database Development Data Architecture 101
16:15:00 Frank Gill Enterprise Database Administration Deployment How to Determine What Data Is Corrupt
16:15:00 Konstantin Melamud BI Platform Architecture, Development Administration Optimizing your data warehouse for OLAP Processing
16:15:00 Steve Hood Strategy and Architecture Indexing Strategy
16:15:00 Allen White Enterprise Database Administration Deployment Maintain SQL Server Performance Baseline w/PowerShell
16:15:00 Jeff Moden Application Database Development The Secret to High Performance Code...The Devil’s in the Data

SessionID: 39978

The Lost Science of Set Theory

Back to calendar

Event Date: 06-02-2016 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: The Lost Science of Set Theory

Abstract:

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

SessionID: 41284

Building dynamic SSIS packages for more flexibility

Back to calendar

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

Speaker: Matt Nelson

Title: Building dynamic SSIS packages for more flexibility

Abstract:

After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with today's date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.

SessionID: 41542

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

Event Date: 06-02-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Feasel

Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Abstract:

So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world can be a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

SessionID: 42378

SQL Server Database Encryption

Back to calendar

Event Date: 06-02-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: SQL Server Database Encryption

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server. Become a SQL Server Encryption Master when you are done with this session. You will also learn how to set up the Encryption for Database Backups.

SessionID: 42973

Building Your Yellow Brick Road: Directing Your Path to a Successful Career

Back to calendar

Event Date: 06-02-2016 - Session time: 08:30:00 - Track: Professional Development

Speaker: Justin Randall

Title: Building Your Yellow Brick Road: Directing Your Path to a Successful Career

Abstract:

For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.

SessionID: 42981

Answering the question, "What happened?" with Query Store

Back to calendar

Event Date: 06-02-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Erin Stellato

Title: Answering the question, "What happened?" with Query Store

Abstract:

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics. If you've ever had to drop everything and try to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature. In this session we'll explore the Query Store feature using the latest CTP of SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, and see how you can force SQL Server to use a specific plan for a query.

SessionID: 41224

SSMS Tips and Tricks

Back to calendar

Event Date: 06-02-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Wayne Sheffield

Title: SSMS Tips and Tricks

Abstract:

Almost everyone uses SSMS to write queries and to browse around on the server - but do you use all of the features that SSMS offers to increase your productivity? Most people use few of these, and probably don't even know that many of these features even exist. Come to this session, consisting almost entirely of demos in SSMS, to see features built in to SSMS that will improve your experience and productivity. Time permitting; we'll also go into some 3rd party products that also increase your productivity in SSMS.

SessionID: 41306

Your BI Blueprint Does Matter: Modeling for MS BI

Back to calendar

Event Date: 06-02-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Delora Bradish

Title: Your BI Blueprint Does Matter: Modeling for MS BI

Abstract:

SessionID: 41560

It's OK to Talk to Strangers

Back to calendar

Event Date: 06-02-2016 - Session time: 09:45:00 - Track: Professional Development

Speaker: Cassandra Faris

Title: It's OK to Talk to Strangers

Abstract:

Tired of job boards and recruiter spam? There’s a better way to manage your career growth. Networking is something that doesn’t come naturally to many people, but it’s a tool that every tech professional should have in their tool belt. In this talk, you’ll learn tips for growing your professional network online and offline. You’ll also learn strategies for intentionally fostering relationships. A good network means fewer strangers, more free lunches, and a better path to finding your next opportunity.

SessionID: 42689

Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Back to calendar

Event Date: 06-02-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Abstract:

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data?

We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! We will then secure our database connections with a simple self-signed SSL certificate. Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. *Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used.

SessionID: 42958

Azure Data Factory: My Data Wandered Lonely as a CLOUD.

Back to calendar

Event Date: 06-02-2016 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Julie Smith

Title: Azure Data Factory: My Data Wandered Lonely as a CLOUD.

Abstract:

Azure Data Factory is a json based data integration tool. It is not SSIS in the cloud, but like SSIS, its main purpose is moving data. This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.

SessionID: 42994

Troubleshooting SQL Server Performance Using Wait Stats

Back to calendar

Event Date: 06-02-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Arko

Title: Troubleshooting SQL Server Performance Using Wait Stats

Abstract:

Sometimes the hardest part of diagnosing performance issues is determining where to start. Wouldn’t it be nice if you could just ask SQL Server what’s slowing it down? Good news: you can! Every single time SQL Server has to wait on a resource it keeps track of it in its Wait Stats. That valuable data can be used to narrow down your troubleshooting efforts and help you get to the root cause quicker. This session will provide an introduction to Wait Stats and explain how they can be leveraged to improve your performance tuning skills.

SessionID: 39988

Execution Plans 101

Back to calendar

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

Speaker: Eugene Meidinger

Title: Execution Plans 101

Abstract:

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, and additional features.

SessionID: 41668

Successfully Virtualizing SQL Server on vSphere - Straight from t

Back to calendar

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

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from t

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. "Virtualize First" is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too "critical" to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring it!

SessionID: 42253

Flying Through the Clouds--Performance Tuning in Azure

Back to calendar

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

Speaker: Joseph D'Antoni

Title: Flying Through the Clouds--Performance Tuning in Azure

Abstract:

So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:

• Optimizing TempDB in an Azure VM • Reducing latency between application VMs and database VMs • Right sizing Azure VMs for performance and cost • Striping I/O across devices in Azure VMs • Performance Tuning in Azure DB

You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.

SessionID: 42954

Inside the Black Box - Making Sense of Service Broker

Back to calendar

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

Speaker: Colleen Morrow

Title: Inside the Black Box - Making Sense of Service Broker

Abstract:

SQL Server Service Broker is often seen as a black box. Messages go in, and hopefully they come out on the other side. But when they don't, DBAs typically don’t know where to look. Trying to figure out what’s wrong quickly turns into a guessing game.

It’s not that complicated once you understand how it all works. Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order. In this session, we'll discuss the basics of the Service Broker architecture, its components, and deployment options. We will discuss troubleshooting tips and performance best practices to help you deploy a Service Broker solution in your own environment.

SessionID: 42964

Improving Your PowerPoint Skills

Back to calendar

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

Speaker: Evelyn Maxwell

Title: Improving Your PowerPoint Skills

Abstract:

PowerPoint can enhance the presentation of any speaker or business professional, but using it effectively in your sessions or presentations can be difficult without practice. In this session, you will learn how to take your PowerPoint skills to the next level, using more advanced transitions, animations, and media forms in your presentations. This will help you engage your audience and communicate visually instead of just verbally, making your presentations more effective. After attending this session, you can feel confident that your PowerPoint skills have improved.

SessionID: 45055

Diagnosing SQL Amnesia: Where is Your Memory Going?

Back to calendar

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

Speaker: Jonathan Kehayias

Title: Diagnosing SQL Amnesia: Where is Your Memory Going?

Abstract:

Memory problems in humans can be caused by injuries, traumatic events, or physical deficiencies. Interestingly enough, the same holds true for SQL Server. In this session, learn about common patterns and problems that affect SQL Server memory usage and how to solve them, based on real-world scenarios. We start with an overview of the SQLOS memory manager and the internals behind the memory components that are necessary to troubleshoot problems. We then move straight into sample scenarios. From incorrectly sized hardware for a specific workload to code and schema design challenges that tax SQL Server memory usage, this session gives you the practical tools necessary to tackle even the most challenging memory problems.

SessionID: 43043

Database Career Opportunities at Hyland

Back to calendar

Event Date: 06-02-2016 - Session time: 12:00:00 - Track: Sponsor Session

Speaker: Adam Belebczuk

Title: Database Career Opportunities at Hyland

Abstract:

SessionID: 46154

SQL Sentry / UpSearch - A case study in SQL monitoring and perfor

Back to calendar

Event Date: 06-02-2016 - Session time: 12:00:00 - Track: Sponsor Session

Speaker: Adam Belebczuk

Title: SQL Sentry / UpSearch - A case study in SQL monitoring and perfor

Abstract:

Join SQL Sentry UpSearch for a case study in SQL Server monitoring and performance tuning

SessionID: 46155

Pyramid Analytics - Power BI On Prem

Back to calendar

Event Date: 06-02-2016 - Session time: 12:00:00 - Track: Sponsor Session

Speaker: Adam Belebczuk

Title: Pyramid Analytics - Power BI On Prem

Abstract:

Have you heard about the recent Power BI on-prem Server? Have you heard about the recent Strategic Alliance between Microsoft and Pyramid Analytics? Come and learn from Michael Ford about the recent Strategic Alliance formed between Pyramid Analytics Microsoft, and learn about the power of BI Office. Do you like Power BI – but your company is not ready to move to the CLOUD? Do you want to allow your business users to build Tabular models on the fly and visualize them immediately? You can do all of this and more with Pyramid Analytics’ BI Office suite.

SessionID: 46156

Pure Storage

Back to calendar

Event Date: 06-02-2016 - Session time: 12:00:00 - Track: Sponsor Session

Speaker: Adam Belebczuk

Title: Pure Storage

Abstract:

Join Pure Storage for their sponsor lunch session

SessionID: 46157

TMW Systems - TMW Awakens

Back to calendar

Event Date: 06-02-2016 - Session time: 12:00:00 - Track: Sponsor Session

Speaker: Adam Belebczuk

Title: TMW Systems - TMW Awakens

Abstract:

Join TMW for their sponsor lunch session

SessionID: 46158

EMC - Transform Database Agility with XtremeIO

Back to calendar

Event Date: 06-02-2016 - Session time: 12:00:00 - Track: Sponsor Session

Speaker: Adam Belebczuk

Title: EMC - Transform Database Agility with XtremeIO

Abstract:

All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.

SessionID: 39864

Turbo-Charged Transaction Logs

Back to calendar

Event Date: 06-02-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Turbo-Charged Transaction Logs

Abstract:

The transaction log is one of the most critical, yet often misunderstood components of SQL Server. From out of control log growth to very long start-up times, problems with the transaction log can cause a lot of pain. In this session, we'll look at how the transaction log works and how to optimize its performance. You'll learn how to determine the right settings for maximum throughput, and what to do when things get out of control.

SessionID: 40088

Introduction to Azure Machine Learning

Back to calendar

Event Date: 06-02-2016 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Warren Sifre

Title: Introduction to Azure Machine Learning

Abstract:

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

SessionID: 40348

TSQL Coding Techniques - Are You Playing with Fire?

Back to calendar

Event Date: 06-02-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: TSQL Coding Techniques - Are You Playing with Fire?

Abstract:

The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL and Parameter Sniffing. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!

SessionID: 41294

The Next Dimension of Data

Back to calendar

Event Date: 06-02-2016 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Dave Mattingly

Title: The Next Dimension of Data

Abstract:

Send your data on a journey through space and time, while engaging your audience’s senses to tell its story.

SQL Server’s geospatial datatype offers pinpoint accuracy and many advanced location-aware capabilities, such as shapes, overlaps, distances, and direction. The Power Map feature can turn your addresses and supporting figures into a movie. Turn your facts and figures into a compelling story by entering geospace: the final frontier.

SessionID: 42303

Demystifying AlwaysOn

Back to calendar

Event Date: 06-02-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Wendy Pastrick

Title: Demystifying AlwaysOn

Abstract:

Microsoft rebranded and upgraded the high availability options for SQL Server 2012. This has caused a flurry of confusion around what features are used in what scenarios. Learn what the prerequisites are for running a Failover Cluster Instance or an Availability Group using AlwaysOn. We will also cover setting up an Availability Group then demonstrate both an automated and manual failover process. Finally, we wrap up with a discussion about using the Listener service and how that needs to be configured for your applications to continue to function on failover.

SessionID: 42965

The SSIS Catalog - What is it and Why should I use it.

Back to calendar

Event Date: 06-02-2016 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Paul Hiles

Title: The SSIS Catalog - What is it and Why should I use it.

Abstract:

The SSIS Catalog was introduced in SQL Server 2012. This session is going to explore what the catalog is and how it can improve the scheduling and tracking package executions. One of the biggest advantages to the SSIS Catalog is that it allows a single package to be ran with multiple environments without having to make any changes to the package. First, we will review some bonus material with SSIS project parameters. Then review their use with the catalog's environments. Next, the fun will begin with examining the catalog and using it to execute packages in different environments. Finally, we will take a look that the catalog's logging and database to monitor and review the packages executions.

SessionID: 42285

Exploring R Services and Advanced Analytics in SQL Server 2016

Back to calendar

Event Date: 06-02-2016 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: David Eldersveld

Title: Exploring R Services and Advanced Analytics in SQL Server 2016

Abstract:

2016 welcomes the new R Services, which brings advanced analytics capabilities to SQL Server. You will learn how SQL Server R Services can enhance the work of a BI developer or analyst as well as impact a DBA. You will witness a few scenarios covering how to leverage R scripts in-database using T-SQL as well as how to use R in Reporting Services and Power BI. Finally, you will experience a gentle introduction to the installation and configuration of R Services. This session is targeted toward SQL professionals who have never used the R language.

SessionID: 42843

DBA 102: Now What

Back to calendar

Event Date: 06-02-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: DBA 102: Now What

Abstract:

Things happened, you got a knock on the head and when you awoke your boss said “congratulations” you are our new DBA, perhaps you came to the role in a more intentional manner or are just DBA curious. Your environment is running but you are wondering “now what” or “what’s next”. In this session we will give an overview of a few things that could, perhaps even should be next and give some recommendations as to where you can find more resources on-line and maybe even suggest a few sessions to attend at this very SQL Saturday. So, what will be covered, recovery strategy (you think I mean backups, I don’t, you’ll see why), a touch on performance tuning with a hint of indexing thrown in, add a pinch of high availability and a smattering of security all of which will give you some idea how to answer “now what”.

SessionID: 42962

Top Development and Design Mistakes

Back to calendar

Event Date: 06-02-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Michael John

Title: Top Development and Design Mistakes

Abstract:

There are many mistakes made repeadedly that are never caught in the database design and subsequent development efforts that affect performance, logic, and casue pain for the DBA.

This session will point these issues out, and help you prevent and identify these issues.

SessionID: 42977

Something Stinks: Avoiding Parameter Sniffing Issues

Back to calendar

Event Date: 06-02-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Michael J Swart

Title: Something Stinks: Avoiding Parameter Sniffing Issues

Abstract:

Some of the most painful database problems involve queries that have inconsistent performance. These queries can run fast on your dev box, but not in QA. These queries can be fast in the morning, but not in the afternoon. I take an in-depth look at the causes of this variable performance. How to recognize such queries at development time and what you can do about it. When we're done, developers who write SQL will have a solid set of tools to help write consistent, predictably fast SQL.

SessionID: 42988

Every Byte Counts: Why Your Data Type Choices Matter

Back to calendar

Event Date: 06-02-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Every Byte Counts: Why Your Data Type Choices Matter

Abstract:

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer?

Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!

When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.

SessionID: 42996

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 06-02-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

SessionID: 39714

Data Architecture 101

Back to calendar

Event Date: 06-02-2016 - Session time: 16: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!

SessionID: 41835

How to Determine What Data Is Corrupt

Back to calendar

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

Speaker: Frank Gill

Title: How to Determine What Data Is Corrupt

Abstract:

There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will. Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt. And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.

SessionID: 42109

Optimizing your data warehouse for OLAP Processing

Back to calendar

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

Speaker: Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Abstract:

Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.

SessionID: 42662

Indexing Strategy

Back to calendar

Event Date: 06-02-2016 - Session time: 16:15:00 - Track: Strategy and Architecture

Speaker: Steve Hood

Title: Indexing Strategy

Abstract:

Index for your entire server's performance instead of indexing for a single query, mostly by ensuring indexes are reusable by as many queries as reasonable. Make the most of every index while limiting overhead of memory usage, I/O, disk, data modifications, and index maintenance. Also look into tuning or rescheduling the queries that fall outside of typical data access patterns to keep index usage as efficient as possible.

SessionID: 42912

Maintain SQL Server Performance Baseline w/PowerShell

Back to calendar

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

Speaker: Allen White

Title: Maintain SQL Server Performance Baseline w/PowerShell

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 45233

The Secret to High Performance Code...The Devil’s in the Data

Back to calendar

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

Speaker: Jeff Moden

Title: The Secret to High Performance Code...The Devil’s in the Data

Abstract:

You found code you need in a “Holy Grail” article complete with test data and tests across several methods “clearly” identifying the best one to use. Excited at your good fortune, you quickly download the code, rerun the tests on your Dev box . It “passes” with flying colors. You promote the code to production and go home on time for a change.

The next day, your boss and the DBA are waiting for you in your cube and, look, the DBA has a bat with your name on it because your code brought the server to its knees and the code failed.

How is that possible? The answer is, “The Devil’s in the Data”.

Whether you’re an SQL “Newbie” or seasoned veteran, this “Black Arts” session will teach you most of what you need to know to build large quantities of just about any test data you might imagine and more quickly than you ever dreamed. It’ll also show you how to avoid the pitfalls that lead to the DBA with the bat. ;-)

This site is open source. Improve this page.