Did you know that there is a set of pre-made reports in Management Studio that can help database administrators gather information in many common areas? There are reports for CPU, memory, disk, sessions, queries, transactions, and more baked right into Management Studio. You can access these reports in SQL Server 2005 and SQL Server 2005 SP1 by following these steps......

As part of my web cast, there are several URLs and sample scripts that I’d like to share with you. Demo 0 – Downloading. The URL that I use to find the download site for SQL Server Express is to start at: http://msdn.microsoft.com/sql/ . It...

Now that SQL Server Express and SQL Server Management Studio Express are out the door as part of the SQL Server 2005 SP1 release , it's time to take a close look at SSMS-E. I will be presenting a 60 minute web cast to show how the tools work great together...