SQLSaturday #1 - Orlando 2007 11/10/2007 12:00:00 AM Free SQL Server Training #sqlsat1 Orlando FL 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 4 Seminole Community College Facility Sponsor http://www.seminolestate.edu/ http://www.seminolestate.edu/media/2009/seminole-state-college.gif 60 170 6 End to End Training Gold Sponsor http://www.endtoendtraining.com http://www.endtoendtraining.com/images/endtoendlogo.jpg 60 170 22 Cizer - A CALIBRE Company Gold Sponsor http://www.cizer.com http://www.cizer.com/images/cizer_logo.gif 60 170 11 Stratus Technology Services Silver Sponsor http://www.stratustech.com/ http://www.stratustech.com/images/logo_stratusTech.gif 60 170 24 Symantec Silver Sponsor http://www.symantec.com http://www.sqlsaturday.com/images/symantec.jpg 60 170 25 Soaring Eagle Consulting Silver Sponsor http://www.soaringeagle.biz http://www.sqlsaturday.com/images/soaring_eagle.jpg 60 170 18 Kforce Bronze Sponsor http://www.kforce.com http://www.sqlsaturday.com/images/kfor_tech_4c.jpg 60 170 3 Orlando .Net Users Group Bronze Sponsor www.onetug.com http://www.onetug.org/DNN/Portals/0/ONETUG.gif 60 170 16 SQL Sentry Bronze Sponsor http://www.sqlsentry.net/ http://www.sqlsentry.net/images/2006sitedesign/sqlSentry_logo.jpg 60 170 17 Redgate Software Corporate Sponsor http://www.red-gate.com/ http://www.red-gate.com/images/logo_v4.1.gif 40 100 2 xCelligent Corporate Sponsor www.xcelligent.biz http://www.sqlsaturday.com/images/xcelligent.bmp 40 100 19 SQL Farms Corporate Sponsor http://www.sqlfarms.com http://www.sqlfarms.com/images/top_logo.gif 40 100 23 Consultis Corporate Sponsor http://www.consultis.com http://www.opass.org/images/opass/consultislogo.png 40 100 12 Telerik Corporate Sponsor http://www.telerik.com http://www.telerik.com/images/telerikLogo.gif 40 100 14 Edgewood Associates Corporate Sponsor http://www.edgewoodsolutions.com/ http://www.edgewoodsolutions.com/image/logo.jpg 40 100 15 MSSQLTips.com Corporate Sponsor http://www.mssqltips.com/ http://www.sqlsaturday.com/images/mssql_logo.jpg 40 100 7 Robert Half Technology Corporate Sponsor http://www.rht.com http://www.roberthalftechnology.com/portal/images/menuitems/130f8ee40d31c527afe5011002f3dfa0/normal/rht_logo.gif 40 100 9 ASPSOFT, Inc. Corporate Sponsor http://www.aspsoft.com http://www.aspsoft.com/images/formatting/aspsoft-logo.jpg 40 100 1 Jeffrey Garbus Room 202 Room 202 This session will cover index types, physical storage structures, and how the server uses and chooses indexes. This is a portion of a class that has been presented directly to Microsoft at their Redmond Campus (Note: 80 min session preferred) 11/10/2007 3:00:00 PM 11/10/2007 4:20:00 PM 2 Wes Dumey Room 307 Room 307 This session will cover an introduction to SSIS. Attendees will learn about SSIS and see sample data flows that can be created in SSIS, reading from a variety of sources and writing to different database and file outputs. 11/10/2007 9:00:00 AM 11/10/2007 9:50:00 AM 3 Wes Dumey Room 228 Room 228 This session will cover the basics of Data warehousing using the SQL Server 2005 tool. During this session we will work with our sample client, a major airline, and build a working data warehouse from business requirements. This session will cover database design, data warehouse loading principles using SSIS, and end user reporting with SSRS. 11/10/2007 3:00:00 PM 11/10/2007 4:20:00 PM 4 Brian Knight Room 307 Room 307 In this session, learn the architectural patterns that derive the highest scale and performance from SQL Server Integration Services. Walk away with a full set of strategies for planning high performance and scale implementations and a range of practical techniques for measuring performance and for identifying and tackling bottlenecks in your data integration processes. 11/10/2007 3:00:00 PM 11/10/2007 4:20:00 PM 5 Brian Knight Room 138 Room 138 Learn what's new in SQL Server 2008 for the DBA, Developer and BI professional. This session is demo-packed with the best features of why you should upgrade to SQL Server 2008. 11/10/2007 9:00:00 AM 11/10/2007 9:50:00 AM 6 Shawn Weisfeld Room 220 Room 220 In this session we will introduce the .NET CLR inside of SQL Server 2005. We will discuss why you might want to use the CLR verses traditional SQL and the pros and cons of it. Finally we will demonstrate the creation of a CLR Stored Procedure. 11/10/2007 3:00:00 PM 11/10/2007 4:20:00 PM 7 Andy Warren Room 307 Room 307 Transactional replication is a powerful tool and surprisingly easy to implement, but there are times when you might need to go beyond the wizard. This session will demo setting up replication in under 10 minutes, then look at how to handle some situations you might run into such as needing to delete rows on the publisher but not the subscriber, applying an alternate set of permissions and indexes to subscribers, troubleshooting replication agents, and more! 11/10/2007 2:00:00 PM 11/10/2007 2:50:00 PM 8 Michael Wells Room 220 Room 220 Looking for reliable local store that you can easily deploy embedded within your application? Wanting to know what programming options are available today, and what’s coming? In this session you’ll see the different data access models including ResultSet and TableDirect. I’ll also discuss and demo the different deployment options available for SQL Server Compact Edition. 11/10/2007 10:00:00 AM 11/10/2007 10:50:00 AM 9 Brandon Kelly Room 303 Room 303 Learn about the Sql Server Management Object (SMO) model in SQL Server 2005. Interact with SQL Server in a variety of ways, including Bulk Copy of SQL data, programtically backup or restore a database, viewing and modifying schema information about a database, interacting with the SQL Server Job Agent and more. This session will consist of presentation, code, and a hands-on lab for attendees to take home. 11/10/2007 11:00:00 AM 11/10/2007 11:50:00 AM 10 David Eichner Room 220 Room 220 How to utilize the Microsoft Dynamics GP SQL Stored Procedures for interacting with backend ERP database through fully validated sql stored procedures. Allows for high speed integrations or real-time integrations between Microsoft Dynamics GP and other database applications. 11/10/2007 2:00:00 PM 11/10/2007 2:50:00 PM 11 Joe Healy Room 220 Room 220 Explore how you can build offline smart client applications in a RAD way that synchronizes backend database with a local Microsoft SQL Server Compact Edition store using the Microsoft Synchronization Services for ADO.NET. Use the Microsoft Visual Studio Designer to help build a two-tier application and N-tier application that incrementally downloads data that can be cached on a SQL Server Compact Edition store. We can also explore how to perform bidirectional synchronization with conflict detect 11/10/2007 1:00:00 PM 11/10/2007 1:50:00 PM 12 Pam Shaw Room 307 Room 307 This session will show methods to make your reports both easier to create and more flexible. We will cover data driven layouts and formatting. We will see how templates make it easier to have more consistent report formats and how to set up data sources that more portable. We will review emailing reports and how this can be integrated into your current application. 11/10/2007 10:00:00 AM 11/10/2007 10:50:00 AM 13 Scott Farriss Room 228 Room 228 This session will provide basic to more advanced techniques when dealing with XML in SQL Server. We will walk through the XML data type, binding schemas, processing, and returning XML. The session will also focus on how .NET developers will work with their SQL developer counterparts to create more seamless applications. 11/10/2007 2:00:00 PM 11/10/2007 2:50:00 PM 14 Bayer White Room 228 Room 228 Workflow styled applications rely heavily on human interaction and long-running, persistent processes. Developing a framework for these extensive business requirements can take valuable time. This is why Microsoft has come out with a new framework for making workflow logic transparent while at the same time providing the tools for building complex workflows. This session focuses on how to use SQL Server 2005 to enable workflows to run for long periods of time and also how to track data associate 11/10/2007 1:00:00 PM 11/10/2007 1:50:00 PM 15 Chris Rock Room 303 Room 303 In this session we'll create a database object (table, proc, functions) backup system using DDL Triggers in SQL Server 2005. This system is beneficial to both DBA's and developers. 11/10/2007 1:00:00 PM 11/10/2007 1:50:00 PM 16 Jose Fuentes Room 228 Room 228 Here we will go though the process of designing and using a new model that is becoming increasingly popular. People are increasingly tearing down their data structure for a more robust option. We have all seen the needs of our end users. They want another field to capture data, what did this involve? This involved getting the new column inserted into the database as well as views and stored procedures and such. Now granted we are going to go though two possible ways of doing the code (non-stron 11/10/2007 11:00:00 AM 11/10/2007 11:50:00 AM 17 Jean-Claude Armand Room 138 Room 138 Come learn about the enhancements in the next version SQL Server for Data Warehousing. The next version of SQL Server provides a comprehensive, scalable Data Warehouse platform that enables organizations to build your DW faster with data integration platform, manage your growing data volumes with an enterprise ready relational database and deliver actionable insights with the integration with the Microsoft BI platform. This is a part one of a two part session. 11/10/2007 10:00:00 AM 11/10/2007 10:50:00 AM 18 Jean-Claude Armand Room 138 Room 138 Come learn about the enhancements in the next version SQL Server for Data Warehousing. The next version of SQL Server provides a comprehensive, scalable Data Warehouse platform that enables organizations to build your DW faster with data integration platform, manage your growing data volumes with an enterprise ready relational database and deliver actionable insights with the integration with the Microsoft BI platform. This is part two of a two part session. 11/10/2007 11:00:00 AM 11/10/2007 11:50:00 AM 20 Mike Antonovich Room 138 Room 138 Like many jobs in IT it seems that everyone only wants to hire senior people with a kazillion years of experience. So how you do find openings for the 'Junior DBA' positions that are out there and what skills should you have to start with? How do you build those skills without having the job first? And what is life as a DBA really like? We'll try to answer all of those questions and more at this session. 11/10/2007 2:00:00 PM 11/10/2007 2:50:00 PM 21 Mike Antonovich Room 307 Room 307 Most languages support an extended version of the IF/THEN syntax and in TSQL it's CASE. It's syntax is a little finicky and to add to the confusion there are two different ways to use it! We'll look at how to use it both ways and show how it contrasts with the IF/THEN syntax. This is a beginner level session. 11/10/2007 1:00:00 PM 11/10/2007 1:50:00 PM 22 Joe Celko Room 202 Room 202 A guide for formatting, designing and using SQL code. Particular stress on ISO Standards, and best practices from scratch paper to the Data Dictionary. 11/10/2007 9:00:00 AM 11/10/2007 9:50:00 AM 25 Trey Johnson Room 303 Room 303 Do you think of data mining as a black box with SQL Server? Learn the basics that will let you intelligently transform data and make the most of the platform. Raise your IQ, become a SSIS and data mining guru, run the “Magic 8-Ball Transformation” and more! Don’t miss out. 11/10/2007 3:00:00 PM 11/10/2007 4:20:00 PM 26 Trey Johnson Room 303 Room 303 Integration Services fulfills the core needs of ETL within the Enterprise. It’s not you're old DTS; but you can learn the techniques that will make it successful for you today. Curious now and want to know just how the technology is being applied to this paradigm as well as alternatives? Join us for this in-depth session of exploring querying of federated data sources; learning integration of Data Mining in the pipeline; and coming to know the blend of out-of-the-box and custom extensions to mak 11/10/2007 9:00:00 AM 11/10/2007 9:50:00 AM 30 Jon Winer Room 202 Room 202 This exciting session will talk about why CLR UDF's are a good choice in many cases, why using UDF's will simplify your code, and then go into setting up environments for testing and debugging. We'll also be discussing a few hard learned tips and tricks that will help you when you start using UDF's. 11/10/2007 10:00:00 AM 11/10/2007 10:50:00 AM 31 Patrick Thompson Room 303 Room 303 What should database design look like given the deep integration of SQL and XML in SQL Server 2005? This session will look at topics such as normalization, dependency analysis, SQL and XML schema integration and the implications for application, service and message design. The speaker worked on both Hailstorm and WinFS and will describe some of the problems that have influenced the current state of the art. 11/10/2007 10:00:00 AM 11/10/2007 10:50:00 AM 32 Kendal Van Dyke Room 307 Room 307 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! 11/10/2007 11:00:00 AM 11/10/2007 11:50:00 AM 33 Barry Ralston Room 220 Room 220 New SQL Server 2005 features make it easier than ever to identify customers, create tie-in sales and even perform data quality assurance. This session will introduce attendees to the data mining models in SQL 2005, how to create a data mining model project in BIDS and finally, demonstrate how to use prediction models in custom software development. 11/10/2007 11:00:00 AM 11/10/2007 11:50:00 AM 35 Ken Tucker Room 202 Room 202 LINQ defines standard query operators that allow code written in LINQ-enabled languages to filter, enumerate, and create projections of several types of collections using the same syntax. In this talk I will cover the basics of Linq to SQL 11/10/2007 2:00:00 PM 11/10/2007 2:50:00 PM 36 Jessica Moss Room 228 Room 228 This session will discuss the basic syntax of mdx queries, query-scoped calculated measures, and common functions that can be used in MDX queries. This session is best suited for people who are familiar with Analysis Services cubes and multidimensional concepts. They are interested in learning how to write custom MDX queries to obtain data from their OLAP cubes. 11/10/2007 9:00:00 AM 11/10/2007 9:50:00 AM 39 Donnie Reynolds Room 202 Room 202 This session will compare architectural differences and similarities between these two RDBMSs. This technical session is an excellent migration tool for Oracle DBA's now working in Microsoft shops. It is also a valuable education for anyone wanting to understand how these two architectures really work. 11/10/2007 1:00:00 PM 11/10/2007 1:50:00 PM 41 Joe Celko Room 138 Room 138 1. Dr. Codd's Basic Eight Relational Operators 2. Why it really should not have been in the Basic Eight 3. Date's Version of Codd's Relational Division 4. Celko's Version of Codd's Relational Division 5. Relational Division with Remainder 6. Relational Division without Remainder 7. Todd's Relational Division 8. Romley's Relational Division 9. Related things you can do 11/10/2007 3:00:00 PM 11/10/2007 4:20:00 PM 42 Joseph Memmo Room 228 Room 228 This session will provide you a framework of Best Practices in establishing standards for SQL Server Integration Services for an enterprise environment from a IT infrastructure prospective. Items discussed will include establishing deployment standards, Package Store options, portability, naming conventions, execution options, and securities concerns. 11/10/2007 10:00:00 AM 11/10/2007 10:50:00 AM 44 Judy Pipia Room 303 Room 303 This session will introduce the Service Broker in SQL Server 2005. During this session we will discuss an overview of Service Broker architecture and delve into the objects needed to create a Service Broker solution. Finally, we will build a sample solution from start to finish using the Adventureworks database. 11/10/2007 2:00:00 PM 11/10/2007 2:50:00 PM 45 Declan Link Room 138 Room 138 This is a vendor session presented by Stratus Technologies and will discuss the value that staffing firms can provide to both employees and employers. Picking the right staffing firm can make a difference on how long it takes to find a job, how good that job is, and how well it pays. Bring your lunch and learn how this part of our industry works! 11/10/2007 12:00:00 PM 11/10/2007 1:00:00 PM 46 Jeffrey Garbus Room 202 Room 202 This session is co-sponsored by Symantec and Soaring Eagle Consulting. SQL Server consultant and author Jeff Garbus will be the presenter for this session. 11/10/2007 12:00:00 PM 11/10/2007 1:00:00 PM 47 Jim Blizzard Room 220 Room 220 In this session we’ll take a lap around Visual Studio Team System for DB Pros to see how it can help you sleep better at night. Ever make a bunch of changes to your database then lose track of what you’ve changed? Frustrated with trying to come up with consistent, “meaningful” test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you’re not part of the team? Come see how VSTS DB can solve your problems! 11/10/2007 9:00:00 AM 11/10/2007 9:50:00 AM 48 Brian Knight Bayer White Room 202 Room 202 In this presentation Bayer White plays the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins! 11/10/2007 11:00:00 AM 11/10/2007 11:50:00 AM