sqlsathistory

Nr: 489

Back to Main list

SQLSaturday #489 - Tampa 2016

Start Time (24h)	Speaker	Track	Title
07:30:00	Pam Shaw	Other	Registration
08:30:00	Pam Shaw	Other	Welcome
09:00:00	Ronald Dameron	Cloud Application Development Deployment	Monitoring and Alerting for an Azure PaaS Application
09:00:00	Neil Pepi	Application Database Development	Solving Real Business Problems Step by Step
09:00:00	Kendal Van Dyke	Enterprise Database Administration Deployment	SQL Server Disaster Recovery and High Availability Overview
09:00:00	Dan King	BI Platform Architecture, Development Administration	Fast Track that Cube Please
09:00:00	Jorge Novo	BI Information Delivery	Parent, Child development Using SSIS Framework
09:00:00	Erica Woods	Professional Development	Conducting an Effective Job Search
09:00:00	Sean McCown	Enterprise Database Administration Deployment	Monster Text Manipulation: Regular Expressions for the DBA
10:00:00	Pam Shaw	Other	Break
10:15:00	Michael Antonovich	BI Information Delivery	So What is Power BI?
10:15:00	Rushabh Mehta	BI Platform Architecture, Development Administration	Mastering and Enhancing Company Data
10:15:00	Janis Griffin	Enterprise Database Administration Deployment	Top 10 Wait Types Everyone Should Know
10:15:00	Mark Kromer	Cloud Application Development Deployment	NoSQL Solutions in the Cloud with Microsoft Azure
10:15:00	John Wang	Analytics and Visualization	Introduction to Fog Analytics
10:15:00	Dmitri Korotkevitch	Strategy and Architecture	Data Partitioning for Database Architects and Mere Mortals
10:15:00	Bradley Ball	Enterprise Database Administration Deployment	Inside the Query Optimizer
10:15:00	Daniel Taylor	Enterprise Database Administration Deployment	Back Up and Restore? Piece of Cake!
11:30:00	Louis Davidson	Application Database Development	Database Design Fundamentals
11:30:00	Andy Warren	Enterprise Database Administration Deployment	Automating Database Restores
11:30:00	Matt Martin	Advanced Analysis Techniques	Windowed Functions - Harness the Power to Forecast with Ease!
11:30:00	Karlyn LeBlanc	Professional Development	Whip Away Stress at Home Work to Create a Better You
11:30:00	miguel Cebollero	BI Platform Architecture, Development Administration	Data Quality Services - Integrating your Data Steward
11:30:00	Mike Byrd	Application Database Development	Indexes: Help or Hinder!
11:30:00	Carlos Colon	Enterprise Database Administration Deployment	Planning and Executing a Successful SQL Server Database Migration
12:30:00	Sayed Saeed	BI Platform Architecture, Development Administration	The Business Intelligence Side of SQL Server
12:30:00	Pam Shaw	Advanced Analysis Techniques	Lunch Break
12:30:00	Bryan Walsh	Enterprise Database Administration Deployment	Transform SQL Server Agility with XtremIO
13:45:00	Kevin Feasel	BI Platform Architecture, Development Administration	Data Migration Using BIML
13:45:00	Arvin Meyer	Professional Development	Intelligent Indexing
13:45:00	Michael Keleher	Enterprise Database Administration Deployment	Building Defense in Depth Using the Full Spectrum of SQL Server Encryption
13:45:00	Grant Fritchey	Application Database Development	Execution Plans: What Can You Do With Them?
13:45:00	Herve Roggero	Enterprise Database Administration Deployment	Managing Multiple SQL Servers Using SSMS
13:45:00	Jennifer McCown	Application Database Development	Designing Stored Procedure Solutions
13:45:00	Luis Figueroa	Information Delivery	A closer look to Azure Data Factory
15:00:00	Troy Gallant	Enterprise Database Administration Deployment	Indexing your Data Warehouse
15:00:00	Bryan Cafferky	Application Database Development	SSIS 2012/2014: The Quiet Revolution
15:00:00	Ronald Dameron	Enterprise Database Administration Deployment	SQL Server Lockdown in Six Steps
15:00:00	Gus Gwynne	Application Database Development	XML in SQL
15:00:00	Patrick LeBlanc	BI Information Delivery	What's New in SSRS 2016
15:00:00	miguel Cebollero	Strategy and Architecture	Datawarehouse Development in an Agile World
15:00:00	Jeff Taylor	Application Database Development	What'S New In SQL Server 2012/2014/2016 For The Developer
16:15:00	Kevin Feasel	Application Database Development	Peanut Butter Chocolate: Integrating Hadoop with SQL Server
16:15:00	Grant Fritchey	Application Database Development	Automating Your Database Deployments
16:15:00	Shawn Meyers	Enterprise Database Administration Deployment	Availability Groups: Monitoring and Alerting
16:15:00	Jemini Joseph	BI Platform Architecture, Development Administration	SSIS Factory
16:15:00	Gareth Swanepoel	Enterprise Database Administration Deployment	What’s New in SQL Server 2016 ?
16:15:00	Sean McCown	Enterprise Database Administration Deployment	Beginning Powershell for DBAs 1.0
17:15:00	Pam Shaw	Other	Raffle

SessionID: 46499

Registration

Back to calendar

Event Date: 27-02-2016 - Session time: 07:30:00 - Track: Other

Speaker: Pam Shaw

Title: Registration

Abstract:

Turn in admission ticket from Speed Pass packet and visit our sponsors.

SessionID: 46502

Welcome

Back to calendar

Event Date: 27-02-2016 - Session time: 08:30:00 - Track: Other

Speaker: Pam Shaw

Title: Welcome

Abstract:

Welcome to SQL Saturday - What you need to know

SessionID: 42786

Monitoring and Alerting for an Azure PaaS Application

Back to calendar

Event Date: 27-02-2016 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Ronald Dameron

Title: Monitoring and Alerting for an Azure PaaS Application

Abstract:

I'll present the fundamentals needed to setup monitoring and alerting for an Azure PaaS application. Coverage will included how to monitor and alert on individual components and setting up alerts in Application Insights.

SessionID: 44529

Solving Real Business Problems Step by Step

Back to calendar

Event Date: 27-02-2016 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Neil Pepi

Title: Solving Real Business Problems Step by Step

Abstract:

When you’re first starting out, queries can be daunting. The experts on your team seem to do it instinctively. But the flexibility of T-SQL makes it seem near impossible to translate a business problem into an executed query.

Luckily, we’ve developed a set of rough guidelines to do just that. In this session, we deconstruct the ad-hoc query in the context of real business problems. We will explore and test our step-by-step approach using the AdventureWorks database as our sandbox, as if you are an employee for Adventure Works and you’ve just been handed a problem to solve.

SessionID: 45453

SQL Server Disaster Recovery and High Availability Overview

Back to calendar

Event Date: 27-02-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kendal Van Dyke

Title: SQL Server Disaster Recovery and High Availability Overview

Abstract:

When it comes to disaster recovery and high availability with SQL Server, there are a lot of options. Most business owners (and many DBAs) lump disaster recovery (DR) and high availability (HA) together. And while they do share some pieces, they also call for different strategies. Should you use one or more of these options? And what criteria should you use to make the choice? It’s important that you understand the decision tree that can guide you to select the right option(s) for your organization and that you can clearly explain those choices to the stakeholders. It’s not as complicated as it sounds, but it is complicated. This session will give you a high-level understanding of the options, their costs and complexities, and reasons for using each of them.

SessionID: 45502

Fast Track that Cube Please

Back to calendar

Event Date: 27-02-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dan King

Title: Fast Track that Cube Please

Abstract:

Have you ever been thrown into a position where upper management wants to analyze and report off their data and your in charge? Are you writing complex T-SQL scripts and know there is a better way to achieve your goal? Maybe a multi-dimensional cube is just the answer your looking for. But do you know how to build it? In this session we will look at a data warehouse and build a small cube from the ground up. We will define a basic star schema and how to use it within a SSAS solution. We will look at the frame work around the cube such as the fact table, dimensions, attribute relationships, dimension usage, measures, and partitions. You will also learn a few tricks along the way to optimize for performance.

SessionID: 45647

Parent, Child development Using SSIS Framework

Back to calendar

Event Date: 27-02-2016 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Jorge Novo

Title: Parent, Child development Using SSIS Framework

Abstract:

Learn how to extend and reuse SSIS development using package controllers and drivers. Extend parallel process and view the different options for SSIS package configurations and become the GURU on ETL development for your organization

SessionID: 45937

Conducting an Effective Job Search

Back to calendar

Event Date: 27-02-2016 - Session time: 09:00:00 - Track: Professional Development

Speaker: Erica Woods

Title: Conducting an Effective Job Search

Abstract:

It’s no surprise that embarking upon a job search can be a high-anxiety time. However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels, working with Recruiters, leveraging alerts and other strategies, etc. can help reduce frustrations and make it better. In this session, we’ll highlight what you should consider prior to starting your search, a 9-step plan to conduct an effective job search, how to work effectively with Recruiters, consideration criteria for evaluating your options, and how to part ways professionally if you’ll be resigning.

SessionID: 46176

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 27-02-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

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

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

SessionID: 46500

Break

Back to calendar

Event Date: 27-02-2016 - Session time: 10:00:00 - Track: Other

Speaker: Pam Shaw

Title: Break

Abstract:

Time between classes

SessionID: 41528

So What is Power BI?

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: BI Information Delivery

Speaker: Michael Antonovich

Title: So What is Power BI?

Abstract:

This session will provide the attendee with an introduction to Power BI Desktop and how to use it with external data sources (sources may vary but could include Web Sites, SharePoint, SQL Server, Excel, Text, or Access). It will compare and contrast it with the features of Power Pivot and Power Chart. Along with way, it will cover some basic table editing techniques, working with data from multiple data sources, and creating multiple visualizations on the same desktop that will interact with each other during the data analysis. This session might be of special interest to anyone currently using Power Pivot, Power Chart, or Power View to see how this tool can be integrated into their toolbox of Business Intelligence skills.

SessionID: 41534

Mastering and Enhancing Company Data

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rushabh Mehta

Title: Mastering and Enhancing Company Data

Abstract:

Getting a good 360 degree view of organizations (customers or vendors) or doing customer centric analysis is often complicated as a result of bad data/ duplicate data / inconsistent data coming from multiple systems. In addition, there are external factors like mergers and acquisitions, inter-company relationships and other nuances that may not be captured in source systems. Getting a clear picture of customer and vendor data can not only provide a clear picture for analysis of information, but also aid in critical risk management functions. In this session, you will learn about some techniques and data services from DB that you can use to clean and enhance your data.

SessionID: 41584

Top 10 Wait Types Everyone Should Know

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Top 10 Wait Types Everyone Should Know

Abstract:

There are over 800 wait types in SQL Server 2014, but there are only 10 (in my experience) that are seen very often. If you can learn these 10 wait types, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait types to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.

SessionID: 42061

NoSQL Solutions in the Cloud with Microsoft Azure

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Mark Kromer

Title: NoSQL Solutions in the Cloud with Microsoft Azure

Abstract:

In this session, I will walk through 3 different Cloud-based NoSQL database options available in Azure that will enable your next-generation Internet applications: Cassandra, MongoDB and Graph. I'll talk about some benefits and gotchas with those platforms as well as building data analytics on top of those database apps.

SessionID: 42278

Introduction to Fog Analytics

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: John Wang

Title: Introduction to Fog Analytics

Abstract:

This session will provide an overview of Fog Analytics and their frameworks: Azure IoT Suite and ConnectTheDots.io. Fog Analytics is applying analytics to the data generated by Internet of Things (IoT) devices in real-time.

SessionID: 43014

Data Partitioning for Database Architects and Mere Mortals

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: Strategy and Architecture

Speaker: Dmitri Korotkevitch

Title: Data Partitioning for Database Architects and Mere Mortals

Abstract:

Data partitioning is a valuable technique that simplifies database administration tasks and helps meet availability and performance SLAs. In this session, Dmitri will cover several techniques and architectural approaches you can use to partition data in the different versions and editions of SQL Server. You will learn about partitioned tables, partitioned views and stretch databases introduced in SQL Server 2016. Finally, Dmitri will discuss the practical questions, such as how to move data between filegroups and disk arrays keeping tables online and how to address some of performance issues caused by data partitioning.

SessionID: 45655

Inside the Query Optimizer

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Bradley Ball

Title: Inside the Query Optimizer

Abstract:

When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

SessionID: 47040

Back Up and Restore? Piece of Cake!

Back to calendar

Event Date: 27-02-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Daniel Taylor

Title: Back Up and Restore? Piece of Cake!

Abstract:

Backup and Restore? Piece of Cake!? Right? Backing up our databases is key to protecting our environment. Do you know your backup schedules, backup location and what is required

from the business if a recovery is required? Essentially your RTO and RPO? It is too late to late to identify these items when you receive the call to start a database recovery. During this webinar I am going to share my thoughts, what I document, and concepts around backup and recovery procedures for you databases. So when you receive that call to recover a database you can say “Piece of Cake”.

SessionID: 42231

Database Design Fundamentals

Back to calendar

Event Date: 27-02-2016 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

SessionID: 42265

Automating Database Restores

Back to calendar

Event Date: 27-02-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Warren

Title: Automating Database Restores

Abstract:

Beginning DBA's think of a RESTORE as something that gets done when something goes wrong. In practice we restore all the time, perhaps most often to refresh our QA and Development environments. Doing one restore isn't hard, but what about when you get five or ten requests a day? It's not just the restore either, you have to alter permissions, change the recovery model, set the database owner, perhaps update synonyms or mask out sensitive data. Restores are a pattern and if we see the pattern, we can do things to make it faster and repeatable.

This presentation will show you the latest version of the system I use, one consisting of a couple of tables and a couple of Powershell scripts. I'll start with my design goals, show you some of the compromises I made to get to a solution that handles 90% or so of the requests, and some of the options I thought about but decided against. I used Powershell, but it's a pattern you could solve using another language, even perhaps TSQL!

SessionID: 45447

Windowed Functions - Harness the Power to Forecast with Ease!

Back to calendar

Event Date: 27-02-2016 - Session time: 11:30:00 - Track: Advanced Analysis Techniques

Speaker: Matt Martin

Title: Windowed Functions - Harness the Power to Forecast with Ease!

Abstract:

In this session, we will do a brief walk through of what windowed functions are, how they execute, and the power that can be realized with them to do advanced computations such as moving averages, running totals, and forecasting. Once we get into the forecasting piece, we will walk through a forecasting model and show how we can leverage windowed functions to take complex calculations and make them easy to interpret. We will also illustrate why windowed functions are much more efficient than the typical update/inner join aggregate for running totals.

At the end of this session, the goal is to empower you to go back to your organization and be able to build a forecasting model in just T-SQL.

SessionID: 45676

Whip Away Stress at Home Work to Create a Better You

Back to calendar

Event Date: 27-02-2016 - Session time: 11:30:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Whip Away Stress at Home Work to Create a Better You

Abstract:

If you are a working professional there is a chance that stress has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.

SessionID: 45949

Data Quality Services - Integrating your Data Steward

Back to calendar

Event Date: 27-02-2016 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: miguel Cebollero

Title: Data Quality Services - Integrating your Data Steward

Abstract:

This session will take you through some of the basics of setting up DQS and how to get started. Beyond the technical work required to setup DQS, there is the Data Steward and their role in the day to day interactions with DQS. This session will explain how to integrated the Data Steward into the process to approve and correct data, in addition to how to integrated those corrections back into your data warehouse loads.

SessionID: 45979

Indexes: Help or Hinder!

Back to calendar

Event Date: 27-02-2016 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Indexes: Help or Hinder!

Abstract:

Indexes can be a boon or decrement for query performance. This session will concentrate with a deep dive into clustered indexes and non-clustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. This presentation will be about one-fourth lecture and three-fourths demos. All materials will be available for download.

SessionID: 46017

Planning and Executing a Successful SQL Server Database Migration

Back to calendar

Event Date: 27-02-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Carlos Colon

Title: Planning and Executing a Successful SQL Server Database Migration

Abstract:

Migrating an existing database to SQL Server requires much more than just moving the schema and data. They key to a successful database migration effort includes designing the target system, identifying all components from the existing system that will need to be migrated, and allowing adequate time for changes and testing.

In this session we will discuss all the different database components and configuration items that will need to be considered during the migration effort, how to utilize the SQL Server Migration Assistant as a planning and implementation tool, what components cannot be migrated (and what can be done about it), and pitfalls to avoid during the development, testing, and final implementation.

SessionID: 46186

The Business Intelligence Side of SQL Server

Back to calendar

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

Speaker: Sayed Saeed

Title: The Business Intelligence Side of SQL Server

Abstract:

This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.

SessionID: 46501

Lunch Break

Back to calendar

Event Date: 27-02-2016 - Session time: 12:30:00 - Track: Advanced Analysis Techniques

Speaker: Pam Shaw

Title: Lunch Break

Abstract:

Grab a lunch and join one of our sponsors for a lunch session.

SessionID: 47097

Transform SQL Server Agility with XtremIO

Back to calendar

Event Date: 27-02-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Bryan Walsh

Title: Transform SQL Server Agility with XtremIO

Abstract:

All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.

SessionID: 41552

Data Migration Using BIML

Back to calendar

Event Date: 27-02-2016 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Feasel

Title: Data Migration Using BIML

Abstract:

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

SessionID: 41646

Intelligent Indexing

Back to calendar

Event Date: 27-02-2016 - Session time: 13:45:00 - Track: Professional Development

Speaker: Arvin Meyer

Title: Intelligent Indexing

Abstract:

Using indexing to improve performance

SessionID: 42477

Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Back to calendar

Event Date: 27-02-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Keleher

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract:

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

SessionID: 43008

Execution Plans: What Can You Do With Them?

Back to calendar

Event Date: 27-02-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Execution Plans: What Can You Do With Them?

Abstract:

People are aware that you can use an execution plan to tune a query, but do they have other uses? This session will drill down on all the hidden information within execution plans. The structures and information with an execution plan shows many of the inner workings of SQL Server. From calculated columns to referential integrity, these, and many other functions, are exposed through execution plans. From this session you’ll be able to better understand the inner workings of SQL Server as well as your own databases and queries.

SessionID: 45440

Managing Multiple SQL Servers Using SSMS

Back to calendar

Event Date: 27-02-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Herve Roggero

Title: Managing Multiple SQL Servers Using SSMS

Abstract:

Do you want to be able to monitor multiple database servers using SSMS, and execute commands such as checking which servers have a specific login, run a DBCC command on 50 servers at the same time, select records from multiple servers as a single output, identify blocking commands on your SQL Server farm, or even check the error log of multiple servers using a single SQL command? What about sending a SMS when the 'sa' user is currently connected?

Now you can do this and more with Enzo Unified, the data server platform that unleashes the power of SQL Server.

SessionID: 46175

Designing Stored Procedure Solutions

Back to calendar

Event Date: 27-02-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

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

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

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

SessionID: 46490

A closer look to Azure Data Factory

Back to calendar

Event Date: 27-02-2016 - Session time: 13:45:00 - Track: Information Delivery

Speaker: Luis Figueroa

Title: A closer look to Azure Data Factory

Abstract:

Azure Data Factory is a modern data orchestration platform design to help you manage any data of any size from any source. It also makes a number of technologies available to you such as Azure Machine learning so that you can integrate predictive machine learning models in your data pipelines. This platform enables you to create intelligent applications that not only provide insights but can also recommend actions upon specific events. Join me in this session as take a closer look at many of the capabilities built in the platform.

SessionID: 41529

Indexing your Data Warehouse

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: Indexing your Data Warehouse

Abstract:

One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.

SessionID: 41763

SSIS 2012/2014: The Quiet Revolution

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Bryan Cafferky

Title: SSIS 2012/2014: The Quiet Revolution

Abstract:

The SQL Server 2012 release of SSIS was a complete game changer. Using sample packages, we'll show you how to deploy projects to the new SSIS catalog. You will see how project level parameters and connection managers can make your life easier. You will learn how to configure packages using the new configuration editor in SSMS. We'll show you how to define a collection of configuration settings called an Environment which can automatically configure packages deployed to a server. Find out why SQL Agent no longer captures SSIS errors in the log and how you can get information about failed packages. Get up to speed on using the latest features of SSIS to make you job easier.

SessionID: 42784

SQL Server Lockdown in Six Steps

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ronald Dameron

Title: SQL Server Lockdown in Six Steps

Abstract:

I will review the fundamentals needed to define a configurable permission model that allows database administrators to do routine work without having unfettered access to business data.

I will demonstrate that many DBA tasks can be done without sysadmin access and explain what permissions are required for the most common tasks. Attendees will learn how to deploy a permission model that allows DBAs to do routine work and how to elevate permissions quickly to respond to emergencies.

I will demonstrate T-SQL and PowerShell scripts that secure the database server, undo the permission model in case of unforeseen circumstances, and discover which servers are non-compliant.

Attendees will leave this session with the realization that DBAs don’t need to be sysadmin as often as typically believed, that most administration tasks can be done without elevated permissions, and with the means to deploy this model in their own environment.

SessionID: 45623

XML in SQL

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Gus Gwynne

Title: XML in SQL

Abstract:

Will cover uses of XML in SQL databases, including dynamic data definition needs, XQuery, and complex data-stream applications. Built on real-world needs for real businesses. This is not theoretical, it is practical and has real-world application.

SessionID: 45842

What's New in SSRS 2016

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: BI Information Delivery

Speaker: Patrick LeBlanc

Title: What's New in SSRS 2016

Abstract:

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

SessionID: 45950

Datawarehouse Development in an Agile World

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Strategy and Architecture

Speaker: miguel Cebollero

Title: Datawarehouse Development in an Agile World

Abstract:

In today's world of Agile, Scrum, Iterative, WiziWigFlimFlam... The data warehouse architect or developer can feel like their development doesn't really fit. Without knowing all of the requirements upfront, how could you possibly successfully design your datawarehouse? How about all of the documentation you would always leave as artifacts? This session will take you through a handful of tools to help through the iterative development cycles and changes in requirements as the project evolves. You will walk away with several document templates, scripts and the knowledge to help you along your next Agile datawarehouse project.

SessionID: 47161

What'S New In SQL Server 2012/2014/2016 For The Developer

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Jeff Taylor

Title: What'S New In SQL Server 2012/2014/2016 For The Developer

Abstract:

This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.

SessionID: 41553

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

Event Date: 27-02-2016 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Abstract:

So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

SessionID: 43007

Automating Your Database Deployments

Back to calendar

Event Date: 27-02-2016 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Automating Your Database Deployments

Abstract:

Deploying your database changes to production can be nerve-wracking as you introduce changes while attempting to protect your data. In order to take the stress out of these deployments, you must ensure that you practice your deployments before you ever get near production. This session shows how automating the deployment and testing processes through your various development and pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.

In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.

SessionID: 44558

Availability Groups: Monitoring and Alerting

Back to calendar

Event Date: 27-02-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Availability Groups: Monitoring and Alerting

Abstract:

So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Did you know it failed over last night?

This session will answer all these questions and more, and will show you what should you be looking at to ensure no surprises... We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and policies to show what to monitor in your AG and how to setup alerts so you know when to take action

SessionID: 44573

SSIS Factory

Back to calendar

Event Date: 27-02-2016 - Session time: 16:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jemini Joseph

Title: SSIS Factory

Abstract:

Assume you have 100's of packages already developed and running in production. How long it will take to find the package that affect a particular table? Want to automate the search through all packages instead of opening each of them manually and checking them? Can it be more interesting if the conversion of those 2008 packages to 2012/2014 and deploy it to the new SSISDB using project deployment model? You can do it through C# (or VB) code using SSIS SDK with your C# scripting skills that you use in SSIS packages. You can also create new SSIS packages to load text/excel files that receive from a vendor even if you don't know the file structure. Let's have some fun..

SessionID: 45941

What’s New in SQL Server 2016 ?

Back to calendar

Event Date: 27-02-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Gareth Swanepoel

Title: What’s New in SQL Server 2016 ?

Abstract:

SQL Server 2016 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s and architects to some of the exciting features available in that version. Topics covered in this session include Query Store, Polybase, Stretch Database, JSON Support, Row Level Security, Always Encrypted, Enhancements to In-Memory OLTP tables and enhancements to AlwaysOn. If you are a SQL Server DBA or developer, an architect, or an IT professional who is excited about the new SQL Server 2016 features and are looking forward to learn more about them, this session is for you.

SessionID: 46178

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 27-02-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 46503

Raffle

Back to calendar

Event Date: 27-02-2016 - Session time: 17:15:00 - Track: Other

Speaker: Pam Shaw

Title: Raffle

Abstract:

Raffle drawings from sponsor to event give aways - MUST BE PRESENT TO WIN.

This site is open source. Improve this page.