sqlsathistory

Nr: 73

Back to Main list

SQLSaturday #73 - Orange County 2011

Start Time (24h) Speaker Track Title
00:00:00 Benjamin Nevarez Tech 100 Partitioned Tables: Management Query Processing
00:00:00 Benjamin Nevarez Rustler Hangout Top Query Optimizer Topics for Better Performance
00:00:00 Andrew Karcher Registration Area Opening Session
00:00:00 Bret Stateham Tech 118 SQL Server Reporting Services Map Visualizations
00:00:00 Carlos Bossy Tech 117 Business Intelligence for Managers/Decision Makers
00:00:00 Carlos Bossy Tech 117 The Data Mining Lifecycle
00:00:00 Matt Hollingsworth Rustler Hangout The Largest SQL Server Projects in the World
00:00:00 Matt Hollingsworth Rustler Hangout Microsoft Business Intelligence All Up
00:00:00 Meredith Ryan-Smith Tech 118 Help Desk to DBA in 60 Minutes
00:00:00 Colin Smith Tech 101 Powershell for the DBA
00:00:00 Denise McInerney Tech 101 DBA as Protector of the Data: Notes from the Field
00:00:00 Denise McInerney Tech 117 My Co-workers Are 9000 Miles Away!
00:00:00 Denise McInerney Rustler Hangout Women in Tech: Encouraging the Next Generation
00:00:00 Diana Dee Tech 100 Relational Database Design 101
00:00:00 Harold Wong Tech 100 Virtualization Basics for the SQL Guru
00:00:00 Ike Ellis Tech 118 Developing on SQL Azure
00:00:00 Joseph Verftido Tech 118 (SSIS, TSQL) - Record Linkage(Fuzzy Match)
00:00:00 Juan Soto Tech 116 Access with SQL Server Express - Perfect!
00:00:00 Juan Soto Tech 116 MS Access with SQL Server Strategies and Tips
00:00:00 Lynn Langit Tech 118 What's New in SQL Azure?
00:00:00 Mark Rosenberg Tech 116 Intro to T-SQL
00:00:00 Denny Cherry Rustler Hangout Index Internals
00:00:00 Denny Cherry Rustler Hangout Table Indexing for the .NET Developer
00:00:00 Denny Cherry Tech 100 Using SQL Server Denali's Always On (HADR)
00:00:00 Peter Kral Tech 101 SQL Server Agent Powershell Jobs 101
00:00:00 Peter Kral Tech 100 Designing Re-Startable SSIS Packages
00:00:00 Jose Pons Tech 117 SSIS - a real life sample
00:00:00 Jose Pons Tech 101 To the power of Transact SQL
00:00:00 Randy Knight Tech 101 Become Bilingual! Oracle for the SQL Server DBA
00:00:00 Randy Knight Tech 101 Visual Studio 2010 Database Projects
00:00:00 Reagan Williams Tech 118 SSIS Development: Improving package reliability
00:00:00 Rob Kerr Tech 117 Delivering BI Solutions with SQL and SharePoint
00:00:00 David Moutray Tech 116 Test Driven Development in SQL Server
00:00:00 Phil Robinson Tech 117 Reporting Services - Charts and more.
00:00:00 Ted Tasker Tech 100 Parallel Data Warehouse - Architecture Overview
00:00:00 Thomas Mueller Rustler Hangout SQL Server Panel Discussion
00:00:00 David McCarter Tech 116 Building nTier Applications with Entity Framework
00:00:00 David McCarter Tech 116 Real World API Design Using The Entity Framework

SessionID: 28457

Partitioned Tables: Management Query Processing

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100

Speaker: Benjamin Nevarez

Title: Partitioned Tables: Management Query Processing

Abstract:

You are implementing partitioning because you want easier management for very large tables and indexes and want to improve your data loading, deletion and archival operations. But you also need to know the query processing implications and understand how partitioning will impact your existing queries. On the other side, many developers believe that the primary purpose of partitioning is to make your queries run faster. This session will show you the reality and will focus on both how to implement partitioning to achieve better maintenance and data availability and how it will impact query processing, including potential issues, benefits and recommendations.

SessionID: 28458

Top Query Optimizer Topics for Better Performance

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout

Speaker: Benjamin Nevarez

Title: Top Query Optimizer Topics for Better Performance

Abstract:

This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.

SessionID: 28549

Opening Session

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Registration Area

Speaker: Andrew Karcher

Title: Opening Session

Abstract:

Opening Session

SessionID: 29243

SQL Server Reporting Services Map Visualizations

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118

Speaker: Bret Stateham

Title: SQL Server Reporting Services Map Visualizations

Abstract:

SQL Server 2008 R2 Reporting Services provides a new map visualziation that allows you place your data in customized map reports. In this session we will review how to get your data onto the map!

SessionID: 29407

Business Intelligence for Managers/Decision Makers

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 117

Speaker: Carlos Bossy

Title: Business Intelligence for Managers/Decision Makers

Abstract:

Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way your organization functions. In this non-technical session Carlos Bossy will show you what a BI project looks like and how it is different from other IT projects, how to determine the ROI of a BI project, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI Analytical Strategy and you should leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions.

SessionID: 29409

The Data Mining Lifecycle

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 117

Speaker: Carlos Bossy

Title: The Data Mining Lifecycle

Abstract:

Take this opportunity to see the development of a real-world data mining model from inception to deployment. The Business Intelligence components of SQL Server make it possible to create powerful predictive models that can easily be incorporated into our applications. In this presentation Carlos Bossy will demonstrate how to develop a data mining model using Analysis Services through the entire lifecycle. You will learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target, selecting the appropriate data, and adapting it for maximum results.

SessionID: 29560

The Largest SQL Server Projects in the World

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout

Speaker: Matt Hollingsworth

Title: The Largest SQL Server Projects in the World

Abstract:

What are the largest SQL Server projects in the world and how do they scale? Come to this session and find out. Based on the work of Microsoft's SQL Server Customer Advisory Team (SQL CAT). SQL CAT represents the customer-facing resources from the SQL Server Product Group. SQL CAT is comprised of product and solution experts that regularly engage in the largest, most complex, and most unique customer deployments worldwide.

SessionID: 29561

Microsoft Business Intelligence All Up

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout

Speaker: Matt Hollingsworth

Title: Microsoft Business Intelligence All Up

Abstract:

This session is almost all demonstration of the Full Microsoft Business Intelligence stack. We will show off all of the latest RTM product sets. Scorecards and Dashboards in SharePoint 2010 and Performance Point Services. SharePoint 2010 Collaboration Integration, Reporting Services Integration into Dashboards, and SharePoint. Data Visualizations using Bing Maps, Reporting Services, and PivotViewer, and finally Managed Self Service Business Intelligence with PowerPivot and Excel 2010. Several demos specific to a Telecommunications provider, a Financial Services provider, and other industry examples.

SessionID: 29578

Help Desk to DBA in 60 Minutes

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118

Speaker: Meredith Ryan-Smith

Title: Help Desk to DBA in 60 Minutes

Abstract:

Most accidental DBAs’ start their foray in to database administration in a similar way. You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all. I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available.

SessionID: 29587

Powershell for the DBA

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 101

Speaker: Colin Smith

Title: Powershell for the DBA

Abstract:

This is a level 100 session going over the basics of powershell. The second half of the session will be seeing powershell in action and some cool scripts for the DBA to help wet the appetite. Powershell is a great tool in the DBA toolbelt that will make you a more valuable assett to your company. I will go over the basics and show you some things that will allow you to do just about anything you want with Powershell..

SessionID: 29890

DBA as Protector of the Data: Notes from the Field

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 101

Speaker: Denise McInerney

Title: DBA as Protector of the Data: Notes from the Field

Abstract:

The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA.

SessionID: 29891

My Co-workers Are 9000 Miles Away!

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 117

Speaker: Denise McInerney

Title: My Co-workers Are 9000 Miles Away!

Abstract:

How to Succeed on a Distributed Team

More and more technology professionals work with colleagues who are based all over the world. Being part of a distributed team means dealing with differences in communication style, work culture and time zones. Based in the U.S., Denise McInerney works on a team that has more than 50% of its members in India. In this session Denise will share her tips and techniques for how to be successful when working with people around the globe.

SessionID: 29892

Women in Tech: Encouraging the Next Generation

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout

Speaker: Denise McInerney

Title: Women in Tech: Encouraging the Next Generation

Abstract:

Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more girls and young women to consider a career in technology? Join a panel of dynamic Women in Technology including Meredith Ryan Smith, Lynn Langit, Denise McInerney and others to discuss this important topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. Everyone is welcome, male and female.

SessionID: 29979

Relational Database Design 101

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100

Speaker: Diana Dee

Title: Relational Database Design 101

Abstract:

Would you like to understand the basic structure of relational databases?

Have you ever wondered how you can flawlessly decide whether two tables have a one-to-many, many-to-many, or one-to-one relationship?

Do you want to understand the basics of top-down and bottom-up database design?

Do you want to be able to explain normalization to third normal form?

Then this presentation is for you!

Content: • Keys and dependencies / determinants • What are the entities? (Top-down design) • Table connectivity (one-to-many or many-to-many) • What are the attributes? (Bottom-up design) • Normalization

SessionID: 30295

Virtualization Basics for the SQL Guru

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100

Speaker: Harold Wong

Title: Virtualization Basics for the SQL Guru

Abstract:

This session will cover Microsoft Virtualization technologies in Windows 7 and Windows Server 2008 R2 (Hyper-V). I will cover how to use the tools in both environments to create and manage Virtual Machines (VMs) and explain when to use Windows 7 versus Server 2008 R2. Lastly, I will show how to configure your system for multi-boot using Boot to VHD. If you have a USB hard drive with 10 GB of free space, I will also give you an unactivated VHD with Server 2008 R2 installed and ready to go with Hyper-V.

SessionID: 30358

Developing on SQL Azure

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118

Speaker: Ike Ellis

Title: Developing on SQL Azure

Abstract:

Learn what SQL Azure means to the developer and the DBA. We'll discuss key differences, gotchas, and performance tuning methods. If we have time, we'll cover SQL Reporting Services in the cloud and SQL Azure Data Sync Services. Lynn Langit and Ike Ellis will be speaking.

SessionID: 31051

(SSIS, TSQL) - Record Linkage(Fuzzy Match)

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118

Speaker: Joseph Verftido

Title: (SSIS, TSQL) - Record Linkage(Fuzzy Match)

Abstract:

We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSS). Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms.The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined.

SessionID: 31082

Access with SQL Server Express - Perfect!

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 116

Speaker: Juan Soto

Title: Access with SQL Server Express - Perfect!

Abstract:

SQL Server Express was the best thing to ever happen to Microsoft Access, it provides security, multi-user service, and processing power beyond what Jet could ever provide. Now you can migrate small databases to a environment that can meet corporate IT policies and enjoy it without paying for a server license. We will discuss migration strategies to SQL Server Express, backup and maintenance, and optimizing the relationship between the two. We will also cover avoiding road blocks and what every SQL Server table should have when working with Access.

SessionID: 31084

MS Access with SQL Server Strategies and Tips

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 116

Speaker: Juan Soto

Title: MS Access with SQL Server Strategies and Tips

Abstract:

Access can be a rapid development UI for small SQL Server databases, saving you time and money over .Net, IF you follow the right strategies and avoid the pitfalls. We will discuss how to fine tune the relationship between the two, strategies on importing data, how to minimize connections to SQL Server and touch on Access Data Projects. We will also discuss where Access as the presentation layer makes sense and DBA strategies in working with Access developers. At the end you will walk away with a better sense of managing the Access/SQL Server relationship.

SessionID: 31528

What's New in SQL Azure?

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118

Speaker: Lynn Langit

Title: What's New in SQL Azure?

Abstract:

Using mostly demos, Lynn will show you how to work with SQL Azure using tools and techniques. She will cover migrating data, feature compatibility and futures.

SessionID: 31575

Intro to T-SQL

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 116

Speaker: Mark Rosenberg

Title: Intro to T-SQL

Abstract:

This is a 100 level session on T-SQL for beginners

SessionID: 32001

Index Internals

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout

Speaker: Denny Cherry

Title: Index Internals

Abstract:

During this session we will be digging into the internals of SQL Server indexes.

SessionID: 32002

Table Indexing for the .NET Developer

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout

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

Using SQL Server Denali's Always On (HADR)

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100

Speaker: Denny Cherry

Title: Using SQL Server Denali's Always On (HADR)

Abstract:

In this session we will look at the features which are provided with Microsoft SQL Server "Denali" as part of the "Always On" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.

Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.

SessionID: 32236

SQL Server Agent Powershell Jobs 101

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 101

Speaker: Peter Kral

Title: SQL Server Agent Powershell Jobs 101

Abstract:

Many SQL Server Database Administrators or T-SQL developers have not had the chance to learn about Powershell scripting. This presentation introduces Powershell scripting within SQL Server Agent jobs, explaining the critical basics you'll need to get started. You'll see examples of SQL jobs that use Powershell scripts to manage files, to control other jobs, and to create and mail simple reports. By the end, you'll be ready to create your first SQL Server Agent job with a Powershell job step.

SessionID: 32237

Designing Re-Startable SSIS Packages

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100

Speaker: Peter Kral

Title: Designing Re-Startable SSIS Packages

Abstract:

SSIS provides the Checkpoint functionality for recovery after a package failure, but many experienced SSIS developers eschew it because of its lack of granularity when restarting a failed package. Sometimes the restarted package will execute tasks that had partially succeeded previously, causing data consistency issues or outright data destruction! In this session, you will see SSIS package design that allows predictable, scalable recovery after a partial or complete failure during execution. Intended for experienced SSIS developers with knowledge of SSIS Expressions and T-SQL.

SessionID: 32316

SSIS - a real life sample

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 117

Speaker: Jose Pons

Title: SSIS - a real life sample

Abstract:

Check out SSIS capabilities and see the diference from DTS technology.

SessionID: 32317

To the power of Transact SQL

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 101

Speaker: Jose Pons

Title: To the power of Transact SQL

Abstract:

Let's put to the test TSQL and see how far the SQL Server engine goes. To attend you need to understand execution plans and SQL Server engine concepts, otherwise it would be fun.

SessionID: 32418

Become Bilingual! Oracle for the SQL Server DBA

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 101

Speaker: Randy Knight

Title: Become Bilingual! Oracle for the SQL Server DBA

Abstract:

In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.

SessionID: 32419

Visual Studio 2010 Database Projects

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 101

Speaker: Randy Knight

Title: Visual Studio 2010 Database Projects

Abstract:

Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.

SessionID: 32475

SSIS Development: Improving package reliability

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118

Speaker: Reagan Williams

Title: SSIS Development: Improving package reliability

Abstract:

This session will provide techniques on how to make SSIS packages more reliable and robust in production.

Topics to cover:

We'll get to do some development, move a lot of data around and have some fun.

SessionID: 32525

Delivering BI Solutions with SQL and SharePoint

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 117

Speaker: Rob Kerr

Title: Delivering BI Solutions with SQL and SharePoint

Abstract:

Microsoft provides a well-integrated set of components that leverage SQL data to deliver compelling BI solutions. In this intermediate-level session we'll pull back the covers from the SharePoint 2010, Analysis Services, PowerPivot and SQL architectures to demonstrate best practices and real-world demos showing how to integrate these technologies into a seamless end-user experience. The session will focus on SharePoint 2010 BI features, security, Analysis Services, Reporting Services Integrated mode, PowerPivot, Excel Services and mobile device integration.

SessionID: 32984

Test Driven Development in SQL Server

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 116

Speaker: David Moutray

Title: Test Driven Development in SQL Server

Abstract:

In the words of Brent Ozar (www.BrentOzar.com), "You can't be a great SQL developer without using Test Driven Development. In the words of Grant Fritchey (www.ScaryDBA.com), "Test Driven Development with SQL Server made me want to tear my hair out." Testing in T-SQL may be more cumbersome than in other development languages, but eventually all software must be tested. How can you thoroughly test a data-dependent application without testing the data pieces that drive the application components? If the database has problems, they will eventually affect the rest of the application. This session explores the basics of Test-Driven Development: unit tests; setting up test data; and automating your tests.

SessionID: 33039

Reporting Services - Charts and more.

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 117

Speaker: Phil Robinson

Title: Reporting Services - Charts and more.

Abstract:

In this session we will explore the 2008R2 chart types along with the Data Bar, Sparkline and Indicator data regions.

We will take a simple table report and enhance it by adding these graphic elements

SessionID: 33327

Parallel Data Warehouse - Architecture Overview

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100

Speaker: Ted Tasker

Title: Parallel Data Warehouse - Architecture Overview

Abstract:

In Nov.2010, Microsoft officially released SQL Server 2008 R2 PDW Edition. Parallel Data Warehouse is a true MPP (massive parallel processing) platform featuring an ultra shared nothing architecture. PDW is capable of delivering very fast query performance and can house up to 500 TB of data. This session will overview both the HW and SW architecture of the PDW appliance. It will explain how Microsoft and HP have engineered a solution using commodity HW and SW that can compete with more expensive platforms like TeraData and ExaData. Additionally, SQL DBAs will see where their current skillset is applicable to managing a PDW appliance.

SessionID: 33721

SQL Server Panel Discussion

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout

Speaker: Thomas Mueller

Title: SQL Server Panel Discussion

Abstract:

In this session SQL Server experts/users will talk about several SQL Server topics.

SessionID: 34623

Building nTier Applications with Entity Framework

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 116

Speaker: David McCarter

Title: Building nTier Applications with Entity Framework

Abstract:

SessionID: 34624

Real World API Design Using The Entity Framework

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 116

Speaker: David McCarter

Title: Real World API Design Using The Entity Framework

Abstract:

In this session I will show you how I used the Entity Framework Services to design and create an API servicing layer to expose back end data to partners. We will dive into using the Entity Framework (data layer), WCF Data Services (service layer), T4 templates (business entities), WCF Message Inspectors (security) and more.