sqlsathistory

Nr: 441

Back to Main list

SQLSaturday #441 - Denver 2015

Start Time (24h) Speaker Track Title
09:00:00 Lance Tidwell Application Database Development Parameter Sniffing the Good and the Bad
09:00:00 Reeves Smith BI Platform Architecture, Development Administration Data Integration with Master Data Services
09:00:00 Todd Kleinhans Professional Development The Life Cycle of a Query in VR
09:00:00 Jason Kassay Enterprise Database Administration Deployment Getting Started with Execution Plans
09:00:00 Shannon Holck BI Information Delivery Power BI Desktop - Intro
09:00:00 Wendy Pastrick Enterprise Database Administration Deployment Transactional Replication 101
10:10:00 Michael Sexton BI Platform Architecture, Development Administration The Augean Stables: Data Cleansing in the Modern Enterprise
10:10:00 Chris Shaw Enterprise Database Administration Deployment Tips for SQL Server Performance and Resiliency
10:10:00 Jason Horner BI Platform Architecture, Development Administration Dimensional Modeling Design Patterns: Beyond Basics
10:10:00 Carlos Bossy BI Information Delivery Use Hive and Hadoop for High Performance Data Warehousing
10:10:00 Melody Zacharias Application Database Development Distributed Replay: Testing With Your Data, Your Way!
10:10:00 Andre DuBois Enterprise Database Administration Deployment 15 Things to ensure survivability of your database
11:20:00 Chris Hyde BI Information Delivery Row-Based Security in SSRS and SSAS
11:20:00 Keith Tate Enterprise Database Administration Deployment Profiler is Dead! Long Live Extended Events!
11:20:00 Russ Thomas Professional Development Stress Inoculation: Maintaining Performance Under Pressure
11:20:00 Leslie Weed BI Platform Architecture, Development Administration Source Control practices for your BI World
11:20:00 Eric Peterson Enterprise Database Administration Deployment Very Large Databases in your future
11:20:00 Amy Herold Enterprise Database Administration Deployment Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
12:30:00 John McAllister BI Platform Architecture, Development Administration Accelerate SQL Server Master Data Services with Profisee Maestro
12:30:00 Trent Sherman Enterprise Database Administration Deployment Advanced Performance Tuning Tips with Database Performance Analyz
12:30:00 Bob Pusateri Application Database Development Keeping Your SQL Under Control: Version Controlling Your Database
12:30:00 Matt White BI Information Delivery Light up your SQL investment with Pyramid Analytics
12:30:00 Kevin Cox BI Platform Architecture, Development Administration Modern BI Solutions based on Lambda Architecture
13:30:00 Ginger Grant BI Information Delivery Predicting the future with Machine Learning
13:30:00 Michelle Poolet Enterprise Database Administration Deployment An Unexpected Journey: SQL Server 2000 to 2014
13:30:00 Tim Gorman Enterprise Database Administration Deployment Accelerating DevOps Using Data Virtualization
13:30:00 Meagan Longoria BI Platform Architecture, Development Administration Building your ETL Framework with BIML
13:30:00 Michael Fal Enterprise Database Administration Deployment SQL Server Benchmarking: The Powershell Speedometer
13:30:00 TJay Belt Application Database Development Hadoop, and Hive, and Json and Data! Oh my!
14:40:00 Marc Beacom BI Platform Architecture, Development Administration Getting started with Dimensional Modeling
14:40:00 Justin Hudnall BI Information Delivery Abstraction Techniques for SQL Server Reporting Services
14:40:00 Glenn Berry Enterprise Database Administration Deployment Analyzing I/O Subsystem Performance
14:40:00 Bob Pusateri Enterprise Database Administration Deployment SQL Server Security Basics
14:40:00 Jeff Renz Application Database Development Introduction to Microsoft Azure DocumentDB
14:40:00 Hope Foley BI Platform Architecture, Development Administration Don't Rely on Magic - Tabular Performance Troubleshooting
15:50:00 Phillip Labry BI Information Delivery Exploring the BI Universe
15:50:00 David Klee Enterprise Database Administration Deployment Achieving Peak Performance from your Virtual SQL Servers
15:50:00 Konstantin Melamud Enterprise Database Administration Deployment Performance Tuning: Index Optimization
15:50:00 Bill Fellows BI Platform Architecture, Development Administration 2014 SSIS Project Deployment Model: Deployment and Maintenance
15:50:00 Rick Lowe Enterprise Database Administration Deployment Why should I care about the plan cache?
15:50:00 Andy Vold Application Database Development Develop your Database using “Database Projects” from SQL Server Data Tools

SessionID: 36779

Parameter Sniffing the Good and the Bad

Back to calendar

Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Application Database Development

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

Data Integration with Master Data Services

Back to calendar

Event Date: 19-09-2015 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reeves Smith

Title: Data Integration with Master Data Services

Abstract:

Master Data Services (MDS) enables the management of non-transactional data that defines business entities within the enterprise. Get a good business and technical understanding of how MDS can help obtain better business clarity across the organization through a Data Governance strategy. Data Governance is a methodology that represents quality, policies, and process management, in relation to handling your enterprise data.

The session will demonstrate the architecture of a Master Data Management solution and the data integration required to implement it within the enterprise. In this session, you will learn:

SessionID: 39203

The Life Cycle of a Query in VR

Back to calendar

Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Professional Development

Speaker: Todd Kleinhans

Title: The Life Cycle of a Query in VR

Abstract:

Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in VR. We will follow a query from beginning to end and "runthrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.

SessionID: 39302

Getting Started with Execution Plans

Back to calendar

Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Kassay

Title: Getting Started with Execution Plans

Abstract:

There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, one of the first things you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.

SessionID: 39306

Power BI Desktop - Intro

Back to calendar

Event Date: 19-09-2015 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Shannon Holck

Title: Power BI Desktop - Intro

Abstract:

Power BI is the latest tool for delivering data visually to your end users. Come learn some basics and get started creating your own dashboard today!

SessionID: 40324

Transactional Replication 101

Back to calendar

Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Wendy Pastrick

Title: Transactional Replication 101

Abstract:

Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring. We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.

SessionID: 36777

The Augean Stables: Data Cleansing in the Modern Enterprise

Back to calendar

Event Date: 19-09-2015 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Michael Sexton

Title: The Augean Stables: Data Cleansing in the Modern Enterprise

Abstract:

Every database professional knows the database design ideal and we have all seen that ideal on numerous occasions - databases in perfect third normal form; constraints and relational integrity rigorously enforced; elegant error handling in every SQL statement; data so clean you can eat off it.

Unfortunately we’ve only seen this ideal in textbooks and sample databases designed by vendors.

The databases we see in the real world are… less than ideal shall we say. Of course, we use other phrases for what we see but human resources frowns on such terms and this is, after all, a family friendly presentation.
Database professionals in Greece circa 600 BCE may have access to the Alpheus and Peneus rivers to cleanse their particular stables but we modern folks need to rely on the tools on our own computers such as SQL and SSIS. Mike will review various techniques and tools for data cleansing that will help you wash away the muck to get to the data gold standard.

SessionID: 36786

Tips for SQL Server Performance and Resiliency

Back to calendar

Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Shaw

Title: Tips for SQL Server Performance and Resiliency

Abstract:

After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;

We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.

SessionID: 38497

Dimensional Modeling Design Patterns: Beyond Basics

Back to calendar

Event Date: 19-09-2015 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond Basics

Abstract:

Dimensional modeling is arguably one of the most important

fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization's data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.

This session provides 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. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

SessionID: 39152

Use Hive and Hadoop for High Performance Data Warehousing

Back to calendar

Event Date: 19-09-2015 - Session time: 10:10:00 - Track: BI Information Delivery

Speaker: Carlos Bossy

Title: Use Hive and Hadoop for High Performance Data Warehousing

Abstract:

Big Data has moved beyond the hype and entered the mainstream as a tool for managing large and unstructured data sets, giving data architects more options for managing data. The Hadoop ecosystem has become the tool of choice and Microsoft has entered this arena with HDInsight in the cloud. For DBAs this means having a place to store data that can be accessed using a highly parallel framework. In this session you’ll see how to use the numerous tools available to store data in Hadoop, process it, manage it, and retrieve it. We’ll explore Sqoop and how its many options can be configured to import data by taking advantage of Hadoop’s massive parallelism. We will develop and run Map\Reduce code, with an emphasis on understanding what belongs in a mapper function versus what belongs in a reducer function, while demonstrating Hadoop Streaming with languages such as R and C#. Finally, Hive will be shown to exhibit the use of a high-level query language in Hadoop for those who prefer SQL.

SessionID: 39162

Distributed Replay: Testing With Your Data, Your Way!

Back to calendar

Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Application Database Development

Speaker: Melody Zacharias

Title: Distributed Replay: Testing With Your Data, Your Way!

Abstract:

Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization? Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing and replay. This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.

SessionID: 39294

15 Things to ensure survivability of your database

Back to calendar

Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Andre DuBois

Title: 15 Things to ensure survivability of your database

Abstract:

Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.

SessionID: 36771

Row-Based Security in SSRS and SSAS

Back to calendar

Event Date: 19-09-2015 - Session time: 11:20:00 - Track: BI Information Delivery

Speaker: Chris Hyde

Title: Row-Based Security in SSRS and SSAS

Abstract:

It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.

SessionID: 38197

Profiler is Dead! Long Live Extended Events!

Back to calendar

Event Date: 19-09-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Keith Tate

Title: Profiler is Dead! Long Live Extended Events!

Abstract:

Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.

That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool! In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!

SessionID: 38740

Stress Inoculation: Maintaining Performance Under Pressure

Back to calendar

Event Date: 19-09-2015 - Session time: 11:20:00 - Track: Professional Development

Speaker: Russ Thomas

Title: Stress Inoculation: Maintaining Performance Under Pressure

Abstract:

Stress is a natural reaction to demanding events for which our natural resources to cope or react are low. Initial effects might be increased energy and focus but can quickly give way to inaction and costly mistakes.

This course presents a variety of simple yet highly actionable techniques borrowed from some of the most stressful fields on earth. In this course, you learn to apply the same methods that doctors, military, law enforcement, and paramedics learn to cope and perform under high-stress situations. Discover how easily these techniques translate to almost any career or endeavor.

Whether you regularly support a multi-million dollar data center on a 24-hour on-call rotation or are asked to restore production while three levels of management look over your shoulder, counting the dollars lost per minute, everyone is susceptible to stress. Some people just have a higher immunity. Attend this inoculation session and get caught up on your boosters.

SessionID: 39190

Source Control practices for your BI World

Back to calendar

Event Date: 19-09-2015 - Session time: 11:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Weed

Title: Source Control practices for your BI World

Abstract:

Source Control is a critical part of any development effort. For small shop developers tools like TFS can be overwhelming especially for developers that come from organizations with little to no source control experience. Let's talk about practices and ways to implement source control for SSIS, SSRS and Database Projects in both multi-developer and multi-tiered environments. We will cover when and how to branch, merge and shelve and discuss ideas around process for deployment and continuous integration.

SessionID: 39238

Very Large Databases in your future

Back to calendar

Event Date: 19-09-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Peterson

Title: Very Large Databases in your future

Abstract:

Your databases may not be terabyte-sized yet, but they're probably growing every day. We'll look at lessons learned

from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout

decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re-

indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.

SessionID: 39279

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

Back to calendar

Event Date: 19-09-2015 - Session time: 11:20: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: 40663

Accelerate SQL Server Master Data Services with Profisee Maestro

Back to calendar

Event Date: 19-09-2015 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: John McAllister

Title: Accelerate SQL Server Master Data Services with Profisee Maestro

Abstract:

Grab your lunch and join John McAllister in the Profisee room for an informative presentation while you eat!

Accelerate SQL Server Master Data Services with Profisee Maestro

SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, a managed schema, hierarchies, versioning, workflow, and Excel Integration. Profisee Maestro slashes your time to deployment on MDS by providing an alternate UI for data Stewards and Application owners. Maestro adds data modeling, a first-rate user experience, ER-Win Integration, Simplified Import/Export to simplify getting MDM in the hands of your users. Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.

SessionID: 40675

Advanced Performance Tuning Tips with Database Performance Analyz

Back to calendar

Event Date: 19-09-2015 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Trent Sherman

Title: Advanced Performance Tuning Tips with Database Performance Analyz

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.

SessionID: 40689

Keeping Your SQL Under Control: Version Controlling Your Database

Back to calendar

Event Date: 19-09-2015 - Session time: 12:30:00 - Track: Application Database Development

Speaker: Bob Pusateri

Title: Keeping Your SQL Under Control: Version Controlling Your Database

Abstract:

Source control isn't just for application development anymore; your database code needs it just as much!

This session will cover the fundamentals of source control systems and how getting your database under version control is an excellent way to collaborate with team members, communicate changes, and keep an audit trail. You'll see how Redgate SQL Source Control makes it incredibly easy and intuitive to maintain your database in nearly any source control system, and how the universe of development pipelines and continuous integration is easily accessible from there.

SessionID: 40691

Light up your SQL investment with Pyramid Analytics

Back to calendar

Event Date: 19-09-2015 - Session time: 12:30:00 - Track: BI Information Delivery

Speaker: Matt White

Title: Light up your SQL investment with Pyramid Analytics

Abstract:

Come see how Pyramid Analytics delivers a powerful, business user friendly platform that empowers organizations to make the most of their Business Intelligence. A demonstration will show you how to leverage your SQL environment to make Business Intelligence available to all within your organization. See how all levels of users can access, understand and present the right information to the right people at the right time.

SessionID: 40729

Modern BI Solutions based on Lambda Architecture

Back to calendar

Event Date: 19-09-2015 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Cox

Title: Modern BI Solutions based on Lambda Architecture

Abstract:

Techniques and Tools for doing BI projects have improved over the past several years. Learn about what is available. Take some of these thoughts back to your work and apply them to your current projects.

SessionID: 36804

Predicting the future with Machine Learning

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Ginger Grant

Title: Predicting the future with Machine Learning

Abstract:

Machine Learning is Microsoft’s big entry in to the predictive analytics arena. . In this introductory session we will discuss the growing new field of predictive analytics and how Machine Learning is used to predict future results. Instead of staring into crystal balls, Machine Learning provides the ability to experiment to determine which algorithm or R code best analyzes the data to determine if past performance is indicative of the future or use scoring to find a more appropriate model.

SessionID: 36886

An Unexpected Journey: SQL Server 2000 to 2014

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michelle Poolet

Title: An Unexpected Journey: SQL Server 2000 to 2014

Abstract:

As a DBA yourself, I’m sure you’ve encountered instances where the SQL Server has been running fine, there’ve been no changes for ages, everything is stable, there’s no exposure to the outside world, and the last time anyone updated or applied a patch to the server was in February 2004… …and then the world intruded, and all of a sudden you’ve been given a directive to “bring that system up to date!” Now what? You’re faced with upgrading not only the SQL Server, but the Windows server as well (and a bunch of other applications), because Microsoft has announced that ALL support for Windows Server 2003 will be going away (far away!) this summer! And some clever person upstairs decided that it would be A GOOD THING to have this SQL Server exposed to the outside…and has commissioned the web dev team to build a whole suite of apps that WILL MAKE THE COMPANY MILLIONS! Where to start…

SessionID: 37813

Accelerating DevOps Using Data Virtualization

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Gorman

Title: Accelerating DevOps Using Data Virtualization

Abstract:

DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.

Constraining DevOps is data. Databases and applications have grown enormous and complex. "Storage is cheap" is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.

Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality. Learn about the technical details behind this solution.

SessionID: 37816

Building your ETL Framework with BIML

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Meagan Longoria

Title: Building your ETL Framework with BIML

Abstract:

BIML makes SSIS development faster and creates reusable modules that help you apply a consistent ETL framework across solutions. In this session, we will write BIML and use it to build an SSIS package. You'll see how BIML allows you to avoid corrupted metadata and the tedious repetition of implementing simple SSIS patterns, freeing you up to take on new and interesting ETL challenges. Then we will review how to use it to create an extensible ETL framework.

SessionID: 38887

SQL Server Benchmarking: The Powershell Speedometer

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: SQL Server Benchmarking: The Powershell Speedometer

Abstract:

How fast do you think you were going? The only way to be sure is to have a reliable way to measure your performance. The challenge with SQL Server is that there are many aspects of your stack that you need to measure and understand. Powershell, with its ability to access and report on all these different levels, can give you a robust tool to benchmark your SQL Server. This session will cover benchmarking methodologies, the tools Powershell offers for capturing performance information, and will demonstrate how you can use them to measure performance statistics. After attending this session, you will understand how to effectively use Powershell to measure your database speed.

SessionID: 40754

Hadoop, and Hive, and Json and Data! Oh my!

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Application Database Development

Speaker: TJay Belt

Title: Hadoop, and Hive, and Json and Data! Oh my!

Abstract:

Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.

SessionID: 36776

Getting started with Dimensional Modeling

Back to calendar

Event Date: 19-09-2015 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marc Beacom

Title: Getting started with Dimensional Modeling

Abstract:

Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we've all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.

SessionID: 37265

Abstraction Techniques for SQL Server Reporting Services

Back to calendar

Event Date: 19-09-2015 - Session time: 14:40:00 - Track: BI Information Delivery

Speaker: Justin Hudnall

Title: Abstraction Techniques for SQL Server Reporting Services

Abstract:

As enterprise Reporting Services solutions mature, maintenance and change requests of existing reports often result in environment inconsistencies and bottleneck new development. Establishing proper abstraction between data and presentation layers can greatly reduce maintenance tasks and ensure development consistency.

In this session we’ll review the following abstraction techniques and how they can ease maintenance burden and promote consistency across your reporting infrastructure. • Keep SQL within the Database not SSRS • One size fits all for parameter aliases • Combine available and default data sets into one procedure

SessionID: 37651

Analyzing I/O Subsystem Performance

Back to calendar

Event Date: 19-09-2015 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Glenn Berry

Title: Analyzing I/O Subsystem Performance

Abstract:

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

SessionID: 38161

SQL Server Security Basics

Back to calendar

Event Date: 19-09-2015 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Pusateri

Title: SQL Server Security Basics

Abstract:

The past few years seem to have had more than their fair share of high-profile data breaches, not all of which were caused by sophisticated hacking attempts. This session explains basic methods for securing your SQL Server by making sure you're not leaving the proverbial front door unlocked (or in some cases, wide open). We will discuss the different levels and methods that can be used for granting and restricting rights, and the pros and cons of each. You'll learn steps you can take to design databases with securability in mind from the beginning so you can better protect your data later on down the road. We'll also demonstrate scripts that can help audit user rights and make sure logins don't have any more permissions than they need. Security doesn't have to be scary! Attend this session and gain a solid foundation to build your DBA career on.

SessionID: 39191

Introduction to Microsoft Azure DocumentDB

Back to calendar

Event Date: 19-09-2015 - Session time: 14:40:00 - Track: Application Database Development

Speaker: Jeff Renz

Title: Introduction to Microsoft Azure DocumentDB

Abstract:

In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript.

Goals: #1 Show how to create validate JSON strings using Notepad++, validate the JSON against a schema using C# Newtonsoft dll. Demonstrate how to work with JSON in SQL Server as a reference on how hard it is to work with JSON when it is not natively stored. #2 Demo the basics of DocumentDB - Create the database, collections and documents using the web interface. Demo how to perform basic selects, joins and filtering. Review java script basics as java script is fundamental in creating stored procedures #3 Demo of how to work with DocumentDB in a C# by creating collections, documents and querying the database using lync and SQL syntax.

SessionID: 39283

Don't Rely on Magic - Tabular Performance Troubleshooting

Back to calendar

Event Date: 19-09-2015 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Hope Foley

Title: Don't Rely on Magic - Tabular Performance Troubleshooting

Abstract:

Many times you'll hear that one of the major advantages of using the tabular model is ease of use and implementation. So that must mean that it will run like a super fast dream all the time out of the box, forever and ever right? Not exactly. There are many things to consider at the time of modeling and implementation for performance. And later if you run into trouble with reports and queries, what do you do then? In this session we'll go through the process to troubleshoot performance of your tabular models and queries to keep things running as fast as possible. Just because tabular is easy to use doesn't mean you have a magical black box that you can't tune when it doesn't run as fast as you want. In this session, we will focus on building a methodology for troubleshooting tabular performance so you can get that super fast dream machine.

SessionID: 37095

Exploring the BI Universe

Back to calendar

Event Date: 19-09-2015 - Session time: 15:50:00 - Track: BI Information Delivery

Speaker: Phillip Labry

Title: Exploring the BI Universe

Abstract:

Business Intelligence has received a great deal of attention over the last few years and there are numerous, often confusing products, strategies and offerings. With so many technologies to choose from it can be very difficult to decide where to start and what technology is the right fit(or more importantly, the wrong fit). Join Phillip as he guides you through the rapidly expanding BI universe. This session is intended for those curious about BI technology who have limited or no experience with it.

SessionID: 37320

Achieving Peak Performance from your Virtual SQL Servers

Back to calendar

Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Achieving Peak Performance from your Virtual SQL Servers

Abstract:

Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!

SessionID: 38343

Performance Tuning: Index Optimization

Back to calendar

Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Konstantin Melamud

Title: Performance Tuning: Index Optimization

Abstract:

As our data size grows larger the need for optimal indexing within our databases becomes even more important than before. This session will help you understand how choose appropriate indexes to streamline our DML operations in our enterprise. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.

SessionID: 38643

2014 SSIS Project Deployment Model: Deployment and Maintenance

Back to calendar

Event Date: 19-09-2015 - Session time: 15:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bill Fellows

Title: 2014 SSIS Project Deployment Model: Deployment and Maintenance

Abstract:

The 2014 SQL Server Integration Services (SSIS) Project Deployment Model introduces new opportunities for the delivery of SSIS solutions. Gone are decisions about logging providers, configuration approaches, and deployment targets. Now, you need to focus on the creation of an .ispac, the approaches to deploying the project, and applying configurations to ensure expected behavior.

This session begins by exploring mapping between elements in an SSIS project and their counterparts in the compiled file, the .ispac. The session then covers three approaches for automating the deployment of this unit into SSISDB We then cover the administration side of the SSIS Catalog. You create SSIS environment variables and apply them to configure run-time behaviour. Finally, you work through the native tooling to troubleshoot failed SSIS packages. We'll cover SQL Server Management Studio (SSMS) reports, Catalog views, and data taps for run-time collection of values.

SessionID: 38917

Why should I care about the plan cache?

Back to calendar

Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment

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. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBA is sometimes so moody.

SessionID: 39200

Develop your Database using “Database Projects” from SQL Server Data Tools

Back to calendar

Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Application Database Development

Speaker: Andy Vold

Title: Develop your Database using “Database Projects” from SQL Server Data Tools

Abstract:

SQL Server Data Tools changes traditional database development by introducing a declarative, model-based experience that supports both online and offline (project-based) database development. In this presentation you will learn how to use this tool for either a new or existing database project. We will also highlight and demonstrate key built-in features like refactoring, pre and post deployment scripts, publish, and schema compare.

This site is open source. Improve this page.