SQLSaturday #55 - San Diego 2010 9/18/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat55 San Diego CA 92121 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 678 BiTKOO Gold Sponsor http://www.bitkoo.com http://www.bitkoo.com/images/logo.jpg 60 170 670 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 677 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 706 SQL Server Magazine Silver Sponsor http://www.sqlmag.com http://www.sqlsaturday.com/files/42a89404-57af-43dd-b452-9375ee13a7b7.jpg 60 170 724 Quest Software Silver Sponsor http://www.quest.com/database-management/ http://www.quest.com/images/common/quest_logo.gif 60 170 676 Telerik Inc Bronze Sponsor http://www.telerik.com http://www.sqlsaturday.com/files/d0751639-e969-4823-b49d-761be365ecf2.jpg 60 170 703 Red Gate Software Bronze Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 712 CozyRoc LLC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 751 Infragistics Bronze Sponsor http://www.infragistics.com http://www.sqlsaturday.com/files/3e49f453-1237-4026-8ac1-4f1e7ba8ae8e.jpg 60 170 711 Altova Contributing Sponsor http://www.altova.com http://www.altova.com/images/linktoaltova/altova.png 40 100 746 JetBrains Contributing Sponsor http://www.jetbrains.com http://www.sqlsaturday.com/files/eb9e2870-d879-479f-9641-95d233e0e203.jpg 40 100 772 O'Reilly Media, Inc. Contributing Sponsor http://ug.oreilly.com/ http://www.sqlsaturday.com/files/49b1ebbd-c6b4-42a3-aa9a-4ac6902101cd.jpg 40 100 773 Aspose Pty Ltd Contributing Sponsor http://www.aspose.com/ http://www.sqlsaturday.com/files/5af15714-8d53-46f7-85be-680a8be5f734.gif 40 100 774 Learn Dev Now Contributing Sponsor http://www.learndevnow.com/ http://www.learndevnow.com/Images/LearnDevNow.1.gif 40 100 775 Nitriq Contributing Sponsor http://www.nitriq.com/ http://www.sqlsaturday.com/files/0c56fc53-31bd-4cb3-9526-b24aed378671.png 40 100 776 Atomiq Contributing Sponsor http://www.getatomiq.com http://www.sqlsaturday.com/files/efbcacab-e6a4-425c-a58c-05a0aeec2cca.png 40 100 777 Apress Contributing Sponsor http://www.apress.com http://www.apress.com/img/masthead_logo.gif 40 100 778 Gerasus Software Contributing Sponsor http://www.gerasus.com/ http://www.sqlsaturday.com/files/a1686897-0a54-4535-a72f-7897835355b2.jpg 40 100 781 Idera Contributing Sponsor http://www.idera.com/Content/Home.aspx http://www.idera.com/images/Logo.jpg 40 100 782 PERPETUUM SOFTWARE LLC Contributing Sponsor http://www.perpetuumsoft.com/ http://www.perpetuumsoft.com/Images/en/PSlogo_white_350x112.png 40 100 2213 Lynn Langit Track 1 Room 1 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. 9/18/2010 1:30:00 PM 9/18/2010 2:30:00 PM 2228 Denny Cherry Track 1 Room 1 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. 9/18/2010 4:00:00 PM 9/18/2010 5:00:00 PM 2238 Dean Richards Track 2 Room 2 Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query. 9/18/2010 10:00:00 AM 9/18/2010 11:00:00 AM 2253 Tara Kizer Track 2 Room 2 We'll touch on SQL Profiler and review its best practices so that you don't impact the production system while gathering data. We'll take a deep dive into server-side traces (SQL Trace) and show how you can run a constant server-side trace with little impact on the production system. We'll also examine the things that I look for when troubleshooting performance issues. 9/18/2010 8:45:00 AM 9/18/2010 9:45:00 AM 2320 Troy Gatchell Track 3 Room 3 Take your system to the next level and scale highly read infrequently changed data with AppFabric today! AppFabric (code named “Velocity”) has been released and is the latest high availability caching product from Microsoft. Every database professional should understand this new technology as another tool in scaling their database systems. This session will review the physical and logical architecture, configuring, and interacting with AppFabric API. Session will demo retrieving data from SQL Server and caching it into an AppFabric structure. 9/18/2010 8:45:00 AM 9/18/2010 9:45:00 AM 2337 Denny Cherry Track 1 Room 1 In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output. This includes looking at the graphical as well as the XML version of the execution plan. We'll explore the variety of operators that the execution plan can present you with, and show you how to tell the SQL Server that you want to change the execution plan to get rid of the operators that you don't want to be using any more. 9/18/2010 2:45:00 PM 9/18/2010 3:45:00 PM 2399 David McCarter Track 3 Room 3 Learn how to build real world nTier applications with the new Entity Framework and related services. With this new technology built into .NET, you can easily wrap an object model around your database and have all the data access automatically generated or use your own stored procedures and views. The session will demonstrate how to create and consume these new technologies from the ground up and focus on database modeling including views and stored procedures along with coding against the model via LINQ. Dynamic data website will also be demonstrated. Lots of code! Make sure to attend Part 2. 9/18/2010 10:00:00 AM 9/18/2010 11:00:00 AM 2400 David McCarter Track 3 Room 3 Learn how to build real world nTier applications with the new Entity Framework and related services. Make sure to attend Part 1. This second part to the series will focus on using the Entity Framework in an nTier/ SOA world by separating out the different layers using T4 templates and using the new WCF Data Services to easily expose entity models via REST and to Silverlight clients. Lots of code! 9/18/2010 11:15:00 AM 9/18/2010 12:15:00 PM 2412 Rajmund Rzepecki Track 3 Room 3 The session is about domain driven development. It seems most ORM frameworks being out there do not really solve the abstraction problem between the two as these are table centric. Do such really follow SOA principles when it comes to treating the db? Empower your next project with... server side ORM. I will let you deeply rethink what you've done so far. My approach let me save days or weeks of otherwise wasted development hours when it comes to 'make a change'. You might feel ORM of your choice seem let you kickstart the project faster, but then... every major change and tweak here and there is a nightmare (refactor, recompile, retest, redeploy). Rewriting an app after every change is like working one step forward, two step backwards. 9/18/2010 2:45:00 PM 9/18/2010 3:45:00 PM 2433 Sumeet Bansal Track 2 Room 2 Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant performance increases using solid state storage. The bottom line: SQL runs 4-10x faster on solid state. This session will discuss the various solid-state storage options with their pros and cons. This session will provide practical knowledge around the use of solid state storage for databases and will use real-world use cases to demonstrate the performance advantages of using solid state. 9/18/2010 11:15:00 AM 9/18/2010 12:15:00 PM 2436 Steve Hendricks Track 3 Room 3 Job Search: Too often what separates us from the job we want is that we don't do HOW to interview. Sadly, if you don't know how to do something, you will probably not do it well. This session is designed to give you the inside track on what employers are looking for and includes an interactive hands-on portion where you can hone your interviewing skills. 9/18/2010 4:00:00 PM 9/18/2010 5:00:00 PM 2437 Steve Hendricks Track 1 Room 1 Database Replication is a daunting subject. This session will lay out the basics of what replication is, the options available to you, the tools you can use and a survey of related technologies. To anyone considering the use of replication in their environment, this session will give you the information needed to make intelligent decisions. 9/18/2010 10:00:00 AM 9/18/2010 11:00:00 AM 2565 David Moutray Track 1 Room 1 We all know that database security is important. Data is the lifeblood of modern business. Moreover, Microsoft has given us tremendous tools for securing our databases at the database level. Yet, how many database developers and database administrators use them? How many understand them? Database security is woefully neglected. There are relatively few articles published on database security. There are no new books on database security. Compare this with the tremendous number of books, articles and conferences on Network Security. Yet, our databases are vulnerable. This is a call to action. 9/18/2010 11:15:00 AM 9/18/2010 12:15:00 PM 2566 David Moutray Track 1 Room 1 We've all seen them. We've commiserated with one another about them over coffee at conferences and in blog sites. Bad database design is much more common than good database design. This discussion will cover a few of the most prominent 'Antipatterns' common to database design today. 9/18/2010 8:45:00 AM 9/18/2010 9:45:00 AM 2584 Matt Galaviz Track 3 Room 3 Knowing how to manipulate XML data in SQL Server can greatly benefit any DBA. In addition to Microsoft providing vital server information through extended events and data definition language (DDL) triggers in XML format, XML has become a ubiquitous format. Learn the basics on working with the XML Data Type in SQL Server. 9/18/2010 1:30:00 PM 9/18/2010 2:30:00 PM 2623 Bill Sheldon Track 2 Room 2 LINQ was introduced in .NET 3.0... by .NET 4.0 parts of it are almost depricated. Let's look at LINQ, what are its strengths, where does it fit moving forward. We'll talk about LINQ to SQL, LINQ to Dataset, LINQ to Entities, LINQ to CAML and where each of these fit. 9/18/2010 1:30:00 PM 9/18/2010 2:30:00 PM 2640 Mark Stewart Track 2 Room 2 Data security presents a challenge for many groups in a company. Application requirements often specify different data content for various users, while those responsible for security recognize the need to limit access as much as possible. Available options typically involve trade-offs in security, flexibility, and added work. SQL Server provides a number of security features, but row-level security is missing. This session will consider some current architectural approaches to implementing flexible data security, and then examine a packaged solution for SQL Server to effectively customize row and column access for users without login accounts. 9/18/2010 2:45:00 PM 9/18/2010 3:45:00 PM 2645 Jim Bears Track 2 Room 2 atterns 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. 9/18/2010 4:00:00 PM 9/18/2010 5:00:00 PM