SQLSaturday #90 - Oklahoma City 2011 8/27/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat90 Oklahoma City OK 73170 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 1286 Consulting Services, Inc. Gold Sponsor http://www.csioklahoma.com/ http://www.csioklahoma.com/userfiles/csi_image001.GIF 60 170 1289 HP - Microsoft Alliance Gold Sponsor http://www.microsoft.com/sqlserver/en/us/solutions-technologies/hp-partnership.aspx http://www.sqlsaturday.com/files/ab0d0eb3-243a-4af4-b7e5-6318c50f541a.png 60 170 1302 Red Gate Software Gold Sponsor http://www.red-gate.com/ http://www.sqlsaturday.com/files/4010ef01-61cb-4d6a-a086-a77c16bcb730.jpg 60 170 1344 Idera Gold Sponsor http://www.idera.com http://www.sqlsaturday.com/files/8d69b21d-e537-491a-bbbe-7f9fd63cf959.png 60 170 1403 Quest Software Gold Sponsor http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 1341 Stonebridge Silver Sponsor http://www.sbti.com http://www.sbti.com/~/media/Images/Header%20Images/logo.ashx 60 170 1502 Quest Software Silver Sponsor http://www.quest.com http://www.quest.com/company/brand-center.aspx 60 170 1303 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1389 Confio Software Bronze Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1384 O'Reilly Media Swag Sponsor http://oreilly.com/ http://oreilly.com/images/orn_logos/oralogo_bk200.gif 40 100 1465 Morgan Kaufmann Swag Sponsor http://www.mkp.com http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 40 100 4724 Rob Vettor Developer TBD Come see the new 'code-centric' approach to managing your application data. In this session, we’ll • Explore the Entity Framework 4.1, its components and show how it works • Define an object model, implementing persistent POCO classes, while customizing the mapping via the tool's fluent API • Walk through a variety of examples that show how to interact with the model • Demonstrate how the Entity Framework automatically tracks data changes and generates updates. You’ll walk-away with a clear understanding of how the new “code only” extensions enable you to implement a code-centric approach to store persistence. 8/27/2011 2:45:00 PM 8/27/2011 3:45:00 PM 4739 William E. Pearson III Business Intelligence TBD SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best. 8/27/2011 2:45:00 PM 8/27/2011 3:45:00 PM 4743 Bryan Smith Developer TBD As recent breaches and disruptions have demonstrated, application security could not be more critical. As the foundation of many of our applications and the stores of our most sensitive data, databases are a prime target. Still, very few developers take advantage of security features available to them to secure the databases behind their applications. Join Bryan Smith, a Database Technical Specialist with Microsoft, in exploring security features and best practices applicable to Microsoft SQL Server which will allow you to secure your database applications. 8/27/2011 11:00:00 AM 8/27/2011 12:00:00 PM 4771 Tim Mitchell Business Intelligence TBD In this session, we'll take a very fast tour through the major components of SQL Server Business Intelligence (Integration Services, Analysis Services, Reporting Services). We'll discuss the roles of each of these tools in the enterprise, briefly reviewing some practical applications of each. This session is ideal for software developers, business principals, or other technical professionals who have had little to no exposure to the SQL Server BI stack. 8/27/2011 9:45:00 AM 8/27/2011 10:45:00 AM 4777 Paul Hunter Developer TBD AKA, things I'd like to see in MS SQL Server. PL/SQL is a powerful and flexible SQL programming language that supports some nice features. This is a good overview of people that have to stray across the great divide into “Oracle world”. 8/27/2011 4:00:00 PM 8/27/2011 4:30:00 PM 4780 Wes Brown Database Administration TBD The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server's Disk I/O System. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations. We will cover the basics of computer systems, hard disks and disk controllers. Next, we will move to the fundamentals of RAID and how to configure your arrays for performance and reliability. Later, we will discuss the relationship between SQL Server and the file system, what is required for SQL Server and how to configure the file system for optimal performance. Finally, we will touch on how to monitor the performance and health of 8/27/2011 9:45:00 AM 8/27/2011 10:45:00 AM 4801 Ben Miller Database Administration TBD Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE. 8/27/2011 4:00:00 PM 8/27/2011 4:30:00 PM 4842 Greg Galloway Business Intelligence TBD How can you make your cube more real-time? How can you get more out of your enterprise data warehouse by putting Analysis Services on top of it? What’s new in Denali for Analysis Services? In this session we will take a deep dive into storage modes in Analysis Services. We’ll discuss the pros and cons of the two storage modes a Multidimensional model can use: MOLAP and ROLAP. We’ll discuss the storage modes in new Tabular models coming in the next version of Analysis Services: Vertipaq and DirectQuery. We’ll preview the new columnar index in the next version of SQL Server and discuss how it impacts Analysis Services. And we’ll discuss why one Fortune 500 company chose ROLAP and another chose MOLAP. 8/27/2011 1:30:00 PM 8/27/2011 2:30:00 PM 4844 Ryan Adams Database Administration TBD In this presentation we talk about Central Management Server and how it can help you manage a disperse environment. We will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise. We will cover and demonstrate PBM for the beginner from creating and evaluating policies to receiving alerts on policy violations. 8/27/2011 11:00:00 AM 8/27/2011 12:00:00 PM 4853 Steve Jones Database Administration TBD In this short session, Steve Jones will demonstrate a few of the Red Gate tools that can save you a tremendous amount of time and make your job as a DBA much easier every day. 8/27/2011 12:15:00 PM 8/27/2011 1:15:00 PM 4927 Sean McCown Database Administration TBD Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success wi 8/27/2011 1:30:00 PM 8/27/2011 2:30:00 PM 4929 Russel Loski Developer TBD When running a stored procedure it is difficult to record what is happening. I developed a simple logging mechanism. In this session we will examine logger code in T-SQL I added to a stored procedure. 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. 8/27/2011 9:45:00 AM 8/27/2011 10:45:00 AM 4940 Jennifer McCown Developer TBD Once upon a time, you inherited an application or a database filled with chaos and inconsistencies. The T-SQL code is overly complex. The architecture is painful to behold, and grueling to code for. Query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious! 8/27/2011 1:30:00 PM 8/27/2011 2:30:00 PM 5227 Tim Mitchell Business Intelligence TBD In this session, we'll compare ETL strategies between SQL Server Integration Services and plain old T-SQL. Is one better than the other? Should I just use SSIS and skip T-SQL altogether, or vice versa? We'll address these questions and more, and will take a look at some practical examples and a few head-to-head comparisons using both tools. Seesion Goals: •Attendees will gain an understanding of the role of Transact-SQL as part of an ETL strategy. •Attendees will gain an understanding of the logistical differences between using SSIS and Transact-SQL for ETL processing. •Attendees will learn, through practical demonstration, some situations that may be better served by Transact-SQL rather than SSIS (and the reverse). 8/27/2011 11:00:00 AM 8/27/2011 12:00:00 PM 5228 Sri Sridharan Database Administration TBD As we all know about SQL sprawl, it becomes cumbersome for the DBAs tostay on top of all the servers in the environment. Come to this sessionand learn about simple techniques can help DBA stay on top of thegrowing SQL environment. 8/27/2011 2:45:00 PM 8/27/2011 3:45:00 PM 5229 Steve Jones Database Administration TBD Keynote 8/27/2011 8:45:00 AM 8/27/2011 9:30:00 AM 5229 Steve Jones Developer TBD Keynote 8/27/2011 8:45:00 AM 8/27/2011 9:30:00 AM 5229 Steve Jones Business Intelligence TBD Keynote 8/27/2011 8:45:00 AM 8/27/2011 9:30:00 AM 5232 Event Committee Business Intelligence TBD Opening of Event 8/27/2011 8:30:00 AM 8/27/2011 8:45:00 AM 5232 Event Committee Developer TBD Opening of Event 8/27/2011 8:30:00 AM 8/27/2011 8:45:00 AM 5232 Event Committee Database Administration TBD Opening of Event 8/27/2011 8:30:00 AM 8/27/2011 8:45:00 AM 5235 Event Committee Database Administration TBD Sponsor raffles, event raffles, and closing remarks. 8/27/2011 4:45:00 PM 8/27/2011 5:15:00 PM 5235 Event Committee Developer TBD Sponsor raffles, event raffles, and closing remarks. 8/27/2011 4:45:00 PM 8/27/2011 5:15:00 PM 5235 Event Committee Business Intelligence TBD Sponsor raffles, event raffles, and closing remarks. 8/27/2011 4:45:00 PM 8/27/2011 5:15:00 PM 5510 Bryan Smith Business Intelligence TBD Come hear cool stuff about HP and Microsoft’s SQL Server appliances and register to win an Xbox 360+Kinect bundle to be raffled off at the end of the presentation. 8/27/2011 12:15:00 PM 8/27/2011 1:15:00 PM 5535 Russel Loski Business Intelligence TBD XML is a convenient method for transferring data from system to system. SQL Server SSIS provides the XML Datasource to import this data into SQL Server. In this session we will learn how to set up a simple XML Datasource. Then we will look at handling XML files with a more hierarchical structure. 8/27/2011 4:00:00 PM 8/27/2011 4:30:00 PM 5670 Sean McCown Developer TBD Come see SQL Server MVPs Sean and Jen McCown do a live recording of their DBAs@Midnight Webshow 8/27/2011 12:15:00 PM 8/27/2011 1:15:00 PM