SQLSaturday #16 - South Florida 20098/8/2009 12:00:00 AMA free one day training event for SQL Server professionals and those interested in SQL Server#sqlsat16South FloridaFL33027143End to End Traininghttp://www.endtoendtraining.comhttp://www.endtoendtraining.com/Images/endtoendlogo.jpg60170144JumpstartTV.comhttp://www.jumpstarttv.comhttp://www.jumpstarttv.com/images/header_logo.jpg60170183Confio Softwarehttp://www.confio.comhttp://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg60170253DevFishhttp://devfish.nethttp://www.devfish.net//images/dfbanner1.jpg60170254Pyn Logichttp://www.pynlogic.comhttp://www.pynlogic.com/images/pynlogic_210px.gif60170256TekPartnershttp://www.tekpartners.comhttp://Webconnect.sendouts.net/cf/tekpartners/img/header.gif60170269Modishttp://www.modis.com/http://images.modispro.com/gtw/Idea-Newsletter/integration/idea-modis-logo.gif60170270Sherlock Technology Staffinghttp://www.sherstaff.comhttp://www.sherstaff.com/images/SherlockTechStaffing.gif60170277Rezult Technology http://rezulttechnology.comhttp://www.rezulttechnology.com/images/rezult_logo.gif60170283FlaDotNethttp://www.fladotnet.comhttp://www.fladotnet.com/images/fladotnet_Logo_Combined.jpg60170284ComputerWayshttp://www.computerways.comhttp://www.computerways.com/images/cways-logo-color_wLogo_Rev3.gif60170267Campus Management Corphttp://campusmanagement.comhttp://www.globalfas.com/images/partners_campus_management.gif60170567Adam JorgensenAdam Jorgensen, MBA, MCDBA is a principal Consultant for Pragmatic Works Consulting and has been delivering innovative SQL Server and Business Intelligence Solutions for over a decade. He works with customers to quickly understand their business models and identify their needs to deliver value as efficiently as possible. Adam has extensive technical and management experience in industries including automotive, manufacturing, software, education, security, and retail and has delivered high perfor@adam_Jorgensenhttp://www.linkedin.com/in/wajorgensenhttps://api.twitter.com/1/users/profile_image?screen_name=@adam_Jorgensen4848520Andy WarrenAndy Warren is the President of End to End Training, an Orlando based provider of SQL Server training. In addition he manages JumpstartTV.com, is the President of the Orlando SQL Group, and serves on the PASS Board of Directors. @sqlandyhttp://www.linkedin.com/in/sqlandyhttp://www.sqlservercentral.com/blogs/andy_warren/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlandy4848546Brian KnightBrian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of 10 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at htt@BrianKnighthttp://www.linkedin.com/profile/view?id=1411557locale=en_UStrk=tab_prohttp://blogs.pragmaticworks.com/brian_knighthttps://api.twitter.com/1/users/profile_image?screen_name=@BrianKnight4848612Chad MillerChad Miller is a SQL Server DBA and Manager of Database Administration at Raymond James Financial. He has 9 years experience as DBA, working with SQL Server 6.5 through SQL Server 2008. He is the author of various technical articles published in SQL Server Central and SQL Server Magazine and has presented at the Tampabay SQL Server User Groups and SQL Saturday. In his spare time Chad is the Project Coordinator/Developer of Codeplex projects SQL Server PowerShell Extensions (SQLPSX) and PoshRSS.http://chadwickmiller.spaces.live.com/4848631Chris EargleChris Eargle is a Microsoft Most Valuable Professional - Visual C# (C#
MVP) and INETA Community Champion from Columbia, SC. Besides designing
and developing software at South Carolina Farm Bureau, he runs the local
.NET User Group: the Columbia Enterprise Developers Guild. In his spare
time he travels to conferences and user groups to promote best practices
and new technologies in the development community.4848609David LapidesDavid Lapides is an Architect with Idea Integration focusing on Portals and Business Intelligence solutions. He has designed and implemented many solutions using SharePoint, SQL Server .Net and other technologies.4848512Dean RichardsDean Richards has over 20 years of Oracle and SQL Server project development, implementation and strategic database architecting. Before coming to Confio, Dean held engineering positions at McDonnell Douglas and Daugherty Systems, an object-oriented solution provider for Anheuser-Busch. Dean was also a technical director for Oracle Corporation managing all aspects of their broadband account including short and long-term technical planning and strategic alliances. As a highly successful liaison @ConfioDeanhttp://www.linkedin.com/profile?viewProfile=key=18302796locale=en_UShttps://api.twitter.com/1/users/profile_image?screen_name=@ConfioDean4848541Devin Knight KnightDevin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jac@https://twitter.com/knight_devinhttp://www.linkedin.com/profile?viewProfile=key=22920224locale=en_UStrk=tab_prohttp://blogs.pragmaticworks.com/devin_knight/https://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/knight_devin4848620Jean-Claude ArmandMicrosoft4848514Jeffrey GarbusJeff has been in the SQL Server business for over 20 years, training and consulting, with an emphasis on performance and tuning. He has written over a dozen books, and hundreds of magazine articles. He has spoken at a week of SQL Saturdays.http://www.linkedin.com/in/jeffgarbushttp://www.soaringeagle.biz4848554Jorge SegarraJorge has been a SQL DBA for over 5 years with experience with SQL 2000, 2005 and 2008. Some of his other specialties include virtualization, specifically on the VMware platform. He is currently the Database Administrator for University Community Hospital (www.universitycommunityhospital.org) in Tampa. Check out his blog at: http://sqlchicken.blogspot.comhttp://sqlchicken.blogspot.com4848568Kendal Van DykeKendal began working with SQL Server 7.0 as a VB developer 9 years ago. He has spent the last 7 years as a production DBA working on systems that process hundreds of millions of transactions per day. He is currently Senior DBA at Channel Intelligence in Celebration, FL where he is responsible for the management, monitoring, and performance of 40+ SQL Servers.
Kendal is known as @SQLDBA on Twitter, is a contributor to the forums on SQLServerCentral.com, and was selected to present a community @http://twitter.com/#!/sqldbahttp://twitter.com/SQLDBAhttp://kendalvandyke.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/#!/sqldba4848619Martin PichardoMicrosoft4848603Matt LarsonMatt Larson is the Founder and technology visionary of Confio Software. Prior to his involvement at Confio, Mr. Larson helped found an oil and gas holding company. The company grew from four employees to over two hundred employees while raising over $110 million. Mr. Larson is an international speaker on technology related topics. He also is the co-author of five, best-selling technology books. Mr. Larson holds a Bachelor of Science in Business Administration from the University of Colorado wher4848560Max TrinidadMax Trinidad is a native of Puerto Rico and has been working with computers since 1979. He has worked with Dbase III/IV, Clipper, RPG, OS/400, OCL/JCL/CL, HTLM and most current MS development technologies. Work for many years as a Senior IT/Developer has provided support for Windows Servers 2003/2008, SQL Servers Applications, Microsoft Virtualization Technologies, and IBM iSeries building Visual Studio solutions. Currently working as a VB.NET Programmer/Analyst. In 2009 got his Microsoft MVP aw@MaxTrinidadhttp://www.linkedin.com/pub/max-trinidad/12/47/775http://www.flpsug.com/https://api.twitter.com/1/users/profile_image?screen_name=@MaxTrinidad4848558Michael AntonovichMike Antonovich is currently the Assistant Director of Web Services for Orange County Public Schools in Orlando, FL where he manages the SharePoint portal team implementing the Internet, intranet, collaboration, project, team, and school sites. Of course SharePoint runs on SQL Server and all custom applications built to run within our portal use SQL Server as well. He recently published his 6th book: Office and SharePoint 2007 User's Guide. Mike has been using SQL Server since 1998, and FoxPr@MPAntonovichhttp://www.linkedin.com/in/michaelpantonovichhttp://www.micmin.orghttps://api.twitter.com/1/users/profile_image?screen_name=@MPAntonovich4848510Mike MollenhourMike is currently a SQL DataManagement/BI Architect consultant for IDEA Integration in Jacksonville Florida. During the past 3 years with IDEA he has worked with many clients all over the US including The Gartner Group, Football Fanatics, Journey Ed as well as many others. These engagements have included High Availability, AS,RS,SQL data mining, and performance tuning. Mike has spoken at several events including SQLSaturday #3 and #13. http://www.linkedin.com/in/mikemollenhour4848518Pam ShawPam Shaw has been in IT for over 27 years. For the last 8 years, Pam has been working with SQL Server, first 2000 and then 2005. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS.@http://www.linkedin.com/in/pshaw1129http://www.linkedin.com/in/pshaw1129http://tampasql.com/https://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw11294848601Shervin ShakibiBio@shervshervhttp://www.linkedin.com/pub/shervin-shakibi/1/563/174https://api.twitter.com/1/users/profile_image?screen_name=@shervsherv4848639Telmo SampaioTelmo Sampaio is the CTO for Blue Dasher Technologies, a street level imagery company out of sunny Miami, FL. In this role Telmo manages a team of developers, database administrators, graphics designers and network managers that are building a detailed virtual reality world in which one can navigate as if driving a car and visiting any address. Telmo gets down to the low level development of the solution as well using SQL Server 2008, .NET 3.5, C++, Silverlight and Virtual Earth .4848632Vishal ShuklaVishal has been behind the key boards since 1991 mainly on Microsoft
technologies from GWBasic to .net 4.0. Vishal works as a System Architect
for the Palm Beach County. He has been actively involved with local user
group communities. He has given various presentaions at code camps, Teched
Tweener and various user group events.
Winner of INETA Community Champions award for 2008 Q3.
Microsoft VB .Net MVP4848578Wes DumeyWes is a Senior Consultant for Durable Impact
Consulting, Inc. and works as a 100% travel consultant working on data
warehouse consulting projects for Fortune 500 companies. http://www.linkedin.com/wesdumeyhttp://www.durableimpact.com4848510510Mike MollenhourRoom 259SQL Smoking MirrorsIn this session I will demonstrate how to configure Mirroring for both high availability and offloading reporting stress via database snapshots. I will also cover the different modes of mirroring and how they may affect performance. 8/8/2009 11:00:00 AM8/8/2009 12:00:00 PM511511Mike MollenhourRoom 254SQL 2008 Data MiningIn this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel.This session will mainly focus on new features available for SQL 20088/8/2009 1:00:00 PM8/8/2009 2:00:00 PM512512Dean RichardsRoom 257Tuna Helper - Proven Process for Tuning SQLMany DBAs and Developers are faced with tuning poorly performing SQL statements. 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 time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.8/8/2009 8:30:00 AM8/8/2009 9:30:00 AM514514Jeffrey GarbusRoom 261Choosing Indexes for PerformanceLearn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session8/8/2009 11:00:00 AM8/8/2009 12:00:00 PM515515Jeffrey GarbusRoom 255Indexing for Join OptimizationEverything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections8/8/2009 2:15:00 PM8/8/2009 3:15:00 PM516516Jeffrey GarbusRoom 257High Availability options in SQL Server 2008SQL Server 2008 high availability options include Clustering, Database Miroring, Replication, and Log Shipping. If you are wondering which ones are best, and under what curcumstances... come on over.8/8/2009 3:30:00 PM8/8/2009 4:30:00 PM518518Pam ShawRoom 255On Demand Report SubscriptionsThis 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.8/8/2009 9:45:00 AM8/8/2009 10:45:00 AM519519Pam ShawRoom 255Tips Tricks for dynamic SSRS ReportsThis 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.8/8/2009 1:00:00 PM8/8/2009 2:00:00 PM520520Andy WarrenRoom 257Introduction to SQL StatisticsThis 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.8/8/2009 1:00:00 PM8/8/2009 2:00:00 PM521521Andy WarrenRoom 257Social and Not so Social Networking for the DBAShould you be networking? In this session we'll talk about why you should be building a network now, how to build it, and how to keep track of and quantify your network. Along the way we'll talk about the most common social networks, why you should consider blogging, and some exercises you can do to strengthen your networking skills.8/8/2009 11:00:00 AM8/8/2009 12:00:00 PM541541Devin Knight KnightRoom 254Best Practices and Performance Tuning SSISIn this session you will learn some of the most common mistakes in SSIS that can cause performance issues. Then Devin will discuss some best practices that you can take back and use in packages you develop.8/8/2009 8:30:00 AM8/8/2009 9:30:00 AM546546Brian KnightRoom 254Loading a Data Warehouse in SSISIn this session, you'll learn how to load a data warehousing using SSIS. See some of the challenges in data warehouse processing and how to get past some of those fact and dimension challenges. 8/8/2009 11:00:00 AM8/8/2009 12:00:00 PM547547Brian KnightRoom 254Introduction to SQL Server Analysis Services(SSAS)Want to deliver slice-and-dice data reports for your end users? Then you'll want to see this session on how to get started in SQL Server Analysis Services (SSAS). In this session, you'll be taken from the data warehouse phase forward into SSAS. You'll also see how to deliver reports to your users.8/8/2009 9:45:00 AM8/8/2009 10:45:00 AM554554Jorge SegarraRoom 255Policy Based Management 101We 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!8/8/2009 8:30:00 AM8/8/2009 9:30:00 AM558558Michael AntonovichRoom 259Save Time by Merging ItThe 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 updating or deleting data from an existing table with a single statment. In this sessionk we will explore 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, and how indexing effects the performance of MERGE statements and more.8/8/2009 3:30:00 PM8/8/2009 4:30:00 PM559559Michael AntonovichRoom 261Identifying and Removing Duplicate Records 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.8/8/2009 8:30:00 AM8/8/2009 9:30:00 AM560560Max TrinidadRoom 261PowerShell and SQL ServerLearn how DBA's and Developers can take advantage of this new .NET scripting technology - PowerShell 2.0. This is a 'most' to learn IT/.NET skill. In this session will discuss the difference between using SMO and the new integrated SQLPS in assisting managing your SQL Server 2000/2005/2008.8/8/2009 2:15:00 PM8/8/2009 3:15:00 PM567567Adam JorgensenRoom 257Performance Optimization TechniquesThis will be an exciting deep dive into optimizing the performance of your Analysis Services Cubes. We will begin with an overview of the underlying query processing architecture. Then we'll jump into discussion and demonstration of techniques and best practices for enhancing query performance, maximizing aggregation value, partitioning, and improving processing performance, among other topics. This will be a great session for those of you who are looking for some under-the-hood insight into SSAS 2008. 8/8/2009 2:15:00 PM8/8/2009 3:15:00 PM568568Kendal Van DykeRoom 258Transactional Replication: Beyond The BasicsAt 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.
Session Goals:
• Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles. Learn how to configure advanced options such as vertical and horizontal filtering
• Demonstrate how to monitor transactional replication performance
• Lear8/8/2009 1:00:00 PM8/8/2009 2:00:00 PM569569Kendal Van DykeRoom 261Configuring SQL Access for the Web Developer\AdminThis session will demonstrate the ways that ASP ASP.NET applications can be configured to make connections to SQL Server from different versions of IIS so that we can keep our servers secure and our DBAs happy.
Session Goals:
• Learn when to use SQL logins and when to use Windows Authentication
• Understand the concept of impersonation
• Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server
• Learn how to configure IIS 5, 6, 7 and Windows XP, 2003, and 2008 to support impersonation
8/8/2009 9:45:00 AM8/8/2009 10:45:00 AM571571Kendal Van DykeRoom 255Working With XML in SQL ServerXML 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 XML data type, do basic 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!
Session Goals:
• Learn how to use FOR XML PATH and WITH NAMESPACE clauses
• Understand the basic use of the XML data type and XML schema collections
• Learn how to use XML DML to manipulate XML data
8/8/2009 3:30:00 PM8/8/2009 4:30:00 PM572572Adam JorgensenRoom 254Dive into Querying Analysis Services with MDXThis session will put you on the fast track to understanding the fundamentals of MDX and querying your Analysis Services Cubes. MDX is a very powerful tool in your cube development arsenal, but the learning curve can be steep. Together, we will discuss and demonstrate working with sets, tuples, and working with your data through the built in functions in MDX and Analysis Service 2008. Examples and demos will be common business cases you will use in your cubes day to day. 8/8/2009 3:30:00 PM8/8/2009 4:30:00 PM578578Wes DumeyRoom 257 Building a Data Warehouse using SQL Server 2008In this session we will go through a data warehouse lifecycle project
using SQL Server and SSIS to demonstrate how to build the data warehouse.
A general overview and code presentation will be provided.8/8/2009 9:45:00 AM8/8/2009 10:45:00 AM579579Wes DumeyRoom 259Transitions: From Employee to Free-lanceHave you ever wondered what it would be like to practice using SQL skills
as a contractor/consultant? Are you concerned about the pitfalls of moving from a
full time opportunity to a free-lance role? Come to this discussion and
learn how to make a successful transition from full time to the free-lance world. Learn what pitfalls await and how to design a successful career plan. 8/8/2009 2:15:00 PM8/8/2009 3:15:00 PM601601Shervin ShakibiRoom 259Intro to SSISA 100 level session for those who are new to SSIS. This beginner session will discuss entry level SSIS topics and if there is time, dive into some intermediate topics.8/8/2009 9:45:00 AM8/8/2009 10:45:00 AM603603Matt LarsonRoom 255Wait-Time Based SQL Server Performance ManagementUsing Wait 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 Wait-Time based performance analysis to solve the most difficult performance related issues.8/8/2009 11:00:00 AM8/8/2009 12:00:00 PM604604Shervin ShakibiRoom 259Advanced SSISA continuation of the previous session this session will discuss advanced SSIS topics.8/8/2009 1:00:00 PM8/8/2009 2:00:00 PM609609David LapidesRoom 259Planning and Deploying Performance Point ServerWant to learn how to get Performance Point up and running in your environment? This session will describe the requirements, planning activities, deployment options as well as trips and tracks for ensuring your PPS depl;oyment is successful. Then we will will walk though an installation of PPS8/8/2009 8:30:00 AM8/8/2009 9:30:00 AM610610David LapidesRoom 254A tour of SQL Server and SharePoint IntegrationLearn how to integrate databases, cubes, and reports into SharePoint, by leveraging features including Excel Services, the Business Data Catalog, Performance Point Dashboards and data query web parts. This session will describe the various SQL Server centric features of SharePoint and demonstrate how they can be used to create a cpomprehensive BI Portal.8/8/2009 2:15:00 PM8/8/2009 3:15:00 PM612612Chad MillerRoom 261Powershell and SQL Server AdministrationIn this sesssion we will look at automating common DBA tasks through Powershell. An overview of the CodePlex project SQL Serer Powershell Extensions will be provided. Specific topics covered include SSIS administration, replication and agent monitoring, performing simple ETL with Powershell and building graphs, charts and diagrams using Powershell.8/8/2009 3:30:00 PM8/8/2009 4:30:00 PM619619Martin PichardoRoom 261SQL Server 2008 Spacial Data TypeThis session will provide an introductory and intermediate look at the Microsoft SQL server 2008 Spacial data types. 8/8/2009 1:00:00 PM8/8/2009 2:00:00 PM620620Jean-Claude ArmandRoom 258DW Prescriptive Architecture Fast Track This session will provide a Fast Track discussion into Data Warehouse architecture.8/8/2009 9:45:00 AM8/8/2009 10:45:00 AM631631Chris EargleRoom 258RESTful DataREST 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.8/8/2009 2:15:00 PM8/8/2009 3:15:00 PM632632Vishal ShuklaRoom 258ADO .Net Sync ServicesThe ability to support mobile and remote workers is becoming more and more important for organizations every day. It is critical that organizations ensure users have access to the same information they have when they are in the office. In today’s discussion we will see how Sync Services for ADO.NET, which is a part of the Microsoft Sync Framework (MSF), enables synchronization of information between database systems and how Sync Services for ADO.NET helps developers avoid many of the common issues associated with taking data offline.8/8/2009 11:00:00 AM8/8/2009 12:00:00 PM639639Telmo SampaioRoom 258SQL Server Beyond RelationalParticipate in an architecture review showcasing the use of SQL Server 2008 Spatial features and the filestream data. The session will focus on a pre-defined solution architecture using SQL Server 2005 with pure relational data and after a brief introduction of new features in SQL Server 2008, changes will be presented and discussed with the group, culminating in a new architecture.8/8/2009 3:30:00 PM8/8/2009 4:30:00 PM