sqlsathistory

Nr: 514

Back to Main list

SQLSaturday #514 - Houston 2016

Start Time (24h) Speaker Track Title
08:30:00 Steve Allison Application Database Development Cursors temp tables and pivots oh boy
08:30:00 Thomas Norman Cloud Application Development Deployment Beginning Azure
08:30:00 William Assaf Application Database Development SQL Server Permissions and Security Principals
08:30:00 Brent Ozar Application Database Development Performance Tuning SQL Server with sp_AskBrent#174; and sp_BlitzCache#174;
08:30:00 Naomi Williams Enterprise Database Administration Deployment SQL Server Internals
08:30:00 Theresa Eller Information Delivery Using SQL to Avoid the SharePoint List Threshold
08:30:00 Faheem Ismat Enterprise Database Administration Deployment Secure your sensitive data with Always Encrypted
08:30:00 Chris Hyde BI Platform Architecture, Development Administration Row-level Security in SSRS and SSAS
09:45:00 Tim Mitchell BI Platform Architecture, Development Administration Introduction to Biml
09:45:00 Jamey Johnston Analytics and Visualization Introduction to R and Data Science Tools in the Microsoft Stack
09:45:00 Steven Ormrod Application Database Development SQL Server Window Functions
09:45:00 Cindy Bean Enterprise Database Administration Deployment Avoiding the Pitfalls of Database Change Automation
09:45:00 Vicky Harp Enterprise Database Administration Deployment Introduction to SQL 2016 Temporal Tables
09:45:00 Robert Bishop Enterprise Database Administration Deployment Hostile Takeover
09:45:00 Amy Herold Enterprise Database Administration Deployment Hi, my name is Powershell, let's be friends! An Intro to PoSH
09:45:00 Brian Dudley Application Database Development SQL Omphaloskepsis: Enlightenment and Productivity Using System Tables
11:00:00 George Govantes Strategy and Architecture So what does it really take to get to four nines
11:00:00 Mike Byrd BI Platform Architecture, Development Administration Change Tracking: A Near Bullet-Proof ETL Synchronization Control
11:00:00 Kris Hokanson Application Database Development Beyond the Where: Full Text Search tips and tricks
11:00:00 Jamey Johnston Enterprise Database Administration Deployment Overview of Security Investments in SQL Server 2016 and Azure SQL Database
11:00:00 Jason Wong Enterprise Database Administration Deployment A Choice Performance Tuning
11:00:00 Sean McCown Enterprise Database Administration Deployment Monster Text Manipulation: Regular Expressions for the DBA
11:00:00 Brian Dudley Application Database Development The Ins and Outs of Partitioned Tables
11:00:00 John Sterrett Cloud Application Development Deployment Azure Database for DBA's
12:30:00 Lori Brown Enterprise Database Administration Deployment Actively Proactive – Straightforward Ways to Manage and Diagnose SQL
12:30:00 Robert Moore Enterprise Database Administration Deployment Cisco UCS, Optimal Platform for SQL Server
12:30:00 Mark Moore Information Delivery What's new in SQL Server 2016
12:30:00 Matt White BI Platform Architecture, Development Administration "Transform into a Data-Driven Organization"
12:30:00 Bryan Walsh Enterprise Database Administration Deployment Transform Database Agility with XtremIO
12:30:00 Victor Gentry Enterprise Database Administration Deployment Tintri SQL Sentry – Optimizing Your Virtualized Workload
12:30:00 Amit Parikh Other A new paradigm for workload analytics in SQL Server
13:30:00 Stacy Gray Enterprise Database Administration Deployment Troubleshooting SQL Server Performance
13:30:00 Tim Mitchell BI Platform Architecture, Development Administration Making the Most of the SSIS Catalog
13:30:00 Kevin Boles Enterprise Database Administration Deployment SQL Server Defaults SUCK!!
13:30:00 Aaron Cutshall Application Database Development T-SQL Tips Tricks
13:30:00 John Harp Enterprise Database Administration Deployment Cluster@#$%! High Availability Solutions. What Could Go Wrong?
13:30:00 Anthony {Tex} Moreign Cloud Application Development Deployment Gen2016™ and the Global “Hybrid” Cloud
13:30:00 Ken Clement Application Database Development Codd's Rules, Normal Forms, and SQL Anti-Patterns - Recognition Repair
13:30:00 Brent Ozar Application Database Development Watch Brent Tune Indexes
14:45:00 Jennifer McCown Application Database Development Designing Stored Procedure Solutions
14:45:00 Daniel Janik Application Database Development Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edit
14:45:00 Kevin Boles Application Database Development Indexing Deep Dive
14:45:00 Bala Shankar Cloud Application Development Deployment Deploy SQL Server with Microsoft Azure Virtual Machine
14:45:00 Patrick LeBlanc BI Information Delivery What's New in SSRS 2016
14:45:00 Keith Tate Enterprise Database Administration Deployment Profiler is Dead! Long Live Extended Events!
14:45:00 Lori Edwards Enterprise Database Administration Deployment SQL Server Statistics – What Are The Chances?
14:45:00 Amy Herold Professional Development Making the Leap from Developer to DBA
16:00:00 John Sterrett Enterprise Database Administration Deployment Why Did My Execution Plan Change? Introduction to Query Store
16:00:00 Patrick LeBlanc BI Information Delivery Introduction to Microsoft Mobile Reporting
16:00:00 Dane Schilling Application Database Development Simple Fun Modeling with SQL Server
16:00:00 Sean McCown Enterprise Database Administration Deployment Understanding Backups
16:00:00 Dave Wiley Enterprise Database Administration Deployment How answers.microsoft.com Overcame the key Challenges of Upgrading to SQL S
16:00:00 Todd Kleinhans Information Delivery The Life Cycle of a Query in Virtual Reality
16:00:00 Richie Rump Application Database Development Who's Afraid of Entity Framework?
16:00:00 Shawn Weisfeld Cloud Application Development Deployment Scale out SQL Server PaaS in Azure Elastically

SessionID: 44657

Cursors temp tables and pivots oh boy

Back to calendar

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

Speaker: Steve Allison

Title: Cursors temp tables and pivots oh boy

Abstract:

Will do an overview of the PIVOT and UNPIVOT functions and how to manipulate your data in really cool ways. Then we will move on to how to deal with Cursor functions and looping through data, then the joys of #tables vs @tables for your temporary table issues.

SessionID: 44903

Beginning Azure

Back to calendar

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

Speaker: Thomas Norman

Title: Beginning Azure

Abstract:

The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let's put SQL Server into the cloud!

SessionID: 45285

SQL Server Permissions and Security Principals

Back to calendar

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

Speaker: William Assaf

Title: SQL Server Permissions and Security Principals

Abstract:

A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA's, developers and system admins.

SessionID: 46198

Performance Tuning SQL Server with sp_AskBrent#174; and sp_BlitzCache#174;

Back to calendar

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

Speaker: Brent Ozar

Title: Performance Tuning SQL Server with sp_AskBrent#174; and sp_BlitzCache#174;

Abstract:

You've already got a SQL Server application in production, and users are complaining about speed. You need to find the bottleneck as quickly as possible, and identify which queries are causing that bottleneck. In this session, you'll learn how to use free tools to quickly analyze your server's performance and pinpoint exactly which queries need to be tuned.

This session is for developers and DBAs who can change queries and indexes on their servers to speed up performance.

SessionID: 46427

SQL Server Internals

Back to calendar

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

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 48318

Using SQL to Avoid the SharePoint List Threshold

Back to calendar

Event Date: 14-05-2016 - Session time: 08:30:00 - Track: Information Delivery

Speaker: Theresa Eller

Title: Using SQL to Avoid the SharePoint List Threshold

Abstract:

What do you do when your SharePoint list exceeds the 5,000 item threshold? Do you turn off throttling for the list? Do you increase the limit in Central Admin? If either of these are your solution, you're risking a SQL database lockup, which could affect more than the one list. Based on a real world scenario, this session will share how a major healthcare institution recently used a SQL view containing 6,000+ items to avoid SharePoint's list threshold. Additionally, attendees will see how a Power View report built in SharePoint used the same SQL data to provide an interactive dashboard for data monitoring.

SessionID: 48395

Secure your sensitive data with Always Encrypted

Back to calendar

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

Speaker: Faheem Ismat

Title: Secure your sensitive data with Always Encrypted

Abstract:

Data security is a major concern for organizations especially when they start to explore cloud-based data options. Microsoft is enhancing security options in almost every major release of SQL Server. In SQL Server 2016, Microsoft has implemented “Always Encrypted” option which is quite different from previously available options including TDE. It is encryption of data not only at rest, but also in use and in transit. We will have a deep discussion about this new end-to-end data encryption feature which can be implemented without any code change on application side for both on premises and cloud SQL Server databases.

SessionID: 48482

Row-level Security in SSRS and SSAS

Back to calendar

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

Speaker: Chris Hyde

Title: Row-level Security in SSRS and SSAS

Abstract:

It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.

SessionID: 44768

Introduction to Biml

Back to calendar

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

Speaker: Tim Mitchell

Title: Introduction to Biml

Abstract:

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.

In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.

SessionID: 45693

Introduction to R and Data Science Tools in the Microsoft Stack

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Jamey Johnston

Title: Introduction to R and Data Science Tools in the Microsoft Stack

Abstract:

Come to this session to get an introduction to the R language including installing and configuring R and RStudio, how to access and manipulate data, install packages, create and use variables, use control flows and some basic graphing and statistical analysis. We will finish with a very brief introduction of how R integrates in Azure ML, Power BI and SQL Server.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey to Data Science!

SessionID: 46986

SQL Server Window Functions

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Steven Ormrod

Title: SQL Server Window Functions

Abstract:

Window functions are a great TSQL tool that will allow you to write simpler, more elegant code. They were first introduced in SQL 2005, and then expanded in SQL 2012. By using TSQL Window functions you can simply your code and make it easier to understand. They allow you to see both aggregations and details all at the same time. In this demo-centric session we will begin with the basics introduced in SQL 2005, then move on to examine the new functions that were added with SQL 2012.

SessionID: 47169

Avoiding the Pitfalls of Database Change Automation

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Cindy Bean

Title: Avoiding the Pitfalls of Database Change Automation

Abstract:

Automation and Continuous Delivery are at the forefront of software development processes today. However, databases are being neglected because database code is different, harder to automate, and DBAs just don't seem to trust database automation. This is not surprising when you consider the number of incidents and instances of downtime that were caused by out-of-process updates, code overrides, and other database glitches. In this session, we will explain the options to automate database changes along with the benefits and issues with each option.

SessionID: 48217

Introduction to SQL 2016 Temporal Tables

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Vicky Harp

Title: Introduction to SQL 2016 Temporal Tables

Abstract:

SQL Server 2016 introduces the concept of temporal tables, also called system-versioned tables. This new feature allows SQL Server to automatically keep track of the history of rows in any table for which it is enabled. In this session we'll cover the basics on how to create and work with temporal tables, including the new FOR SYSTEM_TIME query clause, and we'll discuss some of the ways that they may or may not fill a need in your environment.

SessionID: 48303

Hostile Takeover

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Bishop

Title: Hostile Takeover

Abstract:

In the spirit of Tim Ford's year long Entry Level Challenge, what do you do when given a SQL Server to manage? This presentation will walk you through how to gain access to a SQL Server you have never seen before, what are the basic tools to use to collect inventory information, and what scripts I use to best determine the "health" of the server.

SessionID: 48345

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 48542

SQL Omphaloskepsis: Enlightenment and Productivity Using System Tables

Back to calendar

Event Date: 14-05-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Brian Dudley

Title: SQL Omphaloskepsis: Enlightenment and Productivity Using System Tables

Abstract:

Codd's 4th rule for relational databases requires the database structure to be accessible within the database with the normal query tools. Turning SQL back on the database is a powerful technique that can yield productivity gains whether you are an analyst, a developer, or a DBA.

This talk is designed to share information, techniques, and code examples for using the system metadata for reporting, management, and code generation. Get comfortable with where to find useful information. Understand common query patterns and use cases. Learn useful functions, coding tricks, and how and when to leverage dynamic code.

SessionID: 44666

So what does it really take to get to four nines

Back to calendar

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

Speaker: George Govantes

Title: So what does it really take to get to four nines

Abstract:

As ones responsibilities grow as a senior Database Administrator many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some Database Administrator will argue this is out of my scope of responsibilities why should I care about building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem. Managing customer expectations what do you really mean by 99.99% up time, Translating business requirements to operational realities, commonly overlooked items that impact your 4 nines Avoiding human errors the realities and perception of high availability.

SessionID: 45205

Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Back to calendar

Event Date: 14-05-2016 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Mike Byrd

Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Abstract:

Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.

SessionID: 45473

Beyond the Where: Full Text Search tips and tricks

Back to calendar

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

Speaker: Kris Hokanson

Title: Beyond the Where: Full Text Search tips and tricks

Abstract:

Lots of people know that Full Text Search is a powerful tool for searching unstructured data but did you know that you can utilize its power for structured data as well? Functions like FREETEXTTABLE and CONTAINSTABLE open up some pretty groovy doors in terms of usability. We’ll discuss ways to give your users that search engine like interface that everyone has grown accustomed to without sacrificing query performance. We’ll also hit on creating synonyms to give your users results even when they aren’t quite sure what to search for. It’s an entirely different type of search altogether.

SessionID: 45694

Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Back to calendar

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

Speaker: Jamey Johnston

Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Abstract:

Join me for an overview of the most recent security investments for SQL Server 2016 and Azure SQL Database in the areas of encryption, data filtering and data masking. I will showcase a real-life user scenario with examples and demos of Always Encrypted, Row Level Security and Dynamic Data Masking. The demos include a real working .NET application with source code for testing. This is based on the session and demos I co-presented with Microsoft at SQL Summit 2015 so if you missed Summit or the presentation and are interested in learning what Microsoft is doing in the area of security in SQL Server 2016 and Azure SQL DB then this is the session for you.

SessionID: 48420

A Choice Performance Tuning

Back to calendar

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

Speaker: Jason Wong

Title: A Choice Performance Tuning

Abstract:

We don't just throw resources to a server until we can prove it is going to be utilized. I was often asked how to know and when the SQL Server system needs additional hardware resources? or we can trim down the excessive usage of resources?

It is a choice of judgement from experiences. The optimization goal is not to waste system resources but maintain database best performance. In this session, let me share with you my many years of experiences and show you the general rule of thumb to performance tuning. We will go over the following topics of discussions for typical scenarios that applies to SQL Server generally (not a specific version). The take-away is you would understand better what to do to help your SQL Server reach optimal performance and proactively prevent problems.

CPU: Memory: IO: Storage: SQL Server Default configuration: Development Design: Index: Performance T-SQL: Monitoring and Diagnosis: Demo: http://dbace.us

SessionID: 48479

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

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

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures, filled with table variables, instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cut that work from hours or days to minutes or even seconds. Stop writing code manually and let regular expressions do it for you. Learn:

• The most useful regular expression commands • The appropriate times to use regular expressions • How to use regular expressions to write code for you • How to incorporate regular expressions into large tasks and combine them with other methods

SessionID: 48566

The Ins and Outs of Partitioned Tables

Back to calendar

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

Speaker: Brian Dudley

Title: The Ins and Outs of Partitioned Tables

Abstract:

As data rates continue to increase, databases are growing in size. One tool used to tame large database is table partitioning. It can speed ETL processes and simplify maintenance.

This talk covers the What, Why, and How of Partitioned tables. Learn how to set them up, query and maintain them, and handle common ETL use cases.

SessionID: 49742

Azure Database for DBA's

Back to calendar

Event Date: 14-05-2016 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: John Sterrett

Title: Azure Database for DBA's

Abstract:

Did you think cloud databases like Azure Database could replace your job? It's not, but it will redefine your job as you know it today. Platform as a service (PaaS) databases are here and adoption is growing. In this session, you will learn how to take your current DBA skills and utilize them with Azure Databases. We will focus on getting started, migrating databases, disaster recovery, performance, and security.

SessionID: 47610

Actively Proactive – Straightforward Ways to Manage and Diagnose SQL

Back to calendar

Event Date: 14-05-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Lori Brown

Title: Actively Proactive – Straightforward Ways to Manage and Diagnose SQL

Abstract:

Becoming a proactive DBA is something that most SQL administrators strive to be but many fall short. Meetings, doing non-SQL related tasks, excessive workload and sometimes corporate culture often work against a DBA by creating conditions where it is nearly impossible to pay attention to the tasks involved in taking care of your SQL instances. Our presentation will cover those proactive tasks and alerts that will provide a straightforward method of ensuring that maintenance and monitoring are working for all SQL instances you are responsible for. Additionally, we will cover some ways to identify emergency performance problems that will allow a DBA to quickly resolve issues while making them look like the expert they truly are.

SessionID: 48502

Cisco UCS, Optimal Platform for SQL Server

Back to calendar

Event Date: 14-05-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Moore

Title: Cisco UCS, Optimal Platform for SQL Server

Abstract:

Features and capabilities of Cisco UCS, and how these benefit the deployment and administration of SQL Server.

SessionID: 48681

What's new in SQL Server 2016

Back to calendar

Event Date: 14-05-2016 - Session time: 12:30:00 - Track: Information Delivery

Speaker: Mark Moore

Title: What's new in SQL Server 2016

Abstract:

Join us for lunch and learn about the exiting new features coming in SQL Server 2016.

SessionID: 49208

"Transform into a Data-Driven Organization"

Back to calendar

Event Date: 14-05-2016 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Matt White

Title: "Transform into a Data-Driven Organization"

Abstract:

Do you like Power BI – but your company is not ready to move to the CLOUD? Does your organization need a platform that will provide agility, speed, and scalability without sacrificing governance and security? Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and learn from Matt White about Version 6 BI Office from Pyramid Analytics, an end-to-end platform that enables people across your organization to have governed access to trusted data—to form insights, collaborate freely, and make better data-driven decisions.

SessionID: 49663

Transform Database Agility with XtremIO

Back to calendar

Event Date: 14-05-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Bryan Walsh

Title: Transform Database Agility with XtremIO

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: 49770

Tintri SQL Sentry – Optimizing Your Virtualized Workload

Back to calendar

Event Date: 14-05-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Victor Gentry

Title: Tintri SQL Sentry – Optimizing Your Virtualized Workload

Abstract:

Come learn how Tintri and SQL Sentry can take the risk and guesswork out of virtualizing SQL databases. Tintri Virtual-Aware Storage (VAS) systems blend the predictable performance of solid-state disk (SSD), per-VM Quality-of-Service (QOS) and superior analytics to empower DBAs to confidently deploy even the most demanding enterprise applications with ease. Tintri makes complex database management tasks like cloning, backup/recovery, and test/dev refreshes a breeze through software automation that eliminates error-prone, manual processes. With the recent partnership between Tintri and SQL Sentry, DBAs can monitor specific performance metrics of their Tintri devices within SQL Sentry Performance Advisor. Visit our booth and attend our lunch session to see Tintri and SQL Sentry in action.

SessionID: 49996

A new paradigm for workload analytics in SQL Server

Back to calendar

Event Date: 14-05-2016 - Session time: 12:30:00 - Track: Other

Speaker: Amit Parikh

Title: A new paradigm for workload analytics in SQL Server

Abstract:

In this session, you will learn how to utilize Foglight’s Performance Investigator to analyze and determine the root causes to SQL Server performance issues created by transaction workload. We will discuss the new monitoring architecture used as well demonstrate use-cases that allow for forensic-level analysis of real-time and historical data. Focus areas such as deep-dive lock analysis; comparing workload between time periods and instances; as well as change tracking for database configuration, objects execution plans and system configuration to quickly see the impact on database performance will be showcased during this session.

SessionID: 44649

Troubleshooting SQL Server Performance

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Stacy Gray

Title: Troubleshooting SQL Server Performance

Abstract:

Microsoft SQL Support Engineers troubleshoot performance issues all day, every day. They use a set of tools that not only gather all the data necessary to troubleshoot any performance issue, but the tools also analyze the data and generate visually attractive reports. These tools have been available to the public for free for years. This presentation explains the tools, how to run them and how to interpret the results, including how to determine disk latency root cause, top reasons for high cpu, and what to do when you have excessive waits.

SessionID: 44771

Making the Most of the SSIS Catalog

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Making the Most of the SSIS Catalog

Abstract:

Managing the SQL Server Integration Services (SSIS) ecosystem became significantly easier with the addition of the SSIS catalog in SQL Server 2012. The SSIS catalog offered many new features that made often-laborious tasks such as logging, parameterization, and variable collections much easier to develop and manage. For the SSIS developer as well as the operations staff in charge of day-to-day package execution, using the SSIS catalog helps to make their jobs easier by eliminating several tedious and error-prone processes.

In this session, we will survey and demonstrate many of the useful features of the SSIS catalog. We will discuss the structure of the catalog and review how it changes the way we interact with deployed packages in SSIS. We will also demonstrate how parameters and SSIS environments help to ease the burden of supplying runtime configuration values to packages. In addition, we will demonstrate how package logging is a far simpler exercise in the new SSIS catalog.

SessionID: 46148

SQL Server Defaults SUCK!!

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Boles

Title: SQL Server Defaults SUCK!!

Abstract:

If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

SessionID: 46363

T-SQL Tips Tricks

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: T-SQL Tips Tricks

Abstract:

Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you'll learn about various features such as CTE, ROW_NUMBER, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want.

SessionID: 46480

Cluster@#$%! High Availability Solutions. What Could Go Wrong?

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: John Harp

Title: Cluster@#$%! High Availability Solutions. What Could Go Wrong?

Abstract:

If you have a high availability need in your production environment -- and who doesn't, these days -- you've probably had to think through the options. Clustering, Availabililty Groups, Mirroring, Replication, a third-party solution?

Even when you make an informed decision about what high-availability implementation you'll use, are you sure it will come online and stay online? Join John in this review of some of the more prominent failures (and their solutions) in commonly used high-availability configurations.

SessionID: 47476

Gen2016™ and the Global “Hybrid” Cloud

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Anthony {Tex} Moreign

Title: Gen2016™ and the Global “Hybrid” Cloud

Abstract:

THEME: Like it or not, our industry is driving the world to Gen2016™ {Windows 2016, SQL Server 2016, Azure, etc.,} technologies. This GENeration shift is filled with buzzwords, that hover around or land-on “HYBRID Cloud”. Hint: HCCUG.org has been speaking, for many years, about “Hybrid Cloud” and its “Global” perspective/implications/offering, (e.g., the free-ish offerings in US/China/EU).

#171;#177;#187; SESSION: The focus is on Data (e.g., Big Data Small Data) in the Gen2016™ “Global Hybrid Cloud” offerings from both Microsoft and non-Microsoft – as it appears at this point-in-time/May2016. This is a Level-100 session (no pre-requisites), and is for those who want a jump-start on Gen2016™ offerings, irrespective of whether you are just getting started in the industry, and/or retooling/realigning/revamping your skill set.

#171;#177;#187; NOTE: The presenters, Tex (20+ year technologist) and Zane (budding technologist), are with Hybrid Decisions#174; Corp and are presenting on behalf of HCCUG.org

SessionID: 48571

Codd's Rules, Normal Forms, and SQL Anti-Patterns - Recognition Repair

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Ken Clement

Title: Codd's Rules, Normal Forms, and SQL Anti-Patterns - Recognition Repair

Abstract:

In 1970 E.F. Codd presented a seminal set of ideas now known as the Relational Model of Data. Revolutionary for its time, these notions would give rise to many of the database engines of today including SQL Server. Too many software developers and database designers though are unfamiliar with these ideas or do not know how to effectively apply them. This presentation reviews Codd's rules and the relational normal forms; explains the differences between the relational model of data and the SQL database engines these ideas inspired; identifies some of the SQL anti-patterns that avoidance of these rules and normal forms gives rise to; and discusses both technical and organizational strategies for improving existing applications and their associated database designs and implementations.

SessionID: 50251

Watch Brent Tune Indexes

Back to calendar

Event Date: 14-05-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Brent Ozar

Title: Watch Brent Tune Indexes

Abstract:

You're not starting from scratch - you have a database that's already in production, and you can't make too many changes to the app. You want to make it go faster with as little danger and disruption as possible. You're comfortable writing queries to get the data you need, but you're not so confident when it comes to picking the right nonclustered indexes. How many should you have? What fields should they be on?

In this session, you'll learn Brent Ozar's easy one-hour process to:

SessionID: 44652

Designing Stored Procedure Solutions

Back to calendar

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

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.

SessionID: 45001

Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edit

Back to calendar

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

Speaker: Daniel Janik

Title: Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edit

Abstract:

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.

SessionID: 46149

Indexing Deep Dive

Back to calendar

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

Speaker: Kevin Boles

Title: Indexing Deep Dive

Abstract:

Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.

SessionID: 46381

Deploy SQL Server with Microsoft Azure Virtual Machine

Back to calendar

Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Bala Shankar

Title: Deploy SQL Server with Microsoft Azure Virtual Machine

Abstract:

Microsoft Azure provides multiple options to migrate SQL Server to the Cloud. But migrating SQL Server requires good understanding of the different options and the constraints. This session focuses on Microsoft Cloud option for SQL Server, how to deploy SQL Server on Azure Virtual Machine, how SQL Licensing works on Azure Virtual Machine, deploying Alwayson AG and Hybrid Cloud Scenarios.

SessionID: 46875

What's New in SSRS 2016

Back to calendar

Event Date: 14-05-2016 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Patrick LeBlanc

Title: What's New in SSRS 2016

Abstract:

It’s been 10 years SQL Server Reporting Services has been updated. Hey Microsoft, what’s the hold up? Well the wait is over. Join me in this demo-heavy session where I will discuss and demonstrate all the new features of SSRS, from custom parameter layouts to pinning reports to Power BI.

SessionID: 47166

Profiler is Dead! Long Live Extended Events!

Back to calendar

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

Speaker: Keith Tate

Title: Profiler is Dead! Long Live Extended Events!

Abstract:

Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.

That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool! In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!

SessionID: 48209

SQL Server Statistics – What Are The Chances?

Back to calendar

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

Speaker: Lori Edwards

Title: SQL Server Statistics – What Are The Chances?

Abstract:

For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.

SessionID: 48346

Making the Leap from Developer to DBA

Back to calendar

Event Date: 14-05-2016 - Session time: 14:45:00 - Track: Professional Development

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 45718

Why Did My Execution Plan Change? Introduction to Query Store

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: Why Did My Execution Plan Change? Introduction to Query Store

Abstract:

Join John Sterrett, Principal Consultant at Procure SQL LLC to learn how execution plans get invalidated and why data skew could be the root cause to seeing different execution plans for the same query. We will look at the options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using a new feature in SQL Server 2016 called Query Store.

SessionID: 46872

Introduction to Microsoft Mobile Reporting

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Patrick LeBlanc

Title: Introduction to Microsoft Mobile Reporting

Abstract:

This is a must attend session for every data professional. Join me as I provide an overview of Microsoft Mobile Reporting, Microsofts newly acquired on-premises mobile BI solution. Mobile Reporting is optimized for SQL Server and designed to enable rapid development and publishing of business intelligence in a way that delivers premium user experience on any device. In this session I will provide an overview of Mobile Reporting, discuss its key features, provide an architectural overview and finally demonstrate how to author and publish dashboards.

SessionID: 47046

Simple Fun Modeling with SQL Server

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Dane Schilling

Title: Simple Fun Modeling with SQL Server

Abstract:

Ever want to grow your own data? Or test out simple algorithms? Explore the process with me in a fun easy to follow demonstration. We will build a simple population growth engine that feeds a report on a web page.

SessionID: 48480

Understanding Backups

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Understanding Backups

Abstract:

One of the most important functions a DBA can perform is the backup. And far too many DBAs rely on the wizard to perform this task. Here I'll take you through everything you need to know about understanding command line backups, writing backup routines, and making the right decisions on how to do what kind of restore and when. I will take you through basic backup syntax and fully explain how things work the way they do and why. If you ever wanted to understand the ins and outs of SQL Server backups then this session will give you what you're after.

SessionID: 48512

How answers.microsoft.com Overcame the key Challenges of Upgrading to SQL S

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Wiley

Title: How answers.microsoft.com Overcame the key Challenges of Upgrading to SQL S

Abstract:

As part of the company’s “Get Current/Stay Current” initiative, Microsoft’s IT organization planned to upgrade its community website, answers.microsoft.com from Microsoft SQL Server 2008 to Microsoft SQL Server 2014. At the same time, the site adopted virtualization and needed to maintain the zero downtime environment the group had built with mirroring. Given the site spans four data centers across the globe and supports more than 1.7 million visitors a day, Microsoft cannot afford downtime, not even for maintenance. This case study shares best practices for upgrading to SQL Server 2014, highlights the technologies Microsoft considered to enable continuous availability, and details how the site leveraged AlwaysOn without making application changes.

SessionID: 48550

The Life Cycle of a Query in Virtual Reality

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Information Delivery

Speaker: Todd Kleinhans

Title: The Life Cycle of a Query in Virtual Reality

Abstract:

How would you like to learn about using Virtual Reality (VR) to present information? The ability to become immersed and walk around inside of a VR environment is a new and unique way to present and look at information. As data professionals we need to be open to novel displays of data and explore what VR can do that for us that we have not been able to do in the past. VR can provide a way for people to see relationships and interact among data sets which can be difficult for computers to display visually on a flat screen.

The Life Cycle of a Query in Virtual Reality is built using Epic Games video game engine called Unreal Engine 4 (UE4). With native support for VR, UE4 has been used for applications beyond just video games. With the commercial availability of affordable VR headsets, data professionals can now create visually compelling environments that were almost impossible or extremely expensive just a few years ago on both PC and mobile devices.

SessionID: 48561

Who's Afraid of Entity Framework?

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Richie Rump

Title: Who's Afraid of Entity Framework?

Abstract:

Do any applications in your environment use SQL written not by a person but by the application itself? No, the system isn't self-aware. Chances are it is using the Microsoft Entity Framework (EF).

EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it's changed over time. We'll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we'll review EF-generated T-SQL and give some tips on how to improve performance. If you're a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.

SessionID: 49756

Scale out SQL Server PaaS in Azure Elastically

Back to calendar

Event Date: 14-05-2016 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Shawn Weisfeld

Title: Scale out SQL Server PaaS in Azure Elastically

Abstract:

You have heard all the hype how the cloud can help you scale your databases horizontally, providing you limitless capacity, but how do you do that? In this presentation we will take a look at the Elastic Database tools. We will focus on the key use cases for shard map management, data dependent routing and multi-shard querying.

This site is open source. Improve this page.