sqlsathistory

Nr: 442

Back to Main list

SQLSaturday #442 - Orlando 2015

Start Time (24h)	Speaker	Track	Title
09:00:00	George Walkey	Enterprise Database Administration Deployment	Scripting out SQL Server for Documentation and Disaster Recovery
09:00:00	miguel Cebollero	Application Database Development	SQL Server 2014 In-Memory Programming
09:00:00	Josh Luedeman	Cloud Application Development Deployment	Data Factory: Data Integration in the Cloud
09:00:00	Steve Jones	Application Database Development	The Encryption Primer
09:00:00	Mark Tabladillo	Analytics and Visualization	Microsoft Technologies for Data Science
09:00:00	Mitchell Pearson	BI Platform Architecture, Development Administration	SSIS Performance Tuning Techniques
09:00:00	James McAuliffe	Enterprise Database Administration Deployment	Changing Data Is Easy, Managing Data Change is Hard!
09:00:00	Allan Hirt	Enterprise Database Administration Deployment	What's New for High Availability in SQL Server 2016 and Windows Server 2016
09:00:00	Kendal Van Dyke	Enterprise Database Administration Deployment	Transactional Replication: Architecture, Setup, and Monitoring
09:00:00	Susan Rickman	Application Database Development	DataTypes - What's the Big Deal?
09:00:00	Mark Scott	Analytics and Visualization	Looking for the Power BI on-prem alternative?
10:35:00	Janis Griffin	Enterprise Database Administration Deployment	Top 10 Wait Types Everyone Should Know
10:35:00	Daniel Janik	Advanced Analysis Techniques	Analyze your query plan like a Microsoft Engineer!
10:35:00	Jason Carter	Enterprise Database Administration Deployment	Encryption 101: A look at SQL Encryption Options
10:35:00	Charles Hyman	BI Platform Architecture, Development Administration	SQL 2016 Changes and Enhancements for BI and Beyond
10:35:00	Mike Davis	Professional Development	Interview Puzzles and how to handle them
10:35:00	Dustin Ryan	BI Platform Architecture, Development Administration	Designing a Data Warehouse from the Ground Up
10:35:00	Eric Wisdahl	Application Database Development	An Introductory Look at Execution Plans
10:35:00	Gareth Swanepoel	Cloud Application Development Deployment	A practical guide to Windows Azure SQL Database for the DBA
10:35:00	Damu Venkatesan	BI Information Delivery	Self-Service ETL with Microsoft Power Query
10:35:00	Richie Rump	Application Database Development	Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers
12:30:00	Allan Hirt	Enterprise Database Administration Deployment	Building a Better Mousetrap: Using Cisco UCS for SQL Server Deplo
12:30:00	Jeff Abbott	Application Database Development	Be the SQL Server Dev/Ops Hero, brought to you by Actifio
12:30:00	Todd Phillippe	Advanced Analysis Techniques	Object Level Recovery Made Easy brought to you by Dell Software
12:30:00	Janis Griffin	Application Database Development	Advanced Performance Tuning Tips with Database Performance Analyz
12:30:00	Patrick Pinchera	Enterprise Database Administration Deployment	Flash Storage Drill Down: Know Your Storage Infrastructure
12:30:00	Kendal Van Dyke	Enterprise Database Administration Deployment	Implementing a SANLess Cluster in Under an Hour, brought to you b
13:30:00	Dave Mattingly	Professional Development	Achievement Unlocked: How to Get Promoted
13:30:00	Prakash Heda	Enterprise Database Administration Deployment	Detect Worst Performing SQL Queries During Peak Hour
13:30:00	Jeff Reinhard	Enterprise Database Administration Deployment	AlwaysOn Availability Groups Kickoff
13:30:00	Jorge Besada	Application Database Development	PowerShell and Python - The Clash - Part Deux
13:30:00	Lindsay Clark	Enterprise Database Administration Deployment	Beginners SQL Server Security the Low Hanging Fruit
13:30:00	Jorge Novo	Application Database Development	Loading Complex Data Structures using SSIS Programming
13:30:00	Andy Warren	Professional Development	How To Become a SQL Server DBA
13:30:00	Louis Davidson	Strategy and Architecture	How In-Memory Database Objects Affect Database Design
13:30:00	Sebastian Meine	Application Database Development	SQL Server 2016 Always Encrypted
13:30:00	Pankaj Satyaketu	Cloud Application Development Deployment	An intro to Azure SQL Data Warehouse
13:30:00	Pam Shaw	BI Information Delivery	Taking the Scary out of Monster Reports
13:30:00	Bradley Ball	Application Database Development	What's New in SQL Server 2016
13:30:00	Buck Woody	Advanced Analysis Techniques	Cortana Analytics Demystified
15:15:00	Wayne Sheffield	Application Database Development	Table Vars and Temp Tables – What you NEED to Know!
15:15:00	Ronald Dameron	Enterprise Database Administration Deployment	Real World SQL Server Administration with just a bit of sysadmin
15:15:00	Jeffrey Garbus	Information Delivery	Indexing for Join Optimization
15:15:00	Wes Springob	Analytics and Visualization	How to build your first Power BI Dashboard in 60 Min.
15:15:00	Stuart Ainsworth	Strategy and Architecture	Eating The Elephant; A DBA's Guide to Hadoop Big Data
15:15:00	Maximo Trinidad	Application Database Development	PowerShell with Visual Studio SQL Data Tools
15:15:00	Dmitri Korotkevitch	Application Database Development	Thinking Outside of the In-Memory Box
15:15:00	Karlyn LeBlanc	Professional Development	Balancing Work and Home to Create a Better You
15:15:00	Patrick LeBlanc	BI Information Delivery	Introduction to DataZen
15:15:00	Ian Lanham	Enterprise Database Administration Deployment	Management Data Warehouse and Data Collector
15:15:00	David Pless	Enterprise Database Administration Deployment	SQL SERVER 2016 PERFORMANCE FEATURES
16:30:00	Andrey Korshikov	Professional Development	SQL Injection – are you ready for defense?
16:30:00	Rob Volk	Application Database Development	Tame Your Unruly Data...With Constraints!
16:30:00	Jack Corbett	Application Database Development	Don't Be Trigger Happy: Safe Use of Triggers
16:30:00	Troy Gallant	Enterprise Database Administration Deployment	Indexing your Data Warehouse
16:30:00	Jen Underwood	BI Information Delivery	Roadmap: What's Coming Next for SQL Server BI and Power BI
16:30:00	Robert Biddle	Analytics and Visualization	Introduction To R
16:30:00	Mike Lawell	Application Database Development	Execution Plans for Mere Mortals
16:30:00	Colleen Morrow	Enterprise Database Administration Deployment	Enterprise Auditing with SQL Server Audit
16:30:00	Leigh Freijo	Professional Development	Why I won't hire you and what you can do about it!
16:30:00	Brian Davis	BI Platform Architecture, Development Administration	DQ What? DQ Who? DQ How?

SessionID: 37110

Scripting out SQL Server for Documentation and Disaster Recovery

Back to calendar

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

Speaker: George Walkey

Title: Scripting out SQL Server for Documentation and Disaster Recovery

Abstract:

Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects.

Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers

SessionID: 38633

SQL Server 2014 In-Memory Programming

Back to calendar

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

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

Data Factory: Data Integration in the Cloud

Back to calendar

Event Date: 10-10-2015 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Josh Luedeman

Title: Data Factory: Data Integration in the Cloud

Abstract:

The Azure platform is ever changing. Today is no different. Azure has released a new tool called Data Factory. It is a cloud PaaS that is SSIS in the cloud. Are you curious what all it entails and if you can use it? In this session, we'll go over the basics of Data Factory like structure, billing, and building blocks. We'll go over a couple instances on how you can use Data Factory in current processes that you have in your data warehouse ETL.

SessionID: 38744

The Encryption Primer

Back to calendar

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

Speaker: Steve Jones

Title: The Encryption Primer

Abstract:

Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.

SessionID: 38750

Microsoft Technologies for Data Science

Back to calendar

Event Date: 10-10-2015 - Session time: 09:00:00 - Track: Analytics and Visualization

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

SSIS Performance Tuning Techniques

Back to calendar

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

Speaker: Mitchell Pearson

Title: SSIS Performance Tuning Techniques

Abstract:

SSIS is an extremely powerful ETL tool, but with great power comes great responsibility. The responsibility to not just create SSIS package, but create SSIS package that perform as efficiently as possible. This session will share best practices for developing packages that perform well from the start. It will also walk you step by step through identifying and fixing performance issues in an existing package. After watching this demo filled session you’ll be able to get your package performing better than ever!

SessionID: 38858

Changing Data Is Easy, Managing Data Change is Hard!

Back to calendar

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

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

What's New for High Availability in SQL Server 2016 and Windows Server 2016

Back to calendar

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

Speaker: Allan Hirt

Title: What's New for High Availability in SQL Server 2016 and Windows Server 2016

Abstract:

SQL Server 2016 and Windows Server 2016 are just around the corner. There are changes and enhancements to the availability features that SQL Server deployments - Windows Server failover clusters (WSFCs), clustered instances (FCIs), and availability groups (AGs). This session will cover what is new and what has changed since Windows Server 2012 R2 and SQL Server 2014 for WSFCs, FCIs, and AGs.

SessionID: 38914

Transactional Replication: Architecture, Setup, and Monitoring

Back to calendar

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

Speaker: Kendal Van Dyke

Title: Transactional Replication: Architecture, Setup, and Monitoring

Abstract:

At some point in every DBA's career they'll be probably be asked to work with transactional replication. While it may seem scary at first, it's not that complicated once you understand how all the parts and pieces work together. In this session we'll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly. You'll return to work with the confidence and know-how that you need to set up and manage a transactional replication topology.

SessionID: 40380

DataTypes - What's the Big Deal?

Back to calendar

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

Speaker: Susan Rickman

Title: DataTypes - What's the Big Deal?

Abstract:

Developers and DBAs: How do you determine what DataType will be required for your database? Far too often, Database Development teams are pressured into making quick decisions for their database models, usually full of NVarChars and GUIDs, typically based on a suggestion that these datatypes were the only useful datatypes for Web development. In this session, we will discuss the pro's and con's of the differing datatypes, and arm the Database Developers and DBAs with the analysis necessary to create databases that are easily maintained.

SessionID: 40806

Looking for the Power BI on-prem alternative?

Back to calendar

Event Date: 10-10-2015 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Mark Scott

Title: Looking for the Power BI on-prem alternative?

Abstract:

Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML!

Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics BI Office suite.

SessionID: 36837

Top 10 Wait Types Everyone Should Know

Back to calendar

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

Speaker: Janis Griffin

Title: Top 10 Wait Types Everyone Should Know

Abstract:

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

SessionID: 37012

Analyze your query plan like a Microsoft Engineer!

Back to calendar

Event Date: 10-10-2015 - Session time: 10:35:00 - Track: Advanced Analysis Techniques

Speaker: Daniel Janik

Title: Analyze your query plan like a Microsoft Engineer!

Abstract:

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate.

SessionID: 37734

Encryption 101: A look at SQL Encryption Options

Back to calendar

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

Speaker: Jason Carter

Title: Encryption 101: A look at SQL Encryption Options

Abstract:

Are your backups like a stack of cash free for the taking, or a hardened ATM? Are your database connections scrambled and safe or are you sending data over the party line? In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport. Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement.

SessionID: 37989

SQL 2016 Changes and Enhancements for BI and Beyond

Back to calendar

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

Speaker: Charles Hyman

Title: SQL 2016 Changes and Enhancements for BI and Beyond

Abstract:

Operational Analytics: Insights on operational data, works with in-memory OLTP or on disklt;br/gt;

lt;br/gt; In-memory OLTP enhancements: Greater T-SQL surface area, terabytes of memory supported and greater number of parallel CPUslt;br/gt; lt;br/gt; Query Data Store: Monitor and optimize query plans with full history of query executionlt;br/gt; lt;br/gt; Native JSON: Parsing storing of JSON as relational data exporting relational data to JSON lt;br/gt; Temporal Database: Track historical changeslt;br/gt; lt;br/gt; PolyBase: Manage relational non-relational data with the simplicity of T-SQLlt;br/gt; lt;br/gt; Power Query for Analytics and Reporting: Pull data from countless sources into data models and reportslt;br/gt; lt;br/gt; Enhanced SSIS: Designer support for previous SSIS versions and support for Power Querylt;br/gt; lt;br/gt; Enterprise-grade Analysis Services: Enhanced performance and scalability for Analysis Serviceslt;br/gt; lt;br/gt; Single SSDT in Visual Studio 2015: Build richer analytics solutions as part of your development projec

SessionID: 38176

Interview Puzzles and how to handle them

Back to calendar

Event Date: 10-10-2015 - Session time: 10:35:00 - Track: Professional Development

Speaker: Mike Davis

Title: Interview Puzzles and how to handle them

Abstract:

In today's world of technology interview, employees have come up with more and more tricks and puzzles to test your brain. How would you move mount fuji? How many basketballs would fit in this room? In this session Mike will cover these questions and many more. You will leanr what not to say and how to handle tough questions.

SessionID: 38395

Designing a Data Warehouse from the Ground Up

Back to calendar

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

Speaker: Dustin Ryan

Title: Designing a Data Warehouse from the Ground Up

Abstract:

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes.

SessionID: 38773

An Introductory Look at Execution Plans

Back to calendar

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

Speaker: Eric Wisdahl

Title: An Introductory Look at Execution Plans

Abstract:

In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.

SessionID: 38824

A practical guide to Windows Azure SQL Database for the DBA

Back to calendar

Event Date: 10-10-2015 - Session time: 10:35:00 - Track: Cloud Application Development Deployment

Speaker: Gareth Swanepoel

Title: A practical guide to Windows Azure SQL Database for the DBA

Abstract:

What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ?

If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.

SessionID: 38836

Self-Service ETL with Microsoft Power Query

Back to calendar

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

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

Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Back to calendar

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

Speaker: Richie Rump

Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Abstract:

Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework.

Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.

SessionID: 40685

Building a Better Mousetrap: Using Cisco UCS for SQL Server Deplo

Back to calendar

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

Speaker: Allan Hirt

Title: Building a Better Mousetrap: Using Cisco UCS for SQL Server Deplo

Abstract:

Many DBAs still hold onto the notion that each implementation of SQL Server requires a dedicated physical server. In today’s world dominated by virtualization and an ever increasing eye towards all things cloud, the infrastructure under SQL Server has a greater impact than ever before. This session will discuss the key differences between physical, virtual, and cloud; how the platform choice affects SQL Server deployments; and how Cisco’s UCS can benefit not only SQL Server and the DBAs, but also system administrators.

SessionID: 41241

Be the SQL Server Dev/Ops Hero, brought to you by Actifio

Back to calendar

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

Speaker: Jeff Abbott

Title: Be the SQL Server Dev/Ops Hero, brought to you by Actifio

Abstract:

As the value of Dev/Ops becomes more apparent to IT organizations, increasing demand is placed on the SQL Server DBA to manage a more agile and resilient database environment. A Dev/Ops model requires management of dozens of copies of each database across many servers, The need to provision and refresh these copies quickly is key to the success of any Agile development effort. In this session we will discuss the SQL Server DBA's role within Dev/Ops - we'll talk a bit about things like Sprints, Chef and Puppet, but most importantly we will discuss how you can present a database to any host in your environment in a couple of minutes regardless of size. Come see a copy of a 1.6TB SQL Server database presented to a host (same host or different doesn't matter) in less than 2 minutes - try doing that from a database restore!

SessionID: 41245

Object Level Recovery Made Easy brought to you by Dell Software

Back to calendar

Event Date: 10-10-2015 - Session time: 12:30:00 - Track: Advanced Analysis Techniques

Speaker: Todd Phillippe

Title: Object Level Recovery Made Easy brought to you by Dell Software

Abstract:

Have you ever found yourself in a situation where data mysteriously disappears from your database? Or a stored procedure or function was altered without your knowledge. How do I recover and get back to the original state? Recovering data and/or database code can be a frustrating and time-consuming effort without the proper tools.

In this session, I will show how to recover data and/or database code using native SQL Server tools. Do I have space to restore a copy of the database, do SLAs allow me to do this now or after hours, etc.

Then I will show how NetVault LiteSpeed for SQL Server's Object Level Recovery (OLR) functionality can simplify the process and get back to the original database state in a fraction of the time. The result is you are the hero and everyone is happy.

SessionID: 41257

Advanced Performance Tuning Tips with Database Performance Analyz

Back to calendar

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

Speaker: Janis Griffin

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

Flash Storage Drill Down: Know Your Storage Infrastructure

Back to calendar

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

Speaker: Patrick Pinchera

Title: Flash Storage Drill Down: Know Your Storage Infrastructure

Abstract:

Flash Storage (Solid State Disks) have been proclaimed to be a DBA's best friend. But not all flash storage is the same. In this talk, we will drill down a bit into the technology, and talk about the issues that can degrade your application's performance. This talk examines those issues in detail, looking at how they specifically affect databases and the structured applications that depend on those databases. And just like the free version of Pandora Radio, there will only be one slide that is commercial in nature.

SessionID: 41477

Implementing a SANLess Cluster in Under an Hour, brought to you b

Back to calendar

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

Speaker: Kendal Van Dyke

Title: Implementing a SANLess Cluster in Under an Hour, brought to you b

Abstract:

oin SQL Server MVP Kendal Van Dyke as he demonstrates how to create an SANless AlwaysOn Failover Cluster Instance using SIOS DataKeeper Cluster Edition - no shared storage, SAN, or SAN Admin required - in under an hour. At the conclusion of this sponsored session one lucky attendee will win an Amazon gift card courtesy of UpSearch!

SessionID: 36813

Achievement Unlocked: How to Get Promoted

Back to calendar

Event Date: 10-10-2015 - Session time: 13:30:00 - Track: Professional Development

Speaker: Dave Mattingly

Title: Achievement Unlocked: How to Get Promoted

Abstract:

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.

SessionID: 37169

Detect Worst Performing SQL Queries During Peak Hour

Back to calendar

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

Speaker: Prakash Heda

Title: Detect Worst Performing SQL Queries During Peak Hour

Abstract:

How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it's very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!

In this session, Prakash walks you through with scenario demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.

SessionID: 38094

AlwaysOn Availability Groups Kickoff

Back to calendar

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

Speaker: Jeff Reinhard

Title: AlwaysOn Availability Groups Kickoff

Abstract:

Tired of dealing with Replication issues? Want high availability and readable replicas for reporting? The you should consider availability groups! This session provides a run through from start to end of my experience implementing AlwaysOn Availability Groups for High Availability and read only secondary database copies.

SessionID: 38113

PowerShell and Python - The Clash - Part Deux

Back to calendar

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

Speaker: Jorge Besada

Title: PowerShell and Python - The Clash - Part Deux

Abstract:

Comparison of one application done with both technologies using multi-threading to run simultaneous operations in a large set of servers and databases

SessionID: 38496

Beginners SQL Server Security the Low Hanging Fruit

Back to calendar

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

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

Loading Complex Data Structures using SSIS Programming

Back to calendar

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

Speaker: Jorge Novo

Title: Loading Complex Data Structures using SSIS Programming

Abstract:

On this session we are going to show at end-to-end solution for complex data structures such as IBM-37 using Comp-1, Comp-3 numeric fields, from the initial requirement using excell, creation of custom components, and finally the data loading using metadata to generate ssis dynamic at run time.

SessionID: 38847

How To Become a SQL Server DBA

Back to calendar

Event Date: 10-10-2015 - Session time: 13:30:00 - Track: Professional Development

Speaker: Andy Warren

Title: How To Become a SQL Server DBA

Abstract:

Are you a developer, network or systems admin that wants to become a database administrator? Or are you new to IT and think th role of the DBA might be the one for you? This presentation will start with discussing what a DBA does and how it varies from company to company, and then discuss how to acquire knowledge and experience as you try to land that first job as a working DBA.

SessionID: 38850

How In-Memory Database Objects Affect Database Design

Back to calendar

Event Date: 10-10-2015 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: Louis Davidson

Title: How In-Memory Database Objects Affect Database Design

Abstract:

With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.

SessionID: 38857

SQL Server 2016 Always Encrypted

Back to calendar

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

Speaker: Sebastian Meine

Title: SQL Server 2016 Always Encrypted

Abstract:

Join this session by security expert Sebastian Meine (PhD) for an introduction to the fascinating new SQL Server 2016 feature Always Encrypted. In this session, geared towards the Database Developer, you will learn what makes Always Encrypted more secure and easier to use than prior encryption technologies available in SQL Server. After exploring the architecture behind this new feature, you will be able to observe how to implement Always Encrypted in SQL Server and discover how it might affect your maintenance and recovery strategies.

After attending this session, you will be able to: • Explain how Always Encrypted works. • Setup and use Always Encrypted in your own SQL Server 2016 environment. • Identify places in your application that might require small changes.

To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and not be scared when seeing C# code.

SessionID: 38874

An intro to Azure SQL Data Warehouse

Back to calendar

Event Date: 10-10-2015 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Pankaj Satyaketu

Title: An intro to Azure SQL Data Warehouse

Abstract:

In this session we will be covering one of Microsoft's latest Azure offerings SQL Data Warehouse, which leverages the massive parallel processing (MPP) architecture. We will talk about the differences between SMP vs MPP architectures and benefits of an MPP architecture in the cloud.

SessionID: 38876

Taking the Scary out of Monster Reports

Back to calendar

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

Speaker: Pam Shaw

Title: Taking the Scary out of Monster Reports

Abstract:

So the big wigs have come up with a “master” report that shows everything you could ever want on a single report.#160; It includes grids and charts of varying sizes and complexities.#160; Did I mention they want it pretty as well?#160; In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes.#160; The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts.#160; We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work.#160; To get the most out of this session, you should be able to build a report in SSRS.

SessionID: 40871

What's New in SQL Server 2016

Back to calendar

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

Speaker: Bradley Ball

Title: What's New in SQL Server 2016

Abstract:

SQL Server 2016 is on the way! SQL Server 2016 represents the largest release of SQL Server in almost 20 years. This will be the largest release in SQL Server since SQL 2000. Why? After SQL 2000 Microsoft took an approach to have major releases to the Database engine or the Business Intelligence Platform. That was the pattern for SQL Server 2005, 2008, 2008 R2, 2012, and 2014. In this release we will get change to SSRS, SSAS, SSIS, In-Memory OLTP, and AlwaysOn Availability Groups. We get new features like R integration, JSON Support, Polybase (the ability to query big data sources with T-SQL), Data Zen Integration, HTML 5 support, and much much more. If you use SQL Server, this release will impact you. Come find out how!

SessionID: 41262

Cortana Analytics Demystified

Back to calendar

Event Date: 10-10-2015 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Buck Woody

Title: Cortana Analytics Demystified

Abstract:

Microsoft SQL Server and Microsoft Azure have been announcing so many features it’s hard to keep up. If you’ve heard of Cortana Analytics, you may be a little confused about what it is, and when you would use it. Buck Woody from the Cortana Analytics team is here to help with an overview of the Cortana Analytics stack, examples of how it works, information on what components to use when, and references to learn more. You’ll be able to amaze friend and family alike with your knowledge of the Blue side of the Force. No, really, you’ll be able to do that. He’ll prove it.

SessionID: 36793

Table Vars and Temp Tables – What you NEED to Know!

Back to calendar

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

Speaker: Wayne Sheffield

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

Abstract:

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

SessionID: 36856

Real World SQL Server Administration with just a bit of sysadmin

Back to calendar

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

Speaker: Ronald Dameron

Title: Real World SQL Server Administration with just a bit of sysadmin

Abstract:

I will review the fundamentals needed to define a configurable permission model currently in use at a large insurance company that allows database administrators to do routine work without having unfettered access to business data.

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

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

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

SessionID: 36863

Indexing for Join Optimization

Back to calendar

Event Date: 10-10-2015 - Session time: 15:15:00 - Track: Information Delivery

Speaker: Jeffrey Garbus

Title: Indexing for Join Optimization

Abstract:

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

SessionID: 37540

How to build your first Power BI Dashboard in 60 Min.

Back to calendar

Event Date: 10-10-2015 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Wes Springob

Title: How to build your first Power BI Dashboard in 60 Min.

Abstract:

Power BI is quickly becoming the tool of choice for self-service reporting. It’s time to get up to speed! In this session we will build a basic dashboard from the ground up using an existing database and the Power BI tools. You’ll take away examples to start building great looking dashboards for your organization Monday morning. Prepare to be inspired! The goal of this session is to empower you to start providing insights about your data that have previously been unexplored as well as enabling stakeholders to make data driven decisions that impact your organization.

SessionID: 38178

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

Back to calendar

Event Date: 10-10-2015 - Session time: 15:15:00 - Track: Strategy and Architecture

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

PowerShell with Visual Studio SQL Data Tools

Back to calendar

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

Speaker: Maximo Trinidad

Title: PowerShell with Visual Studio SQL Data Tools

Abstract:

This session will show the integration and use of PowerShell Tools for Visual Studio with SQL Data tools. Also demostrate how

the use of a PowerShell script in SSIS "Script Task" component as part on a ETL flow. Covering some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell.

SessionID: 38446

Thinking Outside of the In-Memory Box

Back to calendar

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

Speaker: Dmitri Korotkevitch

Title: Thinking Outside of the In-Memory Box

Abstract:

SQL Server 2014 In-Memory OLTP comes with a large set of limitations that prevents its widespread adoption and often makes refactoring and migration of existing systems cost ineffective. This session discusses two set of topics:

1. How to address and workaround some of In-Memory OLTP limitations, such as 8,060-byte maximum row size, missing support for unique and foreign key constraints and different indexing behavior.
2. How you can benefit from In-Memory OLTP objects even when system migration is cost ineffective.

SessionID: 38730

Balancing Work and Home to Create a Better You

Back to calendar

Event Date: 10-10-2015 - Session time: 15:15:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Balancing Work and Home to Create a Better You

Abstract:

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

SessionID: 38732

Introduction to DataZen

Back to calendar

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

Speaker: Patrick LeBlanc

Title: Introduction to DataZen

Abstract:

This is a must attend session for every data professional. Join me as I provide an overview of DataZen, Microsofts newly acquired on-premises mobile BI solution. Datazen is optimized for SQL Server and designed to enable rapid development and publishing of business intelligence in a way that delivers premium user experience on any device. In this session I will provide an overview of DataZen, discuss its key features, provide an architectural overview and finally demonstrate how to author and publish dashboards.

SessionID: 38816

Management Data Warehouse and Data Collector

Back to calendar

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

Speaker: Ian Lanham

Title: Management Data Warehouse and Data Collector

Abstract:

If you've ever had to answer "why was the database server was slow at 3 AM?", then you'll want to learn about the Management Data Warehouse feature in SQL Server. If you're already familiar with Server-side Tracing and Data Collector, then you'll also want to add the Management Data Warehouse to your toolkit.

This session will cover installing and configuring the Management Data Warehouse feature in SQL Server, along with some customizations that can be added with additional Data Collector sets and custom SSRS Reports.

SessionID: 38830

SQL SERVER 2016 PERFORMANCE FEATURES

Back to calendar

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

Speaker: David Pless

Title: SQL SERVER 2016 PERFORMANCE FEATURES

Abstract:

In this session we will cover new SQL Server 2016 features, Query Store and Live Query Statistics. Query Store is designed to help with query performance by making it easier to identify poorly performing statements and finding scenarios where performance regresses.

We will discuss how Query Store collects and presents historic information and how it can be used to reduce the time it takes to diagnose and resolve issues. If a query generates different plans, you can use Query Store to analyze the plan changes, identify performance degradation, and even force the query processor to use a particular plan for your query.

Live Query Statistics is a feature added into SQL Management Studio that provides the ability to view the live execution plan of an active query. This live query plan provides real-time insights into query execution process as the controls flow from one query plan operator to another. These execution statistics are extremely useful for debugging performance issues.

SessionID: 36811

SQL Injection – are you ready for defense?

Back to calendar

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

Speaker: Andrey Korshikov

Title: SQL Injection – are you ready for defense?

Abstract:

The fact of the matter is that SQL injection is still a problem at the end of 2015. Web sites are still being hacked by using SQL Injection on a regular basis. Are you ready to learn as to protect your systems?

SessionID: 37687

Tame Your Unruly Data...With Constraints!

Back to calendar

Event Date: 10-10-2015 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data...With Constraints!

Abstract:

Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!

SessionID: 37870

Don't Be Trigger Happy: Safe Use of Triggers

Back to calendar

Event Date: 10-10-2015 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Jack Corbett

Title: Don't Be Trigger Happy: Safe Use of Triggers

Abstract:

Many seasoned DBA's don't want developers to use triggers because of the many common mistakes made when coding triggers that can adversely affect performance. We will discuss the different types of triggers: DDL and DML (Instead of and after) and see many common mistakes made and how to fix them. We will also discuss when a trigger may be the best solution and other options when a trigger is not the best solution.

SessionID: 38137

Indexing your Data Warehouse

Back to calendar

Event Date: 10-10-2015 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: Indexing your Data Warehouse

Abstract:

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

SessionID: 38410

Roadmap: What's Coming Next for SQL Server BI and Power BI

Back to calendar

Event Date: 10-10-2015 - Session time: 16:30:00 - Track: BI Information Delivery

Speaker: Jen Underwood

Title: Roadmap: What's Coming Next for SQL Server BI and Power BI

Abstract:

In case you missed the memo, times have changed in the Microsoft BI world! We are now seeing massive investment in both cloud and on-premises Microsoft BI with rapid weekly releases. In this roadmap session, we will cover the Microsoft BI vision and then dive deeper into what is coming next for SQL Server BI and Power BI. There are many enhancements being made across SQL Server, MDS, SSIS, SSRS, SSAS, Power BI cloud, Power BI Desktop and other areas. Please join me in this "not-to-miss" session to explore upcoming innovations and enjoy a few bleeding edge demos.

SessionID: 38510

Introduction To R

Back to calendar

Event Date: 10-10-2015 - Session time: 16:30:00 - Track: Analytics and Visualization

Speaker: Robert Biddle

Title: Introduction To R

Abstract:

Data Science is a relatively new discipline. Core to this is the visualization of data. R is a language and environment used for data visualization and statistical computing.

In this session we'll explore the basics of the R language and review some examples. Additionally we'll review an implementation that integrates R into an ASP.NET application, allowing for sophisticated ways to display dashboards.

SessionID: 38658

Execution Plans for Mere Mortals

Back to calendar

Event Date: 10-10-2015 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

SessionID: 38734

Enterprise Auditing with SQL Server Audit

Back to calendar

Event Date: 10-10-2015 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Colleen Morrow

Title: Enterprise Auditing with SQL Server Audit

Abstract:

Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output?

In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options.

Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.

SessionID: 38859

Why I won't hire you and what you can do about it!

Back to calendar

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

Speaker: Leigh Freijo

Title: Why I won't hire you and what you can do about it!

Abstract:

As a hiring manager, I see the same mistakes over and over again. In this session we'll talk about common mistakes in resumes, interviews, social media and how you can avoid them. We'll also discuss lost opportunities and how not to miss them. This information applies to both internal and external candidates.

SessionID: 38911

DQ What? DQ Who? DQ How?

Back to calendar

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

Speaker: Brian Davis

Title: DQ What? DQ Who? DQ How?

Abstract:

Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.

This site is open source. Improve this page.