sqlsathistory

Nr: 447

Back to Main list

SQLSaturday #447 - Dallas 2015

Start Time (24h) Speaker Track Title
08:30:00 Nancy Hidy Wilson Enterprise Database Administration Deployment Managing SQL Server in the Enterprise with TLAs
08:30:00 Argenis Fernandez Enterprise Database Administration Deployment (Near) Zero-Downtime Upgrades!
08:30:00 Chris Shaw Enterprise Database Administration Deployment Tips for SQL Server Performance and Resiliency
08:30:00 Trayce Jordan Enterprise Database Administration Deployment Finding root cause for unexplained Availability Group failover
08:30:00 Ginger Grant Advanced Analysis Techniques Incorporating Azure Machine Learning to SQL Server Environments
08:30:00 Paul Hargis Advanced Analysis Techniques Spark SQL and Hadoop - When to leverage in-memory SQL
08:30:00 Patrick Bewley Application Database Development Develop SQL Server Databases from Visual Studio: SQL Server Data Tools
08:30:00 Brennan Bice BI Information Delivery PowerBI / DataZen and Microsoft BI Roadmap
09:45:00 Daniel Janik Enterprise Database Administration Deployment Translating SANanese to English: How to manipulate your storage admin!
09:45:00 Dr. Suresh Rajappa BI Platform Architecture, Development Administration Practical Design Pitfalls in designing Enterprise Data Warehouse
09:45:00 Scott Shaw BI Information Delivery Big Data and the Data Lake from the Analyst Perspective
09:45:00 Bryan Smith Analytics and Visualization Predicting Customer Churn with Azure Machine Learning
09:45:00 Suresh Kandoth Enterprise Database Administration Deployment Configuring SQL Server for Mission Critical and Scalable Deployments
09:45:00 Cindy Bean Enterprise Database Administration Deployment Avoiding the Pitfalls of Database Change Automation
09:45:00 David Stein BI Platform Architecture, Development Administration SSIS Performance Tuning with BimlScript
11:00:00 Steven Rachui Other Configuration Manager and the SQL Broker Service - DRS under the covers
11:00:00 Mike Diehl BI Information Delivery Cash in on the data dividend: how Power BI can realize the untapped value of your data
11:00:00 Shawn Weisfeld Cloud Application Development Deployment Your DB in the cloud?
11:00:00 Scott Shaw Strategy and Architecture Navigating the Hadoop Stack
11:00:00 George Govantes Strategy and Architecture So what does it really take to get to four nines
11:00:00 Randy Knight Application Database Development But it worked great in Dev! Perfomance for Devs
11:00:00 John Harp Enterprise Database Administration Deployment Third-Party Application Deployment: Dispatches from the Trenches
11:00:00 Denzil Ribeiro Enterprise Database Administration Deployment SQL Server 2016 Scale and diagnostics improvements in core database engine
13:15:00 Daniel Janik Advanced Analysis Techniques Analyze your query plan like a Microsoft Engineer!
13:15:00 Lance Tidwell Enterprise Database Administration Deployment SQL Server Agent: The life preserver for the drowning DBA
13:15:00 Stan Geiger BI Platform Architecture, Development Administration What is the SSIS Catalog? and Why do I care?
13:15:00 Jayaprakash Jothiraman BI Platform Architecture, Development Administration ColumnStore Index: Microsoft SQL Server 2014 and Beyond
13:15:00 Kalen Delaney Enterprise Database Administration Deployment Are You Optimistic About Concurrency?
13:15:00 Patrick O'Keeffe Enterprise Database Administration Deployment Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance
13:15:00 Tim Mitchell BI Information Delivery Incremental Load Design Patterns
14:30:00 Kenneth Fisher Enterprise Database Administration Deployment SQL Server Security Basics
14:30:00 Adam Saxton BI Platform Architecture, Development Administration Everything you Want to know about Power BI Dependency on O365
14:30:00 Ryan Adams Enterprise Database Administration Deployment How Active Directory affects SQL Server
14:30:00 Amy Herold Enterprise Database Administration Deployment Beginning Automation with Powershell
14:30:00 Sri Sridharan Strategy and Architecture Modern Data Strategy
14:30:00 Kal Yella Application Database Development What’s that up in the cloud?! It’s the Azure SQL DB in all its new glory!
15:45:00 Mike Byrd Enterprise Database Administration Deployment SS2014 In-Memory Tables: Formula 1 Performance Unleashed!
15:45:00 Reinaldo Kibel Strategy and Architecture Is AlwaysOn really as powerful? Tips and Tricks from the field
15:45:00 Ryan Casey BI Information Delivery The "Data Loading Performance Guide" Presentation
15:45:00 Ahias Portillo Application Database Development Fast and Furious: Discovering Windowing Function
15:45:00 Andre Hass Enterprise Database Administration Deployment High Availability Solutions with Enhanced SQL Server 2016 Always ON
15:45:00 mahesh pujari Other SSIS Monitoring Framework

SessionID: 37228

Managing SQL Server in the Enterprise with TLAs

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Nancy Hidy Wilson

Title: Managing SQL Server in the Enterprise with TLAs

Abstract:

Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server features designed to make a DBA’s life easier. If you aren’t using CMS (Central Management Server), PBM (Policy Based Management), and EPM (Enterprise Policy Management Framework) – come learn what they are and the potential benefits in using them to manage your environment - from SQL 2000 to SQL 2014!

SessionID: 37957

(Near) Zero-Downtime Upgrades!

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Argenis Fernandez

Title: (Near) Zero-Downtime Upgrades!

Abstract:

SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure? You can actually do this, by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

In this session you will:

This is a demo-intensive session, so you can see rolling upgrades live and up close. If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you.

SessionID: 39419

Tips for SQL Server Performance and Resiliency

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Shaw

Title: Tips for SQL Server Performance and Resiliency

Abstract:

After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;

We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.

SessionID: 39429

Finding root cause for unexplained Availability Group failover

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Trayce Jordan

Title: Finding root cause for unexplained Availability Group failover

Abstract:

In this session, we will walk you step by step through one or more support cases that demonstrate how we determine root cause analysis of an unexplained failure in an Availability Group. Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover. We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.

SessionID: 39752

Incorporating Azure Machine Learning to SQL Server Environments

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Incorporating Azure Machine Learning to SQL Server Environments

Abstract:

Azure Machine Learning [ML] is a great tool for gathering more insight with your data, but how do you know if the models you are using are providing the best results? How do you apply modules customized to analyze your data? After this session you will have the answers to these questions, as well as the knowledge necessary to implement machine learning data analysis into your data environment.

Using Azure based SQL Server, attendees will learn rules which can be used to classify the data and the type of analysis desired by Azure ML. Building upon this information, the best methods for determining which ML models to use will be shown. This presentation will demo how to extend the flexibility of Azure ML by implementing custom analysis from other sources. Incorporating items created in R and SQL will show the expanded capabilities available outside of the existing ML components. Lastly we will deploy the Azure ML solution and incorporate the results into our SQL Server Database.

SessionID: 40128

Spark SQL and Hadoop - When to leverage in-memory SQL

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Paul Hargis

Title: Spark SQL and Hadoop - When to leverage in-memory SQL

Abstract:

SQL on Hadoop has many variants. These SQL engines strive to make use of the plethora of data engineers already trained in SQL. A new class of tools, like Apache Spark, aims to increase the speed at which those SQL results can be leveraged by providing an in-memory, distributed framework to hold and process data. This introductory talk will walk through the pros and cons, plus look at a few real-world examples that can be solved more efficiently with the Spark engine.

SessionID: 40150

Develop SQL Server Databases from Visual Studio: SQL Server Data Tools

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Patrick Bewley

Title: Develop SQL Server Databases from Visual Studio: SQL Server Data Tools

Abstract:

Did you know you can design and develop databases from within Visual Studio using SQL Server Data Tools? Attend this session to learn robust and repeatable database development methods and take your team to the next level using Visual Studio. Discover simple ways to manage databases using a tool designed by Microsoft.

SessionID: 40166

PowerBI / DataZen and Microsoft BI Roadmap

Back to calendar

Event Date: 03-10-2015 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Brennan Bice

Title: PowerBI / DataZen and Microsoft BI Roadmap

Abstract:

Microsoft has made a significant leap forward with in the business intelligence world with the public release of PowerBI.com and acquisition of DataZen. Power BI allows customers to create rich visualizes on a cloud platform. DataZen is an intuitive platform with attractive dashboards and KPIs for desktop and mobile devices. Come learn about features of both platforms, pros and cons, and Microsoft's BI roadmap.

SessionID: 37222

Translating SANanese to English: How to manipulate your storage admin!

Back to calendar

Event Date: 03-10-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Daniel Janik

Title: Translating SANanese to English: How to manipulate your storage admin!

Abstract:

This technical session covers everything you ever wanted to know about troubleshooting the storage in SQL Server. Have you ever observed high latency, only to be told "It's not the disks" by the storage admin? This empowering session will give you the knowledge you need to dig down to the root cause! This session will cover DMVs, Performance Monitor, XPerf, and more!

SessionID: 37223

Practical Design Pitfalls in designing Enterprise Data Warehouse

Back to calendar

Event Date: 03-10-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dr. Suresh Rajappa

Title: Practical Design Pitfalls in designing Enterprise Data Warehouse

Abstract:

This session covers practical approaches in avoiding the common design issues in implementing Data Warehouse solutions. This also gives tips to spot the early symptoms on these issues

SessionID: 37621

Big Data and the Data Lake from the Analyst Perspective

Back to calendar

Event Date: 03-10-2015 - Session time: 09:45:00 - Track: BI Information Delivery

Speaker: Scott Shaw

Title: Big Data and the Data Lake from the Analyst Perspective

Abstract:

The concept of a data lake is emerging as a popular way to organize and build the next generation of data systems to master new big data challenges. Organizations are seeking to create data lakes because they manage and use data with increased volume, variety, and unprecedented velocity. However, how can data professionals and analysts access the data lake for the expected insights at the velocity required by the business?

Come and join me for this practical session which will build on your existing SQL skills to demystify Big Data and the Data Lake for analysts. This session is aimed at people who want to keep pace with the latest Big Data technology by adopting the latest techniques to explore the data lake, building on their existing analytical knowledge.

SessionID: 37750

Predicting Customer Churn with Azure Machine Learning

Back to calendar

Event Date: 03-10-2015 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Bryan Smith

Title: Predicting Customer Churn with Azure Machine Learning

Abstract:

Using machine learning, we can tap into the patterns that tell us which of our customers are likely to defect to our competitors. This use case is not only applicable to a wide range of businesses but provides a highly accessible starting point for exploring machine learning.

SessionID: 38458

Configuring SQL Server for Mission Critical and Scalable Deployments

Back to calendar

Event Date: 03-10-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Suresh Kandoth

Title: Configuring SQL Server for Mission Critical and Scalable Deployments

Abstract:

SQL Server offers various configuration settings and tuning parameters. As hardware capabilities increase rapidly, choosing the proper configuration settings is extremely important to scale SQL Server for the required application throughput rates. In the last two years, SQL Server Escalation Team has helped many systems administrators and database administrators scale their SQL Server with several configuration parameters and application patterns. In this session you will hear directly from an experienced member of the Microsoft SQL Server escalation team [Suresh Kandoth], about these specific learnings, configurations and approaches for scaling SQL Server on the largest hardware systems available on the planet.

The goal of this session to help you and guide you to perform successful deployment of SQL Server for your largest SQL Server installations.

SessionID: 39834

Avoiding the Pitfalls of Database Change Automation

Back to calendar

Event Date: 03-10-2015 - 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: 40140

SSIS Performance Tuning with BimlScript

Back to calendar

Event Date: 03-10-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Stein

Title: SSIS Performance Tuning with BimlScript

Abstract:

You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we'll discuss how to use BimlScript to accomplish the following:

The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.

SessionID: 37218

Configuration Manager and the SQL Broker Service - DRS under the covers

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Other

Speaker: Steven Rachui

Title: Configuration Manager and the SQL Broker Service - DRS under the covers

Abstract:

When installed in a hierarchy Configuration Manager leverages the SQL Broker service to replicate data between the various sites. Understanding how Configuration Manager leverages SQL Broker and how to troubleshoot when things go wrong is critical to maintain proper hierarchy function. This session will describe how Configuration Manager replication works along with demonstrations that will highlight replication processing. We will also work through troubleshooting techniques that can be used from easiest to more complex.

SessionID: 37243

Cash in on the data dividend: how Power BI can realize the untapped value of your data

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: BI Information Delivery

Speaker: Mike Diehl

Title: Cash in on the data dividend: how Power BI can realize the untapped value of your data

Abstract:

IDC estimates that the economic value gap between companies that are innovative about data analytics and those that maintain a status quo is $1.6 trillion worldwide over the next four years. This presentation will look at the ways that the data dividend can be realized, and provides an overview of Microsoft Power BI (the tools in Excel and the cloud-based services) so you can understand how it can be applied to your organization.

SessionID: 37290

Your DB in the cloud?

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Shawn Weisfeld

Title: Your DB in the cloud?

Abstract:

Let's face it the cloud is here to stay, and while not every workload will be moving tomorrow an understanding of running database workloads in Azure is a must for every DBA. In this session driven by real world customer conversations we will discuss some of the ramifications of moving your database workload to the cloud. We will look at the PaaS and IaaS offerings available in Azure and discuss the how to choose between them.

SessionID: 37619

Navigating the Hadoop Stack

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Strategy and Architecture

Speaker: Scott Shaw

Title: Navigating the Hadoop Stack

Abstract:

Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We'll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.

SessionID: 37744

So what does it really take to get to four nines

Back to calendar

Event Date: 03-10-2015 - 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: 39408

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Randy Knight

Title: But it worked great in Dev! Perfomance for Devs

Abstract:

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.

SessionID: 39778

Third-Party Application Deployment: Dispatches from the Trenches

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: John Harp

Title: Third-Party Application Deployment: Dispatches from the Trenches

Abstract:

Before you install that third-party solution in your SQL Server environment, come to this fireside chat. John will spin tales from more than a decade of experience in application support to cover some of the more common, and more problematic gotchas you might encounter, as well as their workarounds and solutions. With luck, you'll leave with an improved pre-checklist for deploying purchased products, whether in Development or Production environments.

SessionID: 40047

SQL Server 2016 Scale and diagnostics improvements in core database engine

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Denzil Ribeiro

Title: SQL Server 2016 Scale and diagnostics improvements in core database engine

Abstract:

This session will discuss several core performance and scale improvements to the SQL 2016 Database Engine in order to many of of the most common customer pain points involving tempdb, new CE, partitioning , memory grants among others and will benefit any upgrade to SQL 2016. We will also discuss and demo new diagnostics improvements for faster troubleshooting and problem mitigation.

SessionID: 37220

Analyze your query plan like a Microsoft Engineer!

Back to calendar

Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Advanced Analysis Techniques

Speaker: Daniel Janik

Title: Analyze your query plan like a Microsoft Engineer!

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.

SessionID: 37225

SQL Server Agent: The life preserver for the drowning DBA

Back to calendar

Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Lance Tidwell

Title: SQL Server Agent: The life preserver for the drowning DBA

Abstract:

Automation is a key part to becoming a great DBA. Without automation a DBA can start to drown in a sea of repeating tasks. The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water. In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks. In addition we will look into how to monitor the jobs and alerts created. Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.

SessionID: 38231

What is the SSIS Catalog? and Why do I care?

Back to calendar

Event Date: 03-10-2015 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stan Geiger

Title: What is the SSIS Catalog? and Why do I care?

Abstract:

SQL Server 2012 redefined how SSIS packages are stored and executed. The advent of the SSISDB catalog gives a central point for working with SSIS projects deployed to the server. From this catalog we can set project and package parameter, configure environments, and monitor execution. There is no need to build in package logging because Microsoft had done it for us. This presentation covers what is in the catalog, how to deploy packages, environment, tips and tricks as well as monitoring package execution.

SessionID: 39256

ColumnStore Index: Microsoft SQL Server 2014 and Beyond

Back to calendar

Event Date: 03-10-2015 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jayaprakash Jothiraman

Title: ColumnStore Index: Microsoft SQL Server 2014 and Beyond

Abstract:

Column store technology was first introduced in SQL Server 2012 and has been significantly enhanced for SQL Server 2014 and SQL Server 2016. Column store indexes can not only accelerate data warehouse workloads by an order of magnitude but also reduce storage requirements by an order of magnitude. Column store indexes are a hybrid technology leveraging the best of disk in-memory capabilities. In this session we cover how to take advantage of column store capabilities in your applications and dive into the internals of how column store works in following areas.

Business Rationale , Overview, Trends in the Data Warehousing Space, Data Compression, Query Performance, Clustered Column Store Index, Supportability: DMVs, Perfmon, XEvents, High Availability/Supportability

You will also learn what is available in SQL Server 2012, SQL Server 2014 and SQL Server 2016

SessionID: 39744

Are You Optimistic About Concurrency?

Back to calendar

Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kalen Delaney

Title: Are You Optimistic About Concurrency?

Abstract:

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic? How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency?

In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!

SessionID: 40110

Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance

Back to calendar

Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick O'Keeffe

Title: Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance

Abstract:

We're all told to watch our weight and to exercise more. Join Dell Software experts who will show you painless exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastries not provided).

In this session, you will learn all about SQL Server’s wait statistics; statistics that the database engine stores about the resources it is waiting on. Armed with this information, SQL Server professionals like you can make better informed decisions on which areas of your environment to tune to ensure greater impact on performance. Join this session to discover where to find, interpret, and use this information to tie down problem areas in your SQL Server environment. This won't be only be about how to fix that problem query, but we'll also talk about how to improve overall performance for all your users.

SessionID: 40144

Incremental Load Design Patterns

Back to calendar

Event Date: 03-10-2015 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Tim Mitchell

Title: Incremental Load Design Patterns

Abstract:

The volume of data addressed by the typical ETL operation is constantly on the rise. Not so many years ago, a table with a few million records was considered to be huge. These days, it's not uncommon to deal with multibillion row tables. As a result, ETL professionals are frequently tasked with finding efficient ways to incrementally process these large sets of data without resorting to expensive and time-consuming destructive reloads.

In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing. Among the topics of discussion: --Deciding whether an incremental load is appropriate --Pick your tool: T-SQL or SSIS? --Methods for detecting new and changed records --Common incremental load design patterns

SessionID: 38064

SQL Server Security Basics

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kenneth Fisher

Title: SQL Server Security Basics

Abstract:

In the modern age, data is a company's most valuable resource and, unfortunately, data crimes are common. Because of this, everyone that works with SQL Server should have a basic understanding of database security. Attend this session to learn the what, how, and why of database security. Learn what permissions, securables, and principals are. Learn how to manage database security. Most importantly, learn what the best practices are and why they are important. Your company's data is your responsibility, and after attending this session you can step up and keep it safe.

SessionID: 38733

Everything you Want to know about Power BI Dependency on O365

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Adam Saxton

Title: Everything you Want to know about Power BI Dependency on O365

Abstract:

For most users, you will sign up to use Power BI and never know that Office 365 is the background. For organizations that want to leverage the advanced features of Power BI, you MAY need to perform certain configurations within Office 365. Since most people do not realize that Office 365 is used under hood of Power BI, we will show you how to properly prepare your organization for the new Power BI service. In this demo heavy session we will dispel the myth that you may not need Office 365 to access the full capabilities Power BI.

SessionID: 39707

How Active Directory affects SQL Server

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ryan Adams

Title: How Active Directory affects SQL Server

Abstract:

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session. SQL Server has a large surface area and Active Directory can influence a big part of it. I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.

SessionID: 40154

Beginning Automation with Powershell

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Beginning Automation with Powershell

Abstract:

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.

SessionID: 40486

Modern Data Strategy

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Strategy and Architecture

Speaker: Sri Sridharan

Title: Modern Data Strategy

Abstract:

SessionID: 41121

What’s that up in the cloud?! It’s the Azure SQL DB in all its new glory!

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Kal Yella

Title: What’s that up in the cloud?! It’s the Azure SQL DB in all its new glory!

Abstract:

Azure SQL Database is great relational database platform in the cloud for developing, deploying, and managing data tier in a wide range of cloud applications. In this session we are going to introduce you to Azure SQL Database and its new incarnation, the V12 release and all its new features that helped minimize the gap between Azure and on-premises database environments.

The topics include new features in Azure V12 database; Elastic Database Pools, Enhanced Disaster Recovery features, Transparent Database Encryption, expanded T-SQL Surface Area to name a few. This session is going to be demo rich and is one session that you don’t want to miss if you are looking to learn more about Azure SQL Databases.

SessionID: 37241

SS2014 In-Memory Tables: Formula 1 Performance Unleashed!

Back to calendar

Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Byrd

Title: SS2014 In-Memory Tables: Formula 1 Performance Unleashed!

Abstract:

Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.

This session is all about when and how to apply in-memory tables in a production environment. After this session you will

  1. Understand what in-memory tables are and how to create and maintain them including their limitations
  2. Be able to identify performance gains over equivalent disk back tables
  3. Comprehend the new data monitoring needed for in-memory table

SessionID: 39075

Is AlwaysOn really as powerful? Tips and Tricks from the field

Back to calendar

Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Reinaldo Kibel

Title: Is AlwaysOn really as powerful? Tips and Tricks from the field

Abstract:

CIOs and VPs everywhere are asking me, how do we achieve HA with SQL Server? Having architected and implemented over 100 architectures, see how to architect, design, setup, deploy, tons of gotchas and best practices from real production deployments

With the introduction of AlwaysOn and the deprecation of Database Mirroring, Windows Clustering Services is now more critical than ever. If you have moved away from clustering or implemented database mirroring as an alternative to clustering and found it lacking AlwaysOn is the way forward for you. This talk will demonstrate a complete end-to-end solution using Windows Server Failover Clustering, AlwaysOn, SQL Server 2012 Enterprise edition, and Active Directory.

SessionID: 39833

The "Data Loading Performance Guide" Presentation

Back to calendar

Event Date: 03-10-2015 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Ryan Casey

Title: The "Data Loading Performance Guide" Presentation

Abstract:

Loading huge amounts of data into SQL Server can be challenging. There are quite a few factors that can help, or hurt your goal for tuned performance. For this reason, bulk loading with large amounts of data requires a strategy.

For that strategy, Microsoft has published a famous whitepaper called “The Data Loading Performance Guide.” The problem is that this guide is long and full of small details that can be confusing and daunting at first glance.

In this session, we will turn this whitepaper into a presentation about creating a strategy to optimize your massive data loading processes by applying the techniques mentioned in the whitepaper, as well as other advanced techniques that have emerged since the whitepaper was published.

We will talk about solutions to achieve High Performance Data Loading, Minimal Logging and Bulk Loading, Indexing Techniques including Columstore, properly leveraging Parallelism and Partitioning, Truncate Partition, PolyBase, Delayed Durability, and more.

SessionID: 40352

Fast and Furious: Discovering Windowing Function

Back to calendar

Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Ahias Portillo

Title: Fast and Furious: Discovering Windowing Function

Abstract:

The Windowing Functions are advanced SQL Server commands, existing since 2005, but many database developers forget to use them. In this session we will discuss about how they work, how we should use them and how we can combine them with other development techniques as the use of CTE, procedures, functions, etc.

SessionID: 41123

High Availability Solutions with Enhanced SQL Server 2016 Always ON

Back to calendar

Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Andre Hass

Title: High Availability Solutions with Enhanced SQL Server 2016 Always ON

Abstract:

SQL Server 2016 Always ON Availability Group delivers even Higher Availability for Mission Critical workloads. If you are interested in learning what is new in SQL Server 2016 Always ON Availability Groups, come to see this session where we will cover Always ON Availability Groups in details and present scenarios how it can be used as a solution for High Availability, Disaster Recovery and offload read-only workloads to secondary replicas using on premises or cloud based servers on a hybrid cloud scenario.

SQL Server 2016 Always ON Availability Group newest features will provide even Higher Available Database Server for Mission critical workloads required by most businesses today.

SessionID: 41125

SSIS Monitoring Framework

Back to calendar

Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Other

Speaker: mahesh pujari

Title: SSIS Monitoring Framework

Abstract:

Most Organizations use SSIS as the ETL tool of choice for Data movement. These ETL processes can vary from simple to extremely complex processes. Data from these processes can be consumed by a Data warehouse, various other internal systems or for reporting.

Monitoring these ETL processes from a centralized location can be complicated, and many times performance issues only become apparent when the process fails or continues to keep running abnormally. We shall talk about a framework to proactively monitor SSIS ETL processes for reporting and analysis and to examine performance trends of SSIS packages across servers over time.

This session will discuss the SSIS Monitoring framework and demonstrate a few visualizations to show a performance analysis of ETL processes with minimal effort.

This site is open source. Improve this page.