sqlsathistory

Nr: 517

Back to Main list

SQLSaturday #517 - Philadelphia 2016

Start Time (24h) Speaker Track Title
08:30:00 David Patrick Development 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
08:30:00 Steve Hood DBA Buffer Pool Memory Management
08:30:00 Thomas Grohser DBA Optimizing SQL Server and Databases for large Fact Tables
08:30:00 Greg Moore Strategy and Architecture Tips that have saved my bacon
08:30:00 Tamera Clark SQL Server 2016 Microsoft Business Intelligence 2016 – More Love for Your Data
08:30:00 Robert Pearl Professional Development Social DBA
08:30:00 Bill Emmert SQL Server 2016 Security Investments in SQL Server 2016 Azure SQL Database Service
09:45:00 James Serra Business Intelligence Big data architectures and the data lake
09:45:00 Karen Lopez Development Who's Pissing in Your Data Lake?
09:45:00 Wayne Sheffield Development Crazy Things Developers Do
09:45:00 Carlos L Chacon Azure/Misc Disaster Recovery Options with Azure
09:45:00 Allan Hirt DBA Deploy Highly Available SQL Server for Virtualization the Cloud
09:45:00 Sebastian Meine Professional Development The Phenomenal IT Consultant
11:00:00 Deji Akomolafe DBA Successfully Virtualizing SQL Server on vSphere - Straight from t
11:00:00 Dan Clark Azure/Misc Azure Machine Learning – Bringing Advanced Analytics to the Masses
11:00:00 Gigi Bell Professional Development Dealing With Difficult Co-Workers
11:00:00 Jim Donahoe DBA New Instance, Now what?
11:00:00 Wayne Sheffield Development Table Vars and Temp Tables – What you NEED to Know!
11:00:00 Adam Machanic SQL Server 2016 SQL Server 2016 "Hidden Gems"
11:00:00 Mark Wojciechowicz Business Intelligence Extending PowerBI
11:00:00 Niran Even-Chen Strategy and Architecture Architecting virtual SQL server for performance
12:30:00 Vince Napoli BI Information Delivery Row Level Security in the BI Environment
12:30:00 Joseph D'Antoni DBA Optimizing SQL Server on VMWare
12:30:00 Joseph D'Antoni Azure/Misc MVP Systems Software--Jams Tool
13:30:00 William Wolf Development Common Coding Mistakes and How to Mitigate them
13:30:00 Kevin Howell DBA Always-On Availability Groups: Replicas, Listeners Quorums, Oh My!
13:30:00 Sharon Dooley SQL Server 2016 The New SQL Server 2016 Query Store
13:30:00 Slava Murygin Professional Development SQL Professional: How to get a new job?
13:30:00 Ayman El-Ghazali SQL Server 2016 PolyBase: I now pronounce you SQL and Hadoop
13:30:00 Denny Cherry DBA Table Indexing for the .NET Developer
14:45:00 Andy Mallon DBA Demystifying Data Compression
14:45:00 Justin Dearing SQL Server 2016 An Introduction to Always Encrypted
14:45:00 Chris Bell Business Intelligence Would You Just Load Already?! Maximizing Your SSIS Data Load
14:45:00 Denis McDowell Development DevOps Is Coming to an Enterprise near You
14:45:00 Ray Kim Professional Development Disaster Documents: The role of documentation in disaster recovery
14:45:00 Andy Galbraith DBA Getting Started with Extended Events
16:00:00 Robert Davis Business Intelligence 10 Things Administrators of BI Systems Should Know
16:00:00 Alex Grinberg DBA DMVs and system objects that every DBA should know
16:00:00 Randy Knight Development But it worked great in Dev! Perfomance for Devs
16:00:00 Daniel Bowlin Business Intelligence SSIS Optimization techniques
16:00:00 Kevin Goff SQL Server 2016 In-Memory Technology in SQL 2016 (Columnstore Indexes and In-Memory Tables)
16:00:00 Kerry Tyler SQL Server 2016 New Engine Features in SQL Server 2016
16:00:00 Dominic Falso Development Parsing T-SQL using the TransactSql.ScriptDom library (C#)

SessionID: 45115

3 Ways for Getting Data from SharePoint : SSIS, Excel and Access

Back to calendar

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

Speaker: David Patrick

Title: 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access

Abstract:

Need to report on some data from SharePoint? We'll look at three different techniques to pull data from a SharePoint Server. We'll start with SSIS and the SharePoint List Source and Destinations. Next, we'll use Excel to connect to various SharePoint lists (both online and on premise), and finally we'll use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, we'll have three different ways to get data from SharePoint.

SessionID: 45124

Buffer Pool Memory Management

Back to calendar

Event Date: 04-06-2016 - Session time: 08:30:00 - Track: DBA

Speaker: Steve Hood

Title: Buffer Pool Memory Management

Abstract:

Understand what's in memory, why it's there, and how to reduce the footprint if that's reasonable. Find your large queries with several techniques, justify them, and tune them. Find indexes to drop, consolidate, or create. Finally, purge your data, because even our accounts hire pyromaniacs with scissors!

SessionID: 45135

Optimizing SQL Server and Databases for large Fact Tables

Back to calendar

Event Date: 04-06-2016 - Session time: 08:30:00 - Track: DBA

Speaker: Thomas Grohser

Title: Optimizing SQL Server and Databases for large Fact Tables

Abstract:

A session full of demos demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster.

We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.

SessionID: 45192

Tips that have saved my bacon

Back to calendar

Event Date: 04-06-2016 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Greg Moore

Title: Tips that have saved my bacon

Abstract:

In this session, I propose to share some of the tricks I've used on the operational side of being a DBA.

There's saying, never perform small miracles, people to rely on them, but isn't it useful to have a few in your back-pocket.

Everyone knows log-shipping is great for DR recovery, but what about using it for minor issues, like a delete or update gone bad? Want to move a large table someplace else (like that "oh it'll just be a small audit table, it won't grow large because we'll write the functionality later to keep it small" and they never do? UNC backups... an often overlooked but useful option for making a backup AND getting it off your server. Run a small operation where too many fingers have access to the operational DB and you want to catch them? These are some of the tricks I've picked up over the years and used more than once to perform small miracles and have saved my bacon or the bacon of others

SessionID: 46782

Microsoft Business Intelligence 2016 – More Love for Your Data

Back to calendar

Event Date: 04-06-2016 - Session time: 08:30:00 - Track: SQL Server 2016

Speaker: Tamera Clark

Title: Microsoft Business Intelligence 2016 – More Love for Your Data

Abstract:

Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again.

SessionID: 48791

Social DBA

Back to calendar

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

Speaker: Robert Pearl

Title: Social DBA

Abstract:

What is a socal DBA? It's a DBA that uses social media to excel in his or her DBA career! Social media includes, but not limited to Twitter, LinkedIn, Google, SQL Server forums,community sites, and more! By using various aspects of social media to one's advantage, you can become a DBA star. Whether you're an accidental, junior or senior DBA, if you're not using social media, then you're missing out on the vast array of resources at your fingertips. Can't solve a problem, or issue? Before you call Microsoft Support, come to my session, and I will provide a ton of useful tips on how to get the answers immediately! This session is a Database Professional Development track to boost your ability to get answers when you need them!

SessionID: 50500

Security Investments in SQL Server 2016 Azure SQL Database Service

Back to calendar

Event Date: 04-06-2016 - Session time: 08:30:00 - Track: SQL Server 2016

Speaker: Bill Emmert

Title: Security Investments in SQL Server 2016 Azure SQL Database Service

Abstract:

Session Objective(s):

Get a closer look at the latest investments Microsoft is making in security across the SQL Platform Gain an understanding for how these features can be used to keep data secure and compliant Key Takeaways: Microsoft is focused on delivering industry-leading, differentiated, and ambitious security features that integrate with the latest technologies including Azure Active Directory, Stretch Database, and Hekaton The SQL Platform provides a secure and trusted platform for all database applications

SessionID: 45393

Big data architectures and the data lake

Back to calendar

Event Date: 04-06-2016 - Session time: 09:45:00 - Track: Business Intelligence

Speaker: James Serra

Title: Big data architectures and the data lake

Abstract:

With so many new technologies it can get confusing on the best approach to building a big data architecture. The data lake is a great new concept, usually built in Hadoop, but what exactly is it and how does it fit in? In this presentation I’ll discuss the four most common patterns in big data production implementations, the top-down vs bottoms-up approach to analytics, and how you can use a data lake and a RDBMS data warehouse together. We will go into detail on the characteristics of a data lake and its benefits, and how you still need to perform the same data governance tasks in a data lake as you do in a data warehouse. Come to this presentation to make sure your data lake does not turn into a data swamp!

SessionID: 46991

Who's Pissing in Your Data Lake?

Back to calendar

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

Speaker: Karen Lopez

Title: Who's Pissing in Your Data Lake?

Abstract:

The new data terms of Data Lake, Data Reservoir, and Data Swamp have left me with more questions than answers. In this presentation, Karen discusses the types of data anomalies that organizations can run into when they use external data, the wrong datasets for the right reasons and the right datasets for the wrong reasons.

SessionID: 48643

Crazy Things Developers Do

Back to calendar

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

Speaker: Wayne Sheffield

Title: Crazy Things Developers Do

Abstract:

Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn about SQL Injection attacks and how SQL can use Referential Integrity to optimze queries. Trust me... your DBA will love you for making these changes.

SessionID: 48838

Disaster Recovery Options with Azure

Back to calendar

Event Date: 04-06-2016 - Session time: 09:45:00 - Track: Azure/Misc

Speaker: Carlos L Chacon

Title: Disaster Recovery Options with Azure

Abstract:

Recovery in the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recover in Azure.

SessionID: 49349

Deploy Highly Available SQL Server for Virtualization the Cloud

Back to calendar

Event Date: 04-06-2016 - Session time: 09:45:00 - Track: DBA

Speaker: Allan Hirt

Title: Deploy Highly Available SQL Server for Virtualization the Cloud

Abstract:

While most of us still have some physical, on premises deployments of SQL Server, many of us are moving towards, or already have started deploying SQL Server instances and databases en masse either in virtual machines or in the public cloud. This session will discuss how you should approach availability in this new paradigm when things are both similar to the way we used to do things, but in other ways completely different. You will learn best practices for clustering SQL Server (both FCIs and AGs), how to think about quorum, and more.

SessionID: 49454

The Phenomenal IT Consultant

Back to calendar

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

Speaker: Sebastian Meine

Title: The Phenomenal IT Consultant

Abstract:

Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone.

In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you…

SessionID: 45146

Successfully Virtualizing SQL Server on vSphere - Straight from t

Back to calendar

Event Date: 04-06-2016 - Session time: 11:00:00 - Track: DBA

Speaker: Deji Akomolafe

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

Abstract:

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

SessionID: 45185

Azure Machine Learning – Bringing Advanced Analytics to the Masses

Back to calendar

Event Date: 04-06-2016 - Session time: 11:00:00 - Track: Azure/Misc

Speaker: Dan Clark

Title: Azure Machine Learning – Bringing Advanced Analytics to the Masses

Abstract:

While Machine Learning is not new, it has never been easy to implement. Azure Machine Learning (AML) aims to provide a set of tools that are easier to use and once a model is created easier to consume by client applications. At the core of AML is ML Studio. ML Studio provides an easy to use graphical tool that allows you to control the process from pre-processing the data, to applying learning algorithms, testing the model, and finally deploying the model for use by client applications. This session guides you through the process of creating and deploying a ML model. In addition it will demonstrate how client applications can easily use the model once it is deployed.

SessionID: 47453

Dealing With Difficult Co-Workers

Back to calendar

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

Speaker: Gigi Bell

Title: Dealing With Difficult Co-Workers

Abstract:

Having problems at work dealing with difficult co-workers and end-users? Are these difficult people stressing you out and making you dislike your job? Learn two golden rules to live by that can help ease this stress!

Through case studies and open discussion, we will help you determine how (and if) you should deal with these difficult people. We will identify and categorize different types of behaviors that your co-workers exhibit so that you can effectively deal with them. Mastering these skills can lead to future success and team management.

SessionID: 48425

New Instance, Now what?

Back to calendar

Event Date: 04-06-2016 - Session time: 11:00:00 - Track: DBA

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

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

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

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

SessionID: 48646

Table Vars and Temp Tables – What you NEED to Know!

Back to calendar

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

Speaker: Wayne Sheffield

Title: Table Vars and Temp Tables – What you NEED to Know!

Abstract:

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"

SessionID: 49623

SQL Server 2016 "Hidden Gems"

Back to calendar

Event Date: 04-06-2016 - Session time: 11:00:00 - Track: SQL Server 2016

Speaker: Adam Machanic

Title: SQL Server 2016 "Hidden Gems"

Abstract:

By far the most important SQL Server release since the heady days of 2005, SQL Server 2016 represents a huge leap forward in a number of key areas. You've no doubt heard plenty about such features as Query Store, JSON support, Polybase, and the other big-ticket items. But there are also a number of very cool features that don't usually make the top 10 lists. In this talk you'll learn about enhancements to indexing (including both Columnstore and traditional b-tree indexes), DMVs, compression, string handling, encryption, configuration, and even timezone support. These smaller features may not be highlighted in the latest glossy ads from Microsoft's marketing department, but they're the kinds of things that add up to make your life easier. Attend this session to learn all sorts of new and different reasons to upgrade as quickly as possible.

SessionID: 49924

Extending PowerBI

Back to calendar

Event Date: 04-06-2016 - Session time: 11:00:00 - Track: Business Intelligence

Speaker: Mark Wojciechowicz

Title: Extending PowerBI

Abstract:

This will be a Co-presentation with Ed Bunt and Mark Wojciechowicz.

With PowerBI, we can easily create intuitive reports and dashboards. This highly customizable environment can be extended in many ways, even outside its own environment. In this session, we will look at how to create a custom visual, how to embed PowerBI in a custom application, how to integrate PowerBI with Cortana in windows 10, and, if we can think of anything else before June, we’ll do that too.

SessionID: 50106

Architecting virtual SQL server for performance

Back to calendar

Event Date: 04-06-2016 - Session time: 11:00:00 - Track: Strategy and Architecture

Speaker: Niran Even-Chen

Title: Architecting virtual SQL server for performance

Abstract:

Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications.

Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the author of the official SQL server on VMware best practices guide.

SessionID: 50792

Row Level Security in the BI Environment

Back to calendar

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

Speaker: Vince Napoli

Title: Row Level Security in the BI Environment

Abstract:

Implementing Row Level Security in SQL Server, and also even Cell level security in SSAS, to mask data from other users is a common request and a component in your security and data access model for a data warehouse and BI environment. Information is valuable, but will be a double edge sword if not protected, and should only made visible to only those that should receive it. In this session, we describe the design considerations, highlight multiple scenarios for querying and reporting, and demonstrate how to apply Row Level Security in both pre-SQL 2016, and implementing it using the new Row Level Security feature in SQL 2016. We will also touch on briefly cell level security in SSAS.

SessionID: 50931

Optimizing SQL Server on VMWare

Back to calendar

Event Date: 04-06-2016 - Session time: 12:30:00 - Track: DBA

Speaker: Joseph D'Antoni

Title: Optimizing SQL Server on VMWare

Abstract:

In this session you will learn about best practices for running SQL Server on VMWare from two VMWare vExperts who have a combined 20 years of experience with SQL Server and virtualization. You will learn about things like file systems, optimal storage drivers and configuration to make your virtual servers perform at their best.

SessionID: 51166

MVP Systems Software--Jams Tool

Back to calendar

Event Date: 04-06-2016 - Session time: 12:30:00 - Track: Azure/Misc

Speaker: Joseph D'Antoni

Title: MVP Systems Software--Jams Tool

Abstract:

A look at the advantages of leveraging an enterprise job scheduler instead of SQL Agent. We’ll take a closer look at the added features available with a scheduler and how we can use them to tie our SQL jobs to processes outside of the SQL environment.

SessionID: 45838

Common Coding Mistakes and How to Mitigate them

Back to calendar

Event Date: 04-06-2016 - Session time: 13:30:00 - Track: Development

Speaker: William Wolf

Title: Common Coding Mistakes and How to Mitigate them

Abstract:

Let the Big Bad Wolf huff, puff and blow your bad queries away.

There are several programming design patterns that work great in object oriented code that do not scale well inside of SQL Server.

In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.

After this session, you can go back to your office Monday morning and be the code tuning rock star!

SessionID: 47056

Always-On Availability Groups: Replicas, Listeners Quorums, Oh My!

Back to calendar

Event Date: 04-06-2016 - Session time: 13:30:00 - Track: DBA

Speaker: Kevin Howell

Title: Always-On Availability Groups: Replicas, Listeners Quorums, Oh My!

Abstract:

Would you like to leverage the advantages of an Availability Group within your Enterprise environment to provide high availability and disaster recovery? This discussion will cover different scenarios where an Availability Group could (and should) be implemented, along with a full demonstration of the setup of an Availability Group. We will explore the concepts that are critical to a successful AG deployment and look at the evolution of Availability Groups from SQL 2012 through 2016.

SessionID: 49192

The New SQL Server 2016 Query Store

Back to calendar

Event Date: 04-06-2016 - Session time: 13:30:00 - Track: SQL Server 2016

Speaker: Sharon Dooley

Title: The New SQL Server 2016 Query Store

Abstract:

The query store is a new feature in SQL Server 2016 that gives you extensive performance monitoring and auditing capabilities. In this presentation you will learn

• Use cases for the query store • How to enable the query store • How to extract information from the query store • Best practices for taking advantage of the query store This presentation assumes a knowledge of database performance tuning, query plans and Transact-SQL.

SessionID: 49354

SQL Professional: How to get a new job?

Back to calendar

Event Date: 04-06-2016 - Session time: 13:30:00 - Track: Professional Development

Speaker: Slava Murygin

Title: SQL Professional: How to get a new job?

Abstract:

Do you have an Automobile insurance?

Do you have a Medical insurance? Do you have a Life insurance? Do you have a Job insurance? Would you like to have one? On that session we will be talking about a situation when you have to search for a new job. You have to be always ready for it and I will show you how.

SessionID: 49380

PolyBase: I now pronounce you SQL and Hadoop

Back to calendar

Event Date: 04-06-2016 - Session time: 13:30:00 - Track: SQL Server 2016

Speaker: Ayman El-Ghazali

Title: PolyBase: I now pronounce you SQL and Hadoop

Abstract:

If you thought the Royal wedding of 2011 was a big deal, then you're about to be blown away! This is a match made in Data Heaven. You're all invited, no need to RSVP, there is plenty of food for thought in this session. There will be some background talk and a demo for querying and creating data on HDFS (using Azure Blobs). As a special gift to the happy couple, we will also have a special demo with JSON documents. This will be the greatest coming together of 2016! See you there!

SessionID: 49627

Table Indexing for the .NET Developer

Back to calendar

Event Date: 04-06-2016 - Session time: 13:30:00 - Track: DBA

Speaker: Denny Cherry

Title: Table Indexing for the .NET Developer

Abstract:

In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best.

SessionID: 45678

Demystifying Data Compression

Back to calendar

Event Date: 04-06-2016 - Session time: 14:45:00 - Track: DBA

Speaker: Andy Mallon

Title: Demystifying Data Compression

Abstract:

High-end storage is expensive, and SQL Server data compression can make your database smaller. So compress all the tables! No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of when compression is the right solution, as well as what type of compression to use.

SessionID: 46831

An Introduction to Always Encrypted

Back to calendar

Event Date: 04-06-2016 - Session time: 14:45:00 - Track: SQL Server 2016

Speaker: Justin Dearing

Title: An Introduction to Always Encrypted

Abstract:

This will be an introduction to the new SQL Server 2016 Always Encryption feature. Unlike Transparent Data Encryption Always Encrypted provides encryption in transit as well as encryption at rest. This will be a survey overview of both the operations and development side of Always Encrypted, but will be mainly operations focused. Considerations for porting existing databases to Always Encrypted will also be discussed.

SessionID: 47351

Would You Just Load Already?! Maximizing Your SSIS Data Load

Back to calendar

Event Date: 04-06-2016 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Chris Bell

Title: Would You Just Load Already?! Maximizing Your SSIS Data Load

Abstract:

Loading data via SSIS is great! It’s fast too! Until you hit a bad record. Then things aren’t so great. Now you probably have to waste time dumping and reloading all the data, or worst figure out where the bad record is and try a partial load.

In this session you will learn a simple method to load data via SSIS and identify, remove, and record those bad records allowing you to maximize the amount of data loaded while ensuring data integrity.

SessionID: 48127

DevOps Is Coming to an Enterprise near You

Back to calendar

Event Date: 04-06-2016 - Session time: 14:45:00 - Track: Development

Speaker: Denis McDowell

Title: DevOps Is Coming to an Enterprise near You

Abstract:

Companies are creating more and more technology service offerings, but they are often throttled by IT. To address this, many IT departments are adapting a new concept called DevOps. DevOps is a concept that has risen quickly from niche to mainstream within the IT enterprise. At its core, DevOps represents a way to leverage people, processes, and tools to remove barriers and improve service delivery. An understanding of scripting and automation platforms is becoming a critical skill for SQL Server professionals. This session discusses how technologies such as virtualization, the cloud, and software-defined datacenters have blurred the lines between developers and sysdmins. We also talk about the competencies and tools required to succeed in an increasingly data-driven workplace.

SessionID: 48592

Disaster Documents: The role of documentation in disaster recovery

Back to calendar

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

Speaker: Ray Kim

Title: Disaster Documents: The role of documentation in disaster recovery

Abstract:

I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001. Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery. In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself. We will discuss the documents we had and how they were used in our recovery. We will also discuss what documents we didn't have, and how they could have made the process better.

SessionID: 49023

Getting Started with Extended Events

Back to calendar

Event Date: 04-06-2016 - Session time: 14:45:00 - Track: DBA

Speaker: Andy Galbraith

Title: Getting Started with Extended Events

Abstract:

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!

SessionID: 45556

10 Things Administrators of BI Systems Should Know

Back to calendar

Event Date: 04-06-2016 - Session time: 16:00:00 - Track: Business Intelligence

Speaker: Robert Davis

Title: 10 Things Administrators of BI Systems Should Know

Abstract:

Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administrer BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator?

Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.

SessionID: 46379

DMVs and system objects that every DBA should know

Back to calendar

Event Date: 04-06-2016 - Session time: 16:00:00 - Track: DBA

Speaker: Alex Grinberg

Title: DMVs and system objects that every DBA should know

Abstract:

This session will cover monitoring, performance tuning, trouble shooting, generating SQL scripts, and many other daily activities and tasks for the DBA position. In the lecture "DMVs and system objects that every DBA should know", a session presenter will demonstrate the Dynamic Management Object and system tables that help DBAs simplify their role. The presenter will also go into details regarding returned result values and demonstrate examples using real-case scenarios.

SessionID: 49287

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 04-06-2016 - Session time: 16:00:00 - Track: 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: 49391

SSIS Optimization techniques

Back to calendar

Event Date: 04-06-2016 - Session time: 16:00:00 - Track: Business Intelligence

Speaker: Daniel Bowlin

Title: SSIS Optimization techniques

Abstract:

There are number of things you can do to optimize SSIS packages to improve overall performance and shorten load times. This session will review 3 areas: common mistakes developers make, settings and tweaks, and design pattern improvements. Some of the things you will see can make dramatic improvements in speed, while others are for those seeking to pull every last bit of performance out of your packages.

SessionID: 49432

In-Memory Technology in SQL 2016 (Columnstore Indexes and In-Memory Tables)

Back to calendar

Event Date: 04-06-2016 - Session time: 16:00:00 - Track: SQL Server 2016

Speaker: Kevin Goff

Title: In-Memory Technology in SQL 2016 (Columnstore Indexes and In-Memory Tables)

Abstract:

Some presentations cover the columnstore index and some cover in-memory optimized tables. In this presentation, I'll cover both! I'll demonstrate some actual examples of data warehouse, BI, and OLTP applications where the columnstore index and in-memory optimized tables in SQL 2016 can yield tremendous performance enhancements.

SessionID: 49628

New Engine Features in SQL Server 2016

Back to calendar

Event Date: 04-06-2016 - Session time: 16:00:00 - Track: SQL Server 2016

Speaker: Kerry Tyler

Title: New Engine Features in SQL Server 2016

Abstract:

SQL Server 2016 brings with it a flood of new capabilities over previous versions. Between improved functionality in existing components and outright new functionality, nearly every part of the product has received attention in this release. This session will focus on the new and improved Engine features in 2016. Whether you have Standard Edition deployed or utilize every last feature available in Enterprise, there are new items to explore and contemplate in SQL Server's latest and greatest.

SessionID: 50930

Parsing T-SQL using the TransactSql.ScriptDom library (C#)

Back to calendar

Event Date: 04-06-2016 - Session time: 16:00:00 - Track: Development

Speaker: Dominic Falso

Title: Parsing T-SQL using the TransactSql.ScriptDom library (C#)

Abstract:

T-SQL is a very complicated language to parse, so it can be intimidating to get started. We'll go over basic concepts of what a lexer/parser is and what to expect from it. Then, using the TransactSql.ScriptDom library in the SQL Server SDK, we'll do some examples to get our feet wet.