I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 R2 with the Express version, and SSMS just wouldn't ...

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

The built in "script data" tooling in SQL Management Studio 2008 R2 is broken for me because of spurious "cyclical foreign keys" errors. Plus the "generate scripts" itself has gone from clunky but ...

The differences between this release and the SQL Server 2008 R2 SP3 release from last week are distinct enough to warrant separate releases. As soon as we told you boldly that SQL Server 2008 R2 SP3 ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...