SQL Server 2008 R2: High Availability
SQL Server 2008 R2 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log ...
SQL Server 2008 R2: Implementing Programming Objects
In SQL Server 2008 R2 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one ...
SQL Server 2008 R2: Installation
SQL Server 2008 R2 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, Business Intelligence Development studio, and the SQL ...
SQL Server 2008 R2: Instance and Database Configuration
SQL Server 2008 R2's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. ...
SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes
SQL Server 2008 R2 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server's Service Broker ...
SQL Server 2008 R2: Performing Advanced Query Techniques
Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the ...
SQL Server 2008 R2: Querying and Managing XML Data
XML has been integrated into SQL Server 2008 R2 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type ...
SQL Server 2008 R2: Running Queries and Manipulating Data
SQL Server 2008 R2 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the ...
SQL Server 2008 R2: Security Management
Microsoft SQL Server 2008 R2 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 R2 security features, administrators can guarantee that access to a SQL ...