Microsoft SQL Server 2005: A Beginner''s Guide
It's been five years since Microsoft released a new version of SQL Server—which holds 39% of the Windows database market—and the latest edition of this bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench,T-SQL, automated administration tasks, security, and analysis.
SQL Server System Administration
Microsoft Analysis Services
2 other sections not shown
Other editions - View all
Accounting additional administrator aggregate allows ALTER application backup base belongs budget called changes Chapter choose clause column concerning connection constraint contains corresponding CREATE data type database database objects default defined DELETE described detail dialog box discussed disk displays document DROP emp_lname emp_no employee error Example execution existing Figure function GRANT important includes indices INSERT join language lock login Management means modify NOTE NULL objects operator optimizer option partition performance permissions possible primary project_no provides query relational replication restore result Returns role rows sample sample SELECT schema SELECT statement Server Management Studio Services shows specified SQL Server SQL Server Management step stored procedure supports syntax system procedure Transact-SQL statements transaction log trigger UPDATE values Windows works_on