sqlsathistory

Nr: 392

Back to Main list

SQLSaturday #392 - Atlanta 2015

Start Time (24h) Speaker Track Title
00:00:00 Gene Webb DBA Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner
00:00:00 Michael Fal DBA Getting Started with Database Automation
00:00:00 Michael Fal DBA Powershell and the Art of SQL Server Deployment
08:15:00 Dave Mattingly Reporting Visualization Database: The Motion Picture
08:15:00 Dave Fackler DBA Clustered Columnstore Indexes in SQL Server 2014
08:15:00 Dan Holmes DBA Emulating a SELECT Trigger if Such a Thing Existed
08:15:00 Louis Davidson DEV Database Design Fundamentals
08:15:00 Jeff Reinhard DBA Sliding Window Table Partition Intro
08:15:00 Jim Christopher PowerShell Closing the SSIS Package Management Story with BIPS
08:15:00 Rick Lowe DEV Why should I care about the plan cache?
08:15:00 Scott Currie BIML SSIS Unit and Integration Testing with the Open Source BEST project
08:15:00 Kevin Boles DBA SQL Server Defaults SUCK!!
08:15:00 Teo Lachev BI Increase Your BI Developer Productivity with Community Samples
09:30:00 Jason Brimhall DBA Using Extended Events in SQL Server
09:30:00 Daniel Glenn DBA Tuning SQL Server for SharePoint
09:30:00 Javier Guillen BI Are users working against you? Manage human factors to achieve BI success
09:30:00 Jeffrey Garbus DEV Indexing for Join Optimization
09:30:00 Paco Gonzalez Big Data Data Science Sentiment Analysis with Big Data
09:30:00 Reeves Smith BIML Increase your SSIS productivity with Biml
09:30:00 Lindsay Clark DBA Beginners SQL Server Security the Low Hanging Fruit
09:30:00 Sven Aelterman DEV Gentle Introduction to T-SQL Window Functions
09:30:00 Justin Dearing DBA Version control with GIT for the DBA
09:30:00 Amir Charania ETL/SSIS SSIS 2014: Project Deployment Configuration using SSIS Catalog
10:45:00 Mike Robbins PowerShell PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'
10:45:00 William Wolf DEV Common Coding Mistakes and how to Mitigate them
10:45:00 Phil Pledger DEV Choosing the right clustering key
10:45:00 Robert Biddle ETL/SSIS Loading a Data Warehouse with SSIS
10:45:00 Robert Verell Availability Replication Getting Started With SQL Server Replication
10:45:00 Bill Anton BI 20-Minute Tabular Model
10:45:00 Kevin Hazzard BIML The Absolute Beginner's Guide to BIML
10:45:00 Mark Tabladillo Big Data Data Science Microsoft Technologies for Data Science
10:45:00 Michael Fal DBA Powershell Tips and Tricks for SQL Server Administration
10:45:00 Rob Volk Ask Doc Einstein! Ask Doc Brown and Einstein!
10:45:00 Amy Herold DBA Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
10:45:00 Robert Cain DEV Database Development Using SQL Server Data Tools
11:45:00 Carl Berglund Availability Replication Standalone to High-Availability Clusters over Lunch—with Time to Spare
11:45:00 Gene Webb BI Learn How To Build A Golden Record for Any Subject Over Lunch!
11:45:00 Rie Irish Professional Development Girl, Interrupted: Supporting Women's Voices - Sponsored by Intellinet
11:45:00 Gary Serda Sponsor/Lunch Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS
11:45:00 SIOS Technology Availability Replication Clusters Your Way: #SANLess clusters for physical, virtual cloud environments
11:45:00 Brett Johnson Sponsor/Lunch SQL Server and Microsoft Business Solutions - Tegile
11:45:00 Rob Volk Ask Doc Einstein! 1.21 Gigawatt Talks!
11:45:00 Denny Cherry Sponsor/Lunch SQL Server Clinic
11:45:00 Mark Scott Sponsor/Lunch Learn about Governed Data Discovery with Pyramid Analytics
13:15:00 Carla Sessions BIML How I Became a BIML Believer
13:15:00 Carlos Rodrigues ETL/SSIS Making your SSIS Fly Beyond the Sky
13:15:00 Denis McDowell Sponsor/Lunch DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
13:15:00 Jason Thomas BI Memoirs of Building a 150 GB (and growing) SSAS Tabular Model
13:15:00 Jon Boulineau DEV Continuous Integration with SQL Server Data Tools
13:15:00 miguel Cebollero DEV SQL Server 2014 In-Memory Programming
13:15:00 Denny Cherry DEV Index Internals
13:15:00 Pam Shaw Reporting Visualization Tips Tricks for dynamic SSRS Reports
13:15:00 Lance Tidwell DEV Parameter Sniffing the Good and the Bad
13:15:00 Damu Venkatesan ETL/SSIS Self-Service ETL with Microsoft Power Query
13:15:00 Aaron Nelson PowerShell Awesome PowerShell for SQL 2014
13:15:00 Michael French Professional Development Independent Contracting 101
13:15:00 Allan Hirt Availability Replication Business Continuity: The Real Reason for HA and DR
14:30:00 Ben Miller DBA SQL Server Encryption
14:30:00 Brian Moran Professional Development 9 secrets to independent consulting success
14:30:00 Ed Watson DBA Performance Tuning for Mere Mortals Part I
14:30:00 Jason Horner BI Dimensional Modeling Design Patterns: Beyond Basics
14:30:00 Joseph D'Antoni DBA Becoming a Top DBA--Learning Automation in SQL Server
14:30:00 Mark Fugel DEV Unit Testing with tSQLt an Open Source Testing Framework for SQL
14:30:00 Rafael Salas ETL/SSIS Design principles for robust ETL processes
14:30:00 Wes Springob Reporting Visualization Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
14:30:00 Chad Churchwell Availability Replication Introduction to SQL Server Clustering
14:30:00 Steve Wake ETL/SSIS Near Real-Time Data Warehouse Updates with CDC SSIS
14:30:00 Stuart Ainsworth Big Data Data Science Eating The Elephant; A DBA's Guide to Hadoop Big Data
14:30:00 Tim Radney Professional Development Getting involved and Getting ahead
14:30:00 Wayne Sheffield DEV Table Vars Temp Tables - What you NEED to Know!
14:30:00 Andy Leonard BIML Using BIML as an SSIS Design Patterns Engine
15:45:00 Julie Smith BI Master Data Management with MDS, DQS and SSIS
15:45:00 David Dye ETL/SSIS Advanced SSIS Techniques
15:45:00 Jim Wooley DEV Entity Framework performance monitoring and tuning
15:45:00 James McAuliffe DEV Changing Data Is Easy, Managing Data Change is Hard!
15:45:00 John Welch BI Continuous Delivery for Data Warehouses and Marts
15:45:00 John Deardurff DEV What's your Character Type?
15:45:00 John Morehouse DBA Only You Can Prevent Database Fires!
15:45:00 Kevin Kline DBA SQL Server Internals and Architecture
15:45:00 Luis Figueroa Reporting Visualization R intro for the SQL Server Pro
15:45:00 Mike Lawell DBA Performance Tuning for Mere Mortals Part II
15:45:00 Melissa Coates BI Power BI as a Self-Service BI Platform: Architecture, Strengths, and Shortcomings
15:45:00 Tim Radney DBA Understanding SQL Backups and Restores

SessionID: 14447

Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Back to calendar

Event Date: 16-05-2015 - Session time: 00:00:00 - Track: DBA

Speaker: Gene Webb

Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Abstract:

What is master data management and why should I care about it?

What does the master data services components of SQL Server do for me? Overview of all features of MDS How to build out an MDM subject area How to use MDS for reference data management How to use MDS for data quality How to use MDS with a data warehouse to improve data quality

SessionID: 34780

Getting Started with Database Automation

Back to calendar

Event Date: 16-05-2015 - Session time: 00:00:00 - Track: DBA

Speaker: Michael Fal

Title: Getting Started with Database Automation

Abstract:

Automation is a data professional’s best friend in times of need. Automating our tasks builds consistency, reduces errors, and lightens our workload. The problem is, it is difficult to know how, what, and where to start automating. This session will cover building automation, from defining your process, to choosing your tools, and implementing it into your environment. We will use case studies to walk you through the process and give you concrete examples of how you can build automation in your own environment.

SessionID: 34781

Powershell and the Art of SQL Server Deployment

Back to calendar

Event Date: 16-05-2015 - Session time: 00:00:00 - Track: DBA

Speaker: Michael Fal

Title: Powershell and the Art of SQL Server Deployment

Abstract:

In today’s tech world, IT professionals are being driven to perform tasks faster and more consistently. Automation is the watchword for our success, whether we are deploying SQL Server to private virtual clouds or public platforms such as Azure IaaS. This session will focus on rapidly creating and configuring SQL Servers using Powershell and Desired State Configuration. You will see practical examples of how you can create repeatable builds of SQL Server that can be deployed in a matter of minutes. We will also review how these techniques can be applied to both public and private cloud platforms, ensuring your success for any situation.

SessionID: 12253

Database: The Motion Picture

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: Reporting Visualization

Speaker: Dave Mattingly

Title: Database: The Motion Picture

Abstract:

Power up your data presentations with Power View and Power Map. Charts and maps can be made interactive, generated on the fly, or recorded as video with a soundtrack and special effects. Instead of trying to make your point with a boring list of names, numbers, and dates, put on your movie director's hat and give your data the Hollywood treatment as you yell, "Lights! Cameras! Action!"

SessionID: 12349

Clustered Columnstore Indexes in SQL Server 2014

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA

Speaker: Dave Fackler

Title: Clustered Columnstore Indexes in SQL Server 2014

Abstract:

SQL Server 2012 introduced columnstore indexing but with one major drawback -- columnstore indexes were not updateable. Thus, adopting them to improve data warehousing (or other) query patterns took careful planning and quite a bit of management. SQL Server 2014 introduces clustered columnstore indexes that are now fully updateable! During this session, we'll take a look at how clustered columnstore indexes work, what implications exist for using them, and how the update process is handled. We'll also take a look at what management and maintenance operations are required to keep clustered columnstore indexes performing optimally. Anyone with a large data warehouse environment (or even an OLTP or ODS database with very large tables) will definitely want to attend!

SessionID: 13351

Emulating a SELECT Trigger if Such a Thing Existed

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA

Speaker: Dan Holmes

Title: Emulating a SELECT Trigger if Such a Thing Existed

Abstract:

SELECT triggers don't exist but what if they did? What if you could capture the statement, get a parse tree, or the plan and change what happens? What would you be able to do? What problems could you solve? What are the limitations? Let's go outside the box and see what we can see. Join me on this interesting but unorthodox journey into what SQLServer can do. You decide if it should.

SessionID: 13494

Database Design Fundamentals

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DEV

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

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

SessionID: 16288

Sliding Window Table Partition Intro

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA

Speaker: Jeff Reinhard

Title: Sliding Window Table Partition Intro

Abstract:

A walk-through of creating a sliding window table partition on an AdventureWorks table.

SessionID: 16840

Closing the SSIS Package Management Story with BIPS

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: PowerShell

Speaker: Jim Christopher

Title: Closing the SSIS Package Management Story with BIPS

Abstract:

Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server. Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages.

BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.

In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.

SessionID: 22985

Why should I care about the plan cache?

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DEV

Speaker: Rick Lowe

Title: Why should I care about the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick's "Why should I care" series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV's for the newly motivated audience.

SessionID: 24056

SSIS Unit and Integration Testing with the Open Source BEST project

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: BIML

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

SQL Server Defaults SUCK!!

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA

Speaker: Kevin Boles

Title: SQL Server Defaults SUCK!!

Abstract:

If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

SessionID: 26941

Increase Your BI Developer Productivity with Community Samples

Back to calendar

Event Date: 16-05-2015 - Session time: 08:15:00 - Track: BI

Speaker: Teo Lachev

Title: Increase Your BI Developer Productivity with Community Samples

Abstract:

Microsoft has always provided a comprehensive toolset for BI developers but functionality gaps remains. In attempt to fill in some of these gaps, MVPs and community have implemented outstanding tools. Join this session to learn how to increase your developer productivity and improve your BI solutions by using BIDS Helper, DAX Studio, DAX Editor, Query Capture, and OLAP Extensions. This session assumes developer experience in designing and implementing BI solutions with SSAS, SSRS, and SSIS.

SessionID: 10859

Using Extended Events in SQL Server

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA

Speaker: Jason Brimhall

Title: Using Extended Events in SQL Server

Abstract:

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

SessionID: 12179

Tuning SQL Server for SharePoint

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA

Speaker: Daniel Glenn

Title: Tuning SQL Server for SharePoint

Abstract:

We will discuss SQL and SharePoint integration concepts, walk through the different types of SharePoint databases, and get you more comfortable with the SharePoint platform.

Some of the topics covered will include: the configuration steps and settings needed for SQL Server to properly host SharePoint databases, database size considerations, the SQL permissions your SharePoint administrators REALLY need, and why SharePoint databases have a GUID in their name (and how to avoid them!).

SessionID: 16028

Are users working against you? Manage human factors to achieve BI success

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: BI

Speaker: Javier Guillen

Title: Are users working against you? Manage human factors to achieve BI success

Abstract:

As new technology cycles emerge, we find ourselves immersed in a growing diversity of tools and infrastructures. Success in Business Intelligence, however, depends often on our capacity to increase adoption and is not always tied to the degree of engineering sophistication.

Too often we experience adoption issues that account for partial or complete failures for BI delivery. Are users satisfied with BI assets? Do they continue to build information 'silos'? Are they reluctant to change and utilize governed data sets?

In this presentation, attendees will learn about a perspective that can help increase ROI on BI delivery by actively targeting human factors critical to achieving success.

SessionID: 16336

Indexing for Join Optimization

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DEV

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

Sentiment Analysis with Big Data

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: Big Data Data Science

Speaker: Paco Gonzalez

Title: Sentiment Analysis with Big Data

Abstract:

People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning

SessionID: 22807

Increase your SSIS productivity with Biml

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: BIML

Speaker: Reeves Smith

Title: Increase your SSIS productivity with Biml

Abstract:

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.

SessionID: 24447

Beginners SQL Server Security the Low Hanging Fruit

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA

Speaker: Lindsay Clark

Title: Beginners SQL Server Security the Low Hanging Fruit

Abstract:

Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.

SessionID: 25922

Gentle Introduction to T-SQL Window Functions

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DEV

Speaker: Sven Aelterman

Title: Gentle Introduction to T-SQL Window Functions

Abstract:

Since their infancy in SQL Server 2005 and their growth spurt in SQL Server 2012, T-SQL window functions have provided new ways to solve fairly common end-user query requests. However, their successful use requires thinking a little differently about sets than you're used to. In this session, you will explore the basic concepts of ordering, partitioning and framing. Everything will be demonstrated with easy to follow examples that you will be able to adapt quickly to your query needs.

SessionID: 28345

Version control with GIT for the DBA

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA

Speaker: Justin Dearing

Title: Version control with GIT for the DBA

Abstract:

What does this mean to a DBA? Well. whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We will cover:

What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?

We will be covering using git from both the command line and Vis

SessionID: 9397

SSIS 2014: Project Deployment Configuration using SSIS Catalog

Back to calendar

Event Date: 16-05-2015 - Session time: 09:30:00 - Track: ETL/SSIS

Speaker: Amir Charania

Title: SSIS 2014: Project Deployment Configuration using SSIS Catalog

Abstract:

Are you an ETL Developer that has worked with SSIS 2008 or earlier? If so, you will be excited to learn about some of the new features in SSIS 2012 that make your life a lot easier! In this demo-driven session, we will go through the entire process of building, configuring, deploying, executing and reporting on SSIS packages using the Project Deployment Model. You will see how multiple packages are deployed at one time, how project parameters make configuring your packages a breeze, how environment variables help you move your packages from DEV to UAT to PROD, how project level connection managers help you share connections across packages, and Integration Services Dashboard gives you detailed logging so you can identify the cause of package failure with no extra coding.

By the end of this session, you will be ready to start taking advantage of these new features in your own environment.

SessionID: 20709

PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'

Abstract:

SessionID: 22095

Common Coding Mistakes and how to Mitigate them

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DEV

Speaker: William Wolf

Title: Common Coding Mistakes and how to Mitigate them

Abstract:

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.

SessionID: 22259

Choosing the right clustering key

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DEV

Speaker: Phil Pledger

Title: Choosing the right clustering key

Abstract:

The choice of clustering key can make a huge impact on performance and storage. In this session, we will explore the factors that influence the decision and how to measure the differences that the decision made.

SessionID: 23154

Loading a Data Warehouse with SSIS

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: ETL/SSIS

Speaker: Robert Biddle

Title: Loading a Data Warehouse with SSIS

Abstract:

You've just been assigned a data warehouse project. Maybe you've figured out what tables you want to work with, but outside of that you don't really know how to get started. In this session we'll cover some of the basics of data warehousing, and then we'll show how to use SSIS as an ETL tool to load a Kimball data warehouse.

SessionID: 23255

Getting Started With SQL Server Replication

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: Availability Replication

Speaker: Robert Verell

Title: Getting Started With SQL Server Replication

Abstract:

In this session we will examine how SQL Server replication works. A technology that has been around, this tool is not going anywhere anytime soon. It's an excellent way to keep a subset of data synched with another database without having to synch the entire thing (although you could if you wanted to!). We will examine terms, internals, and walk through the setup of transactional and snapshot replication pieces so you can implement this technology in your environment and use it as a valuable tool in your personal knowledge book.

SessionID: 28181

20-Minute Tabular Model

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: BI

Speaker: Bill Anton

Title: 20-Minute Tabular Model

Abstract:

The Tabular model is still the new kid on the block in the world of SQL Server Analysis Services, and its importance in the Microsoft BI roadmap continues to grow. Based on xVelocity, a highly compressed in-memory technology, Tabular models promise considerable performance improvements over Multidimensional models in many scenarios. 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 basic Tabular model.

SessionID: 28254

The Absolute Beginner's Guide to BIML

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: BIML

Speaker: Kevin Hazzard

Title: The Absolute Beginner's Guide to BIML

Abstract:

You've been curious about the Business Intelligence Markup Language (BIML) but you just don't know where to start. In fact, you don't even know enough to be sure that you're really interested in learning more about it. Invest one hour in this session and you'll know for sure if BIML's pattern-based code generation tools can add value to your projects. You'll learn how BIML can emit ETL projects dynamically from metadata. You'll also discover how to create multidimensional cubes in a fraction of the time it normally takes. And while these sound like complex subjects, this session will help you understand how BIML makes traditionally time-consuming and error-prone tasks like these more efficient, predictable and consistent.

SessionID: 34748

Microsoft Technologies for Data Science

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: Big Data Data Science

Speaker: Mark Tabladillo

Title: Microsoft Technologies for Data Science

Abstract:

Microsoft provides several technologies in and around SQL Server which can be used for casual to serious data science. This presentation provides an authoritative overview of five major options: SQL Server Analysis Services, Excel Add-in for SSAS, Semantic Search, Microsoft Azure Machine Learning, and F#. Also included are tips on working with Python and R. These technologies have been used by the presenter in various companies and industries. Bring your beginner to advanced questions!

SessionID: 34779

Powershell Tips and Tricks for SQL Server Administration

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DBA

Speaker: Michael Fal

Title: Powershell Tips and Tricks for SQL Server Administration

Abstract:

Have you dipped your toe into the Powershell pool, but are still lost on how you can make it work for you? Maybe you're just looking for a few more tools to help you better manage SQL Server administration? In this session, we will cover a handful of useful scripts and patterns in Powershell that will ease your management of SQL Server. Backups, file management, instance configuration, and several other areas will be covered. By attending this session, you will learn more about how you can use Powershell effectively in your environment.

SessionID: 37062

Ask Doc Brown and Einstein!

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: Ask Doc Einstein!

Speaker: Rob Volk

Title: Ask Doc Brown and Einstein!

Abstract:

Do you have a pressing question about SQL Server? Or Time Travel? We have a number of experts that can answer your questions! Stop by Room 205 throughout the day and get your tough SQL Server questions answered by experts in the community! You can also ask about career advice and professional development if you're looking to get into or get better at your SQL Server skills.

SessionID: 9410

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

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DBA

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

Database Development Using SQL Server Data Tools

Back to calendar

Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DEV

Speaker: Robert Cain

Title: Database Development Using SQL Server Data Tools

Abstract:

As a developer, you are using Visual Studio to manage your C#, VB.Net, and other projects. Why not your database projects as well?

As a DBA, you are using SQL Server Management Studio (SSMS) to develop your database projects. But as an experienced DBA, you can get frustrated quickly with its limitations.

There's a better way! Database Development got completely revamped with the release of SQL Server Data Tools. A FREE download, SQL Server Data Tools, or SSDT for short, allows you to manage the development of databases with a powerful, yet easy to use project interface.

In this session we'll look at the tools included with SSDT such as the all new localdb, database snapshots, and the new way to publish your database. You'll also learn how to reverse engineer existing databases into your project, as well as how to do safe refactoring. See how to streamline your database development with SSDT!

SessionID: 11171

Standalone to High-Availability Clusters over Lunch—with Time to Spare

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Availability Replication

Speaker: Carl Berglund

Title: Standalone to High-Availability Clusters over Lunch—with Time to Spare

Abstract:

Don’t miss this demonstration of the hot new container technology that will change your assumptions about what it takes to implement high-availability clusters. Join DH2i’s Carl Berglund as he transforms standalone SQL Server instances of different versions and editions into an automated HA cluster failing over between systems—in just a few minutes. In fact, he’ll have plenty of time left over to show you some other cool tricks with his new cluster, such as: QoS controls at the instance level, SQL and OS updates as fast as an application stop/start, and multi-subnet geo-clustering capabilities. And you’ll still have time to grab dessert.

SessionID: 14448

Learn How To Build A Golden Record for Any Subject Over Lunch!

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: BI

Speaker: Gene Webb

Title: Learn How To Build A Golden Record for Any Subject Over Lunch!

Abstract:

Attend the lunch demo and see how you can use Master Data Services and Maestro to:

• Create a golden record for any subject area in a matter of minutes Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? • Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? • Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting • Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise

SessionID: 36841

Girl, Interrupted: Supporting Women's Voices - Sponsored by Intellinet

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Professional Development

Speaker: Rie Irish

Title: Girl, Interrupted: Supporting Women's Voices - Sponsored by Intellinet

Abstract:

Next time you attend a meeting, watch what happens when females at the table offer ideas. If your office is like most in America, you’ll notice females are interrupted almost three times as often as their male counterparts. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.

This group discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 37004

Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch

Speaker: Gary Serda

Title: Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS

Abstract:

Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.

SessionID: 37006

Clusters Your Way: #SANLess clusters for physical, virtual cloud environments

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Availability Replication

Speaker: SIOS Technology

Title: Clusters Your Way: #SANLess clusters for physical, virtual cloud environments

Abstract:

Abstract: SQL Server MVP Geoff Hiten will discuss how to create #SANLess clusters in environments where traditional shared storage clusters are impractical or impossible: specifically local high performance clusters leveraging SSD/Flash-based storage and clustering in the cloud - no SAN (or SAN Admin required). He will also touch upon cost-effective disaster recovery options without the need for SAN replication.

SessionID: 37011

SQL Server and Microsoft Business Solutions - Tegile

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch

Speaker: Brett Johnson

Title: SQL Server and Microsoft Business Solutions - Tegile

Abstract:

will send via email

SessionID: 37063

1.21 Gigawatt Talks!

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Ask Doc Einstein!

Speaker: Rob Volk

Title: 1.21 Gigawatt Talks!

Abstract:

GREAT SCOTT! You never know when or where a bolt of lightning will strike! But we do now! Come to this session and hear some local and SQL Server community speakers give brief, intense flashes of insight to the audience! And if you have a topic you can present in 5 minutes or less, COME PREPARED! You never know when it might be your chance to get up there! If you put your mind to it, you can accomplish anything!

SessionID: 37164

SQL Server Clinic

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch

Speaker: Denny Cherry

Title: SQL Server Clinic

Abstract:

Join a panel of SQL Server MVPs including Denny Cherry Joey D’Antoni for the SQL Server Clinic. The SQL Server Clinic will be a free style question and answer session where you can ask your SQL Server questions to your favorite authors, consultants and SQL Server experts. Grab your lunch, grab a seat and bring your questions about SQL Server, Consulting, etc.

SessionID: 37235

Learn about Governed Data Discovery with Pyramid Analytics

Back to calendar

Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch

Speaker: Mark Scott

Title: Learn about Governed Data Discovery with Pyramid Analytics

Abstract:

Mark Rob will show you how you can Supercharge your Microsoft BI with Pyramid Analytics “BI Office”. See how BI Office gives you the “freedom to” Scale, Maximize, Visualize, and Mobilize your business users with the new Version 5. Attendees will see how easy it is to go from Analytics to Dashboards and reports in just 45 minutes. Additionally Mark will show you our mobile dashboard offering on the new iPad Air.

SessionID: 11174

How I Became a BIML Believer

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: BIML

Speaker: Carla Sessions

Title: How I Became a BIML Believer

Abstract:

A year ago at SQL Saturday #285 in Atlanta I was introduced to BIML for the first time. Leaving the session, I thought that it was a good tool for some small use cases; I could not have been more wrong. A few months later, I had a chance to use it on a project that made me believe in the true power of BIML. In this session, my mentor on the project, and I will share what I learned in the project, and how you can have a few less growing pains on your way to becoming a BIML Believer. Here is some of what we will cover:

  1. How to import data from a flat file, and auto generate tables, views and SSIS packages based on metadata
  2. Utilizing metadata stored in a database
  3. Using BIML as a metadata store
  4. How to use BIML Annotations
  5. Helpful BimlScript extension methods
  6. Consolidating code with include files
  7. Helpful uses of C# Linq within BimlScript

All of the code and techniques in this session can be used with the free BIDS Helper add-in found on CodePlex.com

SessionID: 11222

Making your SSIS Fly Beyond the Sky

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: ETL/SSIS

Speaker: Carlos Rodrigues

Title: Making your SSIS Fly Beyond the Sky

Abstract:

How fast can an ETL package be? How big of a dataset is too big that make us wait several hours to load data? Remember those properties that you never touched because you were afraid to break something else? Well, let's try them. In this demo-rich presentation, we'll focus on some 101 tips that will maximize your package throughput. We will also go deeper toward a 200-300 level, when we will walk through some very interesting database design patterns that will ultimately affect the performance of your SSIS.

SessionID: 13080

DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: Sponsor/Lunch

Speaker: Denis McDowell

Title: DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development

Abstract:

DevOps is a term that has come to mean many things to many people. At its core, this important concept represents a way to remove old barriers between the infrastructure, application, and development tiers within an IT organization. An understanding of scripting and automation platforms is becoming a critical skill for SQL Server Database Administrators. Additionally, as hardware is increasingly virtualized, new opportunities for scripted deployment and configuration are available. This session will utilize demos to illustrate the many ways SQL Database Administrators can automate routine tasks from deployment through configuration.

SessionID: 15911

Memoirs of Building a 150 GB (and growing) SSAS Tabular Model

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: BI

Speaker: Jason Thomas

Title: Memoirs of Building a 150 GB (and growing) SSAS Tabular Model

Abstract:

Tabular models are an automatic choice for many customers with their in-memory capabilities and state-of-the-art data compression algorithms. Many of the models end up being 50 GB or lesser, achieving compression of 10 to 100x the database size. But if we ask many of the industry experts on what would be a safe size range for a tabular model performance wise, the most common answer is "It Depends". Join me as I take you through my journey of trying to find an answer to that. Watch and learn all the processes and rationale behind building this huge tabular model starting from size estimations and hardware selections. Contemplate on the design decisions (especially on the Multidimensional vs Tabular) and off-the-road architecture trying to balance Processing and Query performance. Watch out for some performance optimizations and development tips tricks you definitely do not want to miss on while working on a huge tabular model. Above all, see the performance statistics for yourself!

SessionID: 17324

Continuous Integration with SQL Server Data Tools

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV

Speaker: Jon Boulineau

Title: Continuous Integration with SQL Server Data Tools

Abstract:

After a long maturation process, SQL Server Data Tools is emerging as a huge step forward in database development. It won't be long before Visual Studio replaces SSMS as the primary IDE for SQL Server developers. One of the greatest benefits of making the switch is the continuous integration capabilities that are now streamlined by the tool set. In this session we will discuss how SSDT works, the goal of continuous integration, and how you can put them together to dramatically improve your productivity as a database developer.

SessionID: 20426

SQL Server 2014 In-Memory Programming

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV

Speaker: miguel Cebollero

Title: SQL Server 2014 In-Memory Programming

Abstract:

SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.

SessionID: 21072

Index Internals

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV

Speaker: Denny Cherry

Title: Index Internals

Abstract:

During this session we will be digging into the internals of SQL Server indexes.

If you came to this session last year, that wasn't this. Since then this session has been totally rewritten, and is mostly demos using a single command, DBCC PAGE! Come check it out, for some insides looks at how SQL Server manages and uses our data for us.

SessionID: 22370

Tips Tricks for dynamic SSRS Reports

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: Reporting Visualization

Speaker: Pam Shaw

Title: Tips Tricks for dynamic SSRS Reports

Abstract:

In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

SessionID: 24436

Parameter Sniffing the Good and the Bad

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good and the Bad

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

Self-Service ETL with Microsoft Power Query

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: ETL/SSIS

Speaker: Damu Venkatesan

Title: Self-Service ETL with Microsoft Power Query

Abstract:

In this session, I will introduce you to Microsoft's new self-service ETL tool "Power Query" for Excel. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to "M" language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn "Power Query".

SessionID: 36842

Awesome PowerShell for SQL 2014

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: PowerShell

Speaker: Aaron Nelson

Title: Awesome PowerShell for SQL 2014

Abstract:

Need to import millions of rows from a CSV in under a minute? No problem. Need to copy all the Users, Databases, and Agent Jobs from one server to another? Done. Need to update all of your development databases to have the same schema, but want to skip the update and only spit out a report if data loss might occur? Piece of CAKE!! These are some of the scenarios that we will cover in this session on how to leverage PowerShell with SQL Server 2014.

SessionID: 37174

Independent Contracting 101

Back to calendar

Event Date: 16-05-2015 - Session time: 13: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: 9276

Business Continuity: The Real Reason for HA and DR

Back to calendar

Event Date: 16-05-2015 - Session time: 13:15:00 - Track: Availability Replication

Speaker: Allan Hirt

Title: Business Continuity: The Real Reason for HA and DR

Abstract:

These days, I've stopped counting how many times I've been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.

SessionID: 10303

SQL Server Encryption

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DBA

Speaker: Ben Miller

Title: SQL Server Encryption

Abstract:

What encryption is available in your version of SQL Server? This session will cover how to set up the Encryption Hierarchy and the requirements for the new Backup with Encryption in SQL 2014. We will also cover end to end Transparent Database Encryption (TDE). This session will go over all the steps and caveats that go with this technology. Encryption is here to stay so jump on and let's take it for a ride.

SessionID: 10768

9 secrets to independent consulting success

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Professional Development

Speaker: Brian Moran

Title: 9 secrets to independent consulting success

Abstract:

Are you an independent consultant focused on Microsoft data or aspire to become one? Maybe you have a few partners or are considering joining forces with friends? This session is for you.

My 25 years of consulting experience include 15 years working for myself or with partners. This session explores the top lessons I’ve learned over that time.

This session doesn’t cover marketing or SME topics. We explore top tips related to most everything else you must know to achieve success as an IC including:

• Common reasons IC’s fail. • Customer satisfaction and happiness. • Formal and informal partnerships. • Legal stuff 101. • Bookkeeping, finance and cash flow. • Taxes and entity structures. • Building equity in your business. • Work life balance.

We often learn the most from our mistakes. 25 years of mistakes has made me an IC expert. Attending this session will shave years from your learning curve.

SessionID: 13702

Performance Tuning for Mere Mortals Part I

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DBA

Speaker: Ed Watson

Title: Performance Tuning for Mere Mortals Part I

Abstract:

In this first part of a two part series, we look at performance tuning from the very beginning. You're a new DBA, you want to be a DBA, or you've been declared an "Accidental DBA" and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? The application is running slowly. Can you help them? Do you even know where to begin to help them? In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow."

SessionID: 15877

Dimensional Modeling Design Patterns: Beyond Basics

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: BI

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond Basics

Abstract:

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

SessionID: 16223

Becoming a Top DBA--Learning Automation in SQL Server

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DBA

Speaker: Joseph D'Antoni

Title: Becoming a Top DBA--Learning Automation in SQL Server

Abstract:

Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:

• Fully Automating SQL Server Installations
• Dynamically Adding Databases to an Availability Group
• Syncing jobs and logins between Availability Group members
• Patching SQL Servers automatically
• Other techniques for process automation

This session will benefit both new and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.

SessionID: 20077

Unit Testing with tSQLt an Open Source Testing Framework for SQL

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DEV

Speaker: Mark Fugel

Title: Unit Testing with tSQLt an Open Source Testing Framework for SQL

Abstract:

This session is for anyone interested int getting started in setting up an environment where you wish to establish unit testing for SQL. It will include how to install, setup, create, run and even come to depend and even enjoy having your unit tests in place to "have your back"! Real examples will used to show how unit tests can be used to test stored procedures and functions. We will discuss how tSQLt can even be used to enforce development standards and even integrated into your automated build and release processes (such as Team City).

SessionID: 22967

Design principles for robust ETL processes

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: ETL/SSIS

Speaker: Rafael Salas

Title: Design principles for robust ETL processes

Abstract:

Is the design of your ETL processes robust? Does your ETL process keep you awake at night?

Data integration is still the most common point of failure of data centric projects and choosing a mature ETL tool, such as SSIS, is not enough. In many cases this is due to improper planning and the use of questionable design principles. During this session we will look at ETL processes from a holistic point of view to identify key areas that are often neglected and that have the potential to affect the system reliability and increase its maintenance cost. We will use SSIS to evaluate key ETL architecture areas - such as re-start ability, monitoring, error handling, among others- and discuss design principles you can use to improve the architecture of your ETL processes going forward. You will find the session valuable regardless of you level of expertise in ETL.

SessionID: 24824

Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Reporting Visualization

Speaker: Wes Springob

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract:

As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

SessionID: 24927

Introduction to SQL Server Clustering

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Availability Replication

Speaker: Chad Churchwell

Title: Introduction to SQL Server Clustering

Abstract:

This session will provide an introductory into failover clustering of SQL Server, including when and why to cluster SQL. We will cover the required components and walk through how clustering works behind the scenes

SessionID: 25722

Near Real-Time Data Warehouse Updates with CDC SSIS

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: ETL/SSIS

Speaker: Steve Wake

Title: Near Real-Time Data Warehouse Updates with CDC SSIS

Abstract:

If you need to keep a data warehouse up-to-date in near real-time, Change Data Capture (CDC) is a solution! If you are looking for a way to setup auditing of database changes, CDC is a solution! CDC has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is configured. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes in a way that can be run quickly and keep your data warehouse up-to-date.

SessionID: 25858

Eating The Elephant; A DBA's Guide to Hadoop Big Data

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Big Data Data Science

Speaker: Stuart Ainsworth

Title: Eating The Elephant; A DBA's Guide to Hadoop Big Data

Abstract:

You're a SQL Server DBA working at Contoso and your boss calls you out of your cubicle one day and tells you that the development team is interested in implementing a Hadoop-based solution to your customers. She wants you to help plan for the implementation and ongoing administration. Where do you begin?

This session will cover the foundations of Hadoop and how it fundamentally differs from the relational approach. The goal is to provide a map between your current skill set and "big data.” Although we will talk about basic techniques for querying data, the focus is on basic understanding of how Hadoop works, how to plan for growth, and what you need to do to start maintaining a Hadoop cluster. Additional discussion will cover the complementary nature of Hadoop and SQL Server.

Examples and demos will highlight basic query tools, including transferring data to and from SQL Server.

SessionID: 26726

Getting involved and Getting ahead

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Professional Development

Speaker: Tim Radney

Title: Getting involved and Getting ahead

Abstract:

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability. PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out. The rewards of the SQL Community are endless.

SessionID: 27771

Table Vars Temp Tables - What you NEED to Know!

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DEV

Speaker: Wayne Sheffield

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

Abstract:

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

SessionID: 9554

Using BIML as an SSIS Design Patterns Engine

Back to calendar

Event Date: 16-05-2015 - Session time: 14:30:00 - Track: BIML

Speaker: Andy Leonard

Title: Using BIML as an SSIS Design Patterns Engine

Abstract:

Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.

SessionID: 11132

Master Data Management with MDS, DQS and SSIS

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: BI

Speaker: Julie Smith

Title: Master Data Management with MDS, DQS and SSIS

Abstract:

Join Audrey Hammonds and Julie Smith present lessons learned from their most recent projects using the Microsoft Master Data Management tools. This session covers automated batch processing as well as the data stewardship workflow.

SessionID: 13190

Advanced SSIS Techniques

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: ETL/SSIS

Speaker: David Dye

Title: Advanced SSIS Techniques

Abstract:

As an ETL developer using SQL Server Integration Services have you ever wondered how to:

  1. Import all .csv files from a folder
  2. Replace dynamic SQL using variables in SSIS
  3. How to configure the data flow buffer
  4. Create custom logging solutions
  5. Use a script component as a data flow transformation This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties.
    Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components. Upon completion of this workshop attendees will be able to:
  6. Import/export multiple sources/destinations
  7. Use an execute SQL task with variables to replace dynamic SQL within a package
  8. Dynamically handle errors within any part of a package

SessionID: 16864

Entity Framework performance monitoring and tuning

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DEV

Speaker: Jim Wooley

Title: Entity Framework performance monitoring and tuning

Abstract:

Object Relational Mapping technologies, including the Entity Framework can drastically simplify the programming model against databases, but when done carelessly, performance can suffer. In this session, we'll explore some real-life strategies that have solved performance issues in production applications that I have encountered at a variety of customers. We'll discuss the pros and cons of working without stored procs and cover strategies for monitoring and tuning your entity queries.

SessionID: 16998

Changing Data Is Easy, Managing Data Change is Hard!

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DEV

Speaker: James McAuliffe

Title: Changing Data Is Easy, Managing Data Change is Hard!

Abstract:

Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.

SessionID: 17210

Continuous Delivery for Data Warehouses and Marts

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: BI

Speaker: John Welch

Title: Continuous Delivery for Data Warehouses and Marts

Abstract:

Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.

Most data warehouses are in a constant state of flux. There are new requirements coming in from the business, updates and improvements to be made to existing data and structures, and new initiatives that drive new data requirements. How do you manage the complexity of keeping up with the changes and delivering new features to your business users in a timely manner, while maintaining high quality? Continuous delivery is an approach for managing this. It focuses on automation of many steps in the process, so that time is spent on adding new functionality, rather than repetitive steps. Attend this session and learn how Continuous Delivery can be applied to your data projects.

SessionID: 17214

What's your Character Type?

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DEV

Speaker: John Deardurff

Title: What's your Character Type?

Abstract:

This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.

SessionID: 17268

Only You Can Prevent Database Fires!

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA

Speaker: John Morehouse

Title: Only You Can Prevent Database Fires!

Abstract:

Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!

SessionID: 18246

SQL Server Internals and Architecture

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA

Speaker: Kevin Kline

Title: SQL Server Internals and Architecture

Abstract:

SessionID: 19005

R intro for the SQL Server Pro

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: Reporting Visualization

Speaker: Luis Figueroa

Title: R intro for the SQL Server Pro

Abstract:

So you’ve heard all the buzz about R and you are ready to start the learning journey but where do you start? in this session, Luis will provide a quick overview of what R is, how to acquire, manipulate and plot simple data sets, how you can leverage your existing knowledge of T-SQL and a number of learning sources that will help you succeed in your jouRney.

SessionID: 20606

Performance Tuning for Mere Mortals Part II

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA

Speaker: Mike Lawell

Title: Performance Tuning for Mere Mortals Part II

Abstract:

This is part two of a two part series, looking at performance tuning (i.e. performance troubleshooting) from the beginning. Part II is about the next steps after taking a look at some of the free performance analysis tools. This session will go into more detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events.

This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.

There will be homework!

SessionID: 24941

Power BI as a Self-Service BI Platform: Architecture, Strengths, and Shortcomings

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: BI

Speaker: Melissa Coates

Title: Power BI as a Self-Service BI Platform: Architecture, Strengths, and Shortcomings

Abstract:

Power BI is Microsoft’s newest solution to facilitate self-service business intelligence. In this session we will discuss which components of Power BI are associated with cloud services, SharePoint on-premises, and client application such as Excel and Power BI Designer. With an emphasis on the overhauled Power BI Preview, we will discuss and demonstrate the key elements of the system, its strengths, its limitations, and how Power BI can fit into an organization’s data delivery platform.

SessionID: 26727

Understanding SQL Backups and Restores

Back to calendar

Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA

Speaker: Tim Radney

Title: Understanding SQL Backups and Restores

Abstract:

Having backups is important for organizations, having restorable backups is critical. Too many times to count, Tim Radney has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL backups. In this session, Tim will the various types of backups that can be taken and demonstrate how to restore each of them. This isn’t your basic session as Tim will not only be covering the common full, differential and log backups, he will also be covering partial, file group, COPY_ONLY, as well as performing a demo of a hack attach for the ultimate tail log restore