SQLSaturday #40 - South Florida 2010 7/31/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat40 South Florida FL 33027 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 600 Fusion-io Platinum Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 621 Red Gate Software Platinum Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 622 expressor software Platinum Sponsor http://www.expressor-software.com http://www.expressor-software.com/collateral/images/english-us/logos/exp_logo_color.jpg 60 170 623 SwiftKnowledge Platinum Sponsor http://www.swiftknowledge.com will send via email 60 170 662 Confio Platinum Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 499 Quest Software Gold Sponsor http://www.quest.com n/a I'll have to send you a file 60 170 609 SQL Server Magazine Gold Sponsor http://www.sqlmag.com http://img.en25.com/eloquaimages/clients/PentonMediaInc/{4c554f51-5143-4a1c-b3a8-8c9c22203c7c}_ALL_SQL_LOGO_SQLServerMag_175x41.jpg 60 170 618 TekPartners Gold Sponsor http://www.tekpartners.com 60 170 627 QQ Solutions, Inc. Gold Sponsor http://www.qqsolutions.com http://www.qqsolutions.com/assets/images/qqsolutions.jpg 60 170 1218 Aaron Nelson DBA4 Room 6 In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1219 Troy Gallant DBA3 Room 5 SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 1238 Mike Davis BI1 Room 1 In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures, and custom code. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1239 Mike Davis BI1 Room 1 In this session, you’ll learn how to control your SSIS packages in a more powerful way by using expressions. The expression language is a bit of an elusive language that can be used to make any component in SSIS dynamic. Then, you’ll learn how to use configuration files to externalize the configuration of your package and lastly how to pass variables into a package. Also learn how to use parent child packages and environment variables. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1241 Mike Davis BI1 Room 1 In this session Mike will show you how to build a data flow using many different sources, transforms and destination. Learn how to use the some of the most commonly used transforms in SSIS. You will also learn how to troubleshoot a data flow using Data Viewers. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1269 Adam Jorgensen BI1 Room 1 Lets take your BI implementation to the next level with SharePoint 2010 BI and PowerPivot. We'll go through excel services, performancepoint services, and pulling it all together in SharePoint 2010. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1467 @ccatto Catto Dev Room 8 In T-SQL 0 - 60 we'll discuss Transact SQL for SQL Server. We'll discuss four major sections: 1 IDE (SSMS) Queries http://tinyurl.com/cattotsql1 2 Query View vs. Design View http://tinyurl.com/cattotsql2 3 Stored Procedures http://tinyurl.com/cattotsql3 4 Sky is the Limit (advanced topics). http://tinyurl.com/cattotsql4 At the end of the seesion we'll understand how to query data in SSMS using T-SQL 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1630 Rodney Landrum DBA1 Room 3 This session will present a top 10 (maybe 20) list of queries and tools that DBAs can use daily. The idea is that everything is included on a single 1G or less thumb drive to be portable. From simple T-SQL statements to full blown SSIS packages, the session demonstrates how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation, performance and much more. All queries, which are SQL 2000, 2005 and yes even 2008 tried and true will be made available in the session to copy to your own thumb drive. If you are lucky you might even receive a free coveted thumb to store the queries. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1631 Rodney Landrum BI2 Room 2 At it's heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1726 Kevin Boles BI2 Room 2 Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1727 Kevin Boles BI2 Room 2 The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1728 Kevin Boles BI2 Room 2 What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1813 Brent Ozar DBA2 Room 4 Brent will cover the basics of SQL Server’s DR options including log shipping, mirroring, replication and more. He’ll explain the pros and cons of each, and teach you how to pick the right method for your application. You'll also learn some of the things that burned him during several hurricanes and role swaps. No DRP experience required - Brent will show you the ropes. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1814 Brent Ozar DBA2 Room 4 You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, 'Did you know about this SQL Server over here?' Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1836 Timothy Ford DBA1 Room 3 Identify and remdiate index fragmentation. Gather information about unused indexes that may be causing your instances unnecessary overhead and impacting performance. Even find out what indexes you may want to create to make your databases perform better: all with the use of SQL Server Dynamic Management Objects. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1838 Timothy Ford DBA1 Room 3 Join this beginner-level session in which we'll go over common mistakes made by new and seasoned SQL Server Professionals alike. Learn how to avoid these issues before they happen. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1839 Argenis Fernandez DBA1 Room 3 Learn how to manage multiple instances of SQL Server with the different tools that SQL Server 2008 and 2008 R2 offer. We will discuss Central Management Servers, multiserver queries, SQL Server Control Point, Policy-Based Management and SQLPS (the Powershell SQL mini-shell). 3rd party tools will be discussed as time permits. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 1849 David Levy DBA1 Room 3 The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. This presentation will provide a high level overview of how to boost your value to your organization by automating the mundane operational tasks and focusing on supporting new development. Topics covered will include tools and techniques available for automation, integration with development teams and relationship management. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1885 Timothy McAliley DBA3 Room 5 Information Technology Infrastructure Library (ITIL) Version III is a public/non-proprietary framework that describes Best Practices in IT Service Management. Conducting database administration within an ITIL framework can improve change management, reduce operational risks, stabilize your environment and pose challenges. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3), the responsibilities and deliverables of DBAs in an ITIL shop, and review a few examples of scaled deployments of the ITIL V3 process framework. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1887 Maximo Trinidad DBA4 Room 6 Will demo a series of way to take advantage of SQL Server 2008 - SQLPS to work with you different version so SQL Servers. See how powerfull the POSH command prompt can be to monitor and manage your SQL Servers. I will also demo the Invoke-SQLCmd cmdlet. There will be lots of samples. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1888 Maximo Trinidad DBA4 Room 6 Come over and see how to work with SQL Server Agent using PowerShell. Lot's of sample, tips and tricks. Displaying jobs, their properties, and creating PowerShell steps. We are going to see the difference between SQLPS, SMO, and PowerShell V2. Also, I will be show some scripting tools very useful for the DBA's. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1889 Jose Chinchilla DBA3 Room 5 Change Data Capture (CDC) is one of the newest features available for SQL Server 2008 which allows you to easily track and keep history of all DML (Data Manipulation Language) changes on user tables such as INSERT, DELETE, and UPDATE without additional overhead. One of the most important benefits of this feature is that it allows you to see the data before after an UPDATE statement which allows you to recover data overwritten or deleted quickly without the need of a database restore. On this presentation we will go over the steps necessary to configure CDC and do an overview of some real world scenarios where this feature can be applied such as Business Intelligence, Disaster Recovery, Auditing, Debugging, Documentation and more. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1900 Jared Nielsen Misc Room 9 Bringing marketing together with technology is a fine art that involves high tech tools, real life solutions, and most important human buy-in from the marketing and IT departments. This lecture will delve into the use of the latest SQL Server 2005 and SQL Server 2008 technologies including recursive common table expressions (CTE), hierarchical data models, and CLR stored procedures for the IT side of the house while also delving into the use of analytics, webmaster monitoring tools, web marketing tactics and search engine optimization techniques for the more marketing minded. Neither SQL nor SEO are four letter words and they go together perfectly! So too can your IT and marketing departments as you tackle the new age of IT Marketing. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1907 Ronald Dameron DBA4 Room 6 I will demonstrate how I automated ID provisioning using PowerShell, SQLPSX, and our corporate standard job scheduler. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1908 Ronald Dameron DBA4 Room 6 I will detail my reasoning why a DBA would benefit from learning PowerShell. I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 1914 Don Gabor Misc Room 9 Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come. Best-selling author and networking expert, Don Gabor will guide you through the conversation process to make networking will be easier and more productive. Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1927 Hector Hernandez Misc Room 9 You don't need Talent to Succeed, but Everything else Counts This session helps you trigger our natural abilities that go unused for years. Once you discover that these are already part of you (us), you will be able to apply them to advance your career, your relationships and your life. You can manage your career and your life—it’s not about balance. Talent is overrated. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1972 Jack Corbett DBA1 Room 3 Triggers can be a handy tool in the toolbox, but many times they are used improperly because of a lack of understanding of how they work. This session will give an overview of the different types of triggers available in SQL Server and then will focus on specifically on the safe use of DML triggers. We will talk about when to use triggers and touch on other options. I will demonstrate of both safe and unsafe triggers. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 2048 Troy Gallant DBA3 Room 5 Many SQL Server DBA's are tasked with the responsibility of choosing an appropriate disaster recovery, reporting, or failover solution for their organization. Much of the time the choice comes down to replication versus log shipping. And while both solutions can be extremely effective, there are both subtle major differences between them that can guide you to choose one over the other. This presentation gets to the nuts and bolts of the two technologies, and helps you make an educated recommendation and implementation. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 2055 Dmitri Korotkevitch DBA2 Room 4 Locking, blocking, waits.. Why developers should care? Those things are for DBA. But what if you don't have DBA in the team? What if DBA complaints directly to your boss? This session will provide you an overview how SQL Server Lock Manager works; how different isolation levels affect the system; gives you bird-eye view of SQLOS and Sql Server Waits; provide you the guidelines how to minimize the locking, avoid deadlocks and improve concurrency of the system. It also shows you a couple of basic methods how to troubleshot problems related with locking and concurrency. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 2056 Dmitri Korotkevitch DBA2 Room 4 One of the biggest benefits of SQL Server is simplicity. Developer creates a database, write a few T-SQL statements and everything is up and running.. until the system grows up and starts to introduce performance problems. And infinite loop begins: Refactor -> Deploy -> Refactor -> Deploy ->.. In a few years developer has gray hairs and ton of experience. The purpose of this session is sharing this experience helping to avoid some of the typical issues for the systems working under heavy load. The session gives the overview of how SQL Server stores data, what criteria Query Optimizer uses choosing the index, how data is locking - essential knowledge when you expect system to handle thousands transactions per second. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 2057 Dmitri Korotkevitch DBA2 Room 4 Why my queries are so slow? Why SQL does not use that index? What 'Hash Match' means? Do we really need to upgrade the hardware? It's essential to know how query optimizer works if you want to design effective solutions. This session will give you an overview of how query optimizer generates query plans, how to read them, how SQL Server executes queries and show a few optimization tricks. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 2088 Sam Abraham Dev Room 8 SSIS enables us to quickly create deployable packages to move/manipulate data. Things do however get a bit challenging when source and destination tables are not known at package design time or when a requirement exists to have an already-deployed package support schema changes in source tables. One solution to this problem is to leverage our ability to create and execute an SSIS package dynamically in code. In this session we will take a look at a complete project for a C# Runtime SSIS Package Designer, taking as input a set of table names and dynamically generating both destination Access tables then creating, validating, saving and executing an SSIS Package at runtime with logging enabled to demonstrate the various package steps. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2098 David Corrales DBA4 Room 6 Preview SAPIEN Technologies’ new dedicated PowerShell editor: Visual PowerShell 2011 The next generation in PowerShell graphical user interface (GUI) creation. Visual PowerShell 2011 builds upon PrimalForms 2009 and adds a plethora of new features and enhancements. New additions include Script Debugging, Multi-Form Support, Built in Console, Snippets and more. The demonstration will cover: - Creating GUIs for PowerShell - Creating SQL Query GUIs using the Database Browser - Packaging your GUIs and scripts into executables - Cover new features such as Snippets, PowerShell Console, WMI Browser and more - Creating Projects for Multi-Form GUIs - Integrated Help and PrimalSense 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2130 Jorge Segarra DBA3 Room 5 On my blog I've started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know (we won't be covering basic T-SQL in this session, just tasks and concepts). This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources! 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 2131 Jorge Segarra DBA3 Room 5 In our 101 session we did a high level overview of the world of SQL Server and how things work within that environment. In this session we'll dive a little deeper and talk about important tasks expected of a DBA such as backups and restores, general maintenance, understanding various resources and virtualization of SQL Server. Attending the 101 session is not a pre-requisite so feel free to join us and continue our SQL Server education! 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2218 Michael Mollenhour BI2 Room 2 In this session you will learn some of the basics to getting you started with Analysis Services. Key terms and as well as best practices will be discussed for developing an Analysis Services Cube. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 2219 Michael Mollenhour BI2 Room 2 This session will show you some of the more complex feature available in SSIS. These features can help your packages run more smoothly and handle problem areas better. See how to enable features like checkpoints and transactions on your packages. You will also learn how to use the native logging features to track package executions. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2220 Elijah Baker DBA2 Room 4 In this session I will go over what database partitioning is and what the structures are to implement it. I will present all of the basic SQL structures that it takes to implement partitioning as well as some general discussion of how to choose the right partitioning key, use of file groups in partitioning, partitioned index alignment, and multi-partitioning. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 2224 Pam Shaw BI1 Room 1 This session we will present methods to create very dynamic reports. We will demonstrate data driven formatting and layouts. We will review how to setup data sources that are more portable as well as see how templates make it easier to have more consistent report formats. We will review emailing reports and how this can be integrated into your current application. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 2225 Herve Roggero Azure Room 7 Let's talk Azure!!! SQL Azure is the Microsoft SQL Server database in the cloud and it comes packed with cool capabilities. Let's review its performance footprint and how to go about designing high performance applications with SQL Azure. We will discuss Sharding, network latency, asynchronous operations and much more! Some of this content is taken directly out of the upcoming book on Pro SQL Azure, from APress. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 2226 Herve Roggero Azure Room 7 In this session I will discuss what it takes to build a shard against SQL Azure. Shards allow developers to access data across a farm of SQL Server or SQL Azure databases transparently. This session places a strong focus on C# and evaluates .NET 4.0 and shows you how to leverage the Task Parallel Library (TPL) and the new Caching namespace to achieve greater performance access SQL Azure. View http://enzosqlshard.codeplex.com/ for information about this shard. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 2230 Joe Healy Azure Room 7 This session will provide an introduction to the Azure platform and 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 2231 Shervin Shakibi BI1 Room 1 This session will provide a great detailed look at SSRS. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 2232 Scott Klein Azure Room 7 This session will dive into what it takes to develop application for SQL Azure. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2312 Telmo Sampaio Dev Room 8 Learn how to use the spatial data types in SQL Server, load spatial data from the web, and display your geographic information using Bing Maps and Silverlight. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM