SQLSaturday #95 - San Diego 2011 9/17/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat95 UCSD Extension – University City Center 6256 Greenwich Dr. San Diego CA 92122 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 1350 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 1492 Red Gate Software Gold Sponsor http://www.red-gate.com/ http://www.red-gate.com/assets/images/common/logo.png 60 170 1354 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1530 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/md-logo-sqlsat-170x60.jpg 60 170 1545 Violin Memory Inc. Silver Sponsor http://www.vmem.com http://media.marketwire.com/attachments/201003/4783_voilin.gif 60 170 1550 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 1565 New Horizons CLC of Southern California Silver Sponsor http://www.nhsocal.com/Localweb/ http://www.nhsocal.com/LocalWeb/images/header_logo.gif 60 170 1480 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1494 SSWUG.ORG Bronze Sponsor http://www.sswug.org http://www.sswug.org/editorial_images/SSWUG_LOGO_CLEAR.jpg 60 170 1520 SQL Solutions Group Bronze Sponsor http://www.sqlsolutionsgroup.com http://www.sqlsolutionsgroup.com/images/logo2.jpg 60 170 1514 UCSD Extension Personal Sponsor http://extension.ucsd.edu http://www.sqlsaturday.com/files/80782d94-fc26-4cf1-aa61-d355ecda807b.gif 40 100 1364 SQLvariant Blog Sponsor http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 1558 Aspose Pty Ltd Contributing Sponsor http://www.aspose.com/adtracker/?code=155159110824 http://www.sqlsaturday.com/files/356fa38b-b561-47db-a86d-18b1b1f19958.jpg 40 100 1580 Elsasoft Contributing Sponsor http://www.elsasoft.org http://www.sqlsaturday.com/files/916b448c-5807-46d0-84c0-9b6a1db97bc0.jpg 40 100 1584 DbVis Software Contributing Sponsor http://www.dbvis.com/ http://www.sqlsaturday.com/files/2764ff6b-5138-4800-afb4-c6097138b406.jpg 40 100 1585 Spectral Core Contributing Sponsor http://www.spectralcore.com/ http://www.sqlsaturday.com/files/d703237d-6b1b-4351-a43c-caee267c2be6.jpg 40 100 1586 SiSense Contributing Sponsor http://www.sisense.com http://www.sisense.com/siteimages/logo-sisense.gif 40 100 1587 xSQL Software Contributing Sponsor http://www.xsqlsoftware.com/ http://www.xsqlsoftware.com/Images/Headers/xSQLLogoWithStripesSmall3.jpg 40 100 1588 Morgan Kaufmann Contributing Sponsor http://mkp.com/ https://fbcdn-profile-a.akamaihd.net/hprofile-ak-snc4/50332_9654029942_8570_n.jpg 40 100 1589 Apress Contributing Sponsor http://www.apress.com http://www.sqlsaturday.com/files/be9a61cf-c3ce-4a57-946d-267097082555.jpg 40 100 1590 O'Reilly Media Contributing Sponsor http://oreilly.com/ http://www.sqlsaturday.com/files/6d7607a5-f303-4ead-a2a7-df69735bb7b2.jpg 40 100 1591 Wrox Press Contributing Sponsor http://www.wrox.com/WileyCDA/ http://newsletter.wrox.com/images/usergroups/usergroup_125x125.gif 40 100 1592 Quest Software Contributing Sponsor http://www.quest.com/ http://www.sqlsaturday.com/files/d4f6d763-ba26-476e-b912-7587ab829252.jpg 40 100 4896 David McCarter Development 316 Learn how to build real world nTier applications with the 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. Then learn how to easily and securely expose your object model using WCF with just a few line of code using WCF Data Services. The session will demonstrate how to create and consume these new technologies from the ground up. 9/17/2011 8:45:00 AM 9/17/2011 9:45:00 AM 4897 David McCarter Development 316 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. 9/17/2011 10:00:00 AM 9/17/2011 11:00:00 AM 4898 Meredith Ryan-Smith DBA 1 317 Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one. 9/17/2011 8:45:00 AM 9/17/2011 9:45:00 AM 4900 Prakash Heda Denali/Other 309 You will learn... What is SQL Server AlwaysOn/HardON What is AlwaysOn Availability Group WSFC changes for AlwaysOn FCI AlwaysON VS Clustering/Mirroring/Log Shipping Availability Group with WSFC Availability Group/ Virtual Name Failover Readable Multiple Secondary AlwaysOn implementation Demo (Availability Group/Virtual Name Failover/Readable Secondary) 9/17/2011 4:00:00 PM 9/17/2011 5:00:00 PM 4921 Clint Kunz Denali/Other 309 This session will cover coming enhancements in SSIS, SSAS, SSRS, PowerPivot, Business Intelligence Semantic Model (BISM), and Project Crescent. I will demo the new Project Crescent ad-hoc analysis tool, and show the capabilities within the new Business Intelligence Semantic Model BISM. There are also some nice visual enhancements coming into PowerPivot that you will not want to miss. 9/17/2011 11:15:00 AM 9/17/2011 12:15:00 PM 4922 Clint Kunz Panels/Other Executive If you are a DBA, and you are hearing from your management team 'Everything else is being virtualized, when can we virtualize your SQL Servers?', then you need to come to this session. In it we will discuss the concepts required to properly virtualize SQL Server. You can take control and lead the virtualization conversation by building a fact based plan for when to virtualize, and when to go with a physical infrastructure. You need ammunition and hard evidence to push the server and virtualization teams to consider your SQL Server environments in a different light. What metrics are important for you to capture before go live, and what metrics you must monitor proactively for success. 9/17/2011 8:45:00 AM 9/17/2011 9:45:00 AM 5019 David Eichner Business Intelligence 306 Learn how easy it is to utilize the free download from Microsoft that allows users to create charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. 9/17/2011 11:15:00 AM 9/17/2011 12:15:00 PM 5063 Ike Ellis DBA 2 308 These are SQL tips for the YouTube generation. I have 20 SQL Server performance tuning and developer tips. They have little to do with each other, and we'll spend about five minutes on each. Think of this as 20 different, five minute presentations. 9/17/2011 1:30:00 PM 9/17/2011 2:30:00 PM 5064 Ike Ellis DBA 2 308 These are SQL tips for the YouTube generation. I have 20 SQL Server performance tuning and developer tips. They have little to do with each other, and we'll spend about five minutes on each. Think of this as 20 different, five minute presentations. 9/17/2011 2:45:00 PM 9/17/2011 3:45:00 PM 5096 Denny Cherry DBA 1 317 In this session we'll dig into the internal structors of indexes. We will explore the differences between clustered and non-clustered indexes, what's layed out within each page of the indexes and how the SQL Server uses the data within the indexes to find rows quickly. 9/17/2011 11:15:00 AM 9/17/2011 12:15:00 PM 5097 Denny Cherry DBA 1 317 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. 9/17/2011 10:00:00 AM 9/17/2011 11:00:00 AM 5098 Denny Cherry Development 316 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. 9/17/2011 2:45:00 PM 9/17/2011 3:45:00 PM 5158 Robert Davis Business Intelligence 306 Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administrate BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator? Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know. 9/17/2011 2:45:00 PM 9/17/2011 3:45:00 PM 5159 Robert Davis DBA 1 317 If you work with very large databases (VLDBs) that must be replicated, you should be using initialization from backup. There are a some misconceptions the have caused DBAs to assume that they could not use initialization from backup. In this session I will explore those misconceptions and prove that they are incorrect. Demos will include initializing a subscriber from a transaction log backup and performing a partial restore of a database and initializing the subscriber from the partial backup. 9/17/2011 4:00:00 PM 9/17/2011 5:00:00 PM 5172 Lakshmi Randall Performance/Other 313 I'll share my project experience implementing Fast Track data warehouse. This session will cover- Fast Track Architecture Overview- Considerations in selecting Fast Track- Why is Fast track a 'recipe' based approach? - Key principles of Fast Track architecture 9/17/2011 8:45:00 AM 9/17/2011 9:45:00 AM 5179 Denise McInerney DBA 2 308 Understanding Transactions Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance. 9/17/2011 11:15:00 AM 9/17/2011 12:15:00 PM 5180 Denise McInerney Denali/Other 309 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. 9/17/2011 8:45:00 AM 9/17/2011 9:45:00 AM 5280 Robert / Denny Davis / Cherry Panels/Other Executive Join two Certified Masters as they discuss the Certified Masters and Certified Architect certifications for SQL Server. There will be a mixture of material to present and questions from attendees. Bring all of your questions! 9/17/2011 1:30:00 PM 9/17/2011 2:30:00 PM 5281 Benjamin Nevarez Performance/Other 313 The SQL Server Query Optimizer is a cost-based optimizer: it analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost. In this session I will go into the internals of the Query Optimizer and will show you the steps that it performs in the background covering everything from the time a query is submitted to SQL Server until an execution plan is generated. Why query optimization is an inherently complex problem and why challenges in some of its most fundamental areas are still being addressed today will be covered as well. 9/17/2011 1:30:00 PM 9/17/2011 2:30:00 PM 5282 Benjamin Nevarez DBA 1 317 Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics. 9/17/2011 2:45:00 PM 9/17/2011 3:45:00 PM 5343 Creighton Kagey Denali/Other 309 In this session we will cover new features of SSIS in Denali in three main areas: the development experience, the deployment experience and the maintenance experience. We will show the results of migrating an existing 2008 SSIS solution that uses package configurations, parent/child package execution and custom logging to Denali. I will compare the new tools to 2008 and will also throw in useful tidbits of SSIS knowledge that I have. If you develop, deploy or maintain SSIS packages then you will take away something positive from the presentation 9/17/2011 2:45:00 PM 9/17/2011 3:45:00 PM 5364 Angel Abundez Business Intelligence 306 Tablix = Table + Matrix. Got it? Good. But wait, what exactly is a Tablix good for then? And where is it in your SSRS Toolbox? Not to worry. Angel will show you how to wake up the Tablix control introduced in SQL Server 2008 R2 using some real-world examples. In this session, you'll learn why the Tablix features help solve many common reporting scenarios such as Timelining, Summarizing, and Subtotaling. Important takeaways from this session are how to aggregate everywhere in your Tablix with single formulas and condensing very wide reports. We’ll also cover some visualization reporting techniques to help solve some pretty common reporting requests such as Exporting to Excel. Please welcome: Table, Matrix, and List. 9/17/2011 4:00:00 PM 9/17/2011 5:00:00 PM 5369 Phil Helmer DBA 2 308 Are you looking for an easier way to de-duplicate your data? Do you need to join a SELECT statement to itself six ways to Sunday? Common Table Expressions (CTEs) can make these tasks (and many others) so much more manageable, you'll wonder how you ever got along without them. CTEs are a very useful method for abstracting data access in most of the popular relational database platforms (MS SQL Server, Oracle, PostgreSQL, DB2). This session will walk through syntax and implementation of CTEs in MS SQL Server. We will then focus on their practical uses, including self-joins, taking advantage of windowing functions, removing duplicates from data sets, and recursion. 9/17/2011 8:45:00 AM 9/17/2011 9:45:00 AM 5481 Lynn Langit Panels/Other Executive Demos! See the tools you can use to explore, setup, migrate and maintain a cloud RDMS (SQL Azure). Includes free tools, such as SQL Server Migration Tools; DBA tools, such as SQL Server Management Studio; Developer tools, such as Visual Studio and SQL Server Developer Tools ('Juneau') and more. 9/17/2011 2:45:00 PM 9/17/2011 3:45:00 PM 5496 Andrew Karcher Business Intelligence 306 Are you just getting into Business Intelligence? Are you a SQL Developer or a DBA that wants to learn more about the skills required to be a BI Professional? If you answered yes to one of those questions, then this is the session for you. This session will take you through the whole Microsoft stack and talk about some of the key areas of knowledge that are needed to call yourself a BI professional at either a beginner, intermediate or advanced level. We will also talk about the various Microsoft Certifications and where they fit. I guarantee you will leave this session with some to-dos and knowledge that you will want to brush up on. 9/17/2011 10:00:00 AM 9/17/2011 11:00:00 AM 5497 Kathy Gibbs Panels/Other Executive Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data. 9/17/2011 10:00:00 AM 9/17/2011 11:00:00 AM 5503 Paul Mendoza DBA 2 308 Lots of devices can give positions and instead of just storing those in a Latitude and Longitude fields in your database you could be using the Geography data type that SQL Server provides. You can even store more complex shapes like zip code boundaries. We will learn how to fill these, how to work with them, how to index these with spatial indexes and how to use the spatial indexes effectively. 9/17/2011 10:00:00 AM 9/17/2011 11:00:00 AM 5507 Rick Morelan Performance/Other 313 Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3. 9/17/2011 10:00:00 AM 9/17/2011 11:00:00 AM 5508 Rick Morelan DBA 1 317 Did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action or control it. This is possible with or without structured error handling. See both ways to control the outcome. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4. 9/17/2011 1:30:00 PM 9/17/2011 2:30:00 PM 5515 Thomas Mueller Panels/Other Executive “Ask the experts” will be an interactive QA session where you can ask veterans anything SQL related. The following experts will answer your questions: - Andrew Karcher - Ben Aminnia - Benjamin Nevarez - Bret Stateham - Denise McInerney - Denny Cherry - Ike Ellis - Lynn Langit 9/17/2011 4:00:00 PM 9/17/2011 5:00:00 PM 5571 Ben Aminnia Business Intelligence 306 This session was inspired by Brian Knight’s excellent book “Microsoft Business Intelligence 24-Hour Trainer” – with an agile notion to summarize each hour of it in two minutes. 9/17/2011 1:30:00 PM 9/17/2011 2:30:00 PM 5604 Lakshmi Randall Denali/Other 309 Project Apollo introduces Columnstore index in Denali. Columnstore index can potentially improve data warehouse query performance on large fact tables (star joins and aggregation) by creating a highly compressed architecture. It utilizes the same vertipaq algorithm used by Powerpivot. Only the data for the columns selected in the query is brought into memory. Columnstore index is recommended primarily for read-only workloads.The demo will include scenarios which will benefit from using columnstore index and will highlight best practices for using columnstore index. 9/17/2011 1:30:00 PM 9/17/2011 2:30:00 PM 5605 Ben Bolte Business Intelligence 306 Whether you are new to SQL Server or you just haven't had the opportunity to learn about it, Integration Services can be a powerful tool to have at your disposal. In this session, I'll introduce you to the basic components of an Integration Services package as well as its most common applications. We'll review best practices for setting up packages for file imports and exports as well as transferring data between servers and automation of packages. Finally, we'll review more advanced processing techniques, deployment options, logging, and implementation of version history through source control. 9/17/2011 8:45:00 AM 9/17/2011 9:45:00 AM 5622 Chris Dickey Performance/Other 313 Learn how I find high cost queries using the SQL Server 2008 tools. DMV's are great for finding a lot of problems fast. But, sometimes you still need Profiler. I will discuss cases where the DMV's are all you need. I will also discuss how to get information from Profiler that is missing from the DMV data. Extended Events are powerful and will be a major tool in the future of troubleshooting. I will explain why we need Extended Events to solve problems in addition to DMV's and Profiler. 9/17/2011 2:45:00 PM 9/17/2011 3:45:00 PM 5636 Meredith Ryan-Smith Panels/Other Executive The number of young women entering IT is declining. What can those of us in the industry do to encourage and inspire young women to seek out careers in technology? Mentoring programs, field trips and 'Bring Your Daughters to Work' days all exist, but what more could we be doing to spark interest? Join us to hear from a panel of technical women talk about organized programs and individual endeavors designed to inspire the next generation of Women in Technology. 9/17/2011 12:15:00 PM 9/17/2011 1:30:00 PM 5684 Scott Reed Development 316 When talking to Sql Azure there are some best practices you are supposed to follow. Things like batching and retrying on connection failure. There are well documented ways to do this using ADO.NET. However more and more applications are being written using Entity Framework rather than ADO.NET. If we are using Entity Framework how do we follow those best practices? 9/17/2011 1:30:00 PM 9/17/2011 2:30:00 PM 5685 Brad Cunningham Denali/Other 309 I will talk about software tools that improve my development process (like R#, slickrun, beyond compare,etc..) I will also cover personal workflow habits and tips on improving your workflow and moving more of your 'life' to the cloud. I will talk about syncing your life to all machines. This includes notes, email, calendar, files etc.. Some of the products I will talke about are. OneNote, SlickRun, R#, Windows HomeServer, Live Mesh, Google Chrome Sync etc.. 9/17/2011 10:00:00 AM 9/17/2011 11:00:00 AM 5690 Woody Pewitt Development 316 Technical debt is the cost of putting off good development practices. This debt must be paid back to avoid the “interest payments” becoming crippling. This presentation will focus on a number of common developer (and project) anti-patterns that can lead to the buildup of technical debt in a project and, having identified these behaviors, we’ll look at techniques to firstly quantify and then to mitigate against them. 9/17/2011 11:15:00 AM 9/17/2011 12:15:00 PM 5691 Joseph Vertido Panels/Other Executive Address data is one of the most common type of contact information found in databases. In this session, we will examine some underlying factors that affect address correctness and build the business case for having good address data. We will touch on how having correct addresses affects all aspects of data quality from matching to enrichment. Handling data is one thing, but knowing your data and understanding the risks are the first step to managing good quality data. Come hear about what you don’t know on Address and Data Quality – it might be costing you. 9/17/2011 11:15:00 AM 9/17/2011 12:15:00 PM 5703 Rajmund Rzepecki Development 316 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/17/2011 4:00:00 PM 9/17/2011 5:00:00 PM 5724 Peter Kral DBA 2 308 In this session, you will be introduced to some simple PowerShell techniques, and see how to combine them to create an event-driven listener job running in SQL Server Agent service. Designed to be accessible to database administrators and database developers, you will see how easy it is to create useful scripts in PowerShell. 9/17/2011 4:00:00 PM 9/17/2011 5:00:00 PM 5800 Deepak Puri Performance/Other 313 SQL Server Analysis Services (SSAS) began life as OLAP Services in SQL Server 7, over a decade ago. Since then there have been major architectural enhancements and SSAS now plays a central role in Micorosoft's Business Intelligence (BI) platform. This session will describe major SSAS functionality, with demos to illustrate key features. We'll also examine the new SSAS features in SQL Server 2008 R2 and preview the SSAS Business Intelligence Semantic Model (BISM) being introduced in 'Denali', the next version of SQL Server. 9/17/2011 4:00:00 PM 9/17/2011 5:00:00 PM 5825 Llewellyn Falco Performance/Other 313 Introduction to Agile 9/17/2011 11:15:00 AM 9/17/2011 12:15:00 PM