SQLSaturday #52 - Colorado 2010 9/25/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat52 Colorado CO 80111 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 613 SQL Server Magazine Platinum http://www.sqlmag.com http://img.en25.com/eloquaimages/clients/PentonMediaInc/{4c554f51-5143-4a1c-b3a8-8c9c22203c7c}_ALL_SQL_LOGO_SQLServerMag_175x41.jpg 60 170 709 Confio Software Platinum http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 725 Quest Software Gold http://www.quest.com/database-management/ http://www.quest.com/images/common/quest_logo.gif 60 170 744 Fusion-io Gold http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 747 Wrox Pres - Wiley Publishing Silver http://www.wrox.com/go/ugmember http://newsletter.wrox.com/images/usergroups/usergroup_728x90.gif 60 170 729 Pearson Education Silver http://www.informit.com http://www.informit.com/display/InformIT/images/header/informit.png 60 170 732 Red Gate Software Silver http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 690 O'Reilly Media Silver http://oreilly.com http://oreilly.com/images/orn_logos/oralogo_bk200.gif 60 170 692 DawaBI Silver http://www.DawaBI.com http://www.dawabi.com/Data/Sites/1/logos/DawaBI_Logo_DawaBI_W_Tag_1.jpg 60 170 697 Telerik Inc Bronze http://www.telerik.com http://www.sqlsaturday.com/files/162b1944-ed8f-4d51-be61-50560ae3e631.jpg 60 170 660 InSphere Insurance Solutions Bronze http://www.insphereis.com/tlenz http://www.insphereis.com/images/logo_insphere_lrg.png 60 170 2036 Chris Shaw DBA 2 Data is becoming more and more critical with the needs of business every day. Technology has enabled businesses to have a global reach much easier than ever before. With the growing needs to increase revenue every avenue will be explored. The outcome of this growth is the need for your database to be online with no downtime if any at all. This session is designed to visit the issues of managing a database that is online around the clock and maintenance time is scarce. We will talk about the challenges you could face each and every day, the maintenance issues such as when, where and how to trim it. 9/25/2010 9:15:00 AM 9/25/2010 10:15:00 AM 2041 Drew Minkin BI 3 This session will focus on using real world data ( no Adventureworks) taken through the life cycle of a data mining application. Topics will include the methodology an introduction to details of DMX, managing output and validating discoveries 9/25/2010 10:30:00 AM 9/25/2010 11:30:00 AM 2049 Steve Jones PD/DBA 6 Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more. 9/25/2010 9:15:00 AM 9/25/2010 10:15:00 AM 2061 Kevin Cox DBA2 5 This is a beginner and intermedidate session for designing for performance. The talk covers logical and physical design, hardware considerations and a variety of topics for getting the best performance out of your database. 9/25/2010 8:00:00 AM 9/25/2010 9:00:00 AM 2062 Kevin Cox Dev 1 This session covers the features in SQL 2008 R2, including PowerPivot, StreamInsight, Parallel Data Warehouse and more. 9/25/2010 10:30:00 AM 9/25/2010 11:30:00 AM 2104 Jason Strate DBA 2 Often, as DBAs, we are presented with the prospect of resolving performance issues. Consider when Bob the Developer shows up accusing the server of inadequacies and expecting resolution. After hours digging through log files and traces and you are able to identify code that Bob deployed that was the root of the problem. What if there was a way to do this type of performance tuning before Bob the Developer shows up and before Sue the User figures out there are performance issues? In this session we’ll take a look at Extended Events and how you can leverage it in every day scenarios. We’ll discuss the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to understand the information. 9/25/2010 8:00:00 AM 9/25/2010 9:00:00 AM 2110 Jason Strate PD/DBA 6 Microsoft has a number of certifications for SQL Server. They cover the DBA, developer and business intelligence skills. But, does anyone take them seriously? In this session, see the tracks for SQL Server certifications and discover what you need to know about the exams. Which track will be right for you? What steps should you take? How do you get going? And what value will they bring to your career? 9/25/2010 10:30:00 AM 9/25/2010 11:30:00 AM 2134 Glenn Berry DBA2 5 SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to both 2005, 2008 and 2008 R2), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment. 9/25/2010 9:15:00 AM 9/25/2010 10:15:00 AM 2136 Glenn Berry Dev 1 SQL Azure is Microsoft's solution for hosting basic SQL Server relational databases in the cloud. Microsoft continues to add new features in each Azure Service Update that makes SQL Azure a more viable solution. For smaller databases that don't require features such as Reporting Services, Analysis Services, or Full Text Search, it can be an easy to use technology that can save lots of money in hardware, license and maintenance costs. This session shows you how to configure, connect to, and manage a SQL Azure database, both from SQL Server Management Studio and from a .NET application, and it gives best practices and tips on how to get the most benefit from SQL Azure. 9/25/2010 12:45:00 PM 9/25/2010 1:45:00 PM 2138 Jennifer McCown Dev 1 You’re a good SQL professional – you attend conferences and webinars, you read articles and books, you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Come and revisit old favorites, and brush up on new T-SQL features and enhancements like MERGE, OVER, and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations. 9/25/2010 9:15:00 AM 9/25/2010 10:15:00 AM 2140 Jennifer McCown Dev 1 Learn the best of what NOT to do when writing Transact-SQL. Comment, format, and streamline your way to a happy and virtuous coding life! 9/25/2010 2:00:00 PM 9/25/2010 3:00:00 PM 2147 Michelle Poolet PD/DBA 6 Covering the What, Why, Who, Where, When How of partitioning data and databases, this lively, audience-interaction-based discussion of partitioning is sure to keep you on your toes and asking questions. From distributed database systems to schemes used to partition data tables, for both transactional databases and data warehouses, Ms. Poolet will lead the audience through the thought processes and steps needed to get a handle on your largest data stores. 9/25/2010 3:15:00 PM 9/25/2010 4:15:00 PM 2170 Michelle Poolet PD/DBA 6 In the new world of IT, where the 'T' (technology) is a commodity, SQL People have to invest themselves in the 'I' (information) in order to be considered truly valuable. The new skills for the upcoming decade: financial literacy; management and interpersonal skills; negotiation skills; process management skills; market understanding; technical chops. OK -- so you've got the last one covered; how about the others? 9/25/2010 8:00:00 AM 9/25/2010 9:00:00 AM 2206 Steve Wake Dev/BI 4 SQL Server 2008 R2 Reporting Services included a new feature that allows you to create a library of report parts that can be shared and used to create and update reports. In this session you will see demos of how to create these report parts, how to access the report parts library and how to include them in other reports. 9/25/2010 12:45:00 PM 9/25/2010 1:45:00 PM 2227 Meredith Ryan-Smith PD/DBA 6 Many of us started our IT careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what we considered “normal.” Today, with our careers underway, how do we build a life outside of our IT world? I will share the tips, tricks and tools I’ve discovered and used to create a work/life balance that allows us to feel fulfilled and refreshed outside the office while maintaining our effectiveness as successful data professionals. 9/25/2010 12:45:00 PM 9/25/2010 1:45:00 PM 2248 Jeremy Lowell DBA 2 Data is not a by-product of a new wiz-bang application. Databases are not just a container for the shiny new website. Databases do not exist simply to be managed. Data is the reason for creating the applications and the IT infrastructure to support it. According to TDWI poor data quality costs businesses in excess of $6 billion per year. The cost of good data existing in multiple systems and business processes to work around or with poor or multiple copies of the same data is likely much higher. This session will address the data in your environment instead of the container that it lives in. We will look at Master Data Services in SQL Server 2008 R2 and how it can help your organization rethink and help define your data strategy. 9/25/2010 3:15:00 PM 9/25/2010 4:15:00 PM 2250 Dean Richards DBA 2 Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query. 9/25/2010 12:45:00 PM 9/25/2010 1:45:00 PM 2254 Janis Griffin DBA 2 Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools. 9/25/2010 2:00:00 PM 9/25/2010 3:00:00 PM 2255 Janis Griffin Dev/BI 4 Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures. 9/25/2010 9:15:00 AM 9/25/2010 10:15:00 AM 2259 Carlos Bossy BI 3 SQL Server allows you to construct an analytic organization by creating a bona fide Business Intelligence foundation, giving you more insight into the status of the business, powerful ad-hoc reporting capabilities, dynamic analytical capabilities, and forecasts that make your psychic jealous. It's an understatement to say this requires really good data and terrific data structures. In this session, Carlos Bossy will discuss how to use SSIS to implement integration, metadata and transformations, SSAS for ad-hoc and predictive analytics, and SSRS to provide users the ability to develop their own reports. You will leave this session with a firm grasp to building a robust data architecture that achieves successful Business Intelligence. 9/25/2010 3:15:00 PM 9/25/2010 4:15:00 PM 2261 Brandon Tucker Dev 1 In this session, we will explore the tracing architecture present in SQL 2005/8 and how it is leveraged by the GUI tool Microsoft provides, SQL Profiler. An initial knowledge base will be established on traces, what they are, how to define them, and how they affect a system. From here, we will apply them to real-world scenarios and be able to immediately see their importance in everyday operations of both DBAs and developers. 9/25/2010 3:15:00 PM 9/25/2010 4:15:00 PM 2264 Brandon Tucker PD/DBA 6 Who said Integration Services was just for developers and BI folk? In this session, we'll cover a few basics in SSIS that can allow DBAs to leverage the beauty of this tool for everyday tasks. We will discuss how we can create a repository of server information, iterate over a list of servers, and deploy packages such that they can run in an automated fashion. 9/25/2010 2:00:00 PM 9/25/2010 3:00:00 PM 2265 Marc Beacom BI 3 By now you have probably already heard about Analysis Services. Maybe you've even said to yourself that you were going to learn more about it but just haven't found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started. 9/25/2010 9:15:00 AM 9/25/2010 10:15:00 AM 2287 Troy Ketsdever DBA2 5 It's nice when, as database developers, we have a clean slate to work with. Most of the time, however, we inherit and must support existing designs and implementations. To add to the challenge, more often than not documentation of the database doesn't exist or is out-of-date with respect to the production system. In this session, we'll look at some tools, techniques, and scripts that will accelerate your understanding of that beast you're now in charge of supporting and extending. 9/25/2010 10:30:00 AM 9/25/2010 11:30:00 AM 2288 Jason Horner DBA 2 This presentation will provide a brief overview of how to get started with powershell and will be demo intensive. Demo topics will include common challenges that database professional's face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices. 9/25/2010 10:30:00 AM 9/25/2010 11:30:00 AM 2290 Troy Ketsdever Dev/BI 4 SQL Server 2008 saw the introduction of the new MERGE DML statement. In this session, we'll take a look at the basic syntax and capabilities of the command. Once we have reviewed some simple examples, we'll dive into some of the more advanced uses (abuses?) of the command, reinforcing our understanding by looking at more complex examples. 9/25/2010 8:00:00 AM 9/25/2010 9:00:00 AM 2292 Tom Norman DBA2 5 I need to get this database in compliance. What do I do? We will take a look at several different features of Sql Server 2008 which will help you get the database to be able to pass audits. We will take a look at Transparent Data Encryption, Security, Auditing and Policy Based Management. Let's pass this audit. 9/25/2010 12:45:00 PM 9/25/2010 1:45:00 PM 2294 Tom Norman DBA2 5 Policy Based Management, what is this? What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers. 9/25/2010 3:15:00 PM 9/25/2010 4:15:00 PM 2306 Rob Schafer BI 3 Most organizations in a SQL Server environment know about Report Services and are aware of its basic functionality. In this session, we will discuss authoring and deploying reports as well as managing and securing your Reporting Services 2008 environment. Attend this session to see how to get your reporting environment up and running efficiently and securely, and take a look at the added functionality and features in SSRS 2008. 9/25/2010 8:00:00 AM 9/25/2010 9:00:00 AM 2307 Todd Kleinhans DBA2 5 When do you need your data encrypted? After providing a brief history and intro to encryption and cryptography, we will look at several ways to secure your SQL Server data and systems. Topics include: column level encryption, transparent data encryption (TDE), third party tools, and enterprise key management (EKM) using hardware security modules (HSM)s. 9/25/2010 2:00:00 PM 9/25/2010 3:00:00 PM 2311 Carlos Bossy Dev/BI 4 This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Use SQL Server features such as Replication, Change Data Capture, and SSIS to extract, transform and load data fast and dependably and view a real demonstration of the system in action. 9/25/2010 2:00:00 PM 9/25/2010 3:00:00 PM 2313 William Pearson BI 3 In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. 9/25/2010 2:00:00 PM 9/25/2010 3:00:00 PM 2329 Jack Corbett Dev/BI 4 This session will give a brief overview of the different types of triggers available in SQL Server (DDL DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers shoul d and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well 9/25/2010 10:30:00 AM 9/25/2010 11:30:00 AM 2330 Jack Corbett Dev 1 With the proliferation of ORM tools like Entity Framework, nHibernate, and Linq to SQL, many projects have decided that stored procedures are not needed and slow down development. While these tools have their place and have improved greatly, stored procedures still have their place, and, in this speaker's opinion, are the best way to do data access. In this session I'll discuss my reasons for using stored procedures and hopefully stimulate some discussion of other access methods. 9/25/2010 8:00:00 AM 9/25/2010 9:00:00 AM 2331 Tim Mitchell Dev/BI 4 The SQL Server BIDS (Business Intelligence Development Studio) is a great tool for graphically designing SSIS packages, but there are times when having the flexibility of just working in code is preferable to the GUI interface. In this session, we'll explore the SSIS API and discuss how it can be used to create and manipulate SSIS packages in .NET code. We'll have a number of practical examples throughout the discussion. 9/25/2010 3:15:00 PM 9/25/2010 4:15:00 PM 2332 Tim Mitchell BI 3 SQL Server Integration Services is an excellent tool for quickly building ETL packages - so much so that many database professionals find themselves managing dozens, or even hundreds, of individual SSIS packages. In this session we will explore a practical approach to building an ETL framework to make the task of managing a large number of packages easier. We'll demonstrate how to use expressions and configurations for object reuse, along with ways to share values and objects among multiple packages. 9/25/2010 12:45:00 PM 9/25/2010 1:45:00 PM