SQLSaturday #44 - Huntington Beach 2010 4/24/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat44 Huntington Beach CA 92647 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 496 Quest Software Platinum Sponsor http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 535 MySpace Platinum Sponsor http://www.myspace.com/ http://myspace.tekgroupweb.com/images/20006/media_gallery/myspace_white-on-blue.jpg 60 170 539 Strategy Companion Gold Sponsor http://www.strategycompanion.com http://www.strategycompanion.com/_Style/images/home_header_00.jpg 60 170 471 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/logo-light.png 60 170 439 WestClinTech Bronze Sponsor http://www.westclintech.com http://westclintech.com/portals/0/images/xldb_logo.jpg 60 170 557 Attunity Bronze Sponsor http://www.attunity.com http://www.attunity.com/images/logo_attunity.gif 60 170 562 SharePoint360 Bronze Sponsor http://www.sharepoint360.com/ http://www.sharepoint360.com/images/sharepoint360-logo.png 60 170 1458 Denny Cherry Track 1 MAT 118 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. 4/24/2010 4:00:00 PM 4/24/2010 5:00:00 PM 1459 Denny Cherry Track 1 MAT 118 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. 4/24/2010 11:15:00 AM 4/24/2010 12:15:00 PM 1460 Denny Cherry Track 1 MAT 118 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. 4/24/2010 8:45:00 AM 4/24/2010 9:45:00 AM 1470 Jen Underwood Track 3 Tech 2 This presentation covers SharePoint 2010 Business Intelligence related technologies including the Chart Web Part, Business Intelligence Center, PerformancePoint, Reporting Services, Report Builder, PowerPivot and Business Connectivity Services. 4/24/2010 10:00:00 AM 4/24/2010 11:00:00 AM 1472 Jen Underwood Track 3 Tech 2 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. 4/24/2010 11:15:00 AM 4/24/2010 12:15:00 PM 1507 Mark Rosenberg Track 2 Tech 1 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 4/24/2010 1:30:00 PM 4/24/2010 2:30:00 PM 1508 Mark Rosenberg Track 2 Tech 1 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. 4/24/2010 8:45:00 AM 4/24/2010 9:45:00 AM 1509 Sumeet Bansal Track 4 Tech 3 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 4/24/2010 2:45:00 PM 4/24/2010 3:45:00 PM 1522 Darrell Burns Track 4 Tech 3 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. 4/24/2010 1:30:00 PM 4/24/2010 2:30:00 PM 1567 Shen Liu Track 3 Tech 2 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 4/24/2010 1:30:00 PM 4/24/2010 2:30:00 PM 1568 Ravi Bodla Track 3 Tech 2 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. 4/24/2010 8:45:00 AM 4/24/2010 9:45:00 AM 1570 Jim Bears Track 2 Tech 1 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. 4/24/2010 10:00:00 AM 4/24/2010 11:00:00 AM 1587 Lynn Langit Track 1 MAT 118 In this demo-filled session, Lynn will explain the differences between Windows Azure storage and SQL Azure. She wil demonstrate working with SQL Azure storage in your application and discuss the option to connect a non-cloud hosted front end and/or a cloud-hosted front end to a SQL Azure back end solution. Lynn will also talk about migration strategies and best practices. In her talk, you wil also learn recommended business scenarios for cloud-based storage. Finally, she will cover in detail features of SQL Server RDMS which are and are not supported in SQL Azure. 4/24/2010 1:30:00 PM 4/24/2010 2:30:00 PM 1590 Benjamin Nevarez Track 2 Tech 1 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. 4/24/2010 4:00:00 PM 4/24/2010 5:00:00 PM 1591 Diana Dee Track 1 MAT 118 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. 4/24/2010 2:45:00 PM 4/24/2010 3:45:00 PM 1615 Stacey Braodwell Track 5 Tech 4 Tip for targeting your job search. Using technology and online resources. 4/24/2010 4:00:00 PM 4/24/2010 5:00:00 PM 1618 Ben Aminnia Track 4 Tech 3 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. 4/24/2010 8:45:00 AM 4/24/2010 9:45:00 AM 1619 Thomas Mueller Track 5 Tech 4 This session will be very interactive. The discussion will include resources such as - websites - magazines - associations - conventions - people - 3rd party companies Attendees are encouraged to voice their opinions about the resources and mention ones that didn’t make the list. 4/24/2010 1:30:00 PM 4/24/2010 2:30:00 PM 1628 Andrew Karcher Track 5 Tech 4 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. 4/24/2010 2:45:00 PM 4/24/2010 3:45:00 PM 1638 Kevin Stephenson Track 2 Tech 1 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. 4/24/2010 11:15:00 AM 4/24/2010 12:15:00 PM 1651 Chris Dickey Track 4 Tech 3 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 4/24/2010 11:15:00 AM 4/24/2010 12:15:00 PM 1671 Steve Hendricks Track 5 Tech 4 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. 4/24/2010 8:45:00 AM 4/24/2010 9:45:00 AM 1697 Steve Hendricks Track 5 Tech 4 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. 4/24/2010 10:00:00 AM 4/24/2010 11:00:00 AM 1745 Carlos Bossy Track 3 Tech 2 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. 4/24/2010 4:00:00 PM 4/24/2010 5:00:00 PM 1746 Bob Abernethy Track 3 Tech 2 Learn how to use Business Intelligence to add value to your SQL Server data – the kind of value business people will be able to see, understand, and appreciate. Specifically, you will learn how to equip business users with Analyzer, an award-winning front-end to Analysis Services, and see how it allows them (and you) to easily interact with the data and quickly create powerful reports and dashboards. You will see why SQL Server magazine recently called Analyzer “the best solution to complete the Microsoft BI platform.” (Editor’s Best award, Dec. 2009) 4/24/2010 2:45:00 PM 4/24/2010 3:45:00 PM 1747 Harold Wong Track 4 Tech 3 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. 4/24/2010 10:00:00 AM 4/24/2010 11:00:00 AM 1778 Jon Saltzman Track 2 Tech 1 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). 4/24/2010 2:45:00 PM 4/24/2010 3:45:00 PM 1784 Doug Wheaton Track 5 Tech 4 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. 4/24/2010 11:15:00 AM 4/24/2010 12:15:00 PM 1791 Jesse Gebhardt Track 4 Tech 3 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. 4/24/2010 4:00:00 PM 4/24/2010 5:00:00 PM 1792 Bret Stateham Track 1 MAT 118 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 4/24/2010 10:00:00 AM 4/24/2010 11:00:00 AM 1794 Andrew Karcher Track 1 MAT 118 Opening Remarks for the Event 4/24/2010 8:20:00 AM 4/24/2010 8:40:00 AM 1795 Andrew Karcher Track 1 MAT 118 Raffle Prizes 4/24/2010 5:00:00 PM 4/24/2010 5:30:00 PM