sqlsathistory

Nr: 48

Back to Main list

SQLSaturday #48 - Columbia 2010

Start Time (24h) Speaker Track Title
00:00:00 Aaron Nelson DB Admin 2 The Dirty Dozen: PowerShell Scripts for Busy DBAs
00:00:00 Aaron Nelson DB Admin 2 PowerShell 2.0 Beyond the Dirty Dozen
00:00:00 Andrew Kelly DB Dev 2 Maximizing Plan Re-use in SQL 2008
00:00:00 Andrew Kelly Large Session Storage and I/O Best Practices for SQL Server
00:00:00 Alex Tocitu DB Dev 1 PowerSQL(CLR)
00:00:00 Alex Tocitu DB Dev 2 CLR 101
00:00:00 Andy Leonard Large Session Database Design for Developers
00:00:00 Andy Leonard BI 1 SSIS Design Patterns
00:00:00 Andy Warren Misc Building a Professional Development Plan
00:00:00 Andy Warren DB Admin 1 DBA 101: The Basics
00:00:00 Ben DeBow DB Admin 1 Consolidated SQL Server Architectures
00:00:00 Bob Langley DB Dev 2 Introduction To Column Level Encryption
00:00:00 Brett Tomson DB Dev 1 What's New In SSRS 2008 (With Added R2 Flair)
00:00:00 Brett Tomson DB Dev 1 T-SQL Enhancements in SQL Server 2008
00:00:00 Julie Smith BI 1 Cool Tricks to Pull from your SSIS Hat
00:00:00 Tim Chapman DB Dev 1 How, where, why, and when to use Dynamic SQL
00:00:00 Chris Skorlinski DB Admin 1 Introduction to Transactional Replication
00:00:00 Chris Skorlinski Misc Top 5 fastest ways as DBA to get fired
00:00:00 David Taylor DB Admin 1 To click or to type, that is the question.
00:00:00 Ed Wilson Large Session Windows PowerShell Best Practices for SQL DBA's
00:00:00 Eric Humphrey Misc Object Relational Mappers for the DBA
00:00:00 Eric Humphrey DB Dev 2 Things To Do With PowerShell SMO
00:00:00 Evan Basalik DB Admin 2 Diagnosing connectivity issues with SQL Server
00:00:00 Evan Basalik BI 1 Troubleshooting SSRS Performance
00:00:00 Geoff Hiten DB Admin 2 Clustering for Mere Mortals
00:00:00 Geoff Hiten Large Session Bad SQL
00:00:00 Janis Griffin DB Admin 2 Tuna Helper - Proven Process for Tuning SQL
00:00:00 Janis Griffin DB Admin 1 SQL Server Service Broker – An Overview
00:00:00 Jose Chinchilla Misc Get Cert! Get Cred!
00:00:00 Jose Chinchilla BI 2 Business Intelligence: Decaffeinated Please!
00:00:00 Jessica Moss BI 1 Make Reporting Services Work For You
00:00:00 Jessica Moss BI 1 Who Needs a Data Warehouse?
00:00:00 John Welch BI 2 Creating Custom Components for SSIS
00:00:00 John Welch DB Dev 2 Processing Flat Files with SSIS
00:00:00 Matthew Campbell DB Dev 1 Going Spatial
00:00:00 Alejandro Mesa Large Session Parameter Sniffing
00:00:00 Rafael Salas Misc Planning your ETL architecture with SSIS
00:00:00 Rafael Salas DB Dev 2 Managing Database Schemas With VS201 DB projects
00:00:00 Sandra Mueller DB Admin 1 Data Files and Transaction Logs -- beyond the GUIs
00:00:00 Sandra Mueller BI 2 OLTP (yes!) Databases and Cube Design
00:00:00 Sergey Pustovit Large Session SQL Server Diagnostics Tools Unleashed
00:00:00 Sergey Pustovit DB Admin 2 SQL Server Performance Related DMVs
00:00:00 Mark Tabladillo BI 2 Data Mining with PowerPivot 2010
00:00:00 Stuart Ainsworth BI 2 Confessions of a Data Integrator: Bad Designs
00:00:00 Stuart Ainsworth DB Dev 1 You Got XML In My Database? What's Up With That?
00:00:00 Wayne Snyder BI 1 Information Visualization - Making great Charts
00:00:00 William E Pearson III BI 2 Getting Started with MDX
00:00:00 William E Pearson III Misc Attribute Discretization in Analysis Services

SessionID: 28402

The Dirty Dozen: PowerShell Scripts for Busy DBAs

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2

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

PowerShell 2.0 Beyond the Dirty Dozen

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2

Speaker: Aaron Nelson

Title: PowerShell 2.0 Beyond the Dirty Dozen

Abstract:

Now that you’ve learned the basics of PowerShell we’ll dive a little deeper and learn to develop scripts that help you get the most out of SQL Server. We’ll take a look at advanced functions, event logging and error handling. Then put everything together in a nice package and create our own modules to deploy to profiles across our entire SQL Server environment.

SessionID: 28559

Maximizing Plan Re-use in SQL 2008

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2

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

Storage and I/O Best Practices for SQL Server

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session

Speaker: Andrew Kelly

Title: Storage and I/O Best Practices for SQL Server

Abstract:

SessionID: 28571

PowerSQL(CLR)

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1

Speaker: Alex Tocitu

Title: PowerSQL(CLR)

Abstract:

This session will gradually increase your awareness of the capabilities of the .NET CLR.

We will show you half a dozen how-to's for querying external system objects like event logs and performance counters. We will continue with ways to integrate these with SSRS, SSIS, and/or Windows Forms.

SessionID: 28572

CLR 101

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2

Speaker: Alex Tocitu

Title: CLR 101

Abstract:

This session will bring you up to speed on simple CLR SQL Server objects implementations.

We will show you how to organize your environment to work with VS2010 Express and up. We will also show you how to organize your SQL Server Express and up, for hosting deployed CLR objects.

SessionID: 28677

Database Design for Developers

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session

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

SSIS Design Patterns

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 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: 28712

Building a Professional Development Plan

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Andy Warren

Title: Building a Professional Development Plan

Abstract:

A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.

SessionID: 28723

DBA 101: The Basics

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1

Speaker: Andy Warren

Title: DBA 101: The Basics

Abstract:

Are you an "accidental" or "unintentional" DBA? Or are you a manager or developer who wants to see more into the DBA world? If you're someone who has to wear a DBA hat or someone considering it, this presentation is for you. This presentation is a beginner session intending to show the basics every DBA needs to know to do the job.

SessionID: 28994

Consolidated SQL Server Architectures

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1

Speaker: Ben DeBow

Title: Consolidated SQL Server Architectures

Abstract:

There is more than one way to approach a consolidation effort, and you must understand the pros and cons of each. Consolidate on physical hardware? Use virtualization? Multiple instance per server or VM? How will availability be achieved for a consolidated environment? These topics and more will be addressed in this session.

SessionID: 29117

Introduction To Column Level Encryption

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2

Speaker: Bob Langley

Title: Introduction To Column Level Encryption

Abstract:

With the new data security standards and legislation, encryption has become a necessity in today’s business world. This session will introduce the new encryption options in SQL Server and then narrow the focus to column level encryption (not so new). The session will include slides and discussions to introduce concepts and will also have a live demo of a simple implementation of column level encryption. This is intended for anyone who is interested in SQL Server encryption, or those who need to implement some sort of encryption as part of their overall database information security strategy.

SessionID: 29246

What's New In SSRS 2008 (With Added R2 Flair)

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1

Speaker: Brett Tomson

Title: What's New In SSRS 2008 (With Added R2 Flair)

Abstract:

Microsoft SQL Server 2008 was released to much fanfare, excitement and anticipation in the IT community. The bevy of enhancements made to the various components coupled with sweeping performance gains made this version one of the most competitive and feature-rich database platforms on the market. In this session, we will examine the enhancements made to Reporting Services in SQL Server 2008 and 2008 R2.

SessionID: 29248

T-SQL Enhancements in SQL Server 2008

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1

Speaker: Brett Tomson

Title: T-SQL Enhancements in SQL Server 2008

Abstract:

The release of SQL Server 2008 represents a paradigm shift in the way that we program T-SQL. With new commands and new data types, 2008 provides the SQL developer with a bevy of options intended to make their development tasks easier. In this session, we will explore what enhancements have been made to T-SQL including (but not limited to) row constructors, the MERGE statement, table-valued parameters as well as what new data types are available to us.

SessionID: 29362

Cool Tricks to Pull from your SSIS Hat

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1

Speaker: Julie Smith

Title: Cool Tricks to Pull from your SSIS Hat

Abstract:

Cool Tricks to Pull from your SSIS Hat: Variables, For Each Loops, and the SSIS Expression Language. This presentation will cover some useful SSIS features commonly used to add flexibility and elegance to more advanced ETL solutions. The presentation demonstrates short case studies of real world business scenarios and solutions.

SessionID: 29446

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

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1

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 database 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: 29524

Introduction to Transactional Replication

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1

Speaker: Chris Skorlinski

Title: Introduction to Transactional Replication

Abstract:

SQL Server Replication allows you to distribute your data across multiple servers in support of a Disaster Recovery strategy or to offload data to a Reporting server. This sessions provides an overview of design and planning needed to successfully implement Transactional Replication topology in your organization.

SessionID: 29526

Top 5 fastest ways as DBA to get fired

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Chris Skorlinski

Title: Top 5 fastest ways as DBA to get fired

Abstract:

Are you new to DBA role, but would rather be a programmer? Have you been a DBA for a while but want a life changing event? Then this session is for you. I'll cover the top 5 things you as a DBA can do to get fired. If instead you want to keep your job as a DBA, attend to see what others are doing in order to get fired and open for you a job opportunity.

SessionID: 30028

To click or to type, that is the question.

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1

Speaker: David Taylor

Title: To click or to type, that is the question.

Abstract:

Are you a clicker or a typer? This session explores the use of scripting vs. using the GUI in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed.

SessionID: 30038

Windows PowerShell Best Practices for SQL DBA's

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session

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

Object Relational Mappers for the DBA

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc

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

Things To Do With PowerShell SMO

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2

Speaker: Eric Humphrey

Title: Things To Do With PowerShell SMO

Abstract:

Want to automatically store your database schema in a version control system (VCS)? Want to make changes across your database or server with less labor? Learn how with PowerShell and SMO. Bonus: compress your backups using 7zip and PowerShell.

SessionID: 30109

Diagnosing connectivity issues with SQL Server

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2

Speaker: Evan Basalik

Title: Diagnosing connectivity issues with SQL Server

Abstract:

Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.

SessionID: 30110

Troubleshooting SSRS Performance

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1

Speaker: Evan Basalik

Title: Troubleshooting SSRS Performance

Abstract:

Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past.

SessionID: 30225

Clustering for Mere Mortals

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2

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

Bad SQL

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session

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

Tuna Helper - Proven Process for Tuning SQL

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2

Speaker: Janis Griffin

Title: Tuna Helper - Proven Process for Tuning SQL

Abstract:

Many DBAs and Developers are faced with tuning poorly performing

SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as indexing strategies, use of column statistics, SQL wait event data, column selectivity and several more that will help the you succeed on future tuning projects.

SessionID: 30429

SQL Server Service Broker – An Overview

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1

Speaker: Janis Griffin

Title: SQL Server Service Broker – An Overview

Abstract:

SessionID: 30602

Get Cert! Get Cred!

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Jose Chinchilla

Title: Get Cert! Get Cred!

Abstract:

Obtaining a certification may be a dreaded and stressing process for some people. Most people fail because of their failure to plan a realistic roadmap towards their goals and not necessarily because they lack the skills.

This session will focus on establishing a roadmap towards certification success for the MCTS and MCITP programs of SQL Server and Business Intelligence. I will do a quick overview of my recent success obtaining 4 certifications in 30 days and how you can achieve similar goals.

But why certify? Join me to find out the opportunities you may be missing on!

SessionID: 30605

Business Intelligence: Decaffeinated Please!

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2

Speaker: Jose Chinchilla

Title: Business Intelligence: Decaffeinated Please!

Abstract:

For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure. In this session I will go over some of the basic concepts that are key in understanding BI and DW. I will also go over the natural roadmap towards BI success, its maturity stages and some of the factors that influence a successful BI project. I will exemplify all these concepts by showcasing a successful real-world BI and DW solution.

SessionID: 30796

Make Reporting Services Work For You

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1

Speaker: Jessica Moss

Title: Make Reporting Services Work For You

Abstract:

Are you frustrated with building reports in SQL Server Reporting Services? Tired of telling your users that you can't give them the perfect report due to limitations in the product? If so, this session will calm your nerves and make you a guru by showing how to utilize custom code and expressions to shine up your new or existing reports. Specifically, we will show how to create dynamic data groups, use paging techniques, add color and formatting, and more. This session is best suited for people with some knowledge of SSRS.

SessionID: 30797

Who Needs a Data Warehouse?

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1

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

Creating Custom Components for SSIS

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2

Speaker: John Welch

Title: Creating Custom Components for SSIS

Abstract:

SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.

SessionID: 30930

Processing Flat Files with SSIS

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2

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.

SessionID: 31601

Going Spatial

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1

Speaker: Matthew Campbell

Title: Going Spatial

Abstract:

Thinking of adding spatial functionality to your application? You'll need to learn how to start using SQL Server Spatial data types. This session will cover the basics of spatial support in SQL Server 2008 as well some freely available tools that will help you go spatial with your data.

SessionID: 31703

Parameter Sniffing

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session

Speaker: Alejandro Mesa

Title: Parameter Sniffing

Abstract:

Is your stored procedure, prepared statement, or ad-hoc query taking to long after a good start?

Learn what is parameter sniffing, how it could affect your query response time, and what can we do when it doesn't help. In this session we will learn about recompiling, OPTION clause, and plan guides.

SessionID: 32503

Planning your ETL architecture with SSIS

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Rafael Salas

Title: Planning your ETL architecture with SSIS

Abstract:

The complexity and importance of Extract, Transform and Load (ETL) projects are often underestimated, and the consequences of a poorly planned and executed ETL project will inevitably lead to maintenance nightmares, low reliability of the system, or worse yet, to the failure of the project.

In this session, we will use ETL best practices to make a requirements checklist you can use in your next ETL implementation, and will demonstrate how you can use SSIS to implement and meet such requirements. If you already learned the basics about SSIS and now want to take your ETL solutions to the next level, or if you became an SSIS developer/architect by accident and wonder what do you need to succeed, then this is the right session for you.

SessionID: 32504

Managing Database Schemas With VS201 DB projects

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2

Speaker: Rafael Salas

Title: Managing Database Schemas With VS201 DB projects

Abstract:

Most developers agree that the database is the most important component in a typical application, yet the processes for managing changes to database objects as part of the development cycle are often rudimentary or inexistent.

In this session Rafael explains how you can use Visual Studio database projects to have better control over your database development cycle and reduce the risk and complexity involved in managing schema changes, testing and deployment. He will talk about the pros and cons he has experienced when using VS DB projects in his last projects, and will highlight some of the improvements available in the latest version of the tool. This session showcases VS 2010, but most the content remains relevant for VSDB2008 GDR2

SessionID: 32767

Data Files and Transaction Logs -- beyond the GUIs

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1

Speaker: Sandra Mueller

Title: Data Files and Transaction Logs -- beyond the GUIs

Abstract:

Performance of SQL Server poor? One cause may have been that starting file size that you didn't think was important because it will auto-grow. Why is auto-grow bad? Why shouldn't logs be auto-shrunk? Explore the physical structure of a database, how table structure effects use of memory and key mistakes to avoid. Additionally, dive into the transaction log process - VLFs, auto-recovery and lock escalation. Solid foundation for Programmers and Administrators!

SessionID: 32768

OLTP (yes!) Databases and Cube Design

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2

Speaker: Sandra Mueller

Title: OLTP (yes!) Databases and Cube Design

Abstract:

OLAP, Cube, BI, SSAS -- what is the difference? In this session look at the difference between a database designed for OLAP and OLTP -- star and snowflake schemas and the benefits and costs of each. After we understand what is sourcing a cube we will look at the basic cube structure, how to source from OLTP or OLAP database and the cost of ROLAP, HOLAP and MOLAP. I have implemented many cubes for small finance departments allowing them to browse a nightly set of data in Excel, without them downloading spreadsheets of data during production hours. The cube improved overall system performance without a redesigned database.

SessionID: 32894

SQL Server Diagnostics Tools Unleashed

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session

Speaker: Sergey Pustovit

Title: SQL Server Diagnostics Tools Unleashed

Abstract:

SessionID: 32895

SQL Server Performance Related DMVs

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2

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

Data Mining with PowerPivot 2010

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 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: 33242

Confessions of a Data Integrator: Bad Designs

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2

Speaker: Stuart Ainsworth

Title: Confessions of a Data Integrator: Bad Designs

Abstract:

SessionID: 33243

You Got XML In My Database? What's Up With That?

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1

Speaker: Stuart Ainsworth

Title: You Got XML In My Database? What's Up With That?

Abstract:

A brief presentation exploring the marriage of XML and relational databases, including when it works and when it doesn't. Coverage will include an overview of four of the five basic xQuery functions supported by SQL Server 2005+, a couple of use case scenarios, and some tips on how to improve performance using design techniques.

SessionID: 33863

Information Visualization - Making great Charts

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1

Speaker: Wayne Snyder

Title: Information Visualization - Making great Charts

Abstract:

SessionID: 33923

Getting Started with MDX

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.

SessionID: 33924

Attribute Discretization in Analysis Services

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc

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.