Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at. Pinal has authored 13 SQL Server database books and 40 Pluralsight courses. He holds a Masters of Science degree and numerous database certifications. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time. For a while DBA who were fans of Query Analyzer requested to bring it back, but as they keep on using SQL Server Management Studio (SSMS) they realized that it was much more convenient if every task related to SQL Server could be accomplished using SSMS. With the release of SQL Server 2005 both of these tools are combined into one tool: SQL Server Management Studio.

In SQL Server 2000, DBA had to use two different tools to maintain the database as well as the query database, specifically SQL Server Enterprise Manager and SQL Server Query Analyzer. I would like to say it is time to upgrade and move to the next version of SQL Server.

Honestly, I still see lots of people still using SQL Server 2000. SQL Server 2008 is a major improvement from SQL Server 2005. Images are used to explain the process easier. I have created this step by step guide Installation Guide. SQL SERVER 2008 has been released for some time and I have got numerous request about how to install SQL Server 2008.

Sql server enterprise manager