Nr: 517
SQLSaturday #517 - Philadelphia 2016
SessionID: 45115
3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
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
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: DBA
Speaker: Steve Hood
Title: Buffer Pool Memory Management
Abstract:
SessionID: 45135
Optimizing SQL Server and Databases for large Fact Tables
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
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
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
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: Professional Development
Speaker: Robert Pearl
Title: Social DBA
Abstract:
SessionID: 50500
Security Investments in SQL Server 2016 Azure SQL Database Service
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
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:
SessionID: 46991
Who's Pissing in Your Data Lake?
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
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
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
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
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…
- if you are struggling to find enough new clients,
- if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you,
- if you feel like you are treading water when it comes to marketing.
Join this session and get started on your way to becoming a Phenomenal IT Consultant.
SessionID: 45146
Successfully Virtualizing SQL Server on vSphere - Straight from t
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
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:
SessionID: 47453
Dealing With Difficult Co-Workers
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?
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!
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"
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
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
Event Date: 04-06-2016 - Session time: 11:00:00 - Track: Strategy and Architecture
Speaker: Niran Even-Chen
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
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:
SessionID: 50931
Optimizing SQL Server on VMWare
Event Date: 04-06-2016 - Session time: 12:30:00 - Track: DBA
Speaker: Joseph D'Antoni
Title: Optimizing SQL Server on VMWare
Abstract:
SessionID: 51166
Event Date: 04-06-2016 - Session time: 12:30:00 - Track: Azure/Misc
Speaker: Joseph D'Antoni
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
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!
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
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:
• 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?
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
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
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
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
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
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:
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
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
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
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
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
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:
SessionID: 49287
But it worked great in Dev! Perfomance for Devs
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
Event Date: 04-06-2016 - Session time: 16:00:00 - Track: Business Intelligence
Speaker: Daniel Bowlin
Title: SSIS Optimization techniques
Abstract:
SessionID: 49432
In-Memory Technology in SQL 2016 (Columnstore Indexes and In-Memory Tables)
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:
SessionID: 49628
New Engine Features in SQL Server 2016
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#)
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.