sqlsathistory

Nr: 82

Back to Main list

SQLSaturday #82 - Indianapolis 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron King	Developer Track	Multi-Tenant Database Model with SQL Azure
00:00:00	Arie Jones	SQl Server Track 2	Take Control of Your Databases with PBM!
00:00:00	Arie Jones	Developer Track	Getting Started With Service Broker
00:00:00	Arie Jones	BI Track	Reporting Services Greatness!
00:00:00	Craig Purnell	SQl Server Track 2	Database Mirroring in the Real World
00:00:00	Craig Purnell	Developer Track	NoSQL- What is it and why do I care?
00:00:00	Eddie Wuerch	SQl Server Track 1	TempDB Performance Troubleshooting and Optimizing
00:00:00	Eddie Wuerch	SQl Server Track 1	Find Performance Problems by Reading the Waits
00:00:00	Ira Warren	BI Track	Creating a Metadata Mart w/ SSIS - Data Governance
00:00:00	Janis Griffin	Developer Track	Looney Tuner? No, there IS a method to my madness
00:00:00	Janis Griffin	SQl Server Track 1	Performance Management – 2008 MDW - How Why
00:00:00	John Welch	BI Track	Do More (ETL) with Less (Effort) - Automating SSIS
00:00:00	John Welch	BI Track	Tuning Analysis Services Processing Performance
00:00:00	John Magnabosco	SQl Server Track 2	Exploring Data Privacy
00:00:00	Kevin Kline	SQl Server Track 1	SQL Server Internals and Architecture
00:00:00	Kevin Kline	SQl Server Track 2	Top 10 Admin Mistakes on SQL Server
00:00:00	Norman Kelm	Developer Track	PowerShell, the New SQL Hammer
00:00:00	Sarah Barela	SQl Server Track 2	SQL Server Forensics: Tracking your users
00:00:00	Luke Jian	SQl Server Track 1	Back to basics - How does the Algebrizer work
00:00:00	Kevin Boles	Developer Track	Advanced TSQL Solutions
00:00:00	Kevin Boles	SQl Server Track 2	SQL Server Memory Deep Dive
00:00:00	William E Pearson III	BI Track	An Overview of PowerPivot for Excel
00:00:00	William E Pearson III	BI Track	Getting Started with MDX

SessionID: 28421

Multi-Tenant Database Model with SQL Azure

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: Developer Track

Speaker: Aaron King

Title: Multi-Tenant Database Model with SQL Azure

Abstract:

This talk will focus on the benefits, features, and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure. Real world topics and use cases will be covered including data sync and staying vendor independent while hosting your data in the cloud. When you use the Multi-Tenant Database Model and SQL Azure together you can create a very powerful solution. We'll start from scratch and go from design to deployment in this session.

SessionID: 28853

Take Control of Your Databases with PBM!

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 2

Speaker: Arie Jones

Title: Take Control of Your Databases with PBM!

Abstract:

A large majority of a modern DBA's workload consists of managing their policies and procedures to ensure that their systems are consistent and in many cases compliant with certain governmental requirements. SQL Server 2008 provides Policy Based Management (PBM) as a tool for the DBA to manage system policies in a very structured way. In this session, we will show you how to configure, monitor, and administer these features to help lower your anxiety levels while increasing your system’s availability. We'll also learn how you can leverage the PBM system across not only your 2008 environment but also all those down-level instances as well!

SessionID: 28857

Getting Started With Service Broker

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: Developer Track

Speaker: Arie Jones

Title: Getting Started With Service Broker

Abstract:

Since SQL Server 2005, Microsoft has implemented a feature known as Service Broker that provides a very sophisticated message queuing service. In this session, we will unearth what is one of the least used features in your SQL Server toolbox and show you how you can implement it in your own environment through a series of real world examples. Along the way, you'll learn how to leverage the technology not only for single server queuing but also for server to server database queuing as well. This is sure to be a real eye opener for some whom have never had the time to dig into this fascinating piece of technology.

SessionID: 28858

Reporting Services Greatness!

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: BI Track

Speaker: Arie Jones

Title: Reporting Services Greatness!

Abstract:

SQL Server Reporting Services is still one of the more underused aspects of the SQL Server stack of technologies. Most of this comes from organizations that don't understand how to properly implement the technology in a way that will bring them a return on investment. In this session, we'll show you how to set up everything for standard to data driven subscriptions, security, export features, and how your developers can even interact with the Reporting Services webs ervice stack. If you have been itching to get your organization on the fast track to reporting success then this session is definitely for you!

SessionID: 29634

Database Mirroring in the Real World

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 2

Speaker: Craig Purnell

Title: Database Mirroring in the Real World

Abstract:

Review of Database Mirroring in the context of operations in the real world. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; discussion of the pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.

SessionID: 29635

NoSQL- What is it and why do I care?

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: Developer Track

Speaker: Craig Purnell

Title: NoSQL- What is it and why do I care?

Abstract:

NoSQL (or, more correctly NoRel) is a moniker applied to a family of non relational software systems for storing data and/or documents that powers some of the largest sites on the internet. Amazingly enough, some of these platforms have been around a very long time. A high level discussion of some of the pros and cons of this technology compared to traditional systems like Oracle and SQL Server. A survey of the most popular "NoSQL" platforms and who uses them.

SessionID: 30155

TempDB Performance Troubleshooting and Optimizing

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 1

Speaker: Eddie Wuerch

Title: TempDB Performance Troubleshooting and Optimizing

Abstract:

Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.

SessionID: 30156

Find Performance Problems by Reading the Waits

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 1

Speaker: Eddie Wuerch

Title: Find Performance Problems by Reading the Waits

Abstract:

Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats, use them to zero in on performance issues, and solve a variety of problems affecting your databases. Stop guessing, start knowing!

SessionID: 30393

Creating a Metadata Mart w/ SSIS - Data Governance

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: BI Track

Speaker: Ira Warren

Title: Creating a Metadata Mart w/ SSIS - Data Governance

Abstract:

Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture , via SSIS, that relys on a metadata mart. The end result a greatly reduced TCO(developemnt effort) for generating the code required vs manual cosing. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts

SessionID: 30453

Looney Tuner? No, there IS a method to my madness

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: Developer Track

Speaker: Janis Griffin

Title: Looney Tuner? No, there IS a method to my madness

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

SessionID: 30455

Performance Management – 2008 MDW - How Why

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 1

Speaker: Janis Griffin

Title: Performance Management – 2008 MDW - How Why

Abstract:

Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools.

SessionID: 30990

Do More (ETL) with Less (Effort) - Automating SSIS

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: BI Track

Speaker: John Welch

Title: Do More (ETL) with Less (Effort) - Automating SSIS

Abstract:

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks or packages that adhere to a pattern, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.

SessionID: 30991

Tuning Analysis Services Processing Performance

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: BI Track

Speaker: John Welch

Title: Tuning Analysis Services Processing Performance

Abstract:

You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube.

SessionID: 30994

Exploring Data Privacy

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 2

Speaker: John Magnabosco

Title: Exploring Data Privacy

Abstract:

Somewhere out there someone is storing data about you. What defines sensitive and personally identifiable data? What should you, as a consumer, expect in regard to the protection of this data? What should you as a database professional do to ensure that your customer's data is protected? In this session we will explore these and other dimensions of the increasingly critical topic of data privacy.

SessionID: 31306

SQL Server Internals and Architecture

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 1

Speaker: Kevin Kline

Title: SQL Server Internals and Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

What’s different about 32- and 64-bit systems? What are the various areas of memory inside of SQL Server? How are queries handled behind the scenes? What does SQL Server do with procedural code, like functions, procedures, and triggers? What happens during checkpoint

SessionID: 31307

Top 10 Admin Mistakes on SQL Server

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 2

Speaker: Kevin Kline

Title: Top 10 Admin Mistakes on SQL Server

Abstract:

Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen?

This session will answer questions like: What’s the most common Transact-SQL programming mistake and how do

SessionID: 32098

PowerShell, the New SQL Hammer

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: Developer Track

Speaker: Norman Kelm

Title: PowerShell, the New SQL Hammer

Abstract:

You've seen all the amazing scripts that use PowerShell, but writing your own is raising more questions. This session will help fill in the gaps by explaining all the moving parts of PowerShell 2.0, the integration with SQL Server and answer the following questions as well as others. Why is Invoke-Sqlcmd necessary? What is and why is there a Minishell for SQL Server? What makes the SQLSERVER: PS Drive so powerful? How does a remote SQL Server get added to the SQLSERVER: PS Drive?

SessionID: 32786

SQL Server Forensics: Tracking your users

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 2

Speaker: Sarah Barela

Title: SQL Server Forensics: Tracking your users

Abstract:

If your SQL Server was hacked, would you know? Would you know how to track down who attacked your SQL Server? What was compromised? When? How? Thankfully most DBAs are not fighting off criminals on a daily basis, but understanding SQL Server forensics will allow you to better understand your SQL Servers and will give you the ability to answer that frequent question “What happened?” This session will walk you through the process of how to determine what happened on your server without the use of expensive third-party tools, using only features available in all editions of Windows and SQL Server. You will learn how to parse the various Windows, SQL Server and database transaction logs. We will also explore the wealth of information availab

SessionID: 32881

Back to basics - How does the Algebrizer work

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 1

Speaker: Luke Jian

Title: Back to basics - How does the Algebrizer work

Abstract:

In this session we’ll look at the operations and transformations of relational algebra in order to understand how query plans are computed.

Relational algebra represents the foundation of relational databases. Any valid SQL query is transformed after parsing into a parse tree in which the internal nodes are operators, leaves are relations (data sets) and subtrees are subexpressions. The primary goal of the query optimizer is to transform query trees into equivalent expression trees, where the average size of the resultsets yielded by subexpressions in the tree are smaller than they were before the optimization. The query optimizer uses a set of rules, to generate equivalent parse trees and then applies proportional costs for operators and

SessionID: 33380

Advanced TSQL Solutions

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: Developer Track

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

SQL Server Memory Deep Dive

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: SQl Server Track 2

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

An Overview of PowerPivot for Excel

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: BI Track

Speaker: William E Pearson III

Title: An Overview of PowerPivot for Excel

Abstract:

Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities.

SessionID: 34065

Getting Started with MDX

Back to calendar

Event Date: 25-06-2011 - Session time: 00:00:00 - Track: BI Track

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, 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.

This site is open source. Improve this page.