sqlsathistory

Nr: 333

SQLSaturday #333 - St. Louis 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Britton Gray	Track 4	Data-ing Advice: Profiles are Important
00:00:00	Bill Fellows	Track 4	SSIS Project Deployment Model: Deployment and maintenance
00:00:00	Dave Bland	Track 3	Change Data Capture - What is it and Why I should use it
00:00:00	Dennis Graham	Track 3	Reporting for SQL Server Health
00:00:00	Dennis Graham	Track 3	Violin Memory - Presentation
00:00:00	Dan Guzman	Track 2	Partition Management
00:00:00	Jeff Foushee	Track 2	Transforming Data using the T-SQL PIVOT / UNPIVOT operators
00:00:00	Kathi Kellenberger	Track 5	WIT Panel
00:00:00	Kathi Kellenberger	Track 1	T-SQL Window Function Performance
00:00:00	Lance Kolie	Track 1	Tabular vs Multidimensional. Lets build it together!
00:00:00	Larry Toothman	Track 3	Bridging The Gap
00:00:00	Randy Knight	Track 5	Understanding SQL Server XML Features
00:00:00	Randy Knight	Track 2	Locks, Blocks, and Deadlocks Oh My!
00:00:00	Rickey Nunn	Track 3	Designing a Better Database
00:00:00	Sreeni Julakanti	Track 2	SQL Server 2014 Cardinality Estimator changes
00:00:00	JK Wood	Track 1	NULL: A Love Story
00:00:00	Scott Shaw	Track 5	Big Data Market Overview
00:00:00	Scott Shaw	Track 5	Hive - Interactive SQL Querying for Hadoop
00:00:00	Stuart Ainsworth	Track 5	The Elephant in the Room; A DBA's Guide to Hadoop Big Data
00:00:00	Warren Sifre	Track 4	Introduction to FileTables in SQL 2012
00:00:00	Aaron King	Track 4	Agile Database Development

SessionID: 10408

Data-ing Advice: Profiles are Important

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Britton Gray

Title: Data-ing Advice: Profiles are Important

Abstract:

Data warehousing professionals often consider data profiling to be drudgery and/or an unnecessary part of the larger warehouse design process. However, information unearthed during this process can prove instrumental in avoiding pitfalls later on. This session will explore the reasons for profiling and scenarios in which it proves particularly useful. We will also discuss profiling methods, including the SSIS profiling task and supplemental profiling techniques that provide both developers and business users insight into the quality and consistency of source data.

SessionID: 10454

SSIS Project Deployment Model: Deployment and maintenance

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Bill Fellows

Title: SSIS Project Deployment Model: Deployment and maintenance

Abstract:

In this session, you'll learn everything you need to know to successfully deliver a modern SSIS solution. We'll cover the mechanics of deployment; creation, configuration and migration of Environment variables; monitoring execution troubleshooting.

SessionID: 12325

Change Data Capture - What is it and Why I should use it

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Dave Bland

Title: Change Data Capture - What is it and Why I should use it

Abstract:

High level overview of Change Data Capture, including what it is, how to configure it and how I can benefit by using it to populate my data warehouse.

SessionID: 13171

Reporting for SQL Server Health

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Dennis Graham

Title: Reporting for SQL Server Health

Abstract:

Many of us make our living writing reports for other people; it is time SQL server Professionals take advantage of reporting. You will walk away from this session with 40 or more reports designed to review an SQL Server system for its health and to predict potential problems.

SessionID: 13172

Violin Memory - Presentation

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Dennis Graham

Title: Violin Memory - Presentation

Abstract:

Violin Memory - Presentation

SessionID: 14919

Partition Management

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Dan Guzman

Title: Partition Management

Abstract:

SQL Server table partitioning can improve manageability of large tables, and in some cases performance too. This session will review table partitioning concepts, discuss common partitioning mistakes, and show how to automate partition management tasks using SQL Agent T-SQL jobs.

SessionID: 16757

Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Jeff Foushee

Title: Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Abstract:

Ever wish your horizontal data were vertical for easier data storage, or vice-versa for reporting purposes? Are you writing elaborate routines to transform between them for one-time usage? Are your queries repeating "OUTER JOIN" or "UNION” so often that you wind up back in Kansas when your read them aloud? Join Jeff Foushee as he explains SQL Server's lesser-known PIVOT and UNPIVOT operators using SQL 2014. After this session, you will no longer need to rotate your monitor!

SessionID: 18442

WIT Panel

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Kathi Kellenberger

Title: WIT Panel

Abstract:

The definition of confidence is “belief in oneself and one’s powers or abilities” but the authors of the new book “The Confidence Code” define confidence as “the quality that turns thoughts into actions.” Traditionally men have been found to have much more confidence in themselves than do women. For example, in a study at Hewlett-Packard, men applied for a promotion when they thought they could meet 60% of the qualifications while women applied only when they thought they could meet 100%. Attend this WIT session to learn more about confidence and how it impacts your career and life. To prepare for the session, it is recommended that you complete The Confidence Quiz (http://theconfidencecode.com/confidence-quiz/)

SessionID: 18444

T-SQL Window Function Performance

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Kathi Kellenberger

Title: T-SQL Window Function Performance

Abstract:

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

SessionID: 18946

Tabular vs Multidimensional. Lets build it together!

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Lance Kolie

Title: Tabular vs Multidimensional. Lets build it together!

Abstract:

This session will be one big demo where we will build both a Tabular and Multidimensional model side by side to contrast and compare the uses of both methods. By the end of this session you should have a good understanding of both modeling methods and how to make use of them in the future.

SessionID: 18968

Bridging The Gap

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Larry Toothman

Title: Bridging The Gap

Abstract:

For many who come to T-SQL from other languages, dealing with result sets and thinking in set based solutions can be frustrating. Our minds are conditioned to think in processing rows of data, not entire sets. As a consequence many give up and misuse cursors or come up with other ways to create RBAR (Row By Agonizing Row) solutions. Some others try to deal with sets but get caught in the tangle of nested queries. In this session I will deal with Table Expressions with particular emphasis on CTEs or Common Table Expressions. Let me show you how using these simple tools can help simplify your code, bridging the gap between RBAR and set based solutions.

SessionID: 22557

Understanding SQL Server XML Features

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Randy Knight

Title: Understanding SQL Server XML Features

Abstract:

The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.

SessionID: 22559

Locks, Blocks, and Deadlocks Oh My!

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Randy Knight

Title: Locks, Blocks, and Deadlocks Oh My!

Abstract:

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.

SessionID: 23138

Designing a Better Database

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Rickey Nunn

Title: Designing a Better Database

Abstract:

Most everyone knows how to build a table, an index, or a relationship, but the real challenge in database design is the process the data professional uses to interpret the business requirements into database designs which are both flexible and extensible.

In this session, I will NOT tell you the syntax of any database object.

In this session, we will review some of the common challenges we face and some philosophies which will help us to design and deliver better database designs.

SessionID: 24571

SQL Server 2014 Cardinality Estimator changes

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Sreeni Julakanti

Title: SQL Server 2014 Cardinality Estimator changes

Abstract:

This session covers the changes made to Cardinality Estimations and Calculations in SQL Server 2014.

SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. Topics Covered in this session How to enable and disable the new cardinality estimator behavior? What changed in new cardinality estimations? How to troubleshoot plan-quality regressions if and when they occur? Note : Presentation based on recent white paper released from Microsoft.

SessionID: 25170

NULL: A Love Story

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: JK Wood

Title: NULL: A Love Story

Abstract:

NULL - an unknown value. At least, that's what it's SUPPOSED to be. The problem is, NULL is often treated differently based on what you're doing - even equality is suspect. Join JK as he works on demystifying NULLs in the database, looking at how they interact with various queries and how to work around and with the idiosyncrasies of this sometimes misunderstood concept.

SessionID: 25186

Big Data Market Overview

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Scott Shaw

Title: Big Data Market Overview

Abstract:

This session will give you an insider look into what is driving the Big Data market. I'll relay lessons learned from talking with C-level executives from some of the largest corporations in the midwest as well as talking with guys in the trenches from companies like LinkedIn, Facebook, and Twitter. Everything is changing and this session will help you ride the tide and understand where things are going.

SessionID: 25187

Hive - Interactive SQL Querying for Hadoop

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Scott Shaw

Title: Hive - Interactive SQL Querying for Hadoop

Abstract:

This session will go into details around the Hive framework and how interactive SQL querying can be accomplished on a distributed file system. The session has a live demo showing the key features and will also discuss future enhancements. Is Hive a SQL Server killer? Let's find out.

SessionID: 25849

The Elephant in the Room; A DBA's Guide to Hadoop Big Data

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Stuart Ainsworth

Title: The Elephant in the Room; A DBA's Guide to Hadoop Big Data

Abstract:

The term "Big Data" has risen to popularity in the last few years, and encompasses data platforms outside of the traditional RDBMS (like SQL Server). The purpose of this session is to introduce SQL Server DBA's to Hadoop, and to promote understanding of how schema-less data can be collected and accessed in coordination with the traditional SQL models. We'll cover the basic vocabulary of the Hadoop platform, Microsoft's integration efforts, and demonstrate how to get started with "big data".

SessionID: 27571

Introduction to FileTables in SQL 2012

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Warren Sifre

Title: Introduction to FileTables in SQL 2012

Abstract:

What are FileTables? How do they work? What are their limitations? These questions and more will be answered in this demo filled presentation. We will walkthrough the configuration and implementation of this feature. We will show you some use cases on how this functionality can help you manage your data in whatever forms it exists.

SessionID: 8830

Agile Database Development

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Aaron King

Title: Agile Database Development

Abstract:

In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC. Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build. He'll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.

This site is open source. Improve this page.