sqlsathistory

Nr: 46

SQLSaturday #46 - Raleigh 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Nelson	Track 6	The Dirty Dozen: PowerShell Scripts for Busy DBAs
00:00:00	Andrew Kelly	Track 3	Maximizing Plan Re-use in SQL 2008
00:00:00	Andrew Kelly	Track 6	SQL Server Configuration Best Practices
00:00:00	Andy Leonard	Track 1	Build Your First SSIS Package
00:00:00	Andy Leonard	Track 4	Database Design for Developers
00:00:00	Andy Leonard	Track 1	SSIS Design Patterns
00:00:00	Allen White	Track 4	XQuery Basics
00:00:00	Tim Chapman	Track 4	How, where, why, and when to use Dynamic SQL
00:00:00	Chris Skorlinski	Track 1	Introduction to Change Data Capture
00:00:00	Chris Skorlinski	Track 1	Integrating CDC and SSIS for Incremental Data Load
00:00:00	Ed Wilson	Track 6	Windows PowerShell Best Practices for SQL DBA's
00:00:00	Eric Humphrey	Track 6	Object Relational Mappers for the DBA
00:00:00	Flavio Almeida	Track 5	Self-Service BI with PowerPivot
00:00:00	Geoff Hiten	Track 5	Bad SQL
00:00:00	Geoff Hiten	Track 6	Clustering for Mere Mortals
00:00:00	Grant Fritchey	Track 3	Identifying and Fixing Performance Problems using
00:00:00	Jana Sattainathan	Track 3	Partitioning in SQL Server 2005/2008
00:00:00	Jessica Moss	Track 5	Who Needs a Data Warehouse?
00:00:00	Jason Hall	Track 5	Recipe for a Happy DBA - A Guide for SQL Server De
00:00:00	John Welch	Track 1	Processing Flat Files with SSIS
00:00:00	John Welch	Track 1	Patterns for SSIS Configuration and Deployment
00:00:00	Kevin Goode	Track 3	Statistics, how to prove everything but the truth.
00:00:00	Kevin Goode	Track 4	Embracing the CLR
00:00:00	Mike Davis	Track 5	Reporting Services 2008 R2, the New Stuff
00:00:00	Mike Davis	Track 2	Using Parameters in SQL Server Reporting Services
00:00:00	Sergey Pustovit	Track 3	SQL Server Performance Related DMVs
00:00:00	Thomas LaRock	Track 3	Performance Tuning Made Easy
00:00:00	Mark Tabladillo	Track 2	Document Classification using DMX in SSAS
00:00:00	Mark Tabladillo	Track 2	Data Mining with PowerPivot 2010
00:00:00	Steven Wright	Track 2	The Shade Tree Mechanic's Guide to SSAS
00:00:00	Kevin Boles	Track 4	Advanced TSQL Solutions
00:00:00	Kevin Boles	Track 4	Common TSQL Programming Mistakes
00:00:00	William E. Pearson III	Track 2	Attribute Discretization in Analysis Services

SessionID: 28409

The Dirty Dozen: PowerShell Scripts for Busy DBAs

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Aaron Nelson

Title: The Dirty Dozen: PowerShell Scripts for Busy DBAs

Abstract:

For DBAs PowerShell provides a simple but powerful way to automate everyday tasks. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of PowerShell to easily find Servers short on space, Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

SessionID: 28555

Maximizing Plan Re-use in SQL 2008

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Andrew Kelly

Title: Maximizing Plan Re-use in SQL 2008

Abstract:

Lack of plan reuse is one of the biggest performance killers in SQL Server and almost everyone has experienced problems in this area before. We will explore exactly how to determine if this is an issue for you and more importantly, how to address it. See what factors determine if a plan gets reused or not and why. We will cover how to issue calls to the database that guarantee reuse and peak performance. Understanding this aspect of SQL Server is something every good DBA should be fully aware of and attending this session will get you the insight to get started immediately.

SessionID: 28556

SQL Server Configuration Best Practices

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Andrew Kelly

Title: SQL Server Configuration Best Practices

Abstract:

There is simply no substitute for proper planning when it comes to deploying and configuring a SQL Server instance. Do you know what options you should change or set when installing or configuring a SQL Server instance? If not you are certainly not alone. This session will cover the best practices for the key areas regarding the configuration of the SQL Server instance and the underlying server. Keeping these best practices mind will give you a head start on ensuring your database will be scalable and perform at its best.

SessionID: 28668

Build Your First SSIS Package

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Andy Leonard

Title: Build Your First SSIS Package

Abstract:

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up

SessionID: 28669

Database Design for Developers

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Andy Leonard

Title: Database Design for Developers

Abstract:

This session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.

SessionID: 28672

SSIS Design Patterns

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Andy Leonard

Title: SSIS Design Patterns

Abstract:

This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference.

SessionID: 28916

XQuery Basics

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Allen White

Title: XQuery Basics

Abstract:

With the introduction of the XML data type in SQL Server 2005 a new level of flexibility has been introduced to relational database environments to support loosely structured data. To get that data back requires an understanding of XQuery, the powerful query language written for XML specifically. This session will cover the basics of XQuery and help you get up to speed on this new environment.

SessionID: 29448

How, where, why, and when to use Dynamic SQL

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Tim Chapman

Title: How, where, why, and when to use Dynamic SQL

Abstract:

This session will be an in-depth session of the reasons for and against using dynamic SQL in applications. We'll look at different ways to write dynamic SQL statements, performance and security considerations that accompany using dynamic SQL, and how and when to take advantage of this powerful tool.

SessionID: 29491

Introduction to Change Data Capture

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Chris Skorlinski

Title: Introduction to Change Data Capture

Abstract:

Change Data Capture (CDC) is used by data warehouse applications to retrieve Type I and Type II dimension updates. This sessions provides a walk through of Microsoft's newest SQL Replication feature called CDC. Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of Type I and Type II data changes.

SessionID: 29492

Integrating CDC and SSIS for Incremental Data Load

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Chris Skorlinski

Title: Integrating CDC and SSIS for Incremental Data Load

Abstract:

Working together, Change Data Capture (CDC) and SSIS can identify changed data and move changes to your Data Warehouse. This session will focus on using SSIS package to pull daily, hourly, or near real-time Type I and Type II dimension changes from SQL Server running CDC.

SessionID: 30036

Windows PowerShell Best Practices for SQL DBA's

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Ed Wilson

Title: Windows PowerShell Best Practices for SQL DBA's

Abstract:

Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences.

SessionID: 30053

Object Relational Mappers for the DBA

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Eric Humphrey

Title: Object Relational Mappers for the DBA

Abstract:

Object Relational Mappers (ORMs) are a tool often praised by developers and despised by DBAs. I'll show that, like most tools, ORMs have their place if used responsibly. They can also get out of hand if they are trusted to always do the right thing. I will demonstrate usage of the most common ORMs for .NET and how each can go awry as well as how to monitor each for proper usage. This will not be a validation or admonishment of their usage; simply a look at their advantages and how to overcome some of their disadvantages.

SessionID: 30189

Self-Service BI with PowerPivot

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Flavio Almeida

Title: Self-Service BI with PowerPivot

Abstract:

PowerPivot is one of the most significant, arguably Microsoft’s most important Business Intelligence (BI) advance since the advent of Microsoft SQL Server Analysis Services 2005. It seriously delivers on the long-awaited promise of “self-service BI” and “BI for the masses”, by leveraging Microsoft Excel, the world’s most-used analysis platform, Microsoft SharePoint, the rapidly growing collaboration platform, and a new, in-memory version of Analysis Services. PowerPivot enables end users to build high performance analytic applications without having to wait for IT to build cubes and develop the extract transform and load (ETL) process to populate them, or to learn MDX to achieve multidimensional calculations.

SessionID: 30227

Bad SQL

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Geoff Hiten

Title: Bad SQL

Abstract:

How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.

SessionID: 30228

Clustering for Mere Mortals

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Geoff Hiten

Title: Clustering for Mere Mortals

Abstract:

Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.

SessionID: 30262

Identifying and Fixing Performance Problems using

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Grant Fritchey

Title: Identifying and Fixing Performance Problems using

Abstract:

This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate methods for addressing the issues and show how the fixed query's execution plans differ. Multiple methods for accessing execution plans including GUI, DMV's, and trace events are demonstrated. This lays a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster.

SessionID: 30422

Partitioning in SQL Server 2005/2008

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jana Sattainathan

Title: Partitioning in SQL Server 2005/2008

Abstract:

Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple, efficient. Manageability and performance come part and parcel.

SessionID: 30800

Who Needs a Data Warehouse?

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Jessica Moss

Title: Who Needs a Data Warehouse?

Abstract:

The decision to incorporate a data warehouse into your company’s daily routine is not an easy process. This interactive session will discuss the benefits and disadvantages of having a data warehouse. As a group, we will present reporting and structural alternatives, as well as the pros and cons of building, maintaining, and using a data warehouse.

SessionID: 30827

Recipe for a Happy DBA - A Guide for SQL Server De

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Jason Hall

Title: Recipe for a Happy DBA - A Guide for SQL Server De

Abstract:

In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. We will also briefly discuss features included in SQL Server 2008 R2 designed to help abstract DBA and developer division of responsibilities. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid beginning execution plan analysis.

SessionID: 30942

Processing Flat Files with SSIS

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: John Welch

Title: Processing Flat Files with SSIS

Abstract:

When doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats. You’ll also see how to produce complex output formats.

SessionID: 30946

Patterns for SSIS Configuration and Deployment

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: John Welch

Title: Patterns for SSIS Configuration and Deployment

Abstract:

SessionID: 31294

Statistics, how to prove everything but the truth.

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Kevin Goode

Title: Statistics, how to prove everything but the truth.

Abstract:

“Like other occult techniques of divination, the statistical method has a private jargon deliberately contrived to obscure its methods from non-practitioners.” Ashley-Perry Statistical Axioms

Statistics are the life blood of a cost based optimizers such as SQL Server and are a key component of performance tuning. This session will attempt to demystify statistics in regards to SQL Server the query optimizer. The internals of statistics will be examined and explained so that you will understand what statistics are available, how the optimizer uses those statistics, what causes statistics to be recomputed and when it happens.

SessionID: 31295

Embracing the CLR

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Kevin Goode

Title: Embracing the CLR

Abstract:

When you mention CLR does your DBA run screaming from the room? Have you considered using the CLR but are intimidated by .Net and how foreign it seems compared to T-SQL? Have you ever thought that working with strings and dates in T-SQL is needlessly difficult and painful? This session will help demystify CLR integration, show you how to expose basic CLR functionality to your database, demonstrate how to get large performance gains from very little CLR code and give you the information and evidence you need to convince your DBA that the CLR is not inherently evil, and in the right circumstance, is the best solution to a problem

SessionID: 31687

Reporting Services 2008 R2, the New Stuff

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Mike Davis

Title: Reporting Services 2008 R2, the New Stuff

Abstract:

In this session Mike shows you the new features in Reporting Services 2008 R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts. Learn how to drill down from the US level to the state level using the map controls.

SessionID: 31688

Using Parameters in SQL Server Reporting Services

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Mike Davis

Title: Using Parameters in SQL Server Reporting Services

Abstract:

In this session Mike shows parameters in many different ways including cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures, and custom code. Learn how to change the formatting of a report using Parameters.

SessionID: 32891

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Sergey Pustovit

Abstract:

There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs.

SessionID: 33067

Performance Tuning Made Easy

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Thomas LaRock

Title: Performance Tuning Made Easy

Abstract:

Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.

SessionID: 33094

Document Classification using DMX in SSAS

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Mark Tabladillo

Title: Document Classification using DMX in SSAS

Abstract:

In this session we will look at what text mining tools are available for document classification with DMX (Data Mining Extensions). This example is a powerful yet often underutilized feature of SSAS (SQL Server Analysis Services). We will walk through the process of allowing SSAS aid in document classification. We will look at criteria to decide implementations based on several different implementations. Finally we will evaluate where text mining can help you in a practical business environment.

SessionID: 33095

Data Mining with PowerPivot 2010

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Mark Tabladillo

Title: Data Mining with PowerPivot 2010

Abstract:

Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies.

SessionID: 33309

The Shade Tree Mechanic's Guide to SSAS

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Steven Wright

Title: The Shade Tree Mechanic's Guide to SSAS

Abstract:

This is a session for the SQL DBA that has SSAS in their environment, but is not sure what happens under the hood when it queried, much less how to tell if it's performing at its best. This is not a session on query optimization. But, this session will help you better understand if there is room for query optimization or if some basic configuration changes might provide that needed boost. We'll discuss the basic architecture of SSAS and cover some of the most pertinent metrics to give you a quick and easy view into your SSAS server's performance.

SessionID: 33540

Advanced TSQL Solutions

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Kevin Boles

Title: Advanced TSQL Solutions

Abstract:

The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.

SessionID: 33541

Common TSQL Programming Mistakes

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Kevin Boles

Title: Common TSQL Programming Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.

SessionID: 33895

Attribute Discretization in Analysis Services

Back to calendar

Event Date: 18-09-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: William E. Pearson III

Title: Attribute Discretization in Analysis Services

Abstract:

Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, we will discuss the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.

This site is open source. Improve this page.