SQLSaturday #15 - Jacksonville 2009 5/2/2009 12:00:00 AM A free one day training event for SQL Server professionals and those interested in learning to use SQL Server #sqlsat15 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 162 Confio Software Gold Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 138 End to End Training Gold Sponsor http://www.endtoendtraining.com http://www.endtoendtraining.com/Images/endtoendlogo.jpg 60 170 139 JumpstartTV.com Gold Sponsor http://www.jumpstarttv.com http://www.jumpstarttv.com/images/header_logo.jpg 60 170 168 Lemington Consulting Bronze Sponsor http://LemingtonIT.com http://lemingtonit.com/images/lem_cons_lk4_trans.gif 60 170 359 Plamen Ratchev Room 1016 (Auditorium) Room 1016 This session will focus on analytical ranking functions in SQL Server 2005/2008 and their use, implementing paging, string concatenation with XML PATH, pivoting, unpivoting, and separating elements in a string/column. 5/2/2009 1:15:00 PM 5/2/2009 2:15:00 PM 360 Plamen Ratchev Room 1016 (Auditorium) Room 1016 This session will present new T-SQL enhancements in SQL Server 2008 including MERGE, table valued parameters, new data types (Date and Time related, FILESTREAM, HIERARCHYID), table value constructors, sparse columns, filtered indexes, delighters, and more. 5/2/2009 3:45:00 PM 5/2/2009 4:45:00 PM 361 Plamen Ratchev Room 1016 (Auditorium) Room 1016 This session will focus on common performance problems, considerations, and solutions. Review of methods for isolating long running queries and techniques for writing better SQL. Learn how to use dynamic management views and functions in SQL Server 2005/2008 for query tuning. Finish with explanation of parameter sniffing and different solutions. 5/2/2009 10:15:00 AM 5/2/2009 11:15:00 AM 381 Eric Wisdahl Room 1016 (Auditorium) Room 1016 This session will step the attendees through the basics of SSIS by setting up a sample solution to import data from a variety of sources. We will look at some of the more common control flow tasks as well as the various components of the data flow task. The sample solution created will be based, at least in part, on questions from the audience. 5/2/2009 9:00:00 AM 5/2/2009 10:00:00 AM 382 Eric Wisdahl Room 1002 Room 1002 Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc. This session will present an example framework which can be used as the basis for future SSIS Package development. 5/2/2009 12:00:00 PM 5/2/2009 1:00:00 PM 404 Kent Waldrop Room 1026 Room 1026 During this session Kent Waldrop will discuss some of his personal experiences with the ups and downs of an IT career. Some of the subjects covered will be watching out for never, never land; flying high; crashing; “coming back”; dealing with personal problem and trying to guard your self. 5/2/2009 1:15:00 PM 5/2/2009 2:15:00 PM 412 Scott Gleason Room 1001 Room 1001 This session will cover the basics of writing optimized query’s with focus on the ‘where clause’ and ‘having clause’ of a select statement. If you have never attended a query performance session before, you’ll learn a lot! 5/2/2009 12:00:00 PM 5/2/2009 1:00:00 PM 426 Vikas Hawaldar Room 1002 Room 1002 The presenter will describe basic building blocks of Data Mining process. These building blocks will be mapped on to the features available in SQL 2005 and then shortcoming on SQL 2005 will be discussion. After that the new features in SQL 2008 Data Mining will be demoed to present how the Shortcoming in 2005 were improved in 2008 and what new power in added in 2008 data mining. 5/2/2009 2:30:00 PM 5/2/2009 3:30:00 PM 427 Vikas Hawaldar Room 1002 Room 1002 Speaker will present basic concepts behind MDX. Then a demonstration will be given on basic to intermediate MDX queries. At the end some examples will be presented about developing calculated measures in SSAS using MDX. 5/2/2009 1:15:00 PM 5/2/2009 2:15:00 PM 428 Brandie Tarvin Room 1003 Room 1003 A non-technical discussion on the methods a business should use to prepare for the inevitable disaster. This discussion includes things you can do to prevent disasters as well as what things to have into place for when the disaster occurs. It goes beyond the usual 'back up SQL Server' thoughts. 5/2/2009 12:00:00 PM 5/2/2009 1:00:00 PM 431 Brandie Tarvin Room 1001 Room 1001 A beginner's level session on how to write the basic SELECT statement and the functions that can make your life either easier or harder. 5/2/2009 10:15:00 AM 5/2/2009 11:15:00 AM 432 Stephen Schneider Room 1009 (Auditorium) Room 1009 I will present the custom stored procedure I use first whenever an event happens on my 2005 servers. Then, I will discuss the interpretation of the output and the underlying code that extracts that information. 5/2/2009 12:00:00 PM 5/2/2009 1:00:00 PM 440 Chris Eargle Room 1002 Room 1002 REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE. This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly. 5/2/2009 3:45:00 PM 5/2/2009 4:45:00 PM 443 Michael Stark Room 1026 Room 1026 Demonstration of using the new Geography datatype in SQLServer 2008. The implementation will showcase in Virtual Earth and .net 3.5 Listview. 5/2/2009 10:15:00 AM 5/2/2009 11:15:00 AM 445 Andy Warren Room 1001 Room 1001 PASS is the Professional Assocation of SQL Server, and it's the official not for profit group for SQL Server professionals. We'll talk about the annual PASS Summit (conference), chapters/user groups, regional events like SQLSaturday, and where PASS is going in the future. This will be an informal presentation with lots of time for questions and discussion. 5/2/2009 11:15:00 AM 5/2/2009 12:00:00 PM 446 Andy Warren Room 1001 Room 1001 Why does SQL Server need statistics? How and when are they created and maintained? How do you know when they are incorrect or out of date? How much difference do they make in query plans? We'll answer all of those questions and more! You'll leave the session with a firm understanding of the working of statistics and what you need to know to keep them in great condition. 5/2/2009 2:30:00 PM 5/2/2009 3:30:00 PM 448 Pam Shaw Room 1026 Room 1026 This session will explore subscriptions which are the scheduled delivery process defined within Reporting Services. We will explore what is required to create subscriptions, what options are available and how we can manipulate these for use on demand. We will review some practical applications that would require use of on demand subscriptions. 5/2/2009 12:00:00 PM 5/2/2009 1:00:00 PM 449 David Fekke Room 1002 Room 1002 This presentation gives developers and SQL Server professionals an overview of the Language Inline Query (LINQ) syntax in .NET 3.5 that can be used to query SQL Server databases. 5/2/2009 9:00:00 AM 5/2/2009 10:00:00 AM 450 Pam Shaw Room 1016 (Auditorium) Room 1016 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. 5/2/2009 2:30:00 PM 5/2/2009 3:30:00 PM 457 Kent Waldrop Room 1009 (Auditorium) Room 1009 MVP Kent Waldrop takes a quick tour of a few of the SQL issues that come up frequently in the MSDN Transact SQL forum. Some of the topics covered include set oriented processing, pitfalls of user defined functions, working with string lists, filtering by date and time and more. 5/2/2009 3:45:00 PM 5/2/2009 4:45:00 PM 459 Rodney Landrum Room 1003 Room 1003 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. 5/2/2009 10:15:00 AM 5/2/2009 11:15:00 AM 462 Michael Antonovich Room 1009 (Auditorium) Room 1009 The SQL Server 2008 MERGE command combines the features of the Insert and Update commands into a single powerful statement. You can now insert new data into one table while also update or delete data from an existing table with a single statement. In this session, we will take a look at this new addition to your TSQL toolbox in SQL Server 2008 to show how to merge two tables without creating duplicate records, how to synchronize two tables, how to use the OUTPUT clause with MERGE to save deleted records from the merge into an archival table, how indexing effects performance of MERGE statements and more. 5/2/2009 2:30:00 PM 5/2/2009 3:30:00 PM 463 Michael Antonovich Room 1001 Room 1001 Perhaps you inherited a database with one or more tables having duplicate potential keys or maybe even entire duplicate records or maybe you generated a recordset from a SELECT statement that has duplicate records. In any case, you have a problem. You need to identify which tables have duplicate records or duplicate index values, isolate those records, and then delete only the duplicate records from the table. This session will focus on the functions and methods that you can use to identify and remove duplicate data from your tables 5/2/2009 3:45:00 PM 5/2/2009 4:45:00 PM 464 Michael Flora Room 1003 Room 1003 As a DBA in a new environment you need to learn as much as you can about the SQL Servers in your enterprise. I came across an SSIS package, created by Rodney Landrum, which gave me the core of what I was looking for. This session will focus on the benefits of the SSIS package as well as provide a walkthrough of the SSIS package, which I have made several changes to support our infrastructure. The server information included is OS edition, OS service pack level, CPU, RAM, Free drive space, SQL server version, SQL service pack, etc. Session will also demonstrate how to deploy this package to an SSIS server and schedule it via SQL agent. 5/2/2009 1:15:00 PM 5/2/2009 2:15:00 PM 465 Wes Dumey Room 1002 Room 1002 We will use SQL Server 2008 and the SSIS tool suite to demonstrate building a data warehouse. This session will cover the basics of a data warehouse before leading into the code demonstration. 5/2/2009 10:15:00 AM 5/2/2009 11:15:00 AM 466 Jonathon Moorman Room 1001 Room 1001 An overview of the system objects that can be utilized to create new database objects. We will investigate the catalog views and object functions with an eye towards creating utility scripts and templates to make the day-to-day work of a database developer easier. 5/2/2009 1:15:00 PM 5/2/2009 2:15:00 PM 467 Kendal Van Dyke Room 1001 Room 1001 Would you buy a million dollar race car then show up to the track on a clear day with rain tires that aren’t properly inflated and wonder why you’re only doing 180 when the manufacturer says it can do 220? Your answer was probably close to something like 'Of course not!'. Now let’s suppose that your million dollar race car is really your DB server and your tires are your hard drives. Do you know the right configuration to use to get the best performance out of them? Sure, there's RAID 1, RAID 10, and RAID 5 but do you know which combination of partition offset, RAID stripe size, and allocation unit size to use? This session will answer those questions by looking at the results of extensive testing performed against local disks and DASD encl 5/2/2009 9:00:00 AM 5/2/2009 10:00:00 AM 468 Kendal Van Dyke Room 1009 (Auditorium) Room 1009 XML in SQL 2000 wasn't very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the new XML data type, do basic XML operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn't a session to convince you to use XML, but to show you what you can do with XML if you do need to use it! 5/2/2009 1:15:00 PM 5/2/2009 2:15:00 PM 469 Kendal Van Dyke Room 1026 Room 1026 At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies. 5/2/2009 3:45:00 PM 5/2/2009 4:45:00 PM 471 Kendal Van Dyke Room 1026 Room 1026 By now we all know that we should use Windows Authentication to connect to SQL Server from our IIS applications...but most of us don't know how. This session aims to clear up the confusion by demonstrating the ways that ASP ASP.NET applications can be configured to make secure connections from different versions of IIS so that we can keep our connections secure and our DBAs happy. 5/2/2009 2:30:00 PM 5/2/2009 3:30:00 PM 472 Mike Davis Room 1003 Room 1003 See the methods available to convert DTS to SSIS. Get an understanding how to convert Active X scripts in your DTS packages to SSIS packages. Watch a demonstration of the software available to discover your packages, convert them, and apply best practices. Learn how to scope out your DTS conversion project. 5/2/2009 2:30:00 PM 5/2/2009 3:30:00 PM 473 Mike Davis Room 1003 Room 1003 Learn how to use SSIS features such as Configuration Files, Configuration Tables, Parent to Child Configurations, Expressions, and Variables to make your SSIS packages Dynamic. Stop the deployment headache by creating packages that can be updated remotely and do not need to be redeployed when a change is needed. Learn how to update multiple packages with a single change. 5/2/2009 3:45:00 PM 5/2/2009 4:45:00 PM 475 Brian Knight Room 1016 (Auditorium) Room 1016 Ever want to implement drag-and-drop reporting in your application and stop the rampant report queue. In this session you'll have a gentle introduction to SQL Server Analysis Services. You'll see how to use it to give your users their own ad-hoc reporting and have better than expected performance results. 5/2/2009 12:00:00 PM 5/2/2009 1:00:00 PM 476 Brian Knight Room 1016 (Auditorium) Room 1016 Lunch served outside 5/2/2009 11:15:00 AM 5/2/2009 12:00:00 PM 477 Bayer White Room 1003 Room 1003 What are the steps for successfully architecting a solution? What makes software projects successful? Have you heard these questions before? Bayer White can show and tell you what makes software projects successful from gathering requirements to providing a stable architecture! This presentation will give you a better idea as to the processes that should be followed and artifacts that should be produced to be make a project 360 degrees successful. 5/2/2009 9:00:00 AM 5/2/2009 10:00:00 AM 480 Jean-Claude Armand Room 1009 (Auditorium) Room 1009 This session will cover SQL Server 2008 adoption momentum in addition to the scheduled 2 SQL Server release that are currently schedule to be release during the next 36 months. As part of this session we will discuss in details of the upcoming release of SQL Server Kilimanjaro release and schedule around SQL11. 5/2/2009 9:00:00 AM 5/2/2009 10:00:00 AM 484 Jean-Claude Armand Room 1009 (Auditorium) Room 1009 This session will provide an overview and guide to SQL Server Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures. 5/2/2009 10:15:00 AM 5/2/2009 11:15:00 AM 485 Brian McDonald Room 1026 Room 1026 Never created a report in Reporting Services 2005? Don't fret! In this session you will learn the basics on creating reports using SQL Server Reporting Services 2005. Topics will include the architecture of reporting services, creating a report using the wizard, creating reports from scratch, as well as deploying them to the server for general usage. 5/2/2009 9:00:00 AM 5/2/2009 10:00:00 AM