As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

Microsoft’s first major release of SQL Server in many years includes such sweeping improvements that it’s sometimes hard to see the old SQL Server underneath. Not a single area of the database remains ...

Policy-Based Management and PowerShell integration are the biggies, but Management Studio has added some other nice features, such as Server Groups, which allows you to run queries against multiple ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...

With the assistance of a heavily armed and battle-ready robot, Microsoft Corp. executive Paul Flessner today promised that new versions of the company’s enterprise database, application development ...

A year from now, Microsoft will stop supporting SQL Server 2005 entirely, so the push is on to migrate customers to newer editions or to Azure Earlier this week, Microsoft reminded SQL Server 2005 ...