sqlsathistory

Nr: 27

Back to Main list

SQLSaturday #27 - Portland 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Atul Borkar	Track 5	Data Architecture – a “Corner Stone” of EA
00:00:00	Buck Woody	Track 4	SQL Server for the Oracle DBA
00:00:00	Buck Woody	Track 2	SQL Server 2008 R2 Overview
00:00:00	Carlos Bossy	Track 3	Data Mining with Analysis Services
00:00:00	Carlos Bossy	Track 3	The Data Warehouse: Your BI Foundation
00:00:00	Remus Rusanu	Track 2	High Volume Real Time Contiguous ETL and Audit
00:00:00	Sumeet Bansal	Track 5	Accelerating SQL with Solid State Technology
00:00:00	Dean Richards	Track 5	Tuna Helper for DBAs and Developers
00:00:00	Greg Larsen	Track 4	Exploring SQL Server System Information with DMVs
00:00:00	Greg Larsen	Track 2	T-SQL Coding Best Practices
00:00:00	Joe Celko	Track 1	Nested Set model for Hierachies in SQL
00:00:00	Joshua Jin	Track 4	SQL Perf Counters, Thresholds, and Vital Signs
00:00:00	Denny Cherry	Track 4	Table Indexing for the .NET Developer
00:00:00	Denny Cherry	Track 2	How to decide if your database is a good candidate
00:00:00	Denny Cherry	Track 2	SQL Server Service Broker in the Real World
00:00:00	Munir Ghamrawi	Track 5	SQL Server 2008 High Availability on Cloud
00:00:00	Paul Litwin	Track 1	Creating Report Subscriptions in Microsoft SQL Ser
00:00:00	Paul Turley	Track 1	Cooking with SSRS: Advanced Report Design Recipes
00:00:00	Paul Turley	Track 3	Multidimensional Reporting: MDX Essentials for Rep
00:00:00	Tim Ford	Track 4	Insight Into Your Indexes With DMVs
00:00:00	Tim Ford	Track 5	Disaster Recovery and High Availability for N00Bs
00:00:00	Tim Giorgi	Track 1	Leveraging Visual Studio Database Edition
00:00:00	Todd McDermid	Track 2	Deep Dive on Integration Services
00:00:00	Todd McDermid	Track 3	Business Intelligence and Data Warehousing Primer
00:00:00	Todd McDermid	Track 3	Dimension Processing with SSIS - Simple to Complex

SessionID: 28884

Data Architecture – a “Corner Stone” of EA

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Atul Borkar

Title: Data Architecture – a “Corner Stone” of EA

Abstract:

Data Architecture – a “Corner Stone” of Enterprise Architecture -As the organizations across the globe, aggressively pursues their strategic objectives; a key strategy and method is required in this pursuit, and that is ‘Data/Information Availability’. Accurate, reliable and available information enables the organization to make timely and better business decisions.

We have seen many differing methodologies over the years with CRM, Portals, B2B efforts and score carding capabilities. The need for well structured and quality information is more important than ever. As a result, we are seeing a significant acceptance and synergy relative to the importance and value having a robust Data Architecture.

Most organizations today have a co

SessionID: 29350

SQL Server for the Oracle DBA

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Buck Woody

Title: SQL Server for the Oracle DBA

Abstract:

Come hear Buck Woody, Microsoft's "Real World DBA" give a marketing-free introduction to SQL Server for the Oracle professional. No experience in SQL Server is necessary - we'll cover the basics of SQL Server Architecture using Oracle concepts as a guide. If you're an Oracle professional and you want to add SQL Server to your "knowledge arsenal", come hear this overview. You'll also get a list of resources that will enable you to research further.

SessionID: 29351

SQL Server 2008 R2 Overview

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Buck Woody

Title: SQL Server 2008 R2 Overview

Abstract:

"R2"? What does THAT mean? Is this a "full" release or not? Buck Woody, Microsoft's real-world DBA and all around Gadfly will regale you with the explanation of such acronyms as "DAC", "UCP" and "MDW", and he'll explain what StreamInsight, Master Data Services and PowerPivot can really do for you. You'll take a quick tour of the features you should know about in SQL Server 2008 R2, the version of SQL Server that just couldn't wait for another year.

SessionID: 29392

Data Mining with Analysis Services

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Carlos Bossy

Title: Data Mining with Analysis Services

Abstract:

Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services to incorporate these complex algorithms seamlessly into your databases, from transactional processing to integration, data analysis and performance management. Attendees will be shown how to create a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample application that seamlessly uses the mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications.

SessionID: 29393

The Data Warehouse: Your BI Foundation

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Carlos Bossy

Title: The Data Warehouse: Your BI Foundation

Abstract:

Many DBAs are thrust into a data warehouse project with little training and no experience, or they are forced to take over the existing Data Warehouse. Designing or fixing a Data Warehouse model that supports the full range of BI functions can be a challenge for the OLTP DBA. This session will reveal the essential components that you should put in place for a successful implementation, including concepts such as the Importance of Transformation, Redundancy and why Reuse can be Detrimental, and one of his favorite topics, Ease of Query. Additionally, the significance of Integration, Metadata, and Governance towards creating a rock-solid, sometimes brilliant, foundation for your Business Intelligence Data Architecture will be presented.

SessionID: 29595

High Volume Real Time Contiguous ETL and Audit

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Remus Rusanu

Title: High Volume Real Time Contiguous ETL and Audit

Abstract:

High volume contiguous ETL is always problematic, and even more so when near-real-time is desired. This presentation goes through a solution collects and aggregates security audit data for nearly 400000 machines, a contiguous 24x7 stream of nearly 200 events per second, using a budget tight solution that involves SQL Express, Service Broker and Database Mirroring.

SessionID: 29623

Accelerating SQL with Solid State Technology

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Sumeet Bansal

Title: Accelerating SQL with Solid State Technology

Abstract:

Solid-state technologies are changing the way that SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how SQL performs.

1. On overview of solid state technology options for SQL Server
2. Why solid state makes a difference?
3. An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each:
4. Customer proof: Wine.com case study

SessionID: 29868

Tuna Helper for DBAs and Developers

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Dean Richards

Title: Tuna Helper for DBAs and Developers

Abstract:

Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process I use with great success and it will include topics such as: SQL diagramming, wait type data, column selectivity, and others that will help you succeed on future tuning projects.

SessionID: 30283

Exploring SQL Server System Information with DMVs

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Greg Larsen

Title: Exploring SQL Server System Information with DMVs

Abstract:

This session will explore different DMV and how they can be used to obtain information about your SQL Server environment. There will be a number of demo's. In these demos different DMV's will be used provide different infomation about how your SQL Server instance is running. Peeking under the covers is now only a DMV away.

SessionID: 30284

T-SQL Coding Best Practices

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Greg Larsen

Title: T-SQL Coding Best Practices

Abstract:

This session will cover T-SQL coding best practices. The basics on how to code T-SQL statements to optimize your queries will be covered. In this session, you will discover some of the common pitfalls that can cause T-SQL statements to run slow. A number of demos will be done to show how by making slight changes in your code will minimize the resources used to process your queries. From this session, you will be able to take home a list of T-SQL coding guidelines to help your code more efficient T-SQL statements.

SessionID: 30585

Nested Set model for Hierachies in SQL

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Joe Celko

Title: Nested Set model for Hierachies in SQL

Abstract:

A look at the basic Nested Sets versus Adjacency List models. Why Nested sets model hierarchies and Adjacency List model trees. This will stress the need for constraints to prevent cycles in either model. The problems of hierarchical aggregation -- Nested Sets requires one set-oriented query and Adjacency List requires iterations or recursion.

SessionID: 31055

SQL Perf Counters, Thresholds, and Vital Signs

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Joshua Jin

Title: SQL Perf Counters, Thresholds, and Vital Signs

Abstract:

Interpreting SQL performance counters and OS related counters is an essential skill for a SQL DBA. In this session, we will discuss most relevant OS and SQL performance counters, vital signs, and preferred threshold values.

SessionID: 31970

Table Indexing for the .NET Developer

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Denny Cherry

Title: Table Indexing for the .NET Developer

Abstract:

In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2008 databases. We will also be looking into the new indexing features that are available in SQL Server 2008 (and SQL Server 2005) and how you the .NET developer can make the best use of them to get your code running its best.

SessionID: 31971

How to decide if your database is a good candidate

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Denny Cherry

Title: How to decide if your database is a good candidate

Abstract:

We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.

SessionID: 31972

SQL Server Service Broker in the Real World

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Denny Cherry

Title: SQL Server Service Broker in the Real World

Abstract:

Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature.

In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting.

SessionID: 32034

SQL Server 2008 High Availability on Cloud

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Munir Ghamrawi

Title: SQL Server 2008 High Availability on Cloud

Abstract:

This session will show how to achieve 99.9999 High Availability of SQL Server database on physical cluster and on Cloud.• SQL Server 2008 cluster Deployment• SQL Server 2008 Mirroring• Sql Server cloud deplyment.

SessionID: 32163

Creating Report Subscriptions in Microsoft SQL Ser

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Paul Litwin

Title: Creating Report Subscriptions in Microsoft SQL Ser

Abstract:

In this session, learn how to set up standard and data-driven subscriptions using Report Manager. We discuss creating file-share, email, and null subscriptions; and how to deal with potential issues with parameters and security. We also demonstrate a sophisticated Microsoft ASP.NET-based application that creates subscriptions by calling the SSRS Web Services API.

SessionID: 32165

Cooking with SSRS: Advanced Report Design Recipes

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Paul Turley

Title: Cooking with SSRS: Advanced Report Design Recipes

Abstract:

The secret to designing compelling report solutions is in the ingredients and the technique. Learn to apply proven design patterns and best practices to create a reporting solution masterpiece. These techniques employ expressions, parameters, custom programming and years of field experience. This presentation is based in-part from our forthcoming Wrox Press Book: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports.

SessionID: 32166

Multidimensional Reporting: MDX Essentials for Rep

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Paul Turley

Title: Multidimensional Reporting: MDX Essentials for Rep

Abstract:

Learn the fundamentals of MDX query design for Analysis Services cubes. Migrate your SQL skills to this simple and elegant language that will enable you to unlock the awsome power of a cube and to gain deep insight from a single version of the truth. Learn to develop dynamic, advanced reports by parameterizing MDX queries using expressions and custom code.

SessionID: 33013

Insight Into Your Indexes With DMVs

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Tim Ford

Title: Insight Into Your Indexes With DMVs

Abstract:

Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY.

SessionID: 33014

Disaster Recovery and High Availability for N00Bs

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Tim Ford

Title: Disaster Recovery and High Availability for N00Bs

Abstract:

This session is targeted for those who have found themselves accidentally responsible for the SQL Server databases where they work, or are generally new to SQL Server. We'll cover the basics of Backup and Restore processes as well as a high overview of HA architectures available including Database Mirroring, Clustering, Replication, and Log Shipping. Scripts will be provided for immediate use in your own environment as a take-away from this presentation.

SessionID: 33372

Leveraging Visual Studio Database Edition

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Tim Giorgi

Title: Leveraging Visual Studio Database Edition

Abstract:

Visual Studio Database Edition (VSDB) offers many benefits for the deployment process as well as the development of database updates. You may know it by its nickname - the "Data Dude". It provides for declarative style of approaching updates in a collaborative environment. This tool has been undergone significant enhancements recently and has many compelling features. We'll view some the key functional areas of the tool, discuss best practices, and take a look at what features companies could take advantage of.

VSDB is free to download for use with Visual Studio 2008 Developer and Team Suite Edition. It is also included as part of the Visual Studio 2010 Premium edition.

SessionID: 33723

Deep Dive on Integration Services

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Todd McDermid

Title: Deep Dive on Integration Services

Abstract:

SQL Server Integration Services is Microsoft’s Extract Transform Load/Data Integration (ETL/DI) tool, replacing DTS. SSIS is a very powerful and complex tool that can read data in from virtually any source, transform and mash that data however you like, then send it out to virtually any type of destination. Understand how SSIS can be used to do just that – from the basics. Find out how to get started using SSIS, hear what it’s really good at, and figure out what things you need a hacker’s spirit to accomplish with it. This session is demo heavy; Tasks, expressions, precedence constraints, text files, Excel, SQL, data type conversions, performance, scripts, configurations, scheduling, and more will be covered with examples.

SessionID: 33759

Business Intelligence and Data Warehousing Primer

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Todd McDermid

Title: Business Intelligence and Data Warehousing Primer

Abstract:

Your CIO's top priority in 2010 is probably Business Intelligence. If you don't know what BI is, or are trying to deliver it directly from your OLTP database, you need to find out what you're getting into. BI is all about helping your business users make better decisions, faster. Find out what it will take to deliver what your CIO is asking for.

BI from your OLTP database has problems - it requires technical knowledge of your data model, compromises your line of business application responsiveness, and won't perform well. The solution to all of those issues is to construct a Data Warehouse based on Dimensional Modeling. I'll show you why normalized OLTP databases have problems supporting BI, and how Kimball method Data Warehouses don't.

SessionID: 33760

Dimension Processing with SSIS - Simple to Complex

Back to calendar

Event Date: 22-05-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Todd McDermid

Title: Dimension Processing with SSIS - Simple to Complex

Abstract:

The SCD Wizard included in Integration Services is easy to use, and has all the features you need for smaller, simple dimension processing. However, it is not the easiest component to adjust, and doesn't perform very well with larger dimensions. This session will cover three alternative techniques for processing changes to dimension tables within SSIS: "rolling your own SCD" with Lookups and Conditional Splits, using the T-SQL MERGE statement, and the Kimball Method SCD component. The strengths and weaknesses of each technique will be described and demonstrated.

This site is open source. Improve this page.