SQLSaturday #107 - Houston 2012 4/21/2012 12:00:00 AM (GMT-06:00) Central Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat107 YES Prep Public Schools - North Central Campus 13703 Aldine-Westfield Houston TX 77039 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 1680 Idera Platinum Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 1656 Red Gate Software Ltd Gold Sponsor http://www.red-gate.com/ http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 1880 HP Gold Sponsor http://www.hp.com http://www.hp.com/hpinfo/newsroom/press_kits/2010/InnovationSummit/images/HP_Logo.jpg 60 170 1667 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1856 Insource Technology Silver Sponsor http://www.insource.com http://www.insource.com/images/insourceLogo_159.jpg 60 170 1970 Texas Memory Systems Silver Sponsor http://RamSan.com https://www.ramsan.com/files/download/166.png 60 170 2004 Joes 2 Pros Silver Sponsor http://www.joes2pros.com http://joes2pros.com/about/Joes2Pros.jpg 60 170 2124 New Horizons Computer Learning Center of Houston Silver Sponsor http://www.newhorizons.com http://www.nhcomputerlearning.com/Content/Images/NHcmykLogo.gif 60 170 2164 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1802 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2137 SQLWatchmen, LLC. Bronze Sponsor http://www.sqlwatchmen.com http://www.sqlwatchmen.com/images/logo.png 60 170 6041 Vicky Harp AD Track Room Y106 Are you confident that your application performs as expected on Leap Day? Do you know how long it would take to run out of identity values in your major tables? Can you support case-sensitive collations and non-standard sort orders? If not, odds are good that you are not edge and corner testing your application. In this session, learn how to define the edges of your application and start to stretch those boundaries by setting up challenging test and development environments. For database administrators, learn what configurations in your environment may be a source of bugs in application code and what you can do about it. Learn about edge cases that you can start hardening your code against on Monday morning! 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 6043 Thomas LeBlanc DBA Track Room Y209 This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window? 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 6044 Jim Murphy DBA Track Room Y205 In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. Denali AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic ConnectionString fail-over using a real web app to see how well that feature works. 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 6046 John Cook AD\DBA Track Room Y218 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.John Cook 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/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 6065 William E. Pearson III BI Track Room Y109 The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this introductory session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions. 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 6070 William E. Pearson III BI Track Room Y114 Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson leads an examination into a way we can accomplish this by implementing a SQL Server Analysis Services 'many-to-many' dimension scenario. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 6111 Bryan Smith BI Track Room Y109 Introduced with SQL Server 2012, columnstore indexes allow users to query data warehouses with fast, consistent performance. In this session, you will learn when to use these indexes, how to effectively implement them, and how to work through their maintenance challenges. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 6112 Bryan Smith BI Track Room Y109 A lot has been made of Microsoft's announcement around support for Apache Hadoop but many in the Microsoft Business Intelligence community have been left scratching their head about what this exactly means. In this session, we will discuss Big Data concepts, pick apart Microsoft's announcement, and explore what Big Data means for Business Intelligence programs traditionally focused on data warehousing. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 6122 Kalen Delaney DBA Track Room Y212 SQL Server offers two methods for an application to provide data consistency: Pessimistic and Optimistic Concurrency Control. In this session we’ll discuss the tradeoffs between consistency and concurrency, and what consistency might mean to your applications,. We'll look at the costs and trade-offs between the two Concurrency Models that SQL Server supports through different transaction isolation levels. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 6124 Steven Ormrod DBA Track Room Y212 Losing your memory is never fun. Well, I can't help you with that, but I can help show you how SQL Server is using its memory and some things to look for with regards to performance problems. When I started as a DBA I didn't know much about SQL Server internals. I inherited quite a few servers and they were experiencing performance problems. Over time I learned more about the internals and how to troubleshoot systems. I'll share some stories with you and talk about some of the methods I use to look at how SQL Server is using its memory. Then we'll look at some examples and demo code. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 6214 Janis Griffin DBA Track Room Y209 More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 6358 William Assaf DBA Track Room Y201 In this practical and script-focused session, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 6569 Wesley Brown DBA Track Room Y209 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 situtation, this presentation will give you the tools you need to make the right choice for your SQL Server environment. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 6570 Wesley Brown DBA Track Room Y209 Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come! 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 6578 James Serra BI Track Room Y114 Learn how SQL Server 2008 can scale to HUNDREDS of terabytes for BI solutions. This session will focus on Fast Track Solutions and Appliances, Reference Architectures, and Parallel Data Warehousing (PDW). Included will be performance numbers and lessons learned on the very first PDW implementation in the world and how a successful BI solution was built on top of it using SSAS. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 6707 Argenis Fernandez AD\DBA Track Room Y218 In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended. 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 6709 Argenis Fernandez DBA Track Room Y205 In this session we will discuss how to perform upgrades while maintaining high availability of your SQL server infrastructure by leveraging the rolling upgrade feature of Database Mirroring. We will pair Mirroring with Log Shipping for a resilient rollback strategy. This is a demo-intensive session that you won't want to miss. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 6722 Andy Warren AD\DBA Track Room Y218 SQL Server has a robust and granular system for granting and denying access to users, but all too often we see applications running as DBO or even sysadmin. Why? Part of is that same granular system can be overwhelming and part is that many developers don't see the point in applying such granular security. In this introductory level presentation we'll start at the beginning with creating and managing logins, take a quick look at system roles, and then get into the nitty gritty of users and roles and permissions at the database level. Along the way we'll talk about why its so important to set security at the database and not just rely on the application enforced security. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 6723 Andy Warren PD Track Room Y117 Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do. 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 6767 Jason Wong PD Track Room Y117 Today, more often than not, an organization runs on both SQL Server and Oracle databases. Both SQL Server and Oracle often implement comparible features, backup recovery, high availability, security etc. It makes sense for DBAs to be familiar with the best practice concepts, armed with knowledge of the both worlds. In this session, I will present SQL Server and Oracle side-by-side for a comparison of similarity and differences on most popular and useful aspects. It is assumed the audience already have some good SQL Server knowledge, but with little or none Oracle exposure. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 6833 Thomas LeBlanc BI Track Room Y114 This session is going to help create a dimensional Data Mart from the AdventureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to reenforce the need for Requirements and Functional specifications. A brief review of ETL for Slowly Changing Dimension and population of the Fact will be deomstrated as well as a simple cube for reporting. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 6946 Anthony {Tex} Moreign PD Track Room Y117 This session is for anyone who is interested in the Cloud specifically Microsofts offerings with a highlight on SQL Azure ... and can expect to leave the session with answers to: 1. What is the Cloud and what are my options in the Cloud – from prominent Cloud Providers? 3. How can the Cloud help me – focus on Microsoft’s Cloud Offerings {Azure, Office 365, Office Live, etc.} 4. Focus on Microsoft SQL Azure (with demos) 5. How do I get started in the Cloud – with bare minimums – today? 5. Most importantly – where to go “AFTER” today – to get answers to Cloud and other technologies! 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 6998 Michael Hotek Multi Track Auditorium You’ve heard that you need one of these things. You spend all of your time trying to figure out what all of these new-fangled terms mean and now you don’t have time to build one. In this session, we’ll clear away all of the clutter of the technobabble aka acronym soup aka latest and greatest techno-term to sell you stuff and get back to the basics of building something that you can use. You’ll learn why you should build a warehouse, what it does for you, and how you go about building one without needing a year, 40 people, and a 7 digit budget. We’ll go from transactional database to data warehouse that can be used in less than 1 hour. 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 7001 Michael Hotek DBA Track Room Y209 If you thought the data in your database was growing fast, just try to figure out your unstructured data. More and more knowledge is being generated in blog posts, tweets, web pages, and various other documents inside and outside of your organization. Gathering all of this data into a usable repository is a difficult task to start with; making sense of all of the information and being able to find what you are looking for are in a whole other league. Two new features in SQL Server 2012 make this daunting task more manageable. We’ll cover how to leverage the FileTable feature to manage the storage of your unstructured data and then how to apply Full-Text Indexing with the new semantic search capabilities to find what you are looking for. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 7008 Michael Hotek DBA Track Room Y205 Backups, check. Off-site storage, check. Ability to actually restore a database… Believe it or not, the vast majority of organizations still don’t have the ability to recover from a real disaster. Based on over 20 years of dealing with real disasters – natural and man-made, you’ll walk through how to deal with a variety of situations while ensuring you are covered. We’ll go from backups, through disaster evaluation, and end up with how to perform a last resort recovery; the kind required when your backups aren’t valid and your off-site storage was also compromised. 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 7133 Mike Saleme DBA Track Room Y205 In this session we’ll explore and examine a proven architecture designed for consolidating SQL Server workloads using Hyper-V. This architecture saves you time by simplifying deployment of a virtualization platform for running databases in a “n-tier” datacenter or a cloud environment. Perhaps you are interested in building your own, this session will help you understand exactly what’s required to design a complete high-end mission-critical architecture built on Hyper-V. Additionally, I’ll outline field proven database migration and consolidation methods and strategies. Finally, we’ll review the design’s HA and scalability options and capabilities. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 7427 Wendy Pastrick AD Track Room Y101 Issue a 'SELECT {data} FROM {myTable}' statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 7428 Wendy Pastrick DBA Track Room Y212 Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring. We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly. 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 7445 Mark Rosenberg Multi Track Auditorium In this talk 4 time MVP Mark Rosenberg will talk about SQL Server stored procedures and techniques you can use to optimize them. He will cover stored procedures from a developer’s point of view including table variables, common table expressions and temporary tables. Which do you use and when do you use it. There will also be a number of quick tips that anyone can use to improve query performance when they walk out of the session 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 7640 Michael Fal DBA Track Room Y205 Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 7641 Michael Fal DBA Track Room Y212 Ladies and gentlemen, boys and girls, data professionals of ALL ages, we welcome you to learn the basics of query plans and their operators. This presentation will not only cure you of mental aches caused by the mysteries of estimated and actual row counts, but will also part the misty veil of physical join operators and aggregates. When you leave this room, you will have the fundamental understanding of the language of query plans so that you can begin the wondrous process of query tuning. 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 7683 Christina Leo DBA Track Room Y212 Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 7720 Kevin Boles Multi Track Auditorium The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure! 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 7721 Kevin Boles Multi Track Auditorium For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure! 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 7798 Tim Mitchell BI Track Room Y109 The release of SQL Server 2012 will bring a number of new and exciting changes to SQL Server Integration Services, making it the most significant release of SSIS since that product replaced DTS in 2005. In this session, we'll explore the top 10(ish) new features of SSIS in SQL Server 2012, including: -- The new project deployment model -- Scripting enhancements -- Logging ... among others. We'll also walk through demonstrations of each of these new behaviors. 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 7799 Tim Mitchell BI Track Room Y114 SQL Server Integration Services provides the ability to nest packages within one another in a parent/child structure. By creating a multilayer package infrastructure using native elements of SSIS, you can easily encapsulate reusable components of your ETL layer, simplify logging, and make the development process more efficient. In this session, we'll take a tour through the parent/child facilities within SSIS, including the following: -- Benefits of using parent/child structures -- Sharing values between parent and child packages -- Parent/child logging -- Dynamic child packages -- Changes in the Execute Package Task from SQL 2008 to SQL 2012 We'll also walk through some practical examples of parent/child package implementatio 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 7807 Jennifer McCown Multi Track Auditorium You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and 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. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool. This session is chock full of code examples, including before-and-after demos and how-tos. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 7808 Jennifer McCown AD Track Room Y101 Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that 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 emerge victorious! 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 8046 AJ Mendo DBA Track Room Y201 Are all your servers standardized across your environment? Do you manually click the next button when installing SQL Server? Do you manually create and configuring your routine maintenance? Are your SQL Agent Jobs owned by other DBAs in your group? Do you know when jobs fail? Or discover them accidentally? Do you have a standardized way to deploy updates? We will discuss all these things and some others during this session and hopefully when we come out the other side some of this will make your life easier. 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 8075 Rick Morelan AD Track Room Y106 Did you know that BEGIN TRAN…COMMIT TRAN is not enough to make everything work together? People are often shocked when they see the demo where there are errors in a transaction and it still commits. When SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action or control it. This is possible with or without structured error handling. See both ways to control the outcome to the way you want it. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 8287 Tim Costello BI Track Room Y109 Anyone can make a bar chart. The tricky part is recognizing the right time to use a bar, line or shape in your viz. What makes a data visualization 'work' ? How do colors, size and proximity affect visual analysis? In this session we'll break down the 'need to know' parts of data visualization and arm you with the know how to go out there and build stunning, interactive dashboards that tell the story of your data. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 8310 Robert Davis DBA Track Room Y201 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/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 8311 Robert Davis DBA Track Room Y212 If you work with very large databases (VLDBs) that must be replicated, you should be using initialization from backup. There are a some misconceptions the have caused DBAs to assume that they could not use initialization from backup. In this session I will explore those misconceptions and prove that they are incorrect. Demos will include initializing a subscriber from a transaction log backup and performing a partial restore of a database and initializing the subscriber from the partial backup. 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 8326 John Sterrett DBA Track Room Y201 This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server 2008. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 8336 Eric Humphrey AD\DBA Track Room Y218 PowerShell’s cmdlets can be pretty powerful on their own, but that’s only part of the power of PowerShell. The .NET Framework is the basis of the PowerShell environment. As such, you have a vast library of operations at your disposal. Learn to use its abilities and save the day without needing a monkey with a bucket. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 8339 Tim Radney DBA Track Room Y201 You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to. 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 8340 Tim Radney DBA Track Room Y201 TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 8372 Kendal Van Dyke PD Track Room Y117 As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine. 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 8374 Jack Corbett AD Track Room Y106 This session will give a brief overview of the different types of triggers available in SQL Server (DDL and 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 should 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 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 8491 Benjamin Nevarez DBA Track Room Y205 This session, updated for SQL Server 2012, will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach. 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 8496 Benjamin Nevarez Multi Track Auditorium The SQL Server Query Optimizer is a cost-based optimizer: it analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost. In this session I will go into the internals of the Query Optimizer and will show you the steps that it performs in the background covering everything from the time a query is submitted to SQL Server until an execution plan is generated. Why query optimization is an inherently complex problem and why challenges in some of its most fundamental areas are still being addressed today will be covered as well. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 8525 David Stein BI Track Room Y114 Building your first Data Warehouse is a long, and often difficult process. How can you get your boss to approve a Data Warehouse project? What’s the best way to explain dimensional modeling and the benefits of a Data Warehouse to a business person? What are the best/most cost effective ways of learning it? What kind of materials, hardware, software, etc do you need? What’s the best way to build a proof of concept that will impress your boss, as rapidly as possible? Come to this presentation, and I’ll answer all of these questions plus the most important question of all. “Is this good for the company?” Absolutely. 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 8531 Russel Loski AD Track Room Y106 XML is all over the place. But how do you get that data into SQL Server? SSIS provides an XML Source, but it is not easy to use. In this session we will handle increasingly complex XML documents. After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets. This includes hierarchically structured XML documents. Attendees will be able to import simple XML using SSIS. They will be able to create import routines that pull data from different elements of more complex XML. They will understand the role the XML Schema plays in defining the XML data they import. 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 8539 Sean McCown AD\DBA Track Room Y218 One of the most important functions a DBA can perform is the backup. And far too many DBAs rely on the wizard to perform this task. Here I'll take you through everything you need to know about understanding command line backups, writing backup routines, and making the right decisions on how to do what kind of restore and when. I will take you through basic backup syntax and fully explain how things work the way they do and why. If you ever wanted to understand the ins and outs of SQL Server backups then this session will give you what you're after. 4/21/2012 11:00:00 AM 4/21/2012 12:00:00 PM 8542 Sean McCown AD\DBA Track Room Y218 The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started. 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 8544 Sean and Jen McCown PD Track Room Y117 The MidnightDBAs will guide you through the most important part of the interview: the tech screening. We’ve both interviewed so many DBAs who fail to meet even the lowest expectations during this portion of the interview. You’ll learn how to answer both tech questions and HR questions in a way that’ll actually get you hired. We’ll also teach you how to avoid common traps that mean certain death. This will be a very fun and interactive session and you’ll wish you’d been doing these things all along. Come to this session. 4/21/2012 9:45:00 AM 4/21/2012 10:45:00 AM 8550 Michael D. Newby BI Track Room Y109 This presentation will provide an overview of using Excel as a frontend for reporting with SQL Server and SQL Server Analysis Services. Topics covered will include best practices for using VBA to execute queries using ADO and ADOMD and a short discussion of queries that facilitate creating dashboards: CASE, PIVOT, and COALESCE. Other topics include, SQL.REQUEST, generating PivotTables and DataTables, OLAP PivotTable Extensions, MS Query, and using VBA to segregate data in the recordset generated using SQL. And last but not least all DBA’s favorite SQL, dynamic SQL…..passing variables from Excel to generate user defined data. Also covered will be some Excel tricks for overcoming error messages sometimes created by bad SQL, no data return 4/21/2012 2:45:00 PM 4/21/2012 3:45:00 PM 8551 Kendal Van Dyke AD Track Room Y101 XML is a technology that Developers and DBAs alike share a love-hate relationship with; it's powerful and flexible yet it can be bloated and difficult to work with at the same time. Regardless, XML has found a home in many applications - including SQL Server (e.g. execution plans) - so it's important to understand how to work with it in your databases. This session will show you how to use the XML data type, perform basic operations on XML data, and how to use FOR XML to create XML from relational data. This isn't a session to convince you to use XML, but to show you what you can do with XML when you do need to use it! 4/21/2012 8:30:00 AM 4/21/2012 9:30:00 AM 8553 Kris Hokanson AD Track Room Y106 Lots of people know that Full Text Search is a powerful tool for searching unstructured data but did you know that you can utilize its power for structured data as well? Functions like FREETEXTTABLE and CONTAINSTABLE open up some pretty groovy doors in terms of usability. We’ll discuss ways to give your users that search engine like interface that everyone has grown accustomed to without sacrificing query performance. We’ll also hit on creating synonyms to give your users results even when they aren’t quite sure what to search for. It’s an entirely different type of search altogether. 4/21/2012 4:00:00 PM 4/21/2012 5:00:00 PM 8554 Nancy Hidy Wilson PD Track Room Y117 Since 1985, the peak of female graduates in IT, there has been a steady decline in women participating in technology jobs. This session will be an open forum for discussion of the challenges which women face in the IT workplace and how we can encourage a new generation of women to enter this exciting field. Expected panel participants are Jen McCown, Wendy Pastrick, Christina Leo, Kalen Delaney, Janis Griffin, and Nancy Hidy Wilson. 4/21/2012 1:30:00 PM 4/21/2012 2:30:00 PM 8668 Nancy Hidy Wilson Multi Track Auditorium Registration 4/21/2012 7:30:00 AM 4/21/2012 8:15:00 AM 8669 Nancy Hidy Wilson Multi Track Auditorium Kickoff SQLSaturday #107 4/21/2012 8:15:00 AM 4/21/2012 8:30:00 AM 8670 Nancy Hidy Wilson Multi Track Auditorium SQLSaturday #107 Wrap-up and Raffles 4/21/2012 5:00:00 PM 4/21/2012 5:30:00 PM 8672 Nancy Hidy Wilson Multi Track Auditorium Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson PD Track Room Y117 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson AD\DBA Track Room Y218 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson AD Track Room Y106 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson AD Track Room Y101 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson BI Track Room Y109 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson BI Track Room Y114 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson DBA Track Room Y205 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson DBA Track Room Y201 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson DBA Track Room Y212 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM 8672 Nancy Hidy Wilson DBA Track Room Y209 Hinze's BBQ 4/21/2012 12:00:00 PM 4/21/2012 1:30:00 PM