Wiley 978-0-7645-7755-0 Datenblatt

Chapter 2New Features in SQL Server 2005In This Chapter䊳 Checking out SQL Server’s improved security features䊳 Finding out about other SQL Server 2005

Concurrent data accessConcurrent data access is about getting to data when others are also access-ing it:⻬ Database snapshots: Creates a logical copy

⻬ Finer Grained Online Repairs: You can restore data filegroup by file-group with the database being available after the primary filegroup isrestored.

You can also partition indexes. If the partitions for data and for indexes arealigned, you can move partitions into or out of a table. This is useful

Transformation Services, and Reporting Services builds on the features ofReporting Services 2000 that was first released early in 2004.Business Intell

34Part I: SQL Server 2005: An Overview 06_577557 ch02.qxp 12/20/05 9:43 PM Page 34

exposed on the Internet. SQL Server has to give you the tools to keep yourdata safe in order to allow the right people to access data that you want th

Automated certificate creation for SSLIn SQL Server 2000, when using Secure Sockets Layer (SSL) to log in to a SQLServer instance, you had to manually

Transact-SQL templatesIn SQL Server Management Studio, you can find many templates to help youcarry out common tasks with Transact-SQL. To view the ra

New datatypesSQL Server 2005 supports several new datatypes:⻬ varchar(max): This allows you to use sequences of characters greaterthan 8000 bytes (800

HTTP endpointsHTTP access to SQL Server 2005 is a new feature that allows programmers toaccess SQL Server without depending on an IIS server running o

⻬ DTS Server (for SQL Server Integration Services)⻬ Full-text Search⻬ SQL BrowserProfilerProfiler has many features that allow you to analyze performa

Full-text searchYou can back up and restore Full-text Search catalogs (the databases wherethe metadata is stored) in the same way as you back up and r

Easier updatesSystem objects are in the resource database in SQL Server 2005. When aservice pack or other update is applied to a SQL Server instance,