Nr: 73
SQLSaturday #73 - Orange County 2011
SessionID: 28457
Partitioned Tables: Management Query Processing
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
Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout
Speaker: Benjamin Nevarez
Abstract:
SessionID: 28549
Opening Session
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
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
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
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
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
Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Rustler Hangout
Speaker: Matt Hollingsworth
Title: Microsoft Business Intelligence All Up
Abstract:
SessionID: 29578
Help Desk to DBA in 60 Minutes
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
Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 101
Speaker: Colin Smith
Title: Powershell for the DBA
Abstract:
SessionID: 29890
DBA as Protector of the Data: Notes from the Field
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!
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
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
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
Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100
Speaker: Harold Wong
Title: Virtualization Basics for the SQL Guru
Abstract:
SessionID: 30358
Developing on SQL Azure
Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118
Speaker: Ike Ellis
Title: Developing on SQL Azure
Abstract:
SessionID: 31051
(SSIS, TSQL) - Record Linkage(Fuzzy Match)
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!
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
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?
Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 118
Speaker: Lynn Langit
Title: What's New in SQL Azure?
Abstract:
SessionID: 31575
Intro to T-SQL
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
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
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)
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
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
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
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
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
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:
SessionID: 32419
Visual Studio 2010 Database Projects
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
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:
- Transactions
- Error Handling
- Logging
- Package Configurations
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
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:
SessionID: 32984
Test Driven Development in SQL Server
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.
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
Event Date: 09-04-2011 - Session time: 00:00:00 - Track: Tech 100
Speaker: Ted Tasker
Title: Parallel Data Warehouse - Architecture Overview
Abstract:
SessionID: 33721
SQL Server Panel Discussion
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
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
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.