SQLSaturday #68 - Olympia 2011 4/9/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat68 Olympia WA 98512 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 1088 Quest Software Gold Sponsor http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 60 170 1171 Microsoft Gold Sponsor http://www.microsoft.com http://www.sqlsaturday.com/files/f540f572-1e01-4aff-bdde-17ec2132c431.png 60 170 1177 Varigence Silver Sponsor http://www.varigence.com http://www.varigence.com/images/VarigenceFullLogo.png 60 170 1069 Perpetual Technologies, Inc. Silver Sponsor http://www.PTI.net http://pti.net/logo 60 170 1124 Confio Software Bronze Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 894 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 951 Telerik Bronze Sponsor http://www.telerik.com http://www.sqlsaturday.com/files/d4e43388-19ce-43c5-ba1e-8b278499f013.png 60 170 1006 Red Gate Software Bronze Sponsor http://www.red-gate.com http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1012 O'Reilly Media Raffle http://oreilly.com/ http://www.sqlsaturday.com/files/b55563cd-7cab-40f7-9ef2-5b1105512ee6.gif 40 100 1016 Perpetuum Software LLC Raffle http://www.perpetuumsoft.com http://www.perpetuumsoft.com/sf/en/ims/Perpetuum_Software_logo116x73.png 40 100 1170 Gerasus Software Raffle http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 40 100 3090 Robert Davis 352 352 Very large databases (VLDBs) are just like regular databases, right? There's just more of them to love. Working with very large databases can be difficult and tricky at times. Everything takes longer and minor issues become major very quickly. In this session you will learn some strategies for working with VLDBs such as how to speed up backups and restores, how to minimize your maintenance window requirements, and how to efficiently and quickly set up failover partners and replicas. Demos will include how I set up a log shipping secondary and a replica of a 2 TB database in less than half an hour. 4/9/2011 10:30:00 AM 4/9/2011 11:45:00 AM 3191 Ron Talmage 352 352 This session focuses on some surprising lessons learned and insights gained from applying DBA practices to relational data warehouses. Scenarios covered include use of table schemas versus synonyms, database chaining, managing user security, logical separation of user work from the data, backup and restore strategies, index maintenance, and change control. 4/9/2011 3:30:00 PM 4/9/2011 4:45:00 PM 3421 William Vaughn 351 351 This session is designed to bring report developers up to speed on report development best practices. We'll show how to use the Visual Studio BI tools as well as Report Builder to build, test, tune and deploy reports to the Reporting Services catalog. We'll discuss managing report projects, re-target them to a SharePoint Integrated site, manage report access rights and tune shared data sources as well as how to script the entire catalog in a single operation. We'll discuss security in-depth as well as how to create report user roles. We include information critical to developers working with all versions of SQL Server and Reporting Services--illustrating what's implemented where and how to migrate from version to version. 4/9/2011 12:30:00 PM 4/9/2011 1:45:00 PM 3424 William Vaughn 151 151 This session was written to help more advanced Reporting Services developers discover the power of report property, Report Code and DLL-based report expressions. We discuss how to use Visual Basic or C# (or any .NET language) to create expressions, imbed them in reports or create sharable DLLs so they can be shared among other report developers. We learn the mysteries behind deploying reports to applications, the BIDS IDE and to reports rendered from the Reporting Services Server. We see how references work (and where they don't), where the BIDS/Visual Studio IDE works to build combined projects (and where it doesn't) and much more. 4/9/2011 2:00:00 PM 4/9/2011 3:15:00 PM 3465 Dale Cunningham 351 351 A real life application of solving one companies serious production issues. This session will touch on many SQL Server tools, Third Party Tools, disciplines and resources and bring them all together into a synergy of useful index generation, and interpreting execution plans to get real performance measurements. 4/9/2011 9:00:00 AM 4/9/2011 10:15:00 AM 3484 Buck Woody 252 252 The term “Cloud Computing” has become so polluted that it has come to mean “web”. How do you de-tangle all the hype and vendor terms and determine when and where you can use it? Buck Woody, a Senior Technical Specialist in Distributed Computing at Microsoft will explain your options – and describe the information you need to take back to your organization. 4/9/2011 2:00:00 PM 4/9/2011 3:15:00 PM 3547 Arie Jones 151 151 A large majority of a modern DBA's workload consists of managing the resources on their systems in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides Resource Governor, which allows the DBA to discretely manage system resources in a very structured way. In this session, we will show you how to configure, monitor, and administer these features as well as demonstrate some of the pitfalls and helpful hints that you will need in order to successfully implement this fascinating tool. 4/9/2011 9:00:00 AM 4/9/2011 10:15:00 AM 3548 Arie Jones 252 252 Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment. 4/9/2011 12:30:00 PM 4/9/2011 1:45:00 PM 3580 Rick Morelan 352 352 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 Programming Joes 2 Pros. 4/9/2011 12:30:00 PM 4/9/2011 1:45:00 PM 3598 Sopheap Suy 351 351 Most women working in technology keep a low profile, rarely standing out, rarely pushing the extra effort that typically denotes excellence. Women are constantly juggling to find the balance between career and family –with added complexity when children are involved. Come and learn about the three essential career considerations for Women in Technology. Understanding and applying these considerations can help you get to the next level of excellence in your career and family life. Men who understand these considerations can better support the women members in their life. I will share some of my own experiences, challenges, and lessons learned as I have learned how to balance career, family, and life in general. 4/9/2011 2:00:00 PM 4/9/2011 3:15:00 PM 3853 John + Crystal Halunen, Manson 252 252 We will describe some of the different architectures (focusing on the db side) that Microsoft Adserving has used to Load Balance ever growing user reporting loads, data refreshes, and database maintenance across multiple reporting servers. The focus will be on the DB side, with minor context given to the web and middle tier pieces necessary for each system to work. Note that this is reporting in the sense of generating end user reports (not using SSRS). 4/9/2011 10:30:00 AM 4/9/2011 11:45:00 AM 3962 John Huang 352 352 This session is written to help developers to read query plans, understand commonly seen operators and properties in the plan. at the end, I will explain how SQL Server estimates the cost of operators and how SQL Server make decisions to choose a plan out of numerous alternatives 4/9/2011 2:00:00 PM 4/9/2011 3:15:00 PM 3977 Hope Foley 151 151 There are many IT pros who know all the snazzy tools to create fantastic reports. The users who know the data inside and out may not know those tools, but odds are that they know Excel. Microsoft has released PowerPivot which seems to bridge the gap between the two worlds. These power users can now create their own fantastic reports within PowerPivot. We will explore what PowerPivot is and how can use it to create a self-service business intelligence solution. 4/9/2011 12:30:00 PM 4/9/2011 1:45:00 PM 3979 Chuck Lathrope 252 252 Replication in SQL Server is great tool for scaling out your master database(s) onto other servers for reporting and remote site access with near real-time data propagation. In this session, I will cover LAN and WAN data replication tricks-of-the-trade to offload work from your master servers. Using these techniques, you can improve your performance and monitoring of your existing installations or gain knowledge and confidence to implement new solution for your company. 4/9/2011 3:30:00 PM 4/9/2011 4:45:00 PM 4043 Diane Robey 351 351 How can you get the most out of SQL Server Standard Edition? The SQL Server Enterprise Edition (EE) is far more expensive than the Standard Edition (SE). Many small office applications use SE. What features do you really need for your database system? Many features that are only available in EE, such as partitioning and data compression, are specific to managing larger databases. If you do not have very large databases, perhaps SE will be sufficient. Find out what actually improves performance for SE. 4/9/2011 3:30:00 PM 4/9/2011 4:45:00 PM 4049 Toshi Watanabe 151 151 RLS (Row Level Security) is often integral part of EDW (Enterprise Data Warehouse) design. There are many ways to implement RLS. This is the story about our evolution of RLS implementation and how SQL-CLR integration helped us solve technical difficulty. 4/9/2011 10:30:00 AM 4/9/2011 11:45:00 AM 4059 Nicholas Cain 351 351 Powershell is a very powerful management tool and you can spend hours writing magical scripts to do all the things you want. Frequently forgotten is the Powershell profile, a place you can add your own functions which can provide you lightening fast access to information. We'll talk about the power a profile puts at your fingertips. I will also demo (and share) a bunch of short functions that I use frequently for common tasks. I'll show you my Powershell profile if you show me yours. 4/9/2011 10:30:00 AM 4/9/2011 11:45:00 AM 4080 Greg Larsen 252 252 'Through the Looking-Glass, and What Alice Found There' - When your world is SQL Server, you need a looking-glass to determine server health, diagnosis problems, and tune performance. In this session will we follow Alice through the looking-glass to determine what she finds in SQLServerLand. Alice will be using dynamic management views and functions (DMVs) to explore the land behind the looking-glass. She will find statistics, poorly performing queries, and much more. Follow Alice and her new friends, as she traverses across SQLServerLand and provides you with snippets of T-SQL code that you can use to explore your own SQLServerLand. 4/9/2011 9:00:00 AM 4/9/2011 10:15:00 AM 4097 Paul Turley 151 151 Do your users have the same old, mundane table reports they’ve been using for decades? Stop living in the past and make your reports pop. Learn to use design patterns, best practices and visuals that pack more usable information into fewer, more usable reports. Use Reporting Services and other Microsoft BI tools to create dynamic, browse-able reports that answer important business questions at a glance and then let business users explore the details to gain insight and take action. Sure, Business Intelligence is all the rage but you don’t have to invest in an entire BI platform to have fresh, usable reports. With a little simple programming code, these design techniques apply to big analytic solutions smaller-scale operational reports. 4/9/2011 3:30:00 PM 4/9/2011 4:45:00 PM 4109 We will 252 252 Lunch 4/9/2011 11:45:00 AM 4/9/2011 12:30:00 PM 4191 Scott Stauffer 352 352 Scott's gentle introduction to SQL Server Integration Services (or SSSIS) will primarily be demonstrating how to you can use this tool in the real world to get work done. READ: very little PowerPoint time. SSIS is a high performance ETL solutions introduced in SQL Server 2005 to replace SQL Server's DTS functionality. ETL? It's okay, Scott will briefly cover some of these concepts too. Relax, sit back and learn how to simplify your 'Extract, Transform, and Load' processes. 4/9/2011 9:00:00 AM 4/9/2011 10:15:00 AM