sqlsathistory

Nr: 531

Back to Main list

SQLSaturday #531 - Louisville 2016

Start Time (24h) Speaker Track Title
08:30:00 John Deardurff Application Database Development The PROCESS of Queries
08:30:00 Peter Shore Enterprise Database Administration Deployment Infrastructure for the DBA: An Introduction
08:30:00 Chris Albrektson BI Information Delivery What's new in Reporting Services 2016
08:30:00 Kevin Wilkie BI Platform Architecture, Development Administration Learning R Using Fantasy Football Data
08:30:00 Justin Randall Enterprise Database Administration Deployment The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags
08:30:00 Daniel Glenn BI Platform Architecture, Development Administration Power BI SharePoint - A Marriage Made in Redmond
09:45:00 Dave Mattingly Advanced Analysis Techniques Word Up: Text Mining in SQL
09:45:00 Ryan Wade BI Platform Architecture, Development Administration Why “R” you not leveraging the power of “R” in Power BI?!?
09:45:00 Mike Walsh Enterprise Database Administration Deployment Baselines and Performance Monitoring with PAL
09:45:00 Aaron Cutshall Application Database Development The Lost Science of Set Theory
09:45:00 Evelyn Maxwell Professional Development Improving Your PowerPoint Skills
09:45:00 James King Application Database Development Service Broker: A Conceptual Approach
11:00:00 Monica Rathbun Professional Development I’m It – Survival Techniques for the Lone DBA
11:00:00 Louis Davidson Application Database Development Let Me Finish... Isolating Write Operations
11:00:00 David Maxwell Enterprise Database Administration Deployment Wait Statistics - The Top 5 Waits You Should Know
11:00:00 Rie Irish Professional Development Women in Technology: Identifying, Understanding and Combating Gender Bias
11:00:00 Kenney Snell Analytics and Visualization Is your Flight on Time? – Power BI Dashboard
11:00:00 Michael Fal Enterprise Database Administration Deployment Exploring SQLPS, the SQL Server Powershell Module
13:00:00 Andrew Loree Enterprise Database Administration Deployment Stretch Database and Managed Backups: Cloud Services for your SQL Servers
13:00:00 Tracy Boggiano Enterprise Database Administration Deployment Query Store Primer
13:00:00 Ed Watson Enterprise Database Administration Deployment Backup Strategies are for Losers...of Data!
13:00:00 Allen White Application Database Development Scalable Application Design with Service Broker
13:00:00 Tim Chapman Application Database Development Getting started with Always Encrypted in SQL Server 2016
13:00:00 Robert Verell Enterprise Database Administration Deployment Getting Started with SQL Server Replication
14:15:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server and PowerShell: Let's Get Serious
14:15:00 David Klee Professional Development The Many Paths of Consulting
14:15:00 Chris Bell Enterprise Database Administration Deployment Statistics Cardinality – How they work to find data efficiently
14:15:00 Patrick LeBlanc BI Information Delivery Introduction to the Power BI Desktop
14:15:00 Eddie Wuerch Enterprise Database Administration Deployment Digging Out From Corruption
14:15:00 Matt Gordon Enterprise Database Administration Deployment Top 5 Tips to Keep Always On Always Humming and Users Happy
15:30:00 Warren Sifre Advanced Analysis Techniques Introduction to Azure Machine Learning
15:30:00 Gigi Bell Professional Development Dealing With Difficult Managers
15:30:00 Ned Otter Enterprise Database Administration Deployment Real world In-Memory OLTP
15:30:00 Rob Volk Enterprise Database Administration Deployment Azure, PowerShell, and SQL Server Virtual Machines
15:30:00 Kevin Feasel Application Database Development Peanut Butter Chocolate: Integrating Hadoop with SQL Server
15:30:00 Jason Brimhall Enterprise Database Administration Deployment Extended Events - Better than Profiler

SessionID: 48383

The PROCESS of Queries

Back to calendar

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

Speaker: John Deardurff

Title: The PROCESS of Queries

Abstract:

This session is an introduction into the PROCESS of queries. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss the differences between Heaps, Clustered Indexes, and Non-Clustered Indexes. Finally we introduce Execution Plans and Statistics. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.

SessionID: 49144

Infrastructure for the DBA: An Introduction

Back to calendar

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

Speaker: Peter Shore

Title: Infrastructure for the DBA: An Introduction

Abstract:

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.

SessionID: 50329

What's new in Reporting Services 2016

Back to calendar

Event Date: 06-08-2016 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Chris Albrektson

Title: What's new in Reporting Services 2016

Abstract:

With the upcoming release of SQL Server 2016, Microsoft has blown the dust off the tried and true SSRS and injected some much needed life. SSRS 2016 introduces a shiny new portal with a new Dashboard/Mobile report types. In this session, we'll take a look at what has changed in SSRS 2016 and how to get up and running using the new Dashboard/Mobile reports. Through demos we'll walk through everything you need to create your first Mobile ready SSRS 2016 Dashboard!

SessionID: 50614

Learning R Using Fantasy Football Data

Back to calendar

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

Speaker: Kevin Wilkie

Title: Learning R Using Fantasy Football Data

Abstract:

R -- it's included in SQL Server 2016. What the heck can I do with it? Why do I need to know yet another software language? How can I use it to figure out important things -- like who do I draft over who in my fantasy football league?

We'll go over the basics of R and rStudio, plus items such as:

SessionID: 51198

The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags

Back to calendar

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

Speaker: Justin Randall

Title: The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags

Abstract:

Microsoft markets SQL Server as a "self-tuning" RDBMS, 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 and trace flags that can impact performance, alter default behaviors and help your troubleshooting efforts.

SessionID: 51210

Power BI SharePoint - A Marriage Made in Redmond

Back to calendar

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

Speaker: Daniel Glenn

Title: Power BI SharePoint - A Marriage Made in Redmond

Abstract:

We will explore the relationship between SharePoint and Excel, how Power BI swooped SharePoint off her feet, and the current Business Intelligence soap opera that stars all three. Using live demos, we will look at data interaction between SharePoint, Excel, Power BI (including the iOS app), and the intriguing new next door neighbor - Microsoft Flow.

SessionID: 47012

Word Up: Text Mining in SQL

Back to calendar

Event Date: 06-08-2016 - Session time: 09:45:00 - Track: Advanced Analysis Techniques

Speaker: Dave Mattingly

Title: Word Up: Text Mining in SQL

Abstract:

Would a database by any other name smell as sweet?

Our databases are filled with words. By mining our text for patterns and meanings, we can extract the emotional content, track changes over time, ferret out plagiarism, find common phrases and usage, and even predict future text.

Learn how to dig through your library of language to make your data better.

SessionID: 48568

Why “R” you not leveraging the power of “R” in Power BI?!?

Back to calendar

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

Speaker: Ryan Wade

Title: Why “R” you not leveraging the power of “R” in Power BI?!?

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft has since incorporated R in Azure ML, SQL Server 2016, and Power BI.

In this session I will focus on the benefits of using R in Power BI. I will show how to leverage R for data munging (ETL) and I will also show how to leverage R to create custom visualizations. I will focus on the "Wickham stack" which is a group of very popular R packages developed by Hadley Wickham. The “Wickham stack” includes the ggplot2, dplyr, and tidyr packages. I will discuss logical use cases for using R within Power BI as well as some of the pitfalls that you may encounter.

SessionID: 48627

Baselines and Performance Monitoring with PAL

Back to calendar

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

Speaker: Mike Walsh

Title: Baselines and Performance Monitoring with PAL

Abstract:

How are your servers running? What is going on in your SQL Server? How are you trending? When will you need the next server? Do you need to throw more hardware at SQL or more query tuning? (Or both?) In this session – we will share some free tools, techniques and approaches you can take right now with resources you already have to answer these questions and more.

SessionID: 48969

The Lost Science of Set Theory

Back to calendar

Event Date: 06-08-2016 - Session time: 09:45: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: 49106

Improving Your PowerPoint Skills

Back to calendar

Event Date: 06-08-2016 - Session time: 09:45: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: 51181

Service Broker: A Conceptual Approach

Back to calendar

Event Date: 06-08-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: James King

Title: Service Broker: A Conceptual Approach

Abstract:

An overview of the concepts and abstractions used by Service Broker. Learn about how Service Broker enables SQL Server to perform asynchronous, distributed and reliable messaging by focusing on the concepts presented.

SessionID: 48122

I’m It – Survival Techniques for the Lone DBA

Back to calendar

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

Speaker: Monica Rathbun

Title: I’m It – Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 48560

Let Me Finish... Isolating Write Operations

Back to calendar

Event Date: 06-08-2016 - 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: 48959

Wait Statistics - The Top 5 Waits You Should Know

Back to calendar

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

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

Women in Technology: Identifying, Understanding and Combating Gender Bias

Back to calendar

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

Speaker: Rie Irish

Title: Women in Technology: Identifying, Understanding and Combating Gender Bias

Abstract:

Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women job responsibilities. We'll learn about the origins of some of these biases and how to identify gender bias when we see it. We'll discuss some strategies for how both men and women can combat this at work in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.

SessionID: 50421

Is your Flight on Time? – Power BI Dashboard

Back to calendar

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

Speaker: Kenney Snell

Title: Is your Flight on Time? – Power BI Dashboard

Abstract:

It’s easy to find useful data on the Internet, model the data and construct a BI Dashboard using Power BI Desktop. The application used in this session shows on-time performance of domestic flights.

Using government data this is available, you can answer these questions:

  1. Which airlines have the best on-time performance?
  2. Which flights between airports are regularly on-time?
  3. What day of the week or month is best to fly to get there on time?
  4. Which airline has the most cancelations? This session covers how to build, model, and deploy a Power BI Dashboard to PowerBI.com that reads flight data and displays aircraft flights on-time performance. The session also shows how to use Power Query to get data from the web.
    Finally, see the Dashboard in action and also how to use QA, a natural-language search technology. Also, see Quick “Data” Insights, which uses Cortana Analytics in the background to show additional insights and analysis using the existing data model.

SessionID: 52464

Exploring SQLPS, the SQL Server Powershell Module

Back to calendar

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

Speaker: Michael Fal

Title: Exploring SQLPS, the SQL Server Powershell Module

Abstract:

A big hurdle for using Powershell and SQL Server together is the SQLPS module. Both old and new users of Powershell don’t completely understand its capabilities. In this session, we’ll talk about the cmdlets you may not know about, tricks to save time using the provider, and even a few gotchas on how the provider works that can save you some time and energy. When we’re finished, you will have a deeper understanding of how you can use SQL Server and Powershell together.

SessionID: 48316

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

Back to calendar

Event Date: 06-08-2016 - Session time: 13:00: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: 50260

Query Store Primer

Back to calendar

Event Date: 06-08-2016 - Session time: 13:00: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: 50474

Backup Strategies are for Losers...of Data!

Back to calendar

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

Speaker: Ed Watson

Title: Backup Strategies are for Losers...of Data!

Abstract:

Defining and documenting a backup strategy in today's data platform is simply not enough to prevent a major catastrophe. For that, a company needs to define a recovery strategy that encompasses their backup solution with an appropriate, tested recovery plan. This session outlines the various backup strategies and how to implement them in a recovery scenario to minimize data loss. This session will discuss various case studies of backup strategy implementations that neglected a strong recovery strategy and resulted in catastrophe for the company.

SessionID: 50644

Scalable Application Design with Service Broker

Back to calendar

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

Speaker: Allen White

Title: Scalable Application Design with Service Broker

Abstract:

How your business applications interact directly with the corporate database can dramatically affect how successful you are. One of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can focus performance concerns where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently and minimizes conflicts with your critical updates. This session walks you through the steps to get Service Broker running and providing a consistent delivery of your business data.

SessionID: 51078

Getting started with Always Encrypted in SQL Server 2016

Back to calendar

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

Speaker: Tim Chapman

Title: Getting started with Always Encrypted in SQL Server 2016

Abstract:

SQL Server 2016 significantly raises the bar in terms of data security. One of the most exciting features introduced in the newest release of SQL Server is Always Encrypted. This feature ensures that data remains encrypted in its entire lifecycle - at rest as well as in transit. Additionally, the encrypted data can be made completely inaccessible to database administrators. With the assistance of an updated .Net client-side driver, this great new feature ensures that applications can leverage Always Encrypted data without application code changes. In this demo-rich session we will look at how to enable and configure Always Encrypted as well as how applications can be configured to use this amazing new technology.

SessionID: 52248

Getting Started with SQL Server Replication

Back to calendar

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

Speaker: Robert Verell

Title: Getting Started with SQL Server Replication

Abstract:

SQL Server replication is an excellent way to keep a subset of data synced with another database for reporting, audit, or recovery purposes. In this session we will examine terms, internals, and walk through the setup of transactional and snapshot replication so you can utilize it as a valuable tool in your toolkit. We will also examine some ways to make replication perform better as well. This session is targeted towards database administrators who have little to no experience with replication and developers looking for different ways to duplicate data for reporting or data consumption.

SessionID: 48535

SQL Server and PowerShell: Let's Get Serious

Back to calendar

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

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

The Many Paths of Consulting

Back to calendar

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

Speaker: David Klee

Title: The Many Paths of Consulting

Abstract:

People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.

This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.

SessionID: 48995

Statistics Cardinality – How they work to find data efficiently

Back to calendar

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

Speaker: Chris Bell

Title: Statistics Cardinality – How they work to find data efficiently

Abstract:

Are your statistics up to date?

Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.

SessionID: 49322

Introduction to the Power BI Desktop

Back to calendar

Event Date: 06-08-2016 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Patrick LeBlanc

Title: Introduction to the Power BI Desktop

Abstract:

Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.

SessionID: 50335

Digging Out From Corruption

Back to calendar

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

Speaker: Eddie Wuerch

Title: Digging Out From Corruption

Abstract:

A "Disaster" doesn't need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA's toolbox.

SessionID: 50867

Top 5 Tips to Keep Always On Always Humming and Users Happy

Back to calendar

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

Speaker: Matt Gordon

Title: Top 5 Tips to Keep Always On Always Humming and Users Happy

Abstract:

Have you ever wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? Let my experience maintaining several production Always On Availability Groups provide you some battle-tested information and hopefully save you some sleepless nights. From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy and the DBA’s phone quiet.

SessionID: 46973

Introduction to Azure Machine Learning

Back to calendar

Event Date: 06-08-2016 - Session time: 15: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: 48997

Dealing With Difficult Managers

Back to calendar

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

Speaker: Gigi Bell

Title: Dealing With Difficult Managers

Abstract:

We have all encountered difficult managers that leave us stressed out. They can be micro-managers, bullies, too timid, or even just apathetic. In any case, you are currently stuck with this manager, and you need coping strategies!

Through case studies and open discussion, we will help you determine if you indeed have a difficult manager. We will identify and categorize behavior patterns of managers so that you can determine the best strategies to deal with him or her. In addition, we will also explore the consequences of these actions, and how they can help you to succeed in furthering your career.

SessionID: 50606

Real world In-Memory OLTP

Back to calendar

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

Speaker: Ned Otter

Title: Real world In-Memory OLTP

Abstract:

What is the optimal way to migrate existing data to In-Memory?

How does Garbage Collection work, what types of memory-optimized objects does it work with, and how can I make sure it's operational?

What are the pros/cons of different ways of handling hot/cold data with In-Memory OLTP?

What causes ALTER TABLE to be fully logged and serially executed?

All of these questions and more are answered as we discuss real-world usage of In-Memory OLTP

SessionID: 50687

Azure, PowerShell, and SQL Server Virtual Machines

Back to calendar

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

Speaker: Rob Volk

Title: Azure, PowerShell, and SQL Server Virtual Machines

Abstract:

SessionID: 50869

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

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

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 is 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: 53415

Extended Events - Better than Profiler

Back to calendar

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

Speaker: Jason Brimhall

Title: Extended Events - Better than Profiler

Abstract:

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

This site is open source. Improve this page.