sqlsathistory

Nr: 77

Back to Main list

SQLSaturday #77 - Pensacola 2011

Start Time (24h) Speaker Track Title
00:00:00 Aaron Nelson Performance Quickly Gather Performance Data with PowerShell
00:00:00 Aaron Nelson MISC Loading Data with PowerShell
00:00:00 Audrey Hammonds DBA and TSQL T-SQL Awesomeness: 3 Ways to Write Cool SQL
00:00:00 Barry Ralston MISC PowerPivot, Idea to Solution in 60 Minutes
00:00:00 Bryan Soltis DEV Deploying Kentico CMS Applcaition to Windows Azure
00:00:00 Bradley Schacht SSIS and BI Dynamic SSIS: Configurations, Expression and Vari
00:00:00 Julie Smith SSIS and BI Up and Running with SSIS in 5,4,3,2, (Datachix)1 !
00:00:00 Eric Wisdahl Performance Performance Tuning With Execution Plans
00:00:00 Joe Healy Windows Phone Garage Windows Phone Garage
00:00:00 Jorge Segarra DBA Pulp SQL
00:00:00 Karla Landrum Windows Phone Garage Windows Phone Garage (Continued)
00:00:00 Karla Landrum DBA RedGate Tools Demonstration
00:00:00 Kevin Grohoske DEV Building Occasionally Connected Apps Using SQL Azu
00:00:00 Devin Knight DBA Introduction to Data Warehousing
00:00:00 Devin Knight Performance Performance Tuning Analysis Services
00:00:00 Vincent Mayfield DEV Windows Azure Overview
00:00:00 Michael Wells MISC Using PowerShell to Rapidly Deploy SQL Server
00:00:00 Mike Huguet DEV The Power of ASP.NET 4.0 Dynamic Data
00:00:00 Mike Huguet DEV Leveraging Open XML to Create More Dynamic Docs
00:00:00 Ryan Duclos DBA and TSQL Introduction to SQL Azure
00:00:00 Rob Volk DBA Revenge: The SQL!
00:00:00 Rodney Landrum DBA and TSQL T-SQL Alphabet Soup
00:00:00 Russ Fustino Windows Phone Garage How to Make (more) Money with WP7
00:00:00 Sven Aelterman MISC Entity Framework v4.1: What's New in 2011
00:00:00 Sven Aelterman DEV Entity Framework Quick Introduction
00:00:00 Shawn McGehee DBA Building SMO Apps for the Non-Programmer DBA
00:00:00 Steve Jones MISC Branding Yourself for a Dream Job - The Modern Res
00:00:00 Steve Jones DBA Preparation for Disaster
00:00:00 Ted Krueger SSIS and BI SSIS: The DBA multiplier
00:00:00 Kevin Boles DBA SQL Server Partitioning from A to Z
00:00:00 Kevin Boles Performance SQL Server Memory Deep Dive
00:00:00 Thomas LeBlanc Performance Execution Plan Basics - Beginners
00:00:00 Tim Radney DBA and TSQL You inherited a database, now what?
00:00:00 Thomas LeBlanc SSIS and BI Transition from DBA to BI Architect
00:00:00 Troy Ketsdever DBA and TSQL Predictive Analytics - You Can, Too!
00:00:00 Wayne Sheffield DBA and TSQL Table Vars and Temp Tables: What you NEED to know!
00:00:00 William E Pearson III SSIS and BI Attribute Discretization in Analysis Services (BI)
00:00:00 William E Pearson III SSIS and BI Design and Implement BI Like Edison!
00:00:00 William Assaf Performance SQL Server DMV Overview

SessionID: 28379

Quickly Gather Performance Data with PowerShell

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance

Speaker: Aaron Nelson

Title: Quickly Gather Performance Data with PowerShell

Abstract:

Continuously gathering performance data to log history and developing a performance baseline is a really important task in any environment. Having quick access to what’s happening right now is equally important. In this session we’ll take a look at how to continuously gather Perfmon counters and DMV info. We’ll also take a look at how to Visualize the data using charts.

SessionID: 28380

Loading Data with PowerShell

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC

Speaker: Aaron Nelson

Title: Loading Data with PowerShell

Abstract:

In this session we’ll take a look at how to load data into SQL Server using various data sources such as: text, csv, table. We’ll also load data from XML files; update data inside of XML files; and even kick off SSIS packages all from PowerShell. Finally we'll re-use our newly found XML scills to modify an SSIS package before we run it.

SessionID: 28888

T-SQL Awesomeness: 3 Ways to Write Cool SQL

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL

Speaker: Audrey Hammonds

Title: T-SQL Awesomeness: 3 Ways to Write Cool SQL

Abstract:

There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability.

Come learn three new-school ways to expand your T-SQL repertoire with: • Recursive Common Table Expressions (CTE) • EXCEPT and INTERSECT • CROSS APPLY and OUTER APPLY

We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills.

SessionID: 28967

PowerPivot, Idea to Solution in 60 Minutes

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC

Speaker: Barry Ralston

Title: PowerPivot, Idea to Solution in 60 Minutes

Abstract:

SessionID: 29303

Deploying Kentico CMS Applcaition to Windows Azure

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV

Speaker: Bryan Soltis

Title: Deploying Kentico CMS Applcaition to Windows Azure

Abstract:

In this session, Bryan Soltis will demonstrate deploying a Kentico CMS application to Windows Azure. Topics covered will include converting a Kentico CMS site to a web application, adding and configuring a Windows Azure web role, implementation and configuration of Windows Azure storage accounts, deployment of a Kentico CMS database to SQL Azure, and deploying the application to Windows Azure. Bryan will demonstrate several code examples, real world applications, and best practices in developing Kentico CMS in the cloud.

SessionID: 29324

Dynamic SSIS: Configurations, Expression and Vari

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI

Speaker: Bradley Schacht

Title: Dynamic SSIS: Configurations, Expression and Vari

Abstract:

One of the biggest hurdles in any organization is migrating from DEV to PROD with minimal issues. In this session Brad will help get you over the learning curve of making dynamic SSIS packages to make this transition easier. Topics of discussion will include using all the different types of package configurations, the SSIS expression language and variables. After diving into each of these topics Brad will talk about best practices as well as the pros, cons and limitations of using each type of configuration. At the end of this session you will be able to configure your SSIS packages to be as simple to modify and move without even opening a package!

SessionID: 29360

Up and Running with SSIS in 5,4,3,2, (Datachix)1 !

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI

Speaker: Julie Smith

Title: Up and Running with SSIS in 5,4,3,2, (Datachix)1 !

Abstract:

This presentation is for those familiar with SQL Server, but absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour, stepping through a classic "old pro" DBA forced into Beginner ETL Developer scenario. We'll quickly cover not just developing the package, but also ways to deploy and execute.

SessionID: 30141

Performance Tuning With Execution Plans

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance

Speaker: Eric Wisdahl

Title: Performance Tuning With Execution Plans

Abstract:

In this session we will look at examining execution plans as a method for performance tuning. With the execution plan we can see the exact type of operation performed, and, more than that, we can look at the differences in what the optimizer thought the query would cost vs what it actually cost to perform the query. By examining the plans we have a road map for determining what type of improvements we should be striving for in order to make the particular statement more optimal.

SessionID: 30832

Windows Phone Garage

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Windows Phone Garage

Speaker: Joe Healy

Title: Windows Phone Garage

Abstract:

You're invited to spend a few hours working with "SAMS WP7 Development in 24 Hours" book authors Kevin Wolf and Joe Healy on your Windows Phone applications. We can play "fix the architecture", brainstorm, troubleshoot, or just give you a quiet zone to co-work on your applications. Every 30 minutes Joe or Kevin will supply some "quick tips" in a lightning talk format from their book. Bring your laptop pre-loaded with the devtools and be ready to go.

SessionID: 31032

Pulp SQL

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Jorge Segarra

Title: Pulp SQL

Abstract:

Pulp SQL: Stories, all have them. In this session Brad and Jorge will tell the tales of how SQL in shops can go horribly wrong, and how to properly go about doing it. This story will be told Tarrantino-style so prepare for some twists, characters and ninja-like tactics* to help you avoid your own SQL mistakes!*fight scenes may or may not break out

SessionID: 31202

Windows Phone Garage (Continued)

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Windows Phone Garage

Speaker: Karla Landrum

Title: Windows Phone Garage (Continued)

Abstract:

You're invited to spend a few hours working with "SAMS WP7 Development in 24 Hours" book authors Kevin Wolf and Joe Healy on your Windows Phone applications. We can play "fix the architecture", brainstorm, troubleshoot, or just give you a quiet zone to co-work on your applications. Every 30 minutes Joe or Kevin will supply some "quick tips" in a lightning talk format from their book. Bring your laptop pre-loaded with the devtools and be ready to go.

SessionID: 31203

RedGate Tools Demonstration

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Karla Landrum

Title: RedGate Tools Demonstration

Abstract:

TBA

SessionID: 31330

Building Occasionally Connected Apps Using SQL Azu

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV

Speaker: Kevin Grohoske

Title: Building Occasionally Connected Apps Using SQL Azu

Abstract:

In this presentation we will walk though utilizing Microsoft SQL Azure, a scalable cloud database service built on SQL Server technologies, and the Microsoft Sync Framework, a comprehensive synchronization platform, to build a highly available and scalable collaboration business application. Along the way we will discuss the capabilities and challenges of building such an application using the current frameworks.

SessionID: 31435

Introduction to Data Warehousing

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Devin Knight

Title: Introduction to Data Warehousing

Abstract:

In this session you will learn why you need a Data Warehouse, how to plan for one, and what the key steps to developing one. You will learn conceptually how you can leverage the Microsoft BI Stack to design and implement a Data Warehouse. This session will focus more on the concepts of development rather than demonstrating the development itself.

SessionID: 31436

Performance Tuning Analysis Services

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance

Speaker: Devin Knight

Title: Performance Tuning Analysis Services

Abstract:

In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.

SessionID: 31651

Windows Azure Overview

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV

Speaker: Vincent Mayfield

Title: Windows Azure Overview

Abstract:

Should you be be looking to the Cloud? Your path to blue skies might be through Windows Azure Platform.Windows Azure is just one element of Microsoft's Cloud Computing Strategy. There are a wide variety of Cloud Services and Cloud Technology offerings from Microsoft. This session will focus on Windows Azure and the Microsoft offerings under this umbrella. It will provide developers and business people an overview of Windows Azure.

SessionID: 31776

Using PowerShell to Rapidly Deploy SQL Server

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC

Speaker: Michael Wells

Title: Using PowerShell to Rapidly Deploy SQL Server

Abstract:

This session will cover a PowerShell project that is designed to allow organizations to rapidly deploy new SQL Server instances to their environment. The process includes automating all aspects of the SQL Server install from Operating System pre-configurations, the SQL Server install, to deploying standard SQL objects such as databases, tables, jobs, and stored procedures.

SessionID: 31905

The Power of ASP.NET 4.0 Dynamic Data

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV

Speaker: Mike Huguet

Title: The Power of ASP.NET 4.0 Dynamic Data

Abstract:

ASP.NET Dynamic Data is now a matured offering of the .NET framework. In this session we will take a feature tour demonstrating its power and flexibility. We’ll discuss practical usages and customizations.

SessionID: 31906

Leveraging Open XML to Create More Dynamic Docs

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV

Speaker: Mike Huguet

Title: Leveraging Open XML to Create More Dynamic Docs

Abstract:

Take advantage of the Open XML format and the .NET SDK to construct and manipulate documents, allowing for simplified interactions with Office documents. This session covers the Open XML format, the Open XML SDK, and shows some examples of how to apply this in real world solutions. We’ll also discuss the role of some of the SharePoint Office Services.

SessionID: 32469

Introduction to SQL Azure

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL

Speaker: Ryan Duclos

Title: Introduction to SQL Azure

Abstract:

SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the full relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer.

SessionID: 32589

Revenge: The SQL!

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG!

This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!

SessionID: 32627

T-SQL Alphabet Soup

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL

Speaker: Rodney Landrum

Title: T-SQL Alphabet Soup

Abstract:

Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.

SessionID: 32682

How to Make (more) Money with WP7

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Windows Phone Garage

Speaker: Russ Fustino

Title: How to Make (more) Money with WP7

Abstract:

When you get your app running… and even more so when published… you are most likely feeling pretty good and on cloud 9. It feels great, doesn’t it? Here are a few suggestions in this chapter to make you feel even better. Of course, more work is needed. Getting your app noticed in marketplace will not happen automatically or optimally by publishing alone. There specific suggestions I will offer up to help the cause. So, grab a deep breath and get ready to settle in and focus on making more money. Make all the time you have invested so far, well worth it. Many of the suggestions are common sense when you think them through, but are a few I found out the hard way and hopefully will save you some pain. Topics include: Marketing Basics, Gettin

SessionID: 32742

Entity Framework v4.1: What's New in 2011

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC

Speaker: Sven Aelterman

Title: Entity Framework v4.1: What's New in 2011

Abstract:

Originally released with Visual Studio 2010 and .NET Framework v4, Entity Framework v4 has seen a remarkable evolution in the past year or so. In April, Microsoft released version 4.1. Most notably, there is now great support for Code First development. This talk will delve into the use of Code First in Entity Framework v4.1 and will be very code focused. Developers will learn how they can use the Entity Framework APIs to create applications that use Entity Framework features to access relational databases without the need to use designers to create the model. It is in essence a "code only" approach, which has many benefits, including for testability and long-term evolution of your code.

SessionID: 32743

Entity Framework Quick Introduction

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV

Speaker: Sven Aelterman

Title: Entity Framework Quick Introduction

Abstract:

For those attendees who want to attend the Entity Framework version 4.1 session, but aren’t quite sure what Entity Framework is, and how to get started with the basics, this talk with some background info and basic demos will get you up to speed. This will use the traditional EF approach of creating a model using a designer based on an existing or new database.

SessionID: 32914

Building SMO Apps for the Non-Programmer DBA

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Shawn McGehee

Title: Building SMO Apps for the Non-Programmer DBA

Abstract:

SMO gives us an exremely powerful library that can be used to perform a slew of SQL Server tasks. Using this library we can build tools to automate daily tasks and even build apps that might not be easy to do or even possible with SSMS/TSQL. In this session I will teach you, the non-programmer DBA, how to build an SMO application that performs some SQL Server health checks and reports back to you in a nice GUI tool. We will go over some basic OOP information but the bulk of this session will be hands on building/demoing. No .NET experience is required. The less experience you have with .NET development the better!!

SessionID: 32931

Branding Yourself for a Dream Job - The Modern Res

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job - The Modern Res

Abstract:

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

SessionID: 32932

Preparation for Disaster

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Steve Jones

Title: Preparation for Disaster

Abstract:

This session will showcase how a DBA can be ready for any problems that might occur in their environment. Steve Jones will talk about how you can develop a well thought out backup and recovery solution for all kinds of disasters, learn about practicing restores, and the value of regularly running checks for corruption in your databases..

SessionID: 33339

SSIS: The DBA multiplier

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI

Speaker: Ted Krueger

Title: SSIS: The DBA multiplier

Abstract:

Ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks!

SessionID: 33447

SQL Server Partitioning from A to Z

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Kevin Boles

Title: SQL Server Partitioning from A to Z

Abstract:

We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.

SessionID: 33448

SQL Server Memory Deep Dive

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance

Speaker: Kevin Boles

Title: SQL Server Memory Deep Dive

Abstract:

Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance.

SessionID: 33565

Execution Plan Basics - Beginners

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance

Speaker: Thomas LeBlanc

Title: Execution Plan Basics - Beginners

Abstract:

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

SessionID: 33608

You inherited a database, now what?

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL

Speaker: Tim Radney

Title: You inherited a database, now what?

Abstract:

You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to.

SessionID: 33713

Transition from DBA to BI Architect

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI

Speaker: Thomas LeBlanc

Title: Transition from DBA to BI Architect

Abstract:

Database Normalization and Dimension Modeling are the same but different. Development in today ‘s larger industries require the design and analysis of Online Transaction Processing (OLTP) to take into account Data Warehousing/OLAP (Online Analytical Processing). My transition from Senior DBA to BI Architect at Amedisys has been a process of sanding the rough edges of my passion from fully normalized databases. The Dimensional Modeling started a re-tooling of my mind to look at end result analytics/statistics from smaller and smaller transactions. From previous experience, I know I am not going to get it right the first time. Lessons learned will mold me into a great BI Guy.

SessionID: 33794

Predictive Analytics - You Can, Too!

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL

Speaker: Troy Ketsdever

Title: Predictive Analytics - You Can, Too!

Abstract:

Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…

SessionID: 33866

Table Vars and Temp Tables: What you NEED to know!

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL

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 represent 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: 34144

Attribute Discretization in Analysis Services (BI)

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI

Speaker: William E Pearson III

Title: Attribute Discretization in Analysis Services (BI)

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, Microsoft BI Architect and SQL Server MVP Bill Pearson discusses the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.

SessionID: 34147

Design and Implement BI Like Edison!

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI

Speaker: William E Pearson III

Title: Design and Implement BI Like Edison!

Abstract:

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

SessionID: 34497

SQL Server DMV Overview

Back to calendar

Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance

Speaker: William Assaf

Title: SQL Server DMV Overview

Abstract:

What are DMV's in SQL 2005/2008, and how can you use them to improve query performance, discover indexing needs and more? Dynamic Management Views are essential tools for the SQL 2005/2008 administrator but have a wide range of applications by developers, network engineers and DBAs. Now updated with more jokes and more practical scripts!