SQLUSA

The future is just a click away! Your future!

Microsoft SQL Server 2005 Best Practices

 

New Features in SQL Server 2005

 

Management Studio

  Includes All Tools
  Object Explorer replaces Enterprise Manager
  Query Editor Replaces Query Analyzer
  New Table Designer
  New Server Properties
  Server Registration Export/Import
  New Database Properties
  Template Explorer
  Solution Explorer
  Projects Management
  Web Browser Window
  Properties Window
  Assisted Editors
  Source Control
  XML Editor
  Toolbars Selection
  Dynamic Help

 

T-SQL Enhancements

  AdventureWorks Sample Database
  Database Schemas
  Script Storage in Project
  Xquery - XML Query Language
  XML Data Type
  varchar(max) & nvarchar(max) Data Types
  varbinary(max) Data Type
  PIVOT and UNPIVOT
  INTERSECT and EXCEPT
  OVER(PARTITION BY...)
  Recursive Query
  Common Table Expression - CTE
  RANK and DENSE_RANK
  NTILE
  ROW_NUMBER
  Partitioned Table, Partition Function, & Partition Scheme
  DDL Trigger
  .NET Assembly support
  CROSS APPLY and OUTER APPLY
  OUTPUT Clause
  TRY and CATCH for Exception Handling
  TOP and TABLESAMPLE Clauses
  EXECUTE AS Clause
  MARS - Multiple Active Result Sets
  Snapshot Isolation
  Indexes with Included Columns

 

SQL Server Profiler

  Deadlock Visualization
  Correlate a Trace with Windows Performance Log Data
  Save Trace as XML File

 

SQL Configuration Manager

  Replaces Services Manager
  Replaces Server Network Utility
  Replaces Client Network Utility

 

SQL Server 2005 Surface Area Configuration

  Surface Area Configuration for Services and Connections
  Surface Area Configuration for Features

 

Utilities

  SQLCMD utility with new scripting language
  Dedicated Administrator Connection(DAC) to Server
   

 

Security

  CREATE CERTIFICATE
  Encryption
  Decryption
  Asymmetric Key
   

 

Operations

  Setup Consistency Checker
  Online Database Restore
  Online Reindex
  Mirrored Backups
  Database Mirroring
  Database Snapshot
  Database Tuning Advisor
   

The World Leader in SQL Server Training

The future is just a click away! Your future!

SQLUSA.com Home Page