sqlsathistory

Nr: 44

Back to Main list

SQLSaturday #44 - Huntington Beach 2010

Start Time (24h) Speaker Track Title
00:00:00 Andrew Karcher Track 1 Opening Remarks (All Tracks - Courtyard)
00:00:00 Andrew Karcher Track 1 Raffle Prizes
00:00:00 Andrew Karcher Track 5 SoCal SQL Community - Feedback, Ideas, Questions?
00:00:00 Ben Aminnia Track 4 SQL XML As a Document Repository
00:00:00 Benjamin Nevarez Track 2 How the Query Optimizer Works
00:00:00 Bret Stateham Track 1 Introduction to SQL Server Reporting Services
00:00:00 Carlos Bossy Track 3 Data Mining with Analysis Services
00:00:00 Sumeet Bansal Track 4 Accelerating SQL with Solid State Technology
00:00:00 Darrell Burns Track 4 Movin Uptown: Migrating from Access to SQLServer
00:00:00 Doug Wheaton Track 5 Heterogeneous Data Integration with SSIS CDC
00:00:00 Diana Dee Track 1 How Indexes Optimize Query Performance
00:00:00 Harold Wong Track 4 Windows Server 2008 R2 and Hyper-V
00:00:00 Steve Hendricks Track 5 Ace the Interview
00:00:00 Steve Hendricks Track 5 SQL Joins: Logical and Physical
00:00:00 Chris Dickey Track 4 Fixing performance problems - Stuff happens
00:00:00 Jen Underwood Track 3 Business Intelligence w/MOSS 2010 and PowerPivot
00:00:00 Jen Underwood Track 3 Building Reporting using Analysis Services Cubes
00:00:00 Jesse Gebhardt Track 4 Data Visualization for the SQL Server Enterprise
00:00:00 Jim Bears Track 2 SQL Design Patterns
00:00:00 Jon Saltzman Track 2 SQL Server 2008 R2 Parallel Data Warehouse
00:00:00 Kevin Stephenson Track 2 Locks, Blocks, Deadlocks and Isolation Levels
00:00:00 Lynn Langit Track 1 SQL Azure
00:00:00 Mark Rosenberg Track 2 Optimizing Stored Procedures
00:00:00 Mark Rosenberg Track 2 Beginning SQL
00:00:00 Denny Cherry Track 1 SQL Server Clustering 101
00:00:00 Denny Cherry Track 1 Is Virtualization is a good choice for SQL Server?
00:00:00 Denny Cherry Track 1 Can I really consolidate my SQL Server database
00:00:00 Ravi Bodla Track 3 Solving Slowly Changing Dimension Problem /w SSIS
00:00:00 Ravi Bodla Track 3 Overview of BI with Microsoft SQL Technologies
00:00:00 Stacey Braodwell Track 5 Targeting your Job Search
00:00:00 Thomas Mueller Track 5 SQL Server resources - Roundtable

SessionID: 28541

Opening Remarks (All Tracks - Courtyard)

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Andrew Karcher

Title: Opening Remarks (All Tracks - Courtyard)

Abstract:

Opening Remarks for the Event

SessionID: 28542

Raffle Prizes

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Andrew Karcher

Title: Raffle Prizes

Abstract:

Raffle Prizes

SessionID: 28543

SoCal SQL Community - Feedback, Ideas, Questions?

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Andrew Karcher

Title: SoCal SQL Community - Feedback, Ideas, Questions?

Abstract:

We have a great SQL community here in Southern California. But, there are always things that we could do better. Do you have ideas or feedback on the community and things that you would like to see? Come to the session and talk with User Group and Community Leaders about User Group and Community Wide Events. Also, get information about how you can get involved.

SessionID: 29019

SQL XML As a Document Repository

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Ben Aminnia

Title: SQL XML As a Document Repository

Abstract:

With introduction of XML in Word 2003 and XML column data type in SQL Server 2005, there's a tremendous opportunity to put both technologies together. I presented my vision of this technical symbiosis about two years ago and now it's time to take it to the next level.

SessionID: 29104

How the Query Optimizer Works

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Benjamin Nevarez

Title: How the Query Optimizer Works

Abstract:

The Query Optimizer is the component of SQL Server that attempts to determine the best way to execute a query by finding an efficient execution plan. This session will show you how a better understanding on how the Query Optimizer works can help you to improve the performance of your databases. See how you can provide SQL Server with appropriate statistics and indexes so it can perform better cardinality estimation and produce an efficient execution plan. Learn how you can troubleshoot problems if you are not getting an efficient execution plan and how you can use other alternatives like hints or plan guides to help the query optimizer to produce a better plan.

SessionID: 29244

Introduction to SQL Server Reporting Services

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Bret Stateham

Title: Introduction to SQL Server Reporting Services

Abstract:

SQL Server Reporting Services 2008 is an enterprise reporting platform included with SQL Server. While it is included with SQL Server, it is a great solution for reporting on any data in your organization whether the data is in SQL Server or not. In this session, I’ll introduce you to SQL Server Reporting Services, it’s architecture, and tools you can use to develop and deliver high quality reports to your users. Topics covered in this session include, SSRS Architecture, Using Business Intelligence Development Studio (BIDS) to develop reports, using Report Builder to develop reports, report deployment and delivery

SessionID: 29390

Data Mining with Analysis Services

Back to calendar

Event Date: 24-04-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: 29620

Accelerating SQL with Solid State Technology

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Sumeet Bansal

Title: Accelerating SQL with Solid State Technology

Abstract:

Solid-state technologies are changing the way that MS 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 MS SQL Servers perform.

This session will address:

  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: a. Disk-based SSDs b. Onboard/Embedded PCI Express devices c. Host-based PCI Express devices
  4. Customer proof: Wine.com case study

SessionID: 29902

Movin Uptown: Migrating from Access to SQLServer

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Darrell Burns

Title: Movin Uptown: Migrating from Access to SQLServer

Abstract:

Darrell will be describing an import classification application initially developed entirely in Access and then converted to SQL Server 2008, leaving the Access UI intact. Darrell will demonstrate both the before and after versions, showing how he migrated the Access macros and VBA code to SQL stored procedures, and what he learned along the way. This topic should be of particular interest to: Database designers, Access developers, SQLServer application developers, and anybody considering an Access-to-SQLServer migration. Some of the key points of interest: Data-driven application design, SQLServer vs Access performance advantages, How to use pass-through SQL, Leveraging the power of SQLServer, Access design considerations.

SessionID: 29964

Heterogeneous Data Integration with SSIS CDC

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Doug Wheaton

Title: Heterogeneous Data Integration with SSIS CDC

Abstract:

This session will focus on Microsoft and partner technologies that enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), and that work with data from Oracle, Teradata, and other heterogeneous sources. You will learn how Microsoft high-speed Connectors by Attunity can be leveraged with change-data-capture (CDC) technologies integrated with SSIS to enable data replication. Use cases highlighting real-time data warehousing and operational reporting, as well as maintenance of data consistency between operational databases and applications will also be outlined.

SessionID: 29978

How Indexes Optimize Query Performance

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Diana Dee

Title: How Indexes Optimize Query Performance

Abstract:

Clustered and nonclustered index structure and operation are explained and demonstrated. Use of query plans, plus Management Studio and dynamic management view methods for determining index structure and fragmentation are shown.

SessionID: 30296

Windows Server 2008 R2 and Hyper-V

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Harold Wong

Title: Windows Server 2008 R2 and Hyper-V

Abstract:

If you are new to server virtualization, this is the perfect session to get familiar with the components and features of Microsoft’s Hyper-V R2 (Windows Server 2008 R2). Once we get the basics out of the way, I will walk through some key items in configuring your own Hyper-V environment for testing as well as key factors for using Hyper-V in a production environment. I will briefly discuss virtualization factors for SQL in preparation for Denny’s session.

SessionID: 30309

Ace the Interview

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Steve Hendricks

Title: Ace the Interview

Abstract:

In this tough job market, it is more important than ever that you present yourself in the best possible light when searching for your next opportunity. The interview plays a crucial role in determining if you are the one that lands the job. In this hands-on session, you will learn what the interviewer is looking for from you and how to supply it. This is a must for job seekers.

SessionID: 30311

SQL Joins: Logical and Physical

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Steve Hendricks

Title: SQL Joins: Logical and Physical

Abstract:

A survey of the various types of joins available at the T-SQL coding level (logical), how the optimizer implements them (physical) and the tools you can use to assure that the best execution plan is being selected.

SessionID: 30370

Fixing performance problems - Stuff happens

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Chris Dickey

Title: Fixing performance problems - Stuff happens

Abstract:

I will discuss tricky tuning issues that I have encountered during my years speeding up SQL Server. Simple rules often don't apply to complex problems. SQL Server queries can have a wide variety of complexities.

Slow queries are caused by these issues: 1. data might be retrieved from disk or RAM 2. row estimates are too high or too low 3. functions are zero costed 4. the optimizer doesn't know the value of a local variable 5. a query is too complex for the optimizer to do a great job 6. indexes compete for RAM 7. optional parameters 8. a high cost query only using 1 cpu 9. table variables 10. the optimizer isn't perfect

SessionID: 30687

Business Intelligence w/MOSS 2010 and PowerPivot

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jen Underwood

Title: Business Intelligence w/MOSS 2010 and PowerPivot

Abstract:

SessionID: 30689

Building Reporting using Analysis Services Cubes

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jen Underwood

Title: Building Reporting using Analysis Services Cubes

Abstract:

This presentation walks through building reports in Reporting Services 2008 and Excel 2007 that query data from Analysis Services Cubes. It will also explain a variety of reporting solution architecture options using Microsoft's Business Intelligence technologies.

SessionID: 30824

Data Visualization for the SQL Server Enterprise

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Jesse Gebhardt

Title: Data Visualization for the SQL Server Enterprise

Abstract:

Data Visualization for the SQL Server Enterprise: Key Principles for Deploying Front-End Visual Analytics Tools

Starting with a quick overview of why the human brain responds more effectively to visual information and ending with recommendations for successful interface design, this topic will help you understand how the addition of visual analysis in your application can increase your users’ satisfaction levels with your SQL Server solution.

Jesse will demonstrate the importance of visual analysis – including the iterative process of asking questions, creating pictures, discovering new hypothesis, and foraging for data.

SessionID: 30848

SQL Design Patterns

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Jim Bears

Title: SQL Design Patterns

Abstract:

Patterns emerge as both templated solutions to recurring problems and designs, as well as provide useful ways to encapsulate complex ideas into smaller, friendlier terms. Patterns gained popularity in the object-orientated community since the Fowler and the Gang Of Four, but declarative languages, like SQL, have had little-to-no coverage of how these patterns can be applied.

Understanding SQL design patterns is a crucial skill every SQL developer must learn and use in their career. SQL patterns can be applied to small projects or large, multi-million dollar systems, to provide common solutions to complex problems.

Patterns create a foundation for "best practices" for SQL, Database Architecture, managers.

SessionID: 31003

SQL Server 2008 R2 Parallel Data Warehouse

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Jon Saltzman

Title: SQL Server 2008 R2 Parallel Data Warehouse

Abstract:

SQL Server 2008 R2 Parallel Data Warehouse - An Unofficial Early Look

at the Possibilities for Fast, Large Scale Data Warehouses

In this session, we will review some of the information that Microsoft has released about the exciting new SQL Server 2008 R2 Parallel Data Warehouse. We will consider the product's origins, the opportunities it will present, and some predictions about what might be possible in the future with the combination of a whole new generation of technology (including solid state drives, faster networking, and more).

SessionID: 31473

Locks, Blocks, Deadlocks and Isolation Levels

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Stephenson

Title: Locks, Blocks, Deadlocks and Isolation Levels

Abstract:

Concurrency management is a fundamental function of RDBMs. In this session, you will learn how SQL Server uses locking to manage the conflicting goals of concurrency and ACID compliance. You will learn about the different lockable resource types, lock granularities and modes, and how the selection of transaction isolation levels modulates locking behavior. A novel locking pattern used at MySpace called READ UNTIL will be described. You will also be given a demonstration of troubleshooting techniques using documented and undocumented features, along with a research technique to help further your own locking knowledge.

SessionID: 31530

SQL Azure

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Lynn Langit

Title: SQL Azure

Abstract:

SessionID: 31576

Optimizing Stored Procedures

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Mark Rosenberg

Title: Optimizing Stored Procedures

Abstract:

Would you like your SQL to run faster and better? Then attend this session, we will talk about Temp Tables and Table Variables as well as tips and tricks to make your SQL run better

SessionID: 31577

Beginning SQL

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Mark Rosenberg

Title: Beginning SQL

Abstract:

Want to learn how to write a basic SQL query? Then this session is for you, I will go over how to write a basic SQL query including joins.

SessionID: 31976

SQL Server Clustering 101

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Denny Cherry

Title: SQL Server Clustering 101

Abstract:

In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.

SessionID: 31977

Is Virtualization is a good choice for SQL Server?

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Denny Cherry

Title: Is Virtualization is a good choice for SQL Server?

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

Can I really consolidate my SQL Server database

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Denny Cherry

Title: Can I really consolidate my SQL Server database

Abstract:

In this session we will look at the available techniques for consolidating a SQL Server database, and when to use each technique to help reduce capital expenses. Most importantly we will talk about how to decide when not to consolidate your databases.

SessionID: 32952

Solving Slowly Changing Dimension Problem /w SSIS

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Ravi Bodla

Title: Solving Slowly Changing Dimension Problem /w SSIS

Abstract:

Slowly Changing Dimension or SCD is a common problem to data warehousing. This session will provide an overview of SCD problem and present several solutions to this particular problem implemented with Microsoft SQL Server Integration Services

SessionID: 32953

Overview of BI with Microsoft SQL Technologies

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Ravi Bodla

Title: Overview of BI with Microsoft SQL Technologies

Abstract:

Business Intelligence or BI has recently become the focus of a lot of organizations. Microsoft SQL technologies (SQL, SSAS, SSIS, SSRS, etc…) provide a comprehensive backend support for implementing BI. This session will provide a high-level overview of BI architectures and roles that Microsoft SQL technologies play in the BI world.

SessionID: 33192

Targeting your Job Search

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Stacey Braodwell

Abstract:

Tip for targeting your job search. Using technology and online resources.

SessionID: 33719

SQL Server resources - Roundtable

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Thomas Mueller

Title: SQL Server resources - Roundtable

Abstract:

This session will be very interactive. The discussion will include resources such as

Attendees are encouraged to voice their opinions about the resources and mention ones that didn’t make the list.

This site is open source. Improve this page.