Wednesday, September 4, 2013

SQL Server management tools that makes life easier (2)

SQL Server Management Studio
Microsoft first introduced SQL Server Management Studio (SSMS) in SQL Server 2005. Database developers use this SQL Server management tool to develop T-SQL queries; create objects such as tables, indexes, constraints, stored procedures, functions and triggers; and debug T-SQL code. At the same time, database administrators use SSMS to perform maintenance tasks, such as index rebuild, index recognize, backup and restore, and security management. You can even create various scripts for analysis services and manage SQL Server Database Engine, SQL Server Integration Services and Reporting Services.

No comments: