sqlsathistory

Nr: 521

Back to Main list

SQLSaturday #521 - Atlanta 2016

Start Time (24h)	Speaker	Track	Title
08:15:00	Daniel Glenn	Other	Keys to Successful SharePoint Administration for the DBA
08:15:00	Monica Rathbun	Professional Development	I'm It - Survival Techniques for the Lone DBA
08:15:00	William Wolf	Application Database Development	Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
08:15:00	Vishal Pawar	Application Database Development	SSIS - Lightning fast processing using Parallel processing Optimization
08:15:00	Jeffrey Garbus	Professional Development	How to be a GREAT DBA
08:15:00	Alex Grinberg	Other	Efficient table design
08:15:00	Teo Lachev	BI Platform Architecture, Development Administration	What's New for BI in SQL Server 2016
08:15:00	Paresh Motiwala	Enterprise Database Administration Deployment	TempDB- More permanent impact than you think
08:15:00	Janis Griffin	Enterprise Database Administration Deployment	Top 10 Wait Types Everyone Should Know
08:15:00	Bill Anton	BI Platform Architecture, Development Administration	20 Minute Tabular Model
08:15:00	Andy Leonard	BI Platform Architecture, Development Administration	SSIS Frameworks and Biml
08:15:00	Rafael Salas	BI Information Delivery	Getting Data with Power BI: Tips, Tricks and Scripts
08:15:00	Mike Oberlin	Enterprise Database Administration Deployment	How answers.microsoft.com Overcame the Challenges of Upgrading to SQLServer
08:15:00	Michael French	Professional Development	Independent Contracting 101
09:30:00	Mike Byrd	Application Database Development	SS2014/16 In-Memory Tables: Formula 1 Performance Unleashed?
09:30:00	miguel Cebollero	Strategy and Architecture	Datawarehouse Development in an Agile World
09:30:00	Tamera Clark	BI Information Delivery	Microsoft Business Intelligence 2016 – More Love for Your Data
09:30:00	Mike Robbins	Other	PowerShell Toolmaking with Advanced Functions and Script Modules
09:30:00	Thomas Grohser	Enterprise Database Administration Deployment	Optimizing the SQL Server and Databases for large Fact Tables
09:30:00	Jon Boulineau	BI Platform Architecture, Development Administration	Introducing Hadoop to SQL Server Pros
09:30:00	Robert Cain	BI Platform Architecture, Development Administration	Introducing the SSAS BI Semantic Model, aka Tabular
09:30:00	Jamey Johnston	Analytics and Visualization	Code Like a Pirate ... Intro to R and Data Science Tools in MS
09:30:00	Jason Brimhall	Enterprise Database Administration Deployment	Murder They Wrote
09:30:00	Carlos L Chacon	Cloud Application Development Deployment	Disaster Recovery Options with Azure
09:30:00	Peter Avenant	BI Platform Architecture, Development Administration	Azure Data Warehousing made easy with Biml
09:30:00	Paco Gonzalez	Advanced Analysis Techniques	Enterprise Machine Learning with R and SQL Server
09:30:00	Damu Venkatesan	BI Platform Architecture, Development Administration	DAX 101
09:30:00	Melissa Coates	Cloud Application Development Deployment	Building Blocks of Cortana Intelligence Suite in Azure
09:30:00	Shabnam Watson	BI Platform Architecture, Development Administration	A SQL Developer’s Guide to MDX Basics
10:45:00	Kevin Feasel	Application Database Development	Peanut Butter Chocolate: Integrating Hadoop with SQL Server
10:45:00	Aaron Cutshall	Application Database Development	The Lost Science of Set Theory
10:45:00	Mindy Curnutt	Application Database Development	TSQL Coding Techniques - Are You Playing with Fire?
10:45:00	Stuart Ainsworth	Strategy and Architecture	Microsoft Data Platform: The Open Space Session
10:45:00	Mike Hillwig	Enterprise Database Administration Deployment	SQL Phone Home: Teaching Your SQL Servers to Call for Help
10:45:00	Andy Mallon	Professional Development	Shortcuts from an Impatient DBA
10:45:00	Daniel McLeod	BI Platform Architecture, Development Administration	What is Biml?
10:45:00	Louis Davidson	Application Database Development	Let Me Finish... Isolating Write Operations
10:45:00	Niran Even-Chen	Enterprise Database Administration Deployment	Architecting virtual SQL server for performance
10:45:00	Michael Fal	Enterprise Database Administration Deployment	Managing Availability Groups (What happens after the build!)
10:45:00	Nathan Boster	Application Database Development	Write Queries Faster with AutoHotKey
10:45:00	Joseph Daigle	Application Database Development	Data Access for Performance Junkies
10:45:00	Ginger Grant	BI Information Delivery	R School for the SQL Practitioner
10:45:00	Jeremy Frye	BI Platform Architecture, Development Administration	Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing
12:00:00	Jeffrey Garbus	Information Delivery	Indexing for Join Optimization
12:00:00	Rie Irish	Professional Development	Making the Most of Virtual Chapters and Other Free Training
12:00:00	Rob Volk	Enterprise Database Administration Deployment	A Modern SQL Server DBA...In 10 Minutes
12:00:00	Konstantin Melamud	BI Platform Architecture, Development Administration	Optimizing your data warehouse for OLAP Processing
12:00:00	Rie Irish	Professional Development	Women in Technology: Identifying, Understanding and Combating Gender Bias
12:00:00	Mark Van de Wiel	BI Information Delivery	Real-time data delivery may be easier than you think
12:00:00	Jason Picker	BI Platform Architecture, Development Administration	Making Microsoft BI On-premise A Reality
12:00:00	SQLSat Lunch	Enterprise Database Administration Deployment	The HA Blueprint for SQL Server
12:00:00	SQLSat Lunch	Enterprise Database Administration Deployment	Tintri SQL Sentry - Optimizing Your Virtualized Workload
12:00:00	Tim Radney	Enterprise Database Administration Deployment	Cisco UCS for the Data Professional
12:00:00	David Bermingham	Cloud Application Development Deployment	Protecting Business Critical Applications in the New Data Center
12:00:00	SQLSat Lunch	Enterprise Database Administration Deployment	Transform SQL Server Agility
13:15:00	Eric Peterson	Enterprise Database Administration Deployment	SQL Server 2016 - New DBMS Features and examples
13:15:00	Luis Figueroa	Information Delivery	A closer look at Azure Data Factory
13:15:00	Dan Holmes	Application Database Development	The Last Mile: Dynamically Created Objects
13:15:00	Chrissy LeMaire	Enterprise Database Administration Deployment	Simplifying SQL Server Migrations using PowerShell
13:15:00	Kevin Kline	Enterprise Database Administration Deployment	Top 10 Admininistrator Mistakes on SQL Server
13:15:00	Taiob Ali	Enterprise Database Administration Deployment	SQL Server Agent : All the Knobs You Need to Know
13:15:00	David Bermingham	Enterprise Database Administration Deployment	SQL Server High Availability in Azure IaaS
13:15:00	Jay Harris	BI Platform Architecture, Development Administration	Biml Recipies: Automatically Create T-SQL Scripts for Common Tasks
13:15:00	Ravi Lobo	Professional Development	A sense of automation
13:15:00	Thomas LeBlanc	Professional Development	Skills Needed to Transition From DBA to BI Architect
13:15:00	Brian Kelley	BI Platform Architecture, Development Administration	Securing the Extract, Transform, and Load (ETL) Pipeline
13:15:00	Brandon Leach	Application Database Development	Partitioning Basics: Treating Your Tables Like Legos
13:15:00	Kerry Tyler	BI Information Delivery	Connecting Power BI to On-Prem Data with SSAS
13:15:00	Patrick LeBlanc	BI Information Delivery	Introduction to the Power BI Desktop
14:30:00	Tim Radney	Enterprise Database Administration Deployment	Azure SQL Database for the Production DBA
14:30:00	Naomi Williams	Enterprise Database Administration Deployment	SQL Server Internals
14:30:00	Jennifer McCown	Application Database Development	Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos
14:30:00	Paul Popovich Jr	Enterprise Database Administration Deployment	Clusters! From the ground up, let's build one together
14:30:00	Deji Akomolafe	Strategy and Architecture	Successfully Virtualizing SQL Server on vSphere - Straight from the Source
14:30:00	Cornell Emile	Advanced Analysis Techniques	Enhancing Data and Predictive Analytics with Azure HDInsight
14:30:00	Matt Martin	Information Delivery	Advanced Error Tracking for Quick Diagnosis
14:30:00	David Maxwell	Enterprise Database Administration Deployment	DBA 911 - Database Corruption
14:30:00	Mike Lawell	Application Database Development	Execution Plans for Mere Mortals
14:30:00	Mark Tabladillo	Application Database Development	T-SQL Window Functions for Analytics
14:30:00	Amy Herold	Enterprise Database Administration Deployment	Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
14:30:00	Sven Aelterman	Cloud Application Development Deployment	Azure SQL Database: Deployment and Development of Your First DB
14:30:00	Jason Horner	BI Platform Architecture, Development Administration	Dimensional Modeling Design Patterns: Beyond the Basics
14:30:00	Brad McKuhen	Enterprise Database Administration Deployment	SQL Auditing - Getting A View Of Yesterday's Activity Today
14:30:00	Julie Smith	Cloud Application Development Deployment	Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.
14:30:00	Lindsay Clark	Professional Development	TechGirlz How You Can Help Usher In The Next Generation
15:45:00	Ben Miller	Enterprise Database Administration Deployment	Administering SQL Server on Server Core with PowerShell
15:45:00	Ed Watson	BI Information Delivery	Introduction to SQL Server Integration Services
15:45:00	Vladimir Oselsky	Analytics and Visualization	Insight through Spatial Data
15:45:00	Christopher Wolff	Application Database Development	Continuous Deployments using SSDT
15:45:00	Lance Tidwell	Application Database Development	Parameter Sniffing the Good, the Bad and the Ugly
15:45:00	Robert Verell	Other	Vote or Die 2016: Which is Faster?
15:45:00	Justin Randall	Enterprise Database Administration Deployment	The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags
15:45:00	Jana Sattainathan	Strategy and Architecture	Small Scale Data Collection Using PowerShell - Going NSA Style!
15:45:00	Scott Currie	BI Platform Architecture, Development Administration	SSIS Unit and Integration Testing with the Open Source BEST project
15:45:00	Scott Currie	BI Platform Architecture, Development Administration	Incrementally Moving to the Cloud Using Biml
15:45:00	Karlyn LeBlanc	Professional Development	Whip Away Stress at Home Work to Create a Better You
15:45:00	Wayne Sheffield	Enterprise Database Administration Deployment	SSMS Tips and Tricks
15:45:00	Daniel Taylor	Enterprise Database Administration Deployment	More than Just a basic Database Backup and Recovery
15:45:00	John Morehouse	Enterprise Database Administration Deployment	Backups Restores: You're Not In Kansas Anymore!

SessionID: 45637

Keys to Successful SharePoint Administration for the DBA

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Other

Speaker: Daniel Glenn

Title: Keys to Successful SharePoint Administration for the DBA

Abstract:

Inherited SharePoint or being tasked to implement it? In this session we will start with the fundamentals of SharePoint and work our way to understanding what it looks like to be a successful SharePoint administrator. We will cover common SharePoint misconceptions use live demos to show frequently performed tasks - all to set you up for success day one. Lastly we will cover the training options and other resources available to make your job easier and more automated.

SessionID: 45762

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Professional Development

Speaker: Monica Rathbun

Title: I'm It - Survival Techniques for the Lone DBA

Abstract:

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

SessionID: 46180

Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Application Database Development

Speaker: William Wolf

Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Abstract:

Deadlocks present a problem to many DBAs. Deadlocks can be minor occurrences or major issues making SQL Server continually choose a victim like constantly quarreling siblings.

To understand how Deadlocking occurs, we must understand basic locking, blocking of SQL Server. We will review Isolation Levels, and when is an appropriate time to use each.

We will then review Deadlocking, how to capture Deadlocks and touch on how to resolve Deadlocks and lessen the family fighting.

SessionID: 46262

SSIS - Lightning fast processing using Parallel processing Optimization

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Vishal Pawar

Title: SSIS - Lightning fast processing using Parallel processing Optimization

Abstract:

SSIS package can be run in Parallel and Optimized .In this session we will learn how to improve SSIS Package performance using parallel processing and Optimization. This knowledge will encourage development of better performing packages and optimize package performance.When creating an efficient and robust solution for Extract, Transform and Load Process, Lot of things do matter especially when you are working with huge size of databases. Challenge is not only to meet functional requirements Also to look at the performance requirements. This session will also cover best practices to enhance and boost performance of a SSIS package.

SessionID: 46303

How to be a GREAT DBA

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Professional Development

Speaker: Jeffrey Garbus

Title: How to be a GREAT DBA

Abstract:

This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

SessionID: 46378

Efficient table design

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Other

Speaker: Alex Grinberg

Title: Efficient table design

Abstract:

The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.

SessionID: 46658

What's New for BI in SQL Server 2016

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Teo Lachev

Title: What's New for BI in SQL Server 2016

Abstract:

SQL Server 2016 delivers many data analytics and information management new features and enhancements. Join this session to discover what's new for BI in Database Engine, SSRS, SSIS, SSAS, and MDS. I'll also explain the SQL Server 2016+ near-future roadmap that will help you implement new solutions and cut cost.

SessionID: 46714

TempDB- More permanent impact than you think

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Paresh Motiwala

Title: TempDB- More permanent impact than you think

Abstract:

As a DBA you hear different theories and "gospel truths" about TempDB from many people. Frankly there is no single version of the truth except that if you don't use and manage it well, it will make your life a real h*ll.

What works for you in one situation may not work for you in another situation. What works for a situation today, might not guarantee its success for a similar situation tomorrow.

We will talk about Temporary User Objects, Work Tables, Interim Results Version Store for Data Standards for its configuration Contention Data Files Per CPU - Myth or Reality? Dynamic Growth or Pre Sized? Trace Flags to Manage Tempdb? Should we store the entire Tempdb on SSDs? Should we shrink TempDB or not?

Hopefully at the end of the session your knowledge on Tempdb won't be Temp.

SessionID: 46744

Top 10 Wait Types Everyone Should Know

Back to calendar

Event Date: 21-05-2016 - Session time: 08: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: 46902

20 Minute Tabular Model

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bill Anton

Title: 20 Minute Tabular Model

Abstract:

Are you familiar w/ SSAS Multidimensional and curious about Tabular? Having trouble deciding between cubes and tabular models? Then this is your session!

Analysis Services Tabular was introduced back in 2012, and yet it has only just started to emerge from the Proof-Of-Concept phase to a legitimate production alternative in most IT departments. Based on xVelocity, a highly compressed in-memory technology, Tabular models provide considerable performance improvements over Multidimensional models in many scenarios. And with major advancements in 2016, Tabular has never been a more appealing solution. But, as is the case with any new technology, there are certain limitations of which to be aware.

Join me in this session and learn what a Tabular model is, how it fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live step-by-step demo where we'll build and deploy a Tabular model.

SessionID: 47120

SSIS Frameworks and Biml

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: SSIS Frameworks and Biml

Abstract:

The material in this session ranges from introductory to advanced.

Building small, function-like SSIS packages is an SSIS best practice. Biml helps generate lots of packages using design patterns.

Now you have a bunch of packages - how do you manage executing them? An SSIS Framework can execute packages in a specified order, and it is driven by metadata. Need to make a change in execution order? Execute a T-SQL statement.

How do you manage the metadata that drives an SSIS Framework? Biml can generate the metadata, as well.

Join SSIS author, blogger, and presenter Andy Leonard for this demo-packed session on Data Integration Lifecycle Management (DILM).

SessionID: 48358

Getting Data with Power BI: Tips, Tricks and Scripts

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: BI Information Delivery

Speaker: Rafael Salas

Title: Getting Data with Power BI: Tips, Tricks and Scripts

Abstract:

You may have already seen a lot of Power BI, but have you look deeper into its capabilities to get, merge and shape data?

Power BI comes with great functionality that allow us to explore, collect an combine data in a powerful and easy way. In this session, we will use Power BI to solve data challenges that used to require a lot of coding and more complex solutions in a quick and effective way. This session is loaded with practical examples that will help you getting a better understanding of Power Query data preparation capabilities and provides you with a good share of hands-on tips and scripts in scenarios such as: Cleansing address data, consume Odata Feeds, APIs calls , execute SSIS packages on demand and more.

SessionID: 48855

How answers.microsoft.com Overcame the Challenges of Upgrading to SQLServer

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Oberlin

Title: How answers.microsoft.com Overcame the Challenges of Upgrading to SQLServer

Abstract:

As part of the company’s “Get Current/Stay Current” initiative, Microsoft’s IT organization planned to upgrade its community website, answers.microsoft.com from Microsoft SQL Server 2008 to Microsoft SQL Server 2014. At the same time, the site adopted virtualization and needed to maintain the zero downtime environment the group had built with mirroring. Given the site spans four data centers across the globe and supports more than 1.7 million visitors a day, Microsoft cannot afford downtime, not even for maintenance. This case study shares best practices for upgrading to SQL Server 2014, highlights the technologies Microsoft considered to enable continuous availability, and details how the site leveraged AlwaysOn without making application changes.

SessionID: 49537

Independent Contracting 101

Back to calendar

Event Date: 21-05-2016 - Session time: 08:15:00 - Track: Professional Development

Speaker: Michael French

Title: Independent Contracting 101

Abstract:

WARNING: Do not quit your job after this presentation. Have you ever thought about becoming an Independent Contractor? Would you like to transition from Full Time Employment to Consulting? Do you want to know how to get started? If so, then this lively session is for you. The session will cover the basics of running a consulting business and a selling yourself as a Technical Resource. We will conclude with an open discussion about the business side of technology.

SessionID: 46268

SS2014/16 In-Memory Tables: Formula 1 Performance Unleashed?

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: SS2014/16 In-Memory Tables: Formula 1 Performance Unleashed?

Abstract:

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

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

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

SessionID: 46270

Datawarehouse Development in an Agile World

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30: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: 46784

Microsoft Business Intelligence 2016 – More Love for Your Data

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: BI Information Delivery

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

PowerShell Toolmaking with Advanced Functions and Script Modules

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Other

Speaker: Mike Robbins

Title: PowerShell Toolmaking with Advanced Functions and Script Modules

Abstract:

Transitioning from writing PowerShell one-liners and basic scripts to creating reusable PowerShell tools with advanced functions and script modules can be a daunting task and with all the different ways that you’ll find on the Internet to accomplish the same task, it can definitely seem overwhelming. During this session, PowerShell MVP Mike F Robbins will demystify many of the intricacies of toolmaking while demonstrating the best practices for using parameters, parameter validation, cmdlet binding, supports should process, pipeline input, error handling, module manifests, and custom formatting. This session will NOT be a deep dive into any one of the previously listed topics. Prior experience with PowerShell is recommended. All code shown during this presentation will be made available on GitHub.

SessionID: 47160

Optimizing the SQL Server and Databases for large Fact Tables

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: Optimizing the 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 learn how to load from an OLTP system with zero impact to it.

SessionID: 47493

Introducing Hadoop to SQL Server Pros

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jon Boulineau

Title: Introducing Hadoop to SQL Server Pros

Abstract:

Finding any IT industry publication that does not frequently reference Hadoop and Big Data is nearly impossible. Even so, to many SQL Server professionals it remains a mystery. 'Introducing Hadoop to SQL Server Pros' is designed to bridge the gap between knowledge of SQL Server and an understanding of Hadoop by comparing familiar features of SQL Server to Hadoop counterparts. Equally important is understanding how Hadoop is different and the use cases in which it compliments SQL Server. Of special note are the ways Microsoft is integrating Hadoop in its data strategy and related products. Perhaps 2016, Hadoop's 10th birthday year, is the time for SQL Server Pros to become familiar with this platform and how to prepare for it's introduction into our work as data professionals.

SessionID: 48463

Introducing the SSAS BI Semantic Model, aka Tabular

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Robert Cain

Title: Introducing the SSAS BI Semantic Model, aka Tabular

Abstract:

SQL Server Analysis Services 2012 introduced the BI Semantic Model, also known as the Tabular model. In this session you'll learn about the newest way to do analytics in SQL Server. We'll compare and contrast it with the traditional Multidimensional Model, then see how to create your first "cube" using the Tabular mode. Finally we'll look at some of the reporting options for using your new Tabular database, including SSRS, Excel, and PowerView.

SessionID: 48510

Code Like a Pirate ... Intro to R and Data Science Tools in MS

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Analytics and Visualization

Speaker: Jamey Johnston

Title: Code Like a Pirate ... Intro to R and Data Science Tools in MS

Abstract:

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.

Come to this session to get an introduction to the R language including:

• Installing and Configuring R and RStudio
• RStudio Overview and Debugging
• How to Access and Manipulate Data
• Install and Manage Packages
• Create and Use Variables
• Control Flows
• Functions
• Basic Graphing and Statistical Analysis

We will finish with a brief introductions of how R integrates in Azure ML, Power BI and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

SessionID: 48591

Murder They Wrote

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Murder They Wrote

Abstract:

Join Microsoft Certified Master, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy. This is the Solo version of the Joint version normally done as an all-day precon.

SessionID: 48824

Disaster Recovery Options with Azure

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Cloud Application Development Deployment

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

Azure Data Warehousing made easy with Biml

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Peter Avenant

Title: Azure Data Warehousing made easy with Biml

Abstract:

During a recent project migrating from on premise to the cloud. First we were going to Redshift and started coding, then were asked to use Azure DWH instead. We soon realized that moving between cloud providers was actually quite similar, just different names and slightly different code format.

In this session we will investigate several options to migrate your existing solution and the "fastest" way to get your data into the cloud including:

1. Reusable data export templates
2. Transferring files to Azure Blob Storage
3. Polybase to load data
4. CTAS to Merge data

Can Biml also do AWS S3 and Redshift? Yes and we will show you the similarities in approaches and how we are using it at one of our customers.

SessionID: 48876

Enterprise Machine Learning with R and SQL Server

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Advanced Analysis Techniques

Speaker: Paco Gonzalez

Title: Enterprise Machine Learning with R and SQL Server

Abstract:

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.

SessionID: 48894

DAX 101

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Damu Venkatesan

Title: DAX 101

Abstract:

In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.

SessionID: 48897

Building Blocks of Cortana Intelligence Suite in Azure

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: Cloud Application Development Deployment

Speaker: Melissa Coates

Title: Building Blocks of Cortana Intelligence Suite in Azure

Abstract:

Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.

SessionID: 49448

A SQL Developer’s Guide to MDX Basics

Back to calendar

Event Date: 21-05-2016 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: A SQL Developer’s Guide to MDX Basics

Abstract:

You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL.

In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.

SessionID: 46082

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45: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: 46361

The Lost Science of Set Theory

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: The Lost Science of Set Theory

Abstract:

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

SessionID: 46419

TSQL Coding Techniques - Are You Playing with Fire?

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: TSQL Coding Techniques - Are You Playing with Fire?

Abstract:

The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL, Parameter Sniffing and Value List Handling. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!

SessionID: 46958

Microsoft Data Platform: The Open Space Session

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Strategy and Architecture

Speaker: Stuart Ainsworth

Title: Microsoft Data Platform: The Open Space Session

Abstract:

Over the last few years, Microsoft has begun to articulate a broader vision of data beyond the flagship product SQL Server. Azure, Hadoop, HDInsight, R; all of these products have begun coalescing into a platform which will take some time for professionals in the field to embrace. The big question is: what do we need to know (as SQL Server professionals) in order to be prepared for the onslaught of Big Data?

This session will provide an interactive discussion around the Microsoft Data Platform, to build on our common experiences and knowledge. As an Open Spaces topic, attendees are expected to participate fully in discussions. I'll act as moderator, but there's no agenda and only a few slides; the content is completely up to the group.

Experience with other components of the Microsoft Data Platform is appreciated, but not required; the goal is to define "what we know we don't know" and to encourage self-motivated learning plans.

SessionID: 48196

SQL Phone Home: Teaching Your SQL Servers to Call for Help

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hillwig

Title: SQL Phone Home: Teaching Your SQL Servers to Call for Help

Abstract:

Did your backup fail? Was that a deadlock? Did that server just reboot? These are common questions that DBAs are constantly being asked, and DBAs should be asking them of their servers.

DBAs need to regularly monitor their servers for a regular health check, and many scripts just become email noise. It's like the kid in the back seat constantly asking "Are we there yet?"

In this session, Microsoft MVP Mike Hillwig will teach you his signature "See Something, Say Something" method. You'll learn how to use the SQL Agent to turn your daily monitoring checklist into actionable alerts. By leveraging the SQL Agent severity alerts and some basic scripting techniques, you'll stop mindlessly going down a checklist and instead have your servers notify you when there is a problem.

SessionID: 48201

Shortcuts from an Impatient DBA

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Professional Development

Speaker: Andy Mallon

Title: Shortcuts from an Impatient DBA

Abstract:

This session is about performance tuning your day.

We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient at writing code. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier.

Whether you're a Junior Developer or a Senior DBA with decades of battle scars, you'll learn something in this session.

SessionID: 48259

What is Biml?

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Daniel McLeod

Title: What is Biml?

Abstract:

You've heard about Business Intelligence Markup Language (Biml). Some people seem to be doing some pretty impressive things with it, but what exactly is it and will it work for you in your job?

Biml is a programming language for creating data warehouse, business intelligence, and other data solutions. It uses XML in combination with small nuggets of C# or VB code to automatically create huge amounts of SQL scripts, SSIS packages, SSAS cubes, and other objects that your team previously had to build manually - usually with slow, tedious, error-prone dragging and dropping. Perhaps the best part is that there is nothing to install on your server - Biml works entirely with your existing data infrastructure.

Want to know more? In this session, you'll find out everything you need to know to get started using Biml.

SessionID: 48380

Let Me Finish... Isolating Write Operations

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Let Me Finish... Isolating Write Operations

Abstract:

OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

SessionID: 48549

Architecting virtual SQL server for performance

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

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

Managing Availability Groups (What happens after the build!)

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Managing Availability Groups (What happens after the build!)

Abstract:

Have you built a SQL Server Availability Group only to be suddenly surprised by all the gotchas and hurdles that pop up? Are you struggling with keeping your Availability Group running smoothly without a lot of management on your part? This session will cover what happens after you have created an Availability Group and how to manage it. We will review tips, tricks, and patterns for handling all the considerations that running this popular high availability solution. After this session, you will be prepared for managing your Availability Groups and how you can streamline that management to make your availability strategy more robust.

SessionID: 48792

Write Queries Faster with AutoHotKey

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Nathan Boster

Title: Write Queries Faster with AutoHotKey

Abstract:

AutoHotKey (AHK) is an open source Windows application used to create macros, hot keys, and "text expansions". Nathan has used this program for years in many different ways, but he finds it especially useful in SQL Server Management Studio. Come and see how AHK can put a library of code snippets--and full queries--at your fingertips.

SessionID: 48794

Data Access for Performance Junkies

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Joseph Daigle

Title: Data Access for Performance Junkies

Abstract:

or: How I Learned to Stop Worrying and Love the ORM.

ORM frameworks get a bad rap for their performance characteristics and complexity. But like any tool, it's all about learning to use correctly and intelligently. In this session we'll look at how application developers often use (and misuse!) these tools, and identify and correct problematic usage patterns. We'll also discover when it's appropriate to use an ORM, when it's not, and how incorporate "raw" SQL where it makes sense.

SessionID: 48932

R School for the SQL Practitioner

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: BI Information Delivery

Speaker: Ginger Grant

Title: R School for the SQL Practitioner

Abstract:

Interest in the R language is has grown along with the amount of data being accumulated. As Microsoft is now incorporating the R language into SQL Server 2016, the language is going to be a required skill for all data professionals in the near future.

Using SQL Server 2016, attendees will learn how to incorporate R in SQL Server stored procedures as well as use of the R Server. The R server provides the ability to scale R code to use more data than can be loaded into memory, and attendees will learn the best use cases for it.

SessionID: 48942

Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing

Back to calendar

Event Date: 21-05-2016 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing

Abstract:

Are you sometimes plagued with the unfortunate event of your SSAS cube refresh exceeding the scheduled maintenance window? Maybe you simply need to update recent data to reflect a critical change during business hours, but can’t afford several hours of downtime. I have a solution for you! In this session, we will focus on building an ETL framework while leveraging your cube’s logical partition design to dynamically process only the necessary data within your measure group. We will discuss audit logging, cube processing options, partition design and metadata access. These techniques and strategies will provide a faster data refresh process for your warehouse or data mart.

SessionID: 46304

Indexing for Join Optimization

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Information Delivery

Speaker: Jeffrey Garbus

Title: Indexing for Join Optimization

Abstract:

Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.

SessionID: 48813

Making the Most of Virtual Chapters and Other Free Training

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Professional Development

Speaker: Rie Irish

Title: Making the Most of Virtual Chapters and Other Free Training

Abstract:

Are you a member of SQL PASS Virtual Chapters? Why not? Do you regularly attend VC training sessions or other free webinars provided by almost endless sources vendors? It costs you nothing but makes you more employable. That's a total win in my book!

We'll teach attendees about Virtual Chapters, how to pick which one works for them, registering for and attending the sessions that would help them most on their career path. We'll also cover other free training provided by PASS, Pragmatic Works, SQL Sentry, etc.

SessionID: 48848

A Modern SQL Server DBA...In 10 Minutes

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: A Modern SQL Server DBA...In 10 Minutes

Abstract:

If you're a new DBA, or an experienced DBA who's a few years behind, you are probably overwhelmed by all the fancy new terms and features: Azure/Cloud/On-Premises, Power Shell/Query/Pivot/View/Map/BI, Availability Groups, In-Memory/Hekaton, Columnstore, Everything-As-A-Service, and even having to deal with the dreaded NoSQL! And you've still got your hands full with clustering, mirroring, replication and backups! What is a modern SQL Server DBA to do?

This lightning talk will offer a gentle guide to all that new-fangled stuff and show you how they can make your current tasks easier and better. You'll learn where to find help and best practices, and how to get started with SQL Server in Azure. We'll also cover Microsoft Virtual Labs and show you how you can get hands-on experience with no risk or cost to you.

You'll laugh, you'll smile, and most of all you'll feel a lot better about all these new features and how to get the most out of them.

SessionID: 48890

Optimizing your data warehouse for OLAP Processing

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Abstract:

Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS and the database engine to ensure optimal performance, as well as enterprise level features within the database engine and SSAS available to us and how aligning those to work side by side would yield us significant improvement in our processing time.

SessionID: 48898

Women in Technology: Identifying, Understanding and Combating Gender Bias

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Professional Development

Speaker: Rie Irish

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

Abstract:

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

SessionID: 50096

Real-time data delivery may be easier than you think

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: BI Information Delivery

Speaker: Mark Van de Wiel

Title: Real-time data delivery may be easier than you think

Abstract:

Join this session to learn how quickly you can integrate - in real-time - data from SQL Server and other relational databases into a SQL Server database, on premises or in Azure. This session will show a live, end-to-end demonstration of a Business Intelligence scenario.

SessionID: 50367

Making Microsoft BI On-premise A Reality

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jason Picker

Title: Making Microsoft BI On-premise A Reality

Abstract:

Have you been looking into using Power BI Desktop but need a BI solution that is designed for enterprise, data-driven deployments, and are not ready to move your data to the cloud? Does your organization need a platform that will provide agility, speed, and scalability without sacrificing governance and security? Come and learn from Jason Picker about Pyramid Analytics BI Office, an end-to-end platform that enables people across your organization to have governed access to trusted data—to form insights, collaborate freely, and make better data-driven decisions. Learn how you can publish Microsoft Power BI Desktop content directly into Pyramid Analytics BI Office in an integrated, governed and secure server-based environment. Strengthen your organizations investment in Microsoft SQL Server and showcase the “so what?” of your analysis while securely sharing content generated in Power BI with Pyramid Analytics BI Office front end.

SessionID: 50596

The HA Blueprint for SQL Server

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: SQLSat Lunch

Title: The HA Blueprint for SQL Server

Abstract:

SQL Server allow applications to achieve high availability (HA) like never before, thanks to synchronous replication technology in AlwaysOn. This capability enables applications to use more resources on more servers, which can significantly improve scalability, performance, and resiliency. But to gain the full value of the SQL Server architecture, you are required to make code modifications at the application or database layers. Deploying database load balancing software is an elegant way to gain enterprise-grade HA without code changes. In this SQL Saturday talk, ScaleArc will provide a blueprint for achieving HA with SQL Server.

SessionID: 50597

Tintri SQL Sentry - Optimizing Your Virtualized Workload

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: SQLSat Lunch

Title: Tintri SQL Sentry - Optimizing Your Virtualized Workload

Abstract:

Learn how Tintri and SQL Sentry take the risk and guesswork out of virtualizing SQL databases. Tintri Virtual-Aware Storage (VAS) systems blend the predictable performance of solid-state disk (SSD), per-VM Quality-of-Service (QOS) and superior analytics to empower DBAs to confidently deploy even the most demanding enterprise applications. Tintri makes complex database management tasks like cloning, backup/recovery and test/dev refreshes a breeze through software automation that eliminates error-prone, manual processes. With the recent partnership between Tintri and SQL Sentry, DBAs can monitor specific performance metrics of their Tintri devices within SQL Sentry Performance Advisor. Stop by our booth and lunch session to see Tintri and SQL Sentry in action.

SessionID: 50607

Cisco UCS for the Data Professional

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Cisco UCS for the Data Professional

Abstract:

Tim Radney will share his experience with working with clients from all over the world that utilize Cisco UCS for the underlying infrastructure as well as how he helped a client migrate thousands of databases with over 100 instances to Cisco's UCS.

SessionID: 50613

Protecting Business Critical Applications in the New Data Center

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Cloud Application Development Deployment

Speaker: David Bermingham

Title: Protecting Business Critical Applications in the New Data Center

Abstract:

How to use SIOS iQ machine learning-based IT analytics solution to optimize SQL Server efficiency and performance in VMware environments.

SessionID: 50615

Transform SQL Server Agility

Back to calendar

Event Date: 21-05-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: SQLSat Lunch

Title: Transform SQL Server Agility

Abstract:

All-Flash Arrays deliver IOPS in abundance. EMC 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: 46338

SQL Server 2016 - New DBMS Features and examples

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Peterson

Title: SQL Server 2016 - New DBMS Features and examples

Abstract:

Microsoft has released an advanced version of SQL Server 2016.

My job as lead architect is to implement these new features, and see how they actually work. The session will cover the following subject areas and include examples of usage:

• Server Setup Changes
• Temporal Data Tables
• Masking Data Columns
• Row Level Security
• Always Encrypted
• Stretch Database
• Always On Enhancements
• In Memory Enhancements
• JSON Support
• Polybase into SQL Server

• more

SessionID: 46489

A closer look at Azure Data Factory

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Information Delivery

Speaker: Luis Figueroa

Title: A closer look at 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 we take a closer look at many of the capabilities built into the platform.

SessionID: 47061

The Last Mile: Dynamically Created Objects

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Dan Holmes

Title: The Last Mile: Dynamically Created Objects

Abstract:

Squeezing the last bit of performance out of you application after you have refactored your SQL and tuned your server and indexes can be frustrating. Making it more difficult might be the requirement to keep a single code base for each user and company that can configure your application to work specifically for them. One possible solution is tailoring programmable objects to each user. It will provide SQL specific to the user's needs thereby ensuring they the best possible performance based on their configuration.

SessionID: 47215

Simplifying SQL Server Migrations using PowerShell

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Chrissy LeMaire

Title: Simplifying SQL Server Migrations using PowerShell

Abstract:

What if migrating SQL Server instances was as simple as executing a single command?

In this presentation, I'll cover the reasons companies migrate, the ways SQL migrations are usually performed, and the considerations that must be made when performing a migration.

Then I'll show you how to use the PowerShell dbatools module to simplify your SQL Server migrations. dbatools makes migrating databases, logins, linked servers, credentials, jobs, database mail, and other essential SQL components extremely easy.

SessionID: 47323

Top 10 Admininistrator Mistakes on SQL Server

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: Top 10 Admininistrator Mistakes on SQL Server

Abstract:

SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

SessionID: 47879

SQL Server Agent : All the Knobs You Need to Know

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Taiob Ali

Title: SQL Server Agent : All the Knobs You Need to Know

Abstract:

As a production DBA, do you struggle to schedule heavy jobs to avoid times when the server is already overloaded? Have you ever felt like your end users notice data corruption, blocked processes, or a full tempdb even before you do? And have you ever been frustrated by the fact that Agent never stores quite enough job history to help you troubleshoot job failures? The fact is, SQL Server Agent can do way more than just schedule jobs at a fixed time. In this session you'll learn how to make SQL Agent run jobs only when ample CPU resources are available, how you can be the first to get notified when data corruption has occurred, and how to use Agent for monitoring data file size issues. You will also walk away with a set of scripts that will help you customize job history retention. By the end of this demo rich session you will understand how to leverage SQL Agent’s hidden gems that will make your database management job more efficient without requiring additional development time.

SessionID: 48113

SQL Server High Availability in Azure IaaS

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: SQL Server High Availability in Azure IaaS

Abstract:

Deploying mission critical SQL Server in Azure IaaS requires an in-depth understanding of storage, virtual networks, load balancers, SQL Server AlwaysOn and more. To qualify for Azure’s SLA of 99.95% availability, steps must be taken to mitigate downtime by leveraging Fault Domains and Update Domains in conjunction with SQL AlwaysOn.

Azure Resource Manager (ARM) replaces Azure “Classic” as the preferred deployment method in Azure. New features such as Deployment Templates and Resource Groups introduced in ARM make it a powerful tool in managing the entire life-cycle of SQL Server in Azure.

In this session attendees will learn how to leverage ARM to deploy SQL AlwaysOn Availability Groups and Failover Cluster Instances. Template Deployments and manual configurations using the Azure Portal and Azure PowerShell will be demonstrated.

SessionID: 48261

Biml Recipies: Automatically Create T-SQL Scripts for Common Tasks

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jay Harris

Title: Biml Recipies: Automatically Create T-SQL Scripts for Common Tasks

Abstract:

You've probably heard a lot about Biml for SSIS automation, but it can also be used for building complex, yet reusable T-SQL statements for common database tasks – in most cases much faster and more easily than with dynamic T-SQL. This will be a scenario driven session where we discuss many real world examples of manual tasks that can be automated with Biml snippets and the free BIDS Helper AddIn to BIDS/SSDT. You will receive all code for your own use. Scenarios include: 1) Generation of T-SQL merge statements that removes all the drudgery of manually mapping columns - including complex SCD column handling. 2) Stale data detection that uses Biml to create queries that display ranges for all date/time columns in each table of a target database - perfect for retiring tables from WorkDB and other ad hoc environments. 3) Sample data creation that automatically produces test data based on DDL schema information from your data model. 4) And much more

SessionID: 48532

A sense of automation

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Professional Development

Speaker: Ravi Lobo

Title: A sense of automation

Abstract:

It is about developing a sense for patterns in our day-to-day repeatable processes, and creating solutions to automate them.

SessionID: 48735

Skills Needed to Transition From DBA to BI Architect

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Professional Development

Speaker: Thomas LeBlanc

Title: Skills Needed to Transition From DBA to BI Architect

Abstract:

Dimensional Modeling is a re-tooling of your existing database normalization knowledge. T-SQL and coding knowledge can transfer to ETL (Extract, Transform and Load) using Integration Services (SSIS). Report Writing has been around for decades and learning Analysis Services (SSAS) can save days of work that custom report writing has taken teams.

Development today requires the design and analysis of Online Transaction Processing (OLTP) to take into account Data Warehousing/OLAP (Online Analytical Processing) output. My personal transition from Sr. DBA to DW Architect has been a process of sanding the rough edges of my passion from fully normalized databases. The Dimensional Modeling started a re-tooling of my mind to look at end results analytically. These lessons have molded me into a DW Architect.

SessionID: 48740

Securing the Extract, Transform, and Load (ETL) Pipeline

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brian Kelley

Title: Securing the Extract, Transform, and Load (ETL) Pipeline

Abstract:

In most organizations, "batch" processing happens at least nightly. Data is moved from one system to another, often with multiple stops along the way. We tend to do a good job securing the endpoints: where the data starts and where it ends up. However, the in-between drops are often neglected.

In this session we're going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might go after. We're going to eliminate FUD (Fear, Uncertainty, and Doubt) by looking at a few typical architectures, discussing risks at each point, identifying options for protecting the vulnerabilities, and what we've seen typically done (if anything) in practice. While this talk primarily uses Microsoft SQL Server as the example/guinea pig, especially the database engine and SSIS, the discussion will be applicable to any solution.

SessionID: 48821

Partitioning Basics: Treating Your Tables Like Legos

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Brandon Leach

Title: Partitioning Basics: Treating Your Tables Like Legos

Abstract:

Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!

With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll also look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how to make decisions on how and when to implement.

SessionID: 48918

Connecting Power BI to On-Prem Data with SSAS

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Kerry Tyler

Title: Connecting Power BI to On-Prem Data with SSAS

Abstract:

Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company's data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn't require data in the cloud.

SessionID: 49450

Introduction to the Power BI Desktop

Back to calendar

Event Date: 21-05-2016 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Patrick LeBlanc

Title: Introduction to the Power BI Desktop

Abstract:

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

SessionID: 45521

Azure SQL Database for the Production DBA

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Azure SQL Database for the Production DBA

Abstract:

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

SessionID: 45530

SQL Server Internals

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 46135

Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos

Abstract:

Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious!

SessionID: 46265

Clusters! From the ground up, let's build one together

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Paul Popovich Jr

Title: Clusters! From the ground up, let's build one together

Abstract:

You're looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides. Let's learn what a cluster is and why it might be the right thing for you. We'll explore the system, network, storage and database administration sides of the equation. And, when it's all said and done we'll even have built a SQL clustered instance!

SessionID: 46380

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Strategy and Architecture

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

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

Enhancing Data and Predictive Analytics with Azure HDInsight

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Cornell Emile

Title: Enhancing Data and Predictive Analytics with Azure HDInsight

Abstract:

The pervasiveness of Big Data has created significant challenges for companies that have historically utilized relational database management systems to perform data analysis and predictive analytics. This presentation outlines the challenges that stem from Big Data as it relates to deriving value from data and how Azure HDInsight can serve as a data platform that significantly enhances the data analysis and predictive analytics capabilities of companies.

SessionID: 46592

Advanced Error Tracking for Quick Diagnosis

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Information Delivery

Speaker: Matt Martin

Title: Advanced Error Tracking for Quick Diagnosis

Abstract:

In this session, we will walk through how to build a detailed error notification service for SQL Server that will trap errors, and email you a well formatted and detailed error report on what went wrong. In many organizations, you typically have SQL agent jobs running, and when failures occur, you get a generic email with a jumbled up message about the error, but it doesn't really help you understand where and at what point did your stored procedure fail.

In this class, we will introduce and go through how to pinpoint errors in real time, and how to identify troubling areas or bottlenecks in stored procedures. In the end, you will have a notification and error handling system that sends you a well formatted email alert with an html table output to show you the events that led up to the error, and what exactly the error was. This toolset has saved many developers and DBA's tons of time researching failures in jobs, and we hope it helps you too!

SessionID: 46811

DBA 911 - Database Corruption

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: DBA 911 - Database Corruption

Abstract:

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands such as DBINFO, CHECKDB and PAGE. You'll learn how to monitor for corruption with SQL Server Agent Alerts and Jobs, and when it's time to restore instead of repair. After attending this session, you will be able to check for issues such as page corruption or data purity problems, and take the appropriate measures to deal with them.

SessionID: 47044

Execution Plans for Mere Mortals

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

As a beginner database professional, execution plans are intimidating. In this session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.

You will understand how, why and when the execution plan will be created and saved to plan cache.

Reading the execution plan will be much less intimidating as we walk through the flow and process of a graphical execution plan.

After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance tuning opportunities.

Finally, you will be able to capture the execution plan, save it for analysis and comparison after modifications have occurred.

SessionID: 48215

T-SQL Window Functions for Analytics

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Mark Tabladillo

Title: T-SQL Window Functions for Analytics

Abstract:

SQL Server 2016 includes advanced T-SQL window functions. These functions allow for high performance native T-SQL, combining three categories of functions with the OVER clause:

• Analytic Functions
• Ranking Functions
• Aggregate Functions

Advanced Excel analysts might be creating similar output with Excel: though intermediate to heavy equation usage is better with SQL Server (Developer Edition recommended). These functions are recommended for feature creation in data science. This presentation will cover the basics of the three T-SQL categories and provide use cases and demos, especially for advanced analytics and machine learning.

SessionID: 48348

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

SessionID: 48529

Azure SQL Database: Deployment and Development of Your First DB

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Sven Aelterman

Title: Azure SQL Database: Deployment and Development of Your First DB

Abstract:

Azure SQL Database offers compelling features for developers, especially those creating cloud applications. In this session, you'll learn about the Azure SQL Database platform and the tools provided for deployment and management of your databases. Demos will provide step-by-step examples of creating a SQL Server and Azure SQL Database, deploying a database using various methods and then managing that database.

SessionID: 48630

Dimensional Modeling Design Patterns: Beyond the Basics

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond the Basics

Abstract:

Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.

In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.

SessionID: 48856

SQL Auditing - Getting A View Of Yesterday's Activity Today

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brad McKuhen

Title: SQL Auditing - Getting A View Of Yesterday's Activity Today

Abstract:

When trouble strikes, often it's the simplest, most recent changes needing addressed first. In this session, we'll explore tools, SQL Server features, and some suggested guidelines to help close the gap between the system today and who did what yesterday, so you can make better choices about the changes to make tomorrow.

SessionID: 48946

Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Julie Smith

Title: Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.

Abstract:

How much Azure can you Azure? How many cloud can you cloud? Hear the lessons learned from an attempt at an “All Azure” BI Project. We’ll explore Azure SQL Database, Azure Data Factory and Power BI as pieces of the solution and learn where On Prem had to be used to fill in the gaps in the solution.

SessionID: 50494

TechGirlz How You Can Help Usher In The Next Generation

Back to calendar

Event Date: 21-05-2016 - Session time: 14:30:00 - Track: Professional Development

Speaker: Lindsay Clark

Title: TechGirlz How You Can Help Usher In The Next Generation

Abstract:

Middle school aged girls often lose interest in STEM topics. Come learn how you can help usher in the next generation of technology gurus. TechGirlz is a grassroots effort to enable busy technology professionals give back to their local communities in a major way, putting the power of technology in the minds of young girls to help keep the spark of interest in the tech fields for future job markets.

SessionID: 45874

Administering SQL Server on Server Core with PowerShell

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: Administering SQL Server on Server Core with PowerShell

Abstract:

Ever wondered what the craze of Server Core is all about? There is a lot of power in Core and with it comes the admin challenge of NO GUI. But there are settings that you want to change in the OS, how do you do that? This session will take you through some of the challenges that are not really challenges when you know. We will use the builtin method of making some changes and also use PowerShell and commandline tools to get you where you want to be with Core. I built a 6 node cluster on Server Core and created it with PowerShell (Cluster and all) and it runs very nicely with a little footprint in RAM for the effort.

SessionID: 46055

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Ed Watson

Title: Introduction to SQL Server Integration Services

Abstract:

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

SessionID: 46258

Insight through Spatial Data

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Vladimir Oselsky

Title: Insight through Spatial Data

Abstract:

Introduction to SQL Server spatial data types. For starters will create basic geometric shapes and discuss how it can be used to improve search of complex polygons. Next will discuss spatial data type static functions and touch on spatial indexes. Lastly will create SSRS and Power BI reports using spacial data. Focus will be on real world examples from transportation industry (U.S. Xpress, Inc.) and how spatial data and report can be used to make correct decisions.

SessionID: 46259

Continuous Deployments using SSDT

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Christopher Wolff

Title: Continuous Deployments using SSDT

Abstract:

DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I'll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.

SessionID: 46840

Parameter Sniffing the Good, the Bad and the Ugly

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good, the Bad and the Ugly

Abstract:

Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

SessionID: 47058

Vote or Die 2016: Which is Faster?

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Other

Speaker: Robert Verell

Title: Vote or Die 2016: Which is Faster?

Abstract:

Ever wondered what's faster between a bulk insert and BCP? What about powershell vs SSIS? This session will review multiple topics of SQL Server that include development, ETL, and administration. In the spirit of the election season, this session will feature having the ability to debate and vote on which of each technology you think we will be best, and if your "candidate" wins, your votes will be entered into a drawing; so the more votes you win the more chances you get!

SessionID: 47116

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

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

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

Abstract:

Microsoft markets SQL Server as a "self-tuning" RDBMS, yet you've heard there are a variety of knobs and switches available to impact performance. Are you curious to know what they are, what they do, and when to use them? In this session you will learn about server and database configuration options and trace flags that can impact performance, alter default behaviors and help your troubleshooting efforts.

SessionID: 47148

Small Scale Data Collection Using PowerShell - Going NSA Style!

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Jana Sattainathan

Title: Small Scale Data Collection Using PowerShell - Going NSA Style!

Abstract:

While we are not the NSA, certain vital data needs to be collected – for example audit data, trace data, session information, performance data etc. – all to a central SQL Server repository, for analysis. In this session let us see how freely available PowerShell code can be used to collect data from multiple SQL Servers instances/databases. At the end of this session, you will have the knowledge and ability to collect pretty much any data to a central repository with just a couple of lines of code all in a manner that works specifically for you!

SessionID: 47616

SSIS Unit and Integration Testing with the Open Source BEST project

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Scott Currie

Title: SSIS Unit and Integration Testing with the Open Source BEST project

Abstract:

Testing is critical to managing a high-quality data lifecycle. Unfortunately, SSIS has no built-in support for test authoring and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered.

Biml Enabled SSIS Test (BEST) [https://github.com/bimlscript/best] is an open source framework that enables users to define unit and integration tests for SSIS packages using your choice of database tables, Excel files, or XML.

In this session, you will learn how to use BEST to author your SSIS tests and how to use free open source tools to report and visualize test results as part of your existing production processes.

Note that while BEST is implemented using Biml, you do not need to learn Biml to use it.

SessionID: 48257

Incrementally Moving to the Cloud Using Biml

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Scott Currie

Title: Incrementally Moving to the Cloud Using Biml

Abstract:

Many organizations are interested in the cost savings, ease of maintenance, and other benefits of hosting data solutions on Microsoft Azure. For most, moving to the cloud is easier said than done, especially when they have a large existing solution that is being actively used by stakeholders.

In this session, we will examine various strategies for incrementally moving your solution to the cloud. This will include strategies that incorporate the use of:

1. New value-added features and services, such as machine learning and big data
2. Hybrid approaches where portions of your existing solutions can be moved to the cloud without requiring everything to be moved
3. Failover and surge approaches that enable the cloud to supplement on premises resources
4. and much more

Business Intelligence Markup Language (Biml) will be central to our approach, enabling the rapid movement of assets back and forth between on premises and cloud hosting.

All code will be shared with attendees.

SessionID: 48466

Whip Away Stress at Home Work to Create a Better You

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45: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: 48633

SSMS Tips and Tricks

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Wayne Sheffield

Title: SSMS Tips and Tricks

Abstract:

Almost everyone uses SSMS to write queries and to browse around on the server - but do you use all of the features that SSMS offers to increase your productivity? Most people use few of these, and probably don't even know that many of these features even exist. Come to this session, consisting almost entirely of demos in SSMS, to see features built in to SSMS that will improve your experience and productivity. Time permitting; we'll also go into some 3rd party products that also increase your productivity in SSMS.

SessionID: 48900

More than Just a basic Database Backup and Recovery

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Daniel Taylor

Title: More than Just a basic Database Backup and Recovery

Abstract:

During our time together we are going to take a quick look into backup and recovery techniques for Full, Differential, and log backups. We will then take a look at how SQL Server keeps track of what will be included within out differential backups. While we’re at it lets look at our transactions logs prior to and post log backups. Next up we will look into advanced recovery scenarios such as piecemeal, point in time, file group, and page recoveries. If you manage databases or like doing recoveries let’s have some fun together during this sessions.

SessionID: 48939

Backups Restores: You're Not In Kansas Anymore!

Back to calendar

Event Date: 21-05-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: John Morehouse

Title: Backups Restores: You're Not In Kansas Anymore!

Abstract:

There is no place like home, there is no place like home! When a database crashes and you have to recover it, this may be what you're saying to yourself over and over. It can feel like a house just landed on you if you're not prepared. Ok, not really, but recovering a database from an unexpected event is often just as terrifying! If you aren't prepared for it, it's really going to hurt. So what do you do? You prepare. You plan. You practice. We'll talk about how the backup restore process works in SQL Server and how it can help you prevent a Wizard of Oz situation!

This site is open source. Improve this page.