http://msdn.microsoft.com/virtuallabs/Microsoft Virtual Labs allow you to either quickly evaluate or learn how to build great applications for Windows and the Web, through a series of guided, hands-on labs which can be completed in 90 minutes.(c) 2007, Microsoft, Inc. All rights reserved.20After completing this lab you will be better able to use: 1) Updated Create New Dimension Wizardhttp://go.microsoft.com/?linkid=87714550745de47-ead3-4aeb-b2ea-eeeb1236d58eWed, 23 Apr 2008 15:44:22 GMTAfter completing this lab you will be better able to: 1) Use Hierarchy ID Datahttp://go.microsoft.com/?linkid=8771456dc4a9b29-0fcb-4e58-84bf-a7a11fa1ad02Wed, 23 Apr 2008 15:46:41 GMTAfter completing this lab you will be better able to: 1) Use the new Date and Time Data typeshttp://go.microsoft.com/?linkid=87714580d812d6c-04f6-4d3f-9081-450eefdda243Wed, 23 Apr 2008 15:50:55 GMTAfter completing this lab you will be better able to: 1) Utilize occasionally connected systemshttp://go.microsoft.com/?linkid=8771454415a3b2e-f2f4-425d-b775-ea42be4193d2Wed, 23 Apr 2008 15:10:46 GMTAfter completing this lab you will be better able to: 1) Use Change Data Capture in Integration Serviceshttp://go.microsoft.com/?linkid=877146001925bb2-e904-48f9-a303-2e90d8f02c37Wed, 23 Apr 2008 15:59:53 GMTAfter completing this lab you will be more familiar with: 1) Table Value Parameters; 2) Merge Statementshttp://go.microsoft.com/?linkid=8771457eba9a2a9-89b5-4979-b559-54d5204243bfWed, 23 Apr 2008 15:49:37 GMTIn this lab, you will learn to: 1) Use the Try/Catch blocks in SQL; 2) PIVOT and UNPIVOT data; 3) Use the SQL Server Management Studiohttp://go.microsoft.com/?linkid=8704620b6ad601c-b5b1-45ba-976d-08a5ff9dd875Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Use the Try/Catch blocks in SQL; 2) PIVOT and UNPIVOT data; 3) Use the SQL Server Management Studiohttp://go.microsoft.com/?linkid=8771472aa57c345-af49-4e25-823a-6ef743191d2aWed, 23 Apr 2008 16:29:23 GMTAfter completing this lab you will be better able to utilize: 1) XEvent – Procedure and Kernel Analysis; 2) XEvent – Queryable Schemahttp://go.microsoft.com/?linkid=8771461bbe9bb10-7248-4024-ad56-c5becc9b148cThu, 07 Feb 2008 16:13:14 GMTAfter completing this lab you will be more familiar with: 1) Managing relational and non-relational data in SQL Server 2008http://go.microsoft.com/?linkid=877145955532e90-0b66-4674-8c42-3f1dbffb07eaWed, 23 Apr 2008 15:58:02 GMTAfter completing this lab, you will be better able to: 1) Use the Declarative Management Framework; 2) Create a Surface Area Facet policy; 3) Configure the server to run the policy; 4) Create a naming convention policyhttp://go.microsoft.com/?linkid=76191759b01532f-1636-497c-8b99-ff295aaa5938Thu, 18 Oct 2007 08:00:00 GMTIn this lab, you will learn to: 1) Create an Analysis Services cube; 2) Create dimension attributes and hierarchies; 3) Create calculated members and Key Performance Indicators (KPIs)http://go.microsoft.com/?linkid=4540575ecc4c154-c057-4e0c-a610-132f88cacf93Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create a Report in Excel; 2) Populate reports with data from a cube; 3) Store your connection and your workbook in SharePoint Libraries; 4) Publish a chart and a workbook; 5) Create a dashboard and populate it with your chart and KPI’s based on the data in your report; 6) Successfully created a SharePoint site; 7) Add a SharePoint site as a trusted site in Excel Serviceshttp://go.microsoft.com/?linkid=6949296e0b521eb-28c0-4840-93d3-5092b0b8049aThu, 14 Jun 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Add it as a trusted site in Excel Services; 2) Successfully created a SharePoint site; 3) Created a Report in Excel; 4) Publish a chart and a workbook; 5) Store your connection and your workbook in SharePoint Libraries; 6) Create a dashboard and populated it with your chart and KPI’s based of the data in your report.; 7) Populated it with data from a cubehttp://go.microsoft.com/?linkid=64261793a3b5ec3-c40c-4c12-bb5e-7eb24ffce9c8Thu, 15 Mar 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Learn Workbook Connections; 2) Learn OLAP Formula Auto-Complete; 3) Learn Key Performance Indicators (KPIs); 4) Learn Server defined formatting; 5) Learn Perspectives; 6) Learn Member properties; 7) Convert Pivot Table to Formulas; 8) Create new OLAP PivotTablehttp://go.microsoft.com/?linkid=6496246627f17b0-f01d-489f-9acf-cfc1536ca0dbTue, 27 Mar 2007 08:00:00 GMTIn this lab, you will learn to: 1) Redesign an upgraded OLAP database to take advantage of the new features in Analysis Services 2005; 2) Perform an in-place upgrade of Analysis Services 2000 to Analysis Services 2005; 3) Perform a side-by-side upgrade of Analysis Services 2000 to Analysis Services 2005http://go.microsoft.com/?linkid=48724788c25cc61-5bca-42ea-b16a-a32b48780265Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Familiarize users with the workspace; 2) Instruct users in the procedure for using already existing scorecard; 3) Instruct users in the procedure for modifying already existing scorecard; 4) Instruct users in the procedure for deploying a scorecard to a SharePoint sitehttp://go.microsoft.com/?linkid=59813087f14ec52-a69b-4116-aaf4-1fd6421c12b5Wed, 27 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) View Mining Accuracy Charts; 2) Create a Prediction Query; 3) Model Time Series; 4) Create Decision Tree and Naïve Bayes Data Mining Modelshttp://go.microsoft.com/?linkid=598130684755902-0613-48eb-ab8d-4e2b03e7e77eWed, 27 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Load ProClarity assets into a scorecard; 2) Navigate through the scorecard and view the ProClarity integration; 3) Create a report view in an existing scorecard and loading ProClarity assets into themhttp://go.microsoft.com/?linkid=6949310c1bd9603-93d8-49c2-a327-f9881ff29dacThu, 14 Jun 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Learn Server defined formatting; 2) Learn Key Performance Indicators (KPIs); 3) Learn Perspectives; 4) Create new OLAP PivotTable; 5) Learn Member properties; 6) Learn OLAP Formula Auto-Complete; 7) Convert Pivot Table to Formulas; 8) Learn Workbook Connectionshttp://go.microsoft.com/?linkid=6949292851e9260-a842-42fd-a07f-65b07ecf8208Thu, 14 Jun 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Monitor the progress of an SSIS package; 2) Log results from an SSIS package to both a text file and the Windows Event log; 3) Create an SSIS package project; 4) Create a SQL Server 2005 Integration Services (SSIS) packagehttp://go.microsoft.com/?linkid=59917666a7bb12c-fb5a-44de-b8b1-06595076b932Thu, 28 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Understand how model item properties affect end user reporting; 2) Auto-generate a Report Model in Model Designer; 3) Refine the model using model item properties; 4) Understand how model item properties affect end user reporting; 5) Auto-generate a Report Model in Model Designer; 6) Refine the model using model item propertieshttp://go.microsoft.com/?linkid=599176471ee6f3d-d983-48a3-bca3-08b9bacff1b0Thu, 28 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create an Analysis Services cube; 2) Create dimension attributes and hierarchies; 3) Create calculated members and Key Perfomance Indicators (KPIs)http://go.microsoft.com/?linkid=598130569024a52-4df1-44b0-8f94-b3df4a9a34c7Wed, 27 Dec 2006 08:00:00 GMTIn this lab, you will learn to: 1) Manually migrate DTS packages to SSIS; 2) Perform migrations by using an in-place or a side-by-side upgrade of SS2000 to SQL Server 2005; 3) Review the support that is available for managing, editing, and executing DTS packages after you upgrade the packages to SSIShttp://go.microsoft.com/?linkid=48724779f2ea87b-daa4-4fef-83b6-d8bfb99cf81fTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Perform a side-by-side upgrade of Reporting Services 2000 to Reporting Services 2005; 2) Perform an in-place upgrade of Reporting Services 2000 to Reporting Services 2005; 3) Review the security requirements and execution features of Report Builder; 4) Perform report project upgrades and deployments by using a new instance of Reporting Services 2005http://go.microsoft.com/?linkid=48724769e5e5eae-8342-44ba-91b0-6fd467850ea1Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create a report view in an existing scorecard and loading ProClarity assets into themhttp://go.microsoft.com/?linkid=6496244f55f0b99-1096-48dd-a3c3-0a9114dee7afTue, 27 Mar 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Explore metadata; 2) Query the CDC table to retrieve captured information; 3) Enable and Set up change data capture (CDC)http://go.microsoft.com/?linkid=7619173ae899724-1484-47d1-be1e-6be23302b3beTue, 23 Oct 2007 08:00:00 GMTAfter completing this lab you will be better able to: 1) Add local cache support to a Windows Forms application; 2) Create an application that supports synchronizing; 3) Create a one-way sync of three lookup tableshttp://go.microsoft.com/?linkid=7695051d9a7ed97-dc03-4067-81f3-1d0eb7d068e7Mon, 05 Nov 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create an object model from the database and customization of mapping between objects and tables; 2) Utilize data access tasks; 3) Use code generation to create the Object modelhttp://go.microsoft.com/?linkid=7126745a31f7977-2cec-4e7c-be64-bbdc5d3ec847Mon, 16 Jul 2007 08:00:00 GMTIn this lab, you will learn to: 1) Fix issues reported by Upgrade Advisor; 2) Prepare the SQL Server 2000 environment for the in-place version upgrade; 3) Perform version upgrade of the SQL Server 2000 environment to SQL Server 2005; 4) Execute Microsoft SQL Server 2005 Upgrade Advisor to determine possible upgrade issueshttp://go.microsoft.com/?linkid=48724792304be00-08f4-44d8-a0e9-1f1394dd5283Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Restore and upgrade the database.; 2) Back up the source database and review instance-level objectshttp://go.microsoft.com/?linkid=48724808509981f-edd9-42ca-b40e-abc939f4a70dTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Review and execute the SSIS package.; 2) Use the Copy Database Wizard to create and save an SQL Server Integration Services (SSIS) package.http://go.microsoft.com/?linkid=48724818ddbe9a4-f822-4581-9d70-a80597b3f970Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Review the source environment to detect server objects that you must migrate manually; 2) Upgrade a SQL Server 2000 database to a SQL Server 2005 database by using the detach and attach method; 3) Perform post-installation tasks that are required to migrate a SQL Server 2000 environment to a SQL Server 2005 environmenthttp://go.microsoft.com/?linkid=4872482712b0cc2-aa5b-40a0-a5b2-84aef347b332Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Build a Windows application displaying a bound data grid; 2) Execute a long-running queryhttp://go.microsoft.com/?linkid=4267443214bd510-b1f8-40ea-96e1-0e8bbc3c95d0Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Use SqlDependency and SqlNotifications; 2) Build a Windows application displaying a bound data grid.http://go.microsoft.com/?linkid=42674447d0af927-6708-499e-9950-8510eeba3329Tue, 20 Jun 2006 08:00:00 GMTIn this lab you will have access to: 1) Free-form SQL Server 2005 environmenthttp://go.microsoft.com/?linkid=46825170ffe6d57-bcb0-4c91-8195-d745d5824374Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Log results from a SSIS package; 2) Monitor the progress of a SSIS package; 3) Create a SQL Server Integration Services (SSIS) packagehttp://go.microsoft.com/?linkid=42674094216a298-41a4-49ea-8cdf-f02bb9534974Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Use the new SQL Server Management Studio; 2) Perform basic SQL Server administration taskshttp://go.microsoft.com/?linkid=426744165d361cf-ef79-44ee-8086-0242008b0726Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Understand how model item properties affect end user reporting; 2) Refine the model using model item properties; 3) Auto-generate a Report Model in Model Designerhttp://go.microsoft.com/?linkid=45405780da5ec36-35ae-4176-8676-922174b0e631Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Add a chart to a report; 2) Create a report that retrieves data from an object data source; 3) Filter the data shown on a report; 4) Customize sorting and grouping on a reporthttp://go.microsoft.com/?linkid=4540581c3ba7493-87ae-4cad-beee-0b2fe40c13a0Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Manage Security; 2) Create a List Report; 3) Create a Report Using the Wizardhttp://go.microsoft.com/?linkid=4267440871bfc41-641f-4eeb-b1cc-204c1df3078dTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Script out database objects with SMO; 2) Create Tables and Databases with Server Management Objects (SMO); 3) Back up databases with SMOhttp://go.microsoft.com/?linkid=4267446db0c50a3-625a-42fb-8257-16b2a2e3df63Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Write programs that service queues in both TSQL and SQLCLR; 2) Use the SqlDependency class to receive query notifications; 3) Create and configure message types, contacts, queues, and services; 4) Understand the relationship between the different Service Broker Constructshttp://go.microsoft.com/?linkid=454058466bddada-cadf-4ecc-b9fb-d2d740405971Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Use the SQL Profiler to troubleshoot deadlocks; 2) Generate a query plan for a poorly performing query; 3) Use the Database Tuning Advisorhttp://go.microsoft.com/?linkid=4267449ff6ba570-60dd-41ce-be4b-89d5a2833f5cTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Handle Exceptions in T-SQL; 2) Use the new PIVOT and UNPIVOT operators; 3) Use Recursive Query Expressionshttp://go.microsoft.com/?linkid=4267445ab5a8acd-bd0c-4166-b4ab-9f5642ea19ccTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create HTTP Endpoints; 2) Consume HTTP Endpointshttp://go.microsoft.com/?linkid=426744766ae895c-6ceb-4059-babf-fe1661621212Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Store XML data in a table; 2) Query XML data using a variety of mechanisms; 3) Modify XML datahttp://go.microsoft.com/?linkid=4267442bcb1a1d1-a891-4888-9f6f-bd2b155f34a7Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Use ProClarity to Share Analysis and Extend Collaboration; 2) Use the ProClarity Analytics Server to Analyze Results Produced in the Dashboard; 3) Facilitate Business Performance Monitoring with the ProClarity Dashboard; 4) Facilitate Unstructured Analysis of Data with ProClarity Professionalhttp://go.microsoft.com/?linkid=6025652fd0da7e2-8a5a-45f7-9ca4-1d334df073efTue, 09 Jan 2007 08:00:00 GMTAfter completing this lab you will be better able to: 1) Work with Change Data Capture in SQL Server 2008http://go.microsoft.com/?linkid=83680611c30fc30-5c3c-442e-b4ac-b6a75347067aFri, 22 Feb 2008 15:17:27 GMTAfter completing this lab you will be better able to: 1) Work with Change Data Capture in SQL Server 2008http://go.microsoft.com/?linkid=8781616f7de6088-c5f1-4b37-a1ca-a5c88c08f393Thu, 24 Apr 2008 19:13:47 GMTAfter completing this lab you will be better able to: 1) Create instances of spatial data types; 2) Use spatial data type methods; 3) Create spatial indexeshttp://go.microsoft.com/?linkid=83680621736307b-046e-416f-b717-a1a6fdfa78a7Fri, 22 Feb 2008 15:19:27 GMTAfter completing this lab you will be better able to: 1) Create instances of spatial data types; 2) Use spatial data type methods; 3) Create spatial indexeshttp://go.microsoft.com/?linkid=8781617783a9fa7-1948-4002-9566-b7e2bc6ad78dThu, 24 Apr 2008 19:15:05 GMTIn this lab, you will learn to: 1) Use the built-in methods of the XML data type to execute XQuery queries; 2) Execute XQuery and T-SQL together; 3) Modify XML data by using XQueryhttp://go.microsoft.com/?linkid=45336543b40971c-00a8-413f-b544-6e3a6714600aTue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be more familiar with: 1) Use the new date/time related datatypes and their related functions; 2) Explore DATE and TIME datatypes; 3) Work with the DATE/TIME datatypes; 4) Modify T-SQL to benefit from the date datatypehttp://go.microsoft.com/?linkid=7619174c1fdbbaa-5bdb-42ff-b403-e94909c200a6Tue, 23 Oct 2007 08:00:00 GMTIn this lab, you will learn to: 1) Create calculated members and Key Performance Indicators (KPIs); 2) Create dimension attributes and hierarchies; 3) Create an Analysis Services cubehttp://go.microsoft.com/?linkid=45405775d471544-9ba1-4923-8006-373cbc203599Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create a report using the Report Designer; 2) Add a list item and a chart item to a report; 3) Design a report to satisfy a specific information requirementhttp://go.microsoft.com/?linkid=6018904ed052e2a-0adf-4220-8b4e-d1bad7ebbaaaTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create a simple matrix report using the Report Wizard; 2) Create a simple tabular report using the Report Wizard; 3) Create a tabular report with subtotals using the Report Wizardhttp://go.microsoft.com/?linkid=4267400cf8f37ab-b66a-46e4-b952-b5ce90038b22Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Publish a chart and a workbook; 2) Store your connection and your workbook in SharePoint Libraries; 3) Create a dashboard and populate it with your chart and KPI’s based of the data in your report.; 4) Create a Report in Excel; 5) Successfully create a SharePoint sitehttp://go.microsoft.com/?linkid=642617874820aac-fa2a-47d4-b3c1-bd120b207d83Thu, 15 Mar 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Convert Pivot Table to Formulas; 2) Learn Key Performance Indicators (KPIs); 3) Learn Perspectives; 4) Create a new Online Analytical Processing (OLAP) PivotTable; 5) Learn Member properties; 6) Learn OLAP Formula Auto-Complete; 7) Learn Workbook Connections; 8) Learn Server defined formattinghttp://go.microsoft.com/?linkid=6496245133a858f-325a-4496-a78a-a5df882ba54dTue, 27 Mar 2007 08:00:00 GMTIn this lab, you will learn to: 1) Perform an in-place upgrade of Analysis Services 2000 to Analysis Services 2005; 2) Perform a side-by-side upgrade of Analysis Services 2000 to Analysis Services 2005; 3) Redesign an upgraded OLAP database to take advantage of the new features in Analysis Services 2005http://go.microsoft.com/?linkid=48724711c2254de-084c-4b54-8e3a-2050c7a9658aTue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Use the ProClarity Analytics Server to Analyze Results Produced in the Dashboard; 2) Facilitate Unstructured Analysis of Data with ProClarity Professional; 3) Facilitate Business Performance Monitoring with the ProClarity Dashboard; 4) Use ProClarity to Share Analysis and Extend Collaborationhttp://go.microsoft.com/?linkid=60256533cd09e27-d66d-4dda-be62-b58e2fb25a8bTue, 09 Jan 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Instruct users in the procedure for modifying already existing scorecard; 2) Familiarize users with the workspace; 3) Instruct users in the procedure for using already existing scorecard; 4) Instruct users in the procedure for deploying a scorecard to a SharePoint sitehttp://go.microsoft.com/?linkid=59813090be7e040-8d45-4595-a19d-e2425a4403beWed, 27 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Model Time Series; 2) View Mining Accuracy Charts; 3) Create a Prediction Query; 4) Create Decision Tree and Naïve Bayes Data Mining Modelshttp://go.microsoft.com/?linkid=5981307d2047218-c511-4e8b-89e4-99d4a27354a8Wed, 27 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create a SQL Server 2005 Integration Services (SSIS) package; 2) Monitor the progress of an SSIS package; 3) Create an SSIS package project; 4) Log results from an SSIS package to both a text file and the Windows Event loghttp://go.microsoft.com/?linkid=59917677ae3e7e2-eec1-4649-9903-648a08d913baThu, 28 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Refine the model using model item properties; 2) Auto-generate a Report Model in Model Designer; 3) Understand how model item properties affect end user reportinghttp://go.microsoft.com/?linkid=5991765023567e2-bcac-44e6-97f5-bf176887a933Thu, 28 Dec 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create a Report Using the Wizard; 2) Create a List Report; 3) Work with Reports; 4) Manage Securityhttp://go.microsoft.com/?linkid=690156222d1a98c-4c01-4b3d-9ea9-374ca0a1e4ecMon, 04 Jun 2007 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create dimension attributes and hierarchies; 2) Create an Analysis Services cube; 3) Create calculated members and Key Perfomance Indicators (KPIs)http://go.microsoft.com/?linkid=5981304f040b11b-3700-4e39-9bba-642d8cf8f44aWed, 27 Dec 2006 08:00:00 GMTIn this lab, you will learn to: 1) Review the support that is available for managing, editing, and executing DTS packages after you upgrade the packages to SSIS; 2) Manually migrate DTS packages to SSIS; 3) Perform migrations by using an in-place or a side-by-side upgrade of SS2000 to SQL Server 2005http://go.microsoft.com/?linkid=4872470e32bfff7-6710-4c30-9e87-7de4bb33a9fdTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Perform report project upgrades and deployments by using a new instance of Reporting Services 2005; 2) Perform a side-by-side upgrade of Reporting Services 2000 to Reporting Services 2005; 3) Review the security requirements and execution features of Report Builder; 4) Perform an in-place upgrade of Reporting Services 2000 to Reporting Services 2005http://go.microsoft.com/?linkid=48724694c0409df-3265-419e-a5d2-1af7160958b6Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Create a report view in an existing scorecard and loading ProClarity assets into themhttp://go.microsoft.com/?linkid=64962438ec1c55c-b93e-4658-843a-5b0e53ba8e07Tue, 27 Mar 2007 08:00:00 GMTAfter completing this lab you will be better able to: 1) Create Decision Tree and Naïve Bayes data-mining models; 2) View mining accuracy charts; 3) Create a prediction query; 4) Create a Time Series modelhttp://go.microsoft.com/?linkid=87816235cccf3b6-f453-41f9-9916-288d7c6b1c68Thu, 24 Apr 2008 19:23:29 GMTAfter completing this lab you will be better able to: 1) Add local cache support to a Windows Forms application; 2) Create an application that supports synchronizing; 3) Create a one-way sync of three lookup tableshttp://go.microsoft.com/?linkid=7530770052b535e-e578-470c-9a58-6868a74c24caTue, 30 Oct 2007 08:00:00 GMTAfter completing this lab you will be better able to: 1) Publish reports with Report Designer; 2) Publish reports with Report Manager; 3) Organize reports; 4) Modify shared data source configurationshttp://go.microsoft.com/?linkid=42673797f989d37-887c-488b-bc66-bc050a832c3bTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Estimate total number of hours to complete a manual conversion; 2) Successfully generate an Assessment Report; 3) Identify potential conversion problemshttp://go.microsoft.com/?linkid=4528054bf0776c9-4e58-49ce-b855-47bfa04640d9Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab you will be better able to: 1) Create a Monthly Report in several different ways; 2) Use the Report wizardhttp://go.microsoft.com/?linkid=89580265b6dfcf8-318e-4997-8836-d32050c6280eThu, 22 May 2008 16:05:10 GMTIn this lab, you will learn to: 1) Back up the source database and review instance-level objects; 2) Restore and upgrade the database.http://go.microsoft.com/?linkid=4872473831e3f2e-f17c-4029-83e4-0808c00cb366Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Use the Copy Database Wizard to create and save an SQL Server Integration Services (SSIS) package.; 2) Review and execute the SSIS package.http://go.microsoft.com/?linkid=48724743fc5560f-ca41-4736-b9ae-ca7ce492bb7fTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Perform version upgrade of the SQL Server 2000 environment to SQL Server 2005; 2) Prepare the SQL Server 2000 environment for the in-place version upgrade; 3) Execute Microsoft SQL Server 2005 Upgrade Advisor to determine possible upgrade issues; 4) Fix issues reported by Upgrade Advisorhttp://go.microsoft.com/?linkid=4872472223d4609-617c-46d3-a19d-30db27b01c1eTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Review the source environment to detect server objects that you must migrate manually; 2) Perform post-installation tasks that are required to migrate a SQL Server 2000 environment to a SQL Server 2005 environment; 3) Upgrade a SQL Server 2000 database to a SQL Server 2005 database by using the detach and attach methodhttp://go.microsoft.com/?linkid=4872475b6603105-87d1-4e02-860c-414230ebe273Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create and subscribe to a report; 2) View reports using Report Services; 3) Use Microsoft CRM 1.2 Report Packhttp://go.microsoft.com/?linkid=42673803f318f6f-b122-4da7-8d8c-9ce71c07ce51Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Run and modify the Smart Client; 2) Deploy and run and upgrade using ClickOnce; 3) Use the .NET Framework and the Global Application Cachehttp://go.microsoft.com/?linkid=4267389bba32d07-2eab-4fa2-916c-588af309cfc3Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Execute a long-running query; 2) Build a Windows application displaying a bound data gridhttp://go.microsoft.com/?linkid=4528093d6436439-ebb9-4cb7-a768-878ca945346eTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Build a Windows application displaying a bound data grid; 2) Use SqlDependency and SqlNotificationshttp://go.microsoft.com/?linkid=452809677d8964a-9b9b-46c6-a9da-46e81375c4fbTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create Decision Tree and Naive Bays Data Mining Models; 2) Create a Prediction Query; 3) View Mining accuracy charts; 4) Model Time Serieshttp://go.microsoft.com/?linkid=4554215740e645b-a330-41de-8489-3ca7b9bbb249Tue, 20 Jun 2006 08:00:00 GMTIn this lab you will have access to: 1) Free-form SQL Server 2005 environmenthttp://go.microsoft.com/?linkid=468251812510267-a654-4b01-9a05-c3acf1b8c783Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Monitor the progress of a SSIS package; 2) Create a SQL Server Integration Services (SSIS) package; 3) Log results from a SSIS packagehttp://go.microsoft.com/?linkid=45280757e174b23-f460-412e-bb44-fab66f1f20ecTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Use the new SQL Server Management Studio; 2) Perform basic SQL Server administration taskshttp://go.microsoft.com/?linkid=45280783e2cc875-5838-4f22-9679-cc820eb88bedTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Refine the model using model item properties; 2) Understand how model item properties affect end user reporting; 3) Auto-generate a Report Model in Model Designerhttp://go.microsoft.com/?linkid=454058059f86d82-8da1-408c-89c2-84ac269f6d24Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create a List Report; 2) Manage Security; 3) Create a Report Using the Wizardhttp://go.microsoft.com/?linkid=45280810a63bb06-d38d-45e9-ad13-5a23430c8da8Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create a report that retrieves data from an object data source; 2) Add a chart to a report; 3) Filter the data shown on a report; 4) Customize sorting and grouping on a reporthttp://go.microsoft.com/?linkid=4540583552a5cd2-2ac8-42de-b0bb-38472f4e7f6aTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Create Tables and Databases with Server Management Objects (SMO); 2) Back up databases with SMO; 3) Script out database objects with SMOhttp://go.microsoft.com/?linkid=4528084bd0a7b61-d1e2-4e0a-ae6e-e80027931107Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Use the SqlDependency class to receive query notifications; 2) Understand the relationship between the different Service Broker Constructs; 3) Write programs that service queues in both TSQL and SQLCLR; 4) Create and configure message types, contacts, queues, and serviceshttp://go.microsoft.com/?linkid=4540586a83a67b0-5416-45b0-8490-136bfa2b3cf1Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Generate a query plan for a poorly performing query; 2) Use the SQL Profiler to troubleshoot deadlocks; 3) Use the Database Tuning Advisorhttp://go.microsoft.com/?linkid=45280905335aa3a-ddef-4b2c-90ee-15b7224c50a3Tue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Handle Exceptions in T-SQL; 2) Use Recursive Query Expressions; 3) Use the new PIVOT and UNPIVOT operatorshttp://go.microsoft.com/?linkid=452809923ccbe15-ff50-41b3-bfd5-15f2ea2ac2fbTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Consume HTTP Endpoints; 2) Create HTTP Endpointshttp://go.microsoft.com/?linkid=4528102b26af531-1272-4630-9089-75379a20a3abTue, 20 Jun 2006 08:00:00 GMTIn this lab, you will learn to: 1) Query XML data using a variety of mechanisms; 2) Store XML data in a table; 3) Modify XML datahttp://go.microsoft.com/?linkid=45281055473b938-6296-44ad-878c-bbed235f89c6Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab you will be better able to: 1) Browse a Microsoft® SQL Server® 2008 Analysis Services cube by using Microsoft Office Excel® 2007; 2) Use Online Analytical Processing (OLAP) formulas in Microsoft Office Excel 2007; 3) Display Analysis Services Key Performance Indicators in Microsoft Office SharePoint® Server 2007http://go.microsoft.com/?linkid=8781622595d9bf6-5531-4eae-a531-1bf7924c6bffThu, 24 Apr 2008 19:22:12 GMTAfter completing this lab you will be better able to: 1) Manage a Microsoft® SQL Server® Analysis Services instance and database; 2) Secure Analysis Services; 3) Monitor Analysis Services performancehttp://go.microsoft.com/?linkid=87816216f815c29-6c69-4e5a-a3e7-4d8d8487ed3eThu, 24 Apr 2008 19:20:54 GMTAfter completing this lab you will be better able to: 1) Demonstrate how unencrypted data can be stolen by restoring a backup file; 2) Encrypt sensitive data by using Transparent Data Encryption; 3) Demonstrate that an encrypted database cannot be stolen by restoring a backup filehttp://go.microsoft.com/?linkid=9636896ab0b027e-5509-4bae-bc3f-d0bbe7e6facbMon, 17 Nov 2008 17:23:26 GMTIn this lab, you will learn to: 1) Execute XQuery and T-SQL together; 2) Modify XML data by using XQuery; 3) Use the built-in methods of the XML data type to execute XQuery querieshttp://go.microsoft.com/?linkid=45336523ed73c1c-26fa-4c8d-a3c1-cdcd826edaa2Tue, 20 Jun 2006 08:00:00 GMTAfter completing this lab, you will be better able to: 1) Implement and work with change data capture; 2) Use the new datatypes included in SQL Server 2008; 3) Implement a naming convention policy using Declarative Management; 4) Implement table valued parametershttp://go.microsoft.com/?linkid=761917275ce1625-3b9b-4780-b68f-0f2ffd83992dTue, 23 Oct 2007 08:00:00 GMT