SQLSaturday #63 - Dallas 2011 4/2/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat63 Dallas TX 75083 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 858 Idera Platinum Sponsor http://www.idera.com http://www.idera.com/images/Logo.jpg 60 170 961 Microsoft Platinum Sponsor http://www.microsoft.com http://www.microsoft.com/presspass/images/gallery/logos/thumbnails/mslogo1_thumb.jpg 60 170 1000 CTREC Hilton IT Academy Platinum Sponsor http://www.ctrechilton.com/ http://www.ctrechilton.com/images/stories/ctrec_logo_large-website.png 60 170 1013 Confio Software Platinum Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1027 Quest Software Platinum Sponsor http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 60 170 1037 Bradmark Technologies Platinum Sponsor http://www.bradmark.com http://www.bradmark.com/images/bmlogo_pass.jpg 60 170 1052 GNet Group Platinum Sponsor http://www.gnetgroup.com http://www.gnetgroup.com/gfx/header/top_logo1.png 60 170 1057 Red Gate Software Platinum Sponsor http://www.red-gate.com/ http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1153 Embarcadero Technologies Platinum Sponsor http://www.embarcadero.com http://edn.embarcadero.com/article/images/40882/thumb02000008.jpg 60 170 1011 Fusion-io Gold Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1017 Matrix Resources Gold Sponsor http://www.matrixresources.com/ http://www.sqlsaturday.com/files/0ad2c644-83f8-48e6-a3a7-a4e5bfecaa70.png 60 170 1155 Penton Media Inc Silver Sponsor http://www.sqlmag.com http://www.pentonmarketingservices.com/themes/zen/zen-internals/images/techAdvPropLogo_sql.gif 60 170 925 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 935 Telerik Bronze Sponsor http://www.telerik.com http://www.sqlsaturday.com/files/2541ee82-5aa2-41b7-9044-946cdc0ebec9.gif 60 170 1117 Morgan Kaufmann Bronze Sponsor http://www.mkp.com http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 60 170 1185 Nitrosphere Bronze Sponsor http://www.nitrosphere.net http://northtexas.sqlpass.org/Portals/9/nitrosphere.jpg 60 170 1152 NerdBooks.com SWAG Sponsor http://www.nerdbooks.com http://www.nerdbooks.com/images/mast_logo_moving.gif 40 100 1163 Apress SWAG Sponsor http://www.apress.com http://apress.com/img/masthead_logo.gif 40 100 1164 Wrox SWAG Sponsor http://www.wrox.com http://media.wiley.com/assets/253/59/wrox_logo.gif 40 100 1180 Gerasus Software SWAG Sponsor http://www.gerasus.com http://www.gerasus.com/images/logo.png 40 100 2839 Wesley Brown Administrator Varies If you have ever wanted to know how SSD's and Flash memory works this talk is for you. We will cover the fundamentals of Flash in detail. I will also highlight some of the specific vendor implementations and what makes a particular SSD 'enterprise ready' vs 'Consumer grade'. We will also cover SQL Server usage patterns what is a good fit for SSD's and when it may be better to go with hard disks. Solid State Storage isn't a cure-all for every situation, this presentation will give you the tools you need to make the right choice for your SQL Server environment. 4/2/2011 8:30:00 AM 4/2/2011 9:30:00 AM 2853 Sri Sridharan Professional Development Varies You have been a DBA for so many years and struggle to decide on what next. Attend this session and find ways to rejuvenate your career to the next step. 4/2/2011 1:30:00 PM 4/2/2011 2:30:00 PM 2916 Ryan Adams Administrator Varies Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it. 4/2/2011 2:45:00 PM 4/2/2011 3:45:00 PM 2985 Paul Hunter Developer Varies Learn how, when and why you may want to incorporate CLR functionality into the database. 4/2/2011 4:00:00 PM 4/2/2011 5:00:00 PM 3074 Steve Jones Professional Development Varies Learn practical ways in this session that you can use to build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral, shares some of the ways in which he has successfully grown his career over the years. Steve will present tips and tricks for using social networking sites, blogging, volunteering, leadership, and more to your advantage. He also has a few resume hints to help you find a great job that fits you. 4/2/2011 9:45:00 AM 4/2/2011 10:45:00 AM 3382 Rob Sullivan Developer Varies In this session, we are going to take a surgical approach to why I as a DBA fear ugly ORM's. Even though you can use views and stored procs as plastic surgery for an ugly case of ORM, there is only so much you can do if it is ugly on the inside. Slides generally bore me, so we will only be looking at a couple before we put on our scrubs and hit the OR(M) to perform an uglyectomy to create an ORM we can live with. Technologies: I'll be using Entity Framework 4, Linq, MVC2 and a variety of virtual surgical tools. I ranked this session as beginner with regards to the topic of ORM's. My session makes assumptions you know about execution plans, traces, the optimizer and other non-beginner topics in SQL Server. 4/2/2011 9:45:00 AM 4/2/2011 10:45:00 AM 3385 Drew Minkin BI Varies This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks.Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time. 4/2/2011 4:00:00 PM 4/2/2011 5:00:00 PM 3509 David Browne Futures Varies An overview of the FastTrack Data Warehouse Architecture. Learn about the storage design for FastTrack, and data loading an and operational requirements for a FastTrack implementation. When to use FastTrack vs custom storage designs vs Enterprise shared storage for SQL Server Data Warehouse and VLDB applications. 4/2/2011 2:45:00 PM 4/2/2011 3:45:00 PM 3516 Ted Tasker Futures Varies 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. 4/2/2011 11:00:00 AM 4/2/2011 12:00:00 PM 3518 Prem Mehra Futures Varies Please attend to learn and understand next generation high availability and disaster recovery solution architectures from SQL Server. How it will help you in meeting the ever increasing goals to reduce Recovery Point and Recovery Time Options (RPO and RTO) while potentially reducing TCO. To fully benefit from this session it is assumed that you have a basic understanding of the current SQL Server HA/DR functionality. 4/2/2011 9:45:00 AM 4/2/2011 10:45:00 AM 3531 Sriram Ganapathy Futures Varies SQL Server Denali is the code name for the next major release of SQL Server. This session wil cover the investments in this release specifically focusing on the following areas: SQL Server AlwaysOn, Column-based Query Accelerator, Unified developer experience, Expanded BI with project crescent and enterprise information management 4/2/2011 8:30:00 AM 4/2/2011 9:30:00 AM 3605 Jessica Moss Futures Varies Starting in the SQL Server Denali release, data takes on a new life in the business intelligence world. Often forgotten, data management needs to be an integral part of your reporting systems. Learn how Microsoft has made your life easier by incorporating external parameters, environments, and groupings into Integration Services. They have also included impact analysis and data lineage, which can be tied to tables and SSIS packages. Two additional newcomer products, data quality services and master data services, complete the quartet. This session will use the first Community Technical Preview of SQL Server Denali to describe and demonstrate the enhancements to the four products that make up EDIM. 4/2/2011 1:30:00 PM 4/2/2011 2:30:00 PM 3606 Jessica Moss BI Varies Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won't ever need to show a plain, boring report again! 4/2/2011 9:45:00 AM 4/2/2011 10:45:00 AM 3613 Andy Warren Professional Development Varies A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan. 4/2/2011 11:00:00 AM 4/2/2011 12:00:00 PM 3616 Doug Brendle Advanced Varies Ever wonder what's in your SQL Plan cache? Wonder why or how it got so big? This session will cover what it is, how it's used, how it can affect performance and how poor application and query design can make it worse. Rather than put participants to sleep with a slide deck we will get down and dirty with lots of demos. 4/2/2011 1:30:00 PM 4/2/2011 2:30:00 PM 3621 Kevin Boles Developer Varies What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine. 4/2/2011 2:45:00 PM 4/2/2011 3:45:00 PM 3622 Kevin Boles Administrator Varies Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability. 4/2/2011 1:30:00 PM 4/2/2011 2:30:00 PM 3667 Scott Whigham Developer Varies Quick - what’s the difference between LEFT and RIGHT OUTER JOINs? How do you know that a NULL in your result set is from the table data or is the result of the join? If you’ve ever struggled with the ins and outs of joins and join syntax then this presentation is perfect for you. This presentation presents a straight-forward and logical approach to understanding and visualizing joins and focuses heavily on the “how” and “why” of the various join types. 4/2/2011 8:30:00 AM 4/2/2011 9:30:00 AM 3674 Bryan Smith Advanced Varies The purpose of this session is to review Analysis Service's security model and explore ways it can be effectively used to deliver complex security requirements. Topics to be addressed include administrative security, dimension data security, cell-data security, and even dynamic security techniques. 4/2/2011 9:45:00 AM 4/2/2011 10:45:00 AM 3691 Tim Costello Advanced Varies rapid-fire visual analysis. ad hoc query capability. easy interactive dashboard building. No, this insn't going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design. 4/2/2011 11:00:00 AM 4/2/2011 12:00:00 PM 3692 Tim Costello Beginner Varies In this session we'll cover all the pieces of a classic Kimball style data mart (Star schema, fact tables, dimension tables). We'll talk about the data warehouse bus architecture and how it can be used to quickly create data marts with conformed dimensions. We'll talk about what it means to have conformed dimensions and why it's important. 4/2/2011 4:00:00 PM 4/2/2011 5:00:00 PM 3693 Erin Welker BI Varies In this session, we'll walk through the steps for creating a multidimensional schema (star schema) for a subject area we're all familiar with, load the tables we create via SSIS, and build an SSAS cube to facilitate analytical analysis. The session is almost completely demo-driven, and will hopefully inspire you to go home and build your first BI solution to facilitate your own analysis. 4/2/2011 8:30:00 AM 4/2/2011 9:30:00 AM 3713 Adam Saxton Beginner Varies We will take a look at what needs to be done to get Reporting Services up and running and how the Server actually works. We will also look at what features the different designers provide and how to know which Viewer Control with your application. 4/2/2011 9:45:00 AM 4/2/2011 10:45:00 AM 3740 Jonathan Clark Advanced Varies We will cover some basics about setting up simple replication tests and dive into what happens to the underlying meta-data when changes are replicated. A good opporunity to see a demonstration style explanation of what goes on 'under the hood' during replication. Scripts will be provided. 4/2/2011 2:45:00 PM 4/2/2011 3:45:00 PM 3743 Suresh Kandoth Advanced Varies Troubleshooting Database availability and recovery problems: Do you want to become proficient in troubleshooting some of the common database availability problems? Do you want to know what are the common causes of these problems? Do you want to understand some of the internals of how SQL Server generates these errors? Come and listen to this talk from Microsoft CSS team on how they troubleshoot and resolve these problems first hand. You can also learn about all the tools you need to keep ready when you need to use them for a disaster recovery situation. We will also cover best practices to avoid encountering these type of situations. 4/2/2011 4:00:00 PM 4/2/2011 5:00:00 PM 3781 David Smithey Professional Development Varies There are times as a DBA that you need help from other DBA’s, especially if you’re the only DBA around. We will talk about the various ways of getting help (Twitter, SQL Server Central, StackOverflow). We will talk about how to ask for help (and the ways not to). 4/2/2011 8:30:00 AM 4/2/2011 9:30:00 AM 3788 Aparna Vishwamitra Administrator Varies We will cover some basic and common scenarios of SQL Connectivity issues and how to MS Support troubleshoots and resolves the same 4/2/2011 4:00:00 PM 4/2/2011 5:00:00 PM 3812 Trevor Barkhouse Beginner Varies Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance's activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system's workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls. 4/2/2011 11:00:00 AM 4/2/2011 12:00:00 PM 3850 Randy Dyess Advanced Varies In this session, you will learn the differences between administering a data warehouse database, or a reporting database, versus a database meant for OLTP operations. This session will cover the basic administration tasks and how they can be different for DBAs working with data warehouse/reporting databases. 4/2/2011 8:30:00 AM 4/2/2011 9:30:00 AM 3852 Anand Pandya BI Varies In this session you’ll learn how to use PowerPivot to create self-service BI in your organization. We will learn how to combinie data from heterogenous data sources and then create reports/dashboardsfor end users to consume and collboarate in SharePoint 2010. We will also cover when you should use PowerPivot in comparison with SQl Server Analysis Services (OLAP) so you are equiped to create robust Self Service BI applications in your organization. 4/2/2011 1:30:00 PM 4/2/2011 2:30:00 PM 3856 Russel Loski Developer Varies When running a stored procedure it is difficult to record what is happening. In this session we will develop logger code in T-SQL to add to your stored procedures. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the 'For xml' statement as well as the xml datatype methods, especially the modify method. Finally we will look at how to read the logs when finished. 4/2/2011 1:30:00 PM 4/2/2011 2:30:00 PM 3865 Russel Loski BI Varies SQL Server Reporting Services provides a powerful tool to render report based on information in a database table. But in order to use this feature, you are required to purchase an Enterprise license of SQL Server. In this session, we will create an SSIS package that renders reports based on the results of a query. 4/2/2011 11:00:00 AM 4/2/2011 12:00:00 PM 3872 David Stein Developer Varies Do you have a Zombie Database? Does your database suffer from roaming hordes of problems like the lack of primary and foreign keys, poor normalization, in place updates and deletes, and an insatiable drive to eat your braaaaaaaaaaaaaains (CPU cycles). Fear not fellow survivor for in this session, I’ll show you how to fortify your code against zombie infestation. How to deal with the unknown (nulls), how to Restore Order by Joining together in Groups. Flak Jackets are Optional. 4/2/2011 11:00:00 AM 4/2/2011 12:00:00 PM 3875 John Cook Beginner Varies Learn tips and tricks to make more effective use of SSMS. Use portable applications to get your work done without installing applications on a server. Use free tools to simplify your life. 4/2/2011 2:45:00 PM 4/2/2011 3:45:00 PM 3901 Eric Humphrey Beginner Varies Want to automatically store your database schema in a version control system (VCS)? Want to make changes across your database or server with less labor? Want to compress your backups using 7zip and PowerShell. Figure out memory allocation on an active/active cluster? How about download many files in the background? Come learn what is possible with PowerShell. 4/2/2011 1:30:00 PM 4/2/2011 2:30:00 PM 4061 Jen McCown Beginner Varies What is SQL Server? It's just software. What is SQL Server for? At its simplest, it lets you store data safely, and get it back out again. Is there a right way to say 'SQL'? Yes, actually! In this session we will work with the tools to show you around SQL Server, and explore what it can do. If you're looking to get into databases, this is your session. 4/2/2011 8:30:00 AM 4/2/2011 9:30:00 AM