Module 1 Introduction to SQL Server® 2008 R2 and its Toolset Module Overview Introduction to the SQL Server Platform Working with SQL Server Tools Configuring SQL Server Services Lesson 1: Introduction to the SQL Server Platform SQL Server Architecture SQL ponents SQL Server Instances SQL Server Editions SQL Server Versions SQL Server Architecture Complete set of enterprise-ready technologies and tools More than a simple relational database management system anizational data Derive value from information within the data High performance High availability Secure Scalable Low total cost of ownership Highly integrated platform Productive management and development tooling SQL ponents Not just a database engine Relational and Business ponents SQL ponents Database Engine Analysis Services Integration Services Reporting Services Master Data Services StreamInsight Data Mining Full-Text Search PowerPivot Replication SQL Server Instances Many SQL ponents are instance-aware Database Engine Analysis Services / Data Mining Reporting Services Instances allows for isolation of Administration and Security Configuration Performance, Service Level Agreements Versions, Collations Can assist with upgrade scenarios Two instance types Default instance Named instances SQL Server Editions Premium Editions Parallel Data Warehouse Datacenter Core Editions Enterprise Standard Other Editions Express Compact Developer Workgroup Web SQL Azure SQL Server Versions Version Release Year
1989
1991
1992
1994
1995
1996
1998 2000 2000 2005 2005 2008 2008 2008 R2 2010 vNext TBD Lesson 2: Working with SQL Server Tools Connecting from Clients and Applications Software Layers for Connections SQL Server Management Studio Demonstration 2A: SQL Server Management Studio Business Intelligence Development Studio Demonstration 2B: Business Intelligence Development Studio Books Online Demonstration 2C: Books Online Connec