SQLSaturday #90 - Oklahoma City 20118/27/2011 12:00:00 AMSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat90Oklahoma CityOK731701286Consulting Services, Inc.http://www.csioklahoma.com/http://www.csioklahoma.com/userfiles/csi_image001.GIF601701289HP - Microsoft Alliancehttp://www.microsoft.com/sqlserver/en/us/solutions-technologies/hp-partnership.aspxhttp://www.sqlsaturday.com/files/ab0d0eb3-243a-4af4-b7e5-6318c50f541a.png601701302Red Gate Softwarehttp://www.red-gate.com/http://www.sqlsaturday.com/files/4010ef01-61cb-4d6a-a086-a77c16bcb730.jpg601701344Iderahttp://www.idera.comhttp://www.sqlsaturday.com/files/8d69b21d-e537-491a-bbbe-7f9fd63cf959.png601701403Quest Softwarehttp://www.quest.comhttp://www.quest.com/images/common/quest-logo.gif601701502Quest Softwarehttp://www.quest.comhttp://www.quest.com/company/brand-center.aspx601701341Stonebridgehttp://www.sbti.comhttp://www.sbti.com/~/media/Images/Header%20Images/logo.ashx601701389Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/ignite_confio_logo.gif601701303CozyRochttp://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601701384O'Reilly Mediahttp://oreilly.com/http://oreilly.com/images/orn_logos/oralogo_bk200.gif401001465Morgan Kaufmannhttp://www.mkp.comhttp://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg401004801Ben MillerBen Miller is a SQL Server MVP. He has been working in IT for over 20 years and has been in both Development and IT Admin functions throughout his career. He worked for Microsoft for 7 1/2 years, spending some time in SQL Server Support. He is the President of the SQL Server User Group in Utah County, Utah and the Virtual PowerShell User Group at SQLPASS. He is a frequent speaker on SQL topics and loves to share information with the community. He lives in Lehi, UT and loves technology.@dbaduckhttp://www.linkedin.com/in/dbaduckhttp://sqlblog.com/blogs/ben_miller/https://api.twitter.com/1/users/profile_image?screen_name=@dbaduck48484743Bryan SmithBryan Smith is a Database Technical Specialist with Microsoft and a triple MCITP with SQL Server 2008. http://www.linkedin.com/pub/bryan-smith/17/98B/16148484842Greg GallowayGreg Galloway is a SQL Server MVP, mainly for his work with Analysis Services. He has been a BI architect with Artis Consulting in Dallas, Texas since 2003. He is a coordinator on several Codeplex projects including well-known BIDS Helper, the Analysis Services Stored Procedure project, and OLAP PivotTable Extensions.http://www.artisconsulting.com/blogs/GregGalloway48484940Jennifer McCownJen McCown is a Microsoft SQL Server MVP, developer, DBA and presenter, currently serving as the lead DBA at a state trade association in Texas. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She also writes for Petri IT Knowledgebase and is a forum moderator. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. @MidnightDBAhttp://www.linkedin.com/in/jennifermccownhttp://www.MidnightDBA.com/Jenhttps://api.twitter.com/1/users/profile_image?screen_name=@MidnightDBA48484777Paul HunterI have over 10 years experience in building and delivering great business solutions with MS SQL Server.@SqlNightOwlhttp://www.linkedin.com/in/paulhunterindallashttps://api.twitter.com/1/users/profile_image?screen_name=@SqlNightOwl48484724Rob VettorRob Vettor is a C# MVP, INETA Regional Speaker and senior .NET Technologist. Rob has built systems for a number of corporations, including Avanade, Raytheon, American Express and Jack Henry and Associates. Rob lives in Dallas, TX, with his wife, twin sons and three dogs, and is the founder of Hands-On-Coding (http://www.hands-on-coding.net/), a user group in which attendees bring their laptops and learn .NET coding by doing. You can contact Rob at robvettor@hotmail.com.http://www.robvet.net48484929Russel LoskiRuss Loski is an independent software developer and trainer based in Dallas, TX. He has worked with SQL Server since 6.5 and also develops .Net applications. He has worked with clients such as the Dallas Cowboys, T-Mobile and Coca Cola Enterprises. Currently he is working for Bank of America. He especially likes to work with ETL products such as SSIS.@sqlmovershttp://www.linkedin.com/in/russloski https://api.twitter.com/1/users/profile_image?screen_name=@sqlmovers48484844Ryan AdamsRyan is a SQL DBA and has worked for a Fortune 100 company for 13 years. He is the sole SQL Server DBA for his organization, supporting both vendor databases and custom databases. His primary focus is database design and performance, but also works with SSRS report development, and SSIS ETL. He serves on the board of directors for the North Texas SQL Server User Group and holds the following certifications: MCP MCSA MCSE MCDBA - SQL 2000 MCTS - SQL 2005 MCITP - SQL 2005. @ryanjadamshttp://www.linkedin.com/in/ryanjadamshttp://www.ryanjadams.comhttps://api.twitter.com/1/users/profile_image?screen_name=@ryanjadams48484927Sean McCownSean McCown holds a double MCITP in SQL Server 2008 for both Administration and Development. He is also a SQL Server MVP with over 15yrs experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight. @MidnightDBAhttp://MidnightDBA.com/DBARanthttps://api.twitter.com/1/users/profile_image?screen_name=@MidnightDBA48485228Sri SridharanSri Sridharan is the President of North Texas SQL Server User Group. Srihas been involved with SQL Server since version 4.2 and has held variousroles developer/dba/architect over the years. Sri holds 2 Mastersdegrees (Computer Science and an MBA).@dallassqlhttps://api.twitter.com/1/users/profile_image?screen_name=@dallassql48484853Steve JonesSteve Jones has been working with SQL Server since 1991 and been a DBA in a variety of large and small companies and industries. In 2001 Steve founded SQLServerCentral with two partners and has been publishing technical articles and facilitating discussions among SQL Server professionals ever since. He currently is the full time editor of SQLServerCentral, owned by Red Gate Software.@way0utwesthttp://www.linkedin.com/in/way0utwesthttp://www.voiceofhedba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@way0utwest48484771Tim MitchellTim Mitchell is a business intelligence consultant, database developer, speaker, and trainer. He has been working with SQL Server for over 8 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting. He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas AM at Commerce, and is a Microsoft SQL Server MVP. Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area.@Tim_Mitchellhttp://www.linkedin.com/in/timmitchellhttp://www.timmitchell.nethttps://api.twitter.com/1/users/profile_image?screen_name=@Tim_Mitchell48484780Wes BrownWes Brown is a PASS chapter leader. He writes for SQL Server Central and maintains his blog at http://www.sqlserverio.com. Wes is Currently serving as a Database Administrator Consultant for Dell. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays.@SQLServerIOhttp://www.linkedin.com/in/sqlserveriohttp://www.sqlserverio.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLServerIO48484739William E. Pearson IIIBill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution.@Bill_Pearsonhttp://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85ehttps://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85Ehttps://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson484847244724Rob VettorTBDEntityFramework 360: CodeOnly 4.1Come 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 PM8/27/2011 3:45:00 PM47394739William E. Pearson IIITBDSerene Velocity: Reporting Services and SSAS DataSSRS 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 PM8/27/2011 3:45:00 PM47434743Bryan SmithTBDBuilding Secure Applications with SQL ServerAs 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 AM8/27/2011 12:00:00 PM47714771Tim MitchellTBDBI Drive By: A Quick Tour of SQL Server BIIn 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 AM8/27/2011 10:45:00 AM47774777Paul HunterTBDWhat's so special about PL/SQL in 30 MinutesAKA, 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 PM8/27/2011 4:30:00 PM47804780Wes BrownTBDUnderstanding Storage Systems and SQL ServerThe 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 of8/27/2011 9:45:00 AM8/27/2011 10:45:00 AM48014801Ben MillerTBDSQL Server TDE in 30 MinutesHave 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 PM8/27/2011 4:30:00 PM48424842Greg GallowayTBDMaking Heads or Tails of Analysis Services StorageHow 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 PM8/27/2011 2:30:00 PM48444844Ryan AdamsTBDManage your shop with CMS and Policy Based MgmtIn 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 AM8/27/2011 12:00:00 PM48534853Steve JonesTBDRed Gate Tools DemonstrationIn 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 PM8/27/2011 1:15:00 PM49274927Sean McCownTBDThe Backup Tune-upHave 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 PM8/27/2011 2:30:00 PM49294929Russel LoskiTBDStored procedure tracing using the xml datatype 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 AM8/27/2011 10:45:00 AM49404940Jennifer McCownTBDUnraveling Tangled Code – A Spellbinding TaleOnce 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 PM8/27/2011 2:30:00 PM52275227Tim Mitchell TBDETL Head-to-Head: T-SQL vs. SSISIn 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 AM8/27/2011 12:00:00 PM52285228Sri SridharanTBDGoverning Your Database Environment 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 PM8/27/2011 3:45:00 PM52295229Steve JonesTBDThe Winding RoadKeynote8/27/2011 8:45:00 AM8/27/2011 9:30:00 AM52295229Steve JonesTBDThe Winding RoadKeynote8/27/2011 8:45:00 AM8/27/2011 9:30:00 AM52295229Steve JonesTBDThe Winding RoadKeynote8/27/2011 8:45:00 AM8/27/2011 9:30:00 AM52325232Event CommitteeTBDOpening of EventOpening of Event8/27/2011 8:30:00 AM8/27/2011 8:45:00 AM52325232Event CommitteeTBDOpening of EventOpening of Event8/27/2011 8:30:00 AM8/27/2011 8:45:00 AM52325232Event CommitteeTBDOpening of EventOpening of Event8/27/2011 8:30:00 AM8/27/2011 8:45:00 AM52355235Event CommitteeTBDEvent ClosingSponsor raffles, event raffles, and closing remarks.8/27/2011 4:45:00 PM8/27/2011 5:15:00 PM52355235Event CommitteeTBDEvent ClosingSponsor raffles, event raffles, and closing remarks.8/27/2011 4:45:00 PM8/27/2011 5:15:00 PM52355235Event CommitteeTBDEvent ClosingSponsor raffles, event raffles, and closing remarks.8/27/2011 4:45:00 PM8/27/2011 5:15:00 PM55105510Bryan SmithTBDHP+MS AppliancesCome 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 PM8/27/2011 1:15:00 PM55355535Russel LoskiTBDHow to use the XML Datasource in SSISXML 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 PM8/27/2011 4:30:00 PM56705670Sean McCownTBDDBAs@Midnight Webshow...Come see SQL Server MVPs Sean and Jen McCown do a live recording of their DBAs@Midnight Webshow8/27/2011 12:15:00 PM8/27/2011 1:15:00 PM