SQLSaturday #38 - Jacksonville 2010 5/8/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat38 Jacksonville FL 32224 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 362 Pragmatic Works Gold Sponsor http://www.pragmaticworks.com http://www.pragmaticworks.com/images/l4.gif 60 170 538 TEKsystems Gold Sponsor http://www.teksystems.com http://www.dtsxchange.com/sqlsaturday/TEK_Vert_Blk_sm1.jpg 60 170 401 Red Gate Software Silver Sponsor http://www.red-gate.com http://www.red-gate.com/images/logo_v4.1.gif 60 170 409 Confio Software Silver Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 427 Incepture Silver Sponsor http://www.incepture.com/ http://www.incepture.com/media/images/logo-285.png 60 170 510 Apress Silver Sponsor http://www.apress.com/ http://www.apress.com/img/masthead_logo.gif 60 170 527 Kforce Silver Sponsor http://www.kforce.com http://www.dtsxchange.com/sqlsaturday/Kforce_Logo.JPG 60 170 559 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 561 Attunity Silver Sponsor http://www.attunity.com http://www.attunity.com/images/logo_attunity.gif 60 170 365 Addison-Wesley/Sams Publishing Bronze Sponsor http://www.informit.com http://www.informit.com/display/InformIT/images/header/informit.png 60 170 425 Align Networks Bronze Sponsor http://www.alignnetworks.com/ 60 170 503 Quest Software Bronze Sponsor http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 1120 Devin Knight Business Intelligence -1102 1102 (Auditorium) In this session you will learn how to plan for a Data Warehousing project. Why you need one, what the key steps are to developing one and designing a plan to have a successful project will all be discussed. You will learn conceptually how you can leverage the Microsoft BI Stack to design and implement a Data Warehouse. This session will focus more on the concepts of development rather than demonstrating the development itself. 5/8/2010 12:00:00 PM 5/8/2010 1:00:00 PM 1122 Troy Gallant 1404 1404 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. 5/8/2010 12:00:00 PM 5/8/2010 1:00:00 PM 1130 Aaron Nelson 1406 1406 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 task we will explore the benefits of 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 using PowerShell. 5/8/2010 3:45:00 PM 5/8/2010 4:45:00 PM 1131 Aaron Nelson 1202 (Auditorium) 1202 (Auditorium) With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop 5/8/2010 1:15:00 PM 5/8/2010 2:15:00 PM 1137 Mike Davis Business Intelligence -1102 1102 (Auditorium) In this session Mike builds a cube from a basic data warehouse. He shows also covers the basics of what a data warehouse is and explains dimensional modeling. He shows how to create the cube, including dimensions, hierarchies, and calculations. 5/8/2010 1:15:00 PM 5/8/2010 2:15:00 PM 1143 Brian McDonald Business Intelligence -1102 1102 (Auditorium) SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this introductory session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. 5/8/2010 9:00:00 AM 5/8/2010 10:00:00 AM 1167 Plamen Ratchev 1202 (Auditorium) 1202 (Auditorium) Become a better SQL coder by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them. 5/8/2010 9:00:00 AM 5/8/2010 10:00:00 AM 1168 Plamen Ratchev 1202 (Auditorium) 1202 (Auditorium) Many people live by the motto “If it’s not broken, don’t fix it”. But if you believe that you are missing all enhancements introduced in newer versions of SQL Server (2005/2008). These new features can help you develop better solutions with improved performance, scalability, and maintainability. Learn how to craft a better query using the new MERGE statement, ranking functions, and more. Practical examples with tips and tricks. 5/8/2010 2:30:00 PM 5/8/2010 3:30:00 PM 1177 Vikas Hawaldar 1402 1402 Session will present the development lifecycle of a Datamining engine using SQL Server 2008. 5/8/2010 2:30:00 PM 5/8/2010 3:30:00 PM 1186 Robby Robertson 1402 1402 Now that you've built it, how do you get it out there for consumption? This session will focus on highly configurable and data-driven solutions for SSIS package deployment. We will discuss a variety of topics as they relate to package implementation and delivery, including: The pros and cons of file system vs. SQL Server deployment, package configuration methods, package security, using meta-data to drive package flexibility, deployment and execution automation techniques. 5/8/2010 1:15:00 PM 5/8/2010 2:15:00 PM 1203 Michael Antonovich 1406 1406 This session defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML. 5/8/2010 9:00:00 AM 5/8/2010 10:00:00 AM 1204 Michael Antonovich 1406 1406 This sessions is designed for user with experience developing Access applications. It will focus on Access 2010 with SharePoint 2010 to explore the different degrees of publishing Access and how it solve issues many IT departments have with Access including: Access databases are never backed up. Every copy of the XYZ Access database has different data in it. Publishing form and report updates to dozens or hundreds of users is a nightmare. We will then dive deep into how IT departments can publish an Access application to Access Services on SharePoint with Web forms, reports, queries, and macros that eliminate the need for Access on the client machine entirely. 5/8/2010 10:15:00 AM 5/8/2010 11:15:00 AM 1213 Jorge Segarra 1404 1404 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. This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources! 5/8/2010 9:00:00 AM 5/8/2010 10:00:00 AM 1214 Jorge Segarra 1400 1400 We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers! 5/8/2010 10:15:00 AM 5/8/2010 11:15:00 AM 1220 Bradley Schacht Business Intelligence -1102 1102 (Auditorium) This session will get you past the learning curve of SSIS. Brad covers creating an end to end package that covers many of the concepts in SSIS. He covers, looping over a set of files, processing each file and then archiving. This session will be great for anyone who is a beginner to SSIS. 5/8/2010 10:15:00 AM 5/8/2010 11:15:00 AM 1229 Timothy McAliley 1400 1400 Conducting database administration within an ITIL framework can improve change management, reduce operational risks and stabilize your environment. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3) and review a few examples of scaled deployments of the ITIL V3 process framework. 5/8/2010 12:00:00 PM 5/8/2010 1:00:00 PM 1267 Adam Jorgensen Business Intelligence -1102 1102 (Auditorium) 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. 5/8/2010 2:30:00 PM 5/8/2010 3:30:00 PM 1348 Rodney Landrum 1202 (Auditorium) 1202 (Auditorium) From everyday movement of code and data, standards must be set and met depending on the size of your company and your available resources. Rodney will discuss SQL deployments best practices using industry standard tools. From SSIS, stored procedures, SQL objects such as tables and indexes, to the data itself, deploying SQL code from one environment to another is not always as straight forward as you may think. 5/8/2010 12:00:00 PM 5/8/2010 1:00:00 PM 1354 Dean Richards 1202 (Auditorium) 1202 (Auditorium) Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response Time based performance analysis to solve the most difficult performance related issues. Designed for the SQL Server DBA, Developer or anyone concerned with performance. 5/8/2010 10:15:00 AM 5/8/2010 11:15:00 AM 1355 Dean Richards 1402 1402 Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects. 5/8/2010 9:00:00 AM 5/8/2010 10:00:00 AM 1386 Jonathon Moorman 1406 1406 An introduction to the basic elements of the Sql Server Profiler. An overview, from a sql developer perspective, of useful events, useful column data, how to apply filters, how to execute, how to search results and a look at canned and custom templates. 5/8/2010 12:00:00 PM 5/8/2010 1:00:00 PM 1387 Jonathon Moorman 1402 1402 From IDENTITY seed and increment, to specifying specific values, we'll look at IDENTITY columns at all angles to find their strengths and limitations. 5/8/2010 3:45:00 PM 5/8/2010 4:45:00 PM 1421 Brandie Tarvin 1404 1404 For the beginner and intermediate T-SQL coder, this is a class on how to use aliases and joins to your advantage. This session introduces the topics and throws in a few tips tricks that can help you find exactly the data you need. 5/8/2010 10:15:00 AM 5/8/2010 11:15:00 AM 1429 Mustika Nengah 1404 1404 Accessing multidimensional data such as SSAS’s cubes and KPI from .NET client applications using ADOMD.NET . ActiveX Data Objects Multi-dimensional (ADOMD) provides easy access to multi-dimensional data from client applications (Web, Console, or Windows application). This session shows you how to use ADOMD.NET to retrieve data and metadata from an SSAS instance. 5/8/2010 2:30:00 PM 5/8/2010 3:30:00 PM 1524 Sumeet Bansal 1406 1406 Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how MS SQL Servers perform. This session will address: 1) On overview of solid state technology options for SQL Server 2) Why solid state makes a difference? 3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: a. Disk-based SSDs b. Onboard/Embedded PCI Express devices c. Host-based PCI Express devices 4) Customer proof: Wine.com case study 5/8/2010 1:15:00 PM 5/8/2010 2:15:00 PM 1540 Jared Nielsen 1402 1402 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. 5/8/2010 10:15:00 AM 5/8/2010 11:15:00 AM 1558 Andy Warren 1400 1400 This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know. 5/8/2010 9:00:00 AM 5/8/2010 10:00:00 AM 1563 Steve Schneider 1400 1400 Learn how to implement SQL 2005 Encryption using 2-way and 1-way encryption and why you would use either. Learn what a DBA needs to know and what the developer needs to know. Learn how to maintain encryption...backup and restore issues as well as cross-server issues. This will include a live demonstrations of the concepts presented. 5/8/2010 1:15:00 PM 5/8/2010 2:15:00 PM 1598 Eric Wisdahl 1402 1402 This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found. 5/8/2010 12:00:00 PM 5/8/2010 1:00:00 PM 1600 Eric Wisdahl 1406 1406 In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. 5/8/2010 2:30:00 PM 5/8/2010 3:30:00 PM 1657 Elijah Baker 1202 (Auditorium) 1202 (Auditorium) This session will go over what database table partitioning is and what the structures are to implement it. There will also be some general information on partitioning strategies. If you ever looked into table partitioning and just wanted a little more information this session is for you. 5/8/2010 3:45:00 PM 5/8/2010 4:45:00 PM 1689 Michael Flora Business Intelligence -1102 1102 (Auditorium) During the brief 15 minutes I will show you how to loop through a list of servers to gather information. With this knowledge you can build your own SQL server monitoring tool. 5/8/2010 11:15:00 AM 5/8/2010 12:15:00 PM 1691 Shawn McGehee 1404 1404 Working with limited resources in the hardware and software fields can be troubling for a DBA. Making things work smoothly when sharing servers among many applications can be a difficult and time consuming task. With SQL Server 2008 a new feature has been given to the DBA world that can make the process much easier. We will take a look at the resource governor from the ground up in this session and build a solution to alleviate some of the issues that come with sharing hardware. 5/8/2010 3:45:00 PM 5/8/2010 4:45:00 PM 1701 Shawn Harrison 1404 1404 In this session, Shawn will cover the basics of using parameters in reports and work up to a more intermediate level such as using parameters in stored procedures and cascading parameters. 5/8/2010 1:15:00 PM 5/8/2010 2:15:00 PM 1757 Brian Knight Business Intelligence -1102 1102 (Auditorium) In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You'll see a battle between two SSIS experts (Brian Knight and Adam Jorgensen), attempting to load the data warehouse the best way. You'll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition. 5/8/2010 3:45:00 PM 5/8/2010 4:45:00 PM 1781 Jeff Cole 1400 1400 This session will focus on Microsoft and partner technologies that enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), and that work with data from Oracle, Teradata, and other heterogeneous sources. You will learn how Microsoft high-speed Connectors by Attunity can be leveraged with change-data-capture (CDC) technologies integrated with SSIS to enable data replication. Use cases highlighting real-time data warehousing and operational reporting, as well as maintenance of data consistency between operational databases and applications will also be outlined. 5/8/2010 2:30:00 PM 5/8/2010 3:30:00 PM 1783 Eric Humphrey 1400 1400 Object Relational Mappers (ORMs) are often praised by developers and despised by DBAs. I'll show that like most tools, ORMs have their place if used responsibly. Also, how they can get out of hand if not monitored. 5/8/2010 3:45:00 PM 5/8/2010 4:45:00 PM