This tip shows you an option that exists within SSMS to automatically generate scripts for all table changes when using the table designer.  Read more...

Learn how to use the SSMS GUI to modify tables in this SQL School video.  Read more...

This article is the final article in a series that explores new features that are available in SQL Server 2008 Management Studio  Read more...

This article shows the new features that are available in SQL Server 2008 Management Studio   Read more...

SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.  Read more...

SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.  Read more...

Learn the basics of how to work with Management Studio in this SQL School video.  Read more...

Maintaining your database server is something every DBA or developer needs to do. This video shows how to setup a basic maintenance plan.  Read more...

SQL Server Management Studio (SSMS) is now the primary tool that we all use to manage SQL Server. Whenever I open up SSMS I always go through the same steps to connect to a server and open certain query files. Are there any shortcuts or alternative ways of starting SSMS?  Read more...

In this SQL School video, Brian Knight shows you how to create and use database diagrams in Management Studio.  Read more...

This video shows how you can use Management Studio to execute your Integration Services packages.  Read more...

Not everyone who had to use Management Studio when it first appeared in SQL Server 2005 liked it. The paint was still wet and there was still scaffolding around. To give Microsoft its credit, it has succeeded in transforming it into a much more useful product, in its SQL Server 2008 reincarnation.  Read more...

MVP Brian Knight walks through the scripting capabilities of Management Studio to show how the code for table creation and the various dependent objects. Brian looks at the options available with scripting and what the implication of choosing them will be.  Read more...

Read more...

SQL Server MVP Jacob Sebastian starts a new series looking at the changes in SQL Server 2008 to the management tools.  Read more...

Books Online will try to connect to the net and it may get stuck if there is no internet connection.  Read more...

Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.  Read more...

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...

This article examines the built in reports called SQL Server Management Studio Reports and an additional add-on called Performance Dashboard.  Read more...

There is not enough time in the day to keep it all straight! There is no shame in making use of any short cuts or cheats that allow you to be a more productive and well-versed SQL Professional in order to cope with the sheer volume of expectations you are required to meet on a daily basis.   Read more...

This article shows the new features that are available in SQL Server 2008 Management Studio   Read more...

This article is the final article in a series that explores new features that are available in SQL Server 2008 Management Studio  Read more...

Not everyone who had to use Management Studio when it first appeared in SQL Server 2005 liked it. The paint was still wet and there was still scaffolding around. To give Microsoft its credit, it has succeeded in transforming it into a much more useful product, in its SQL Server 2008 reincarnation.  Read more...