Denny's SQL Secrets Troubleshoot Slow-Running Queries In SQL Server Denny breaks down how to identify and fix speed issues in multiple versions of SQL Server. By Denny Cherry 12/11/2013 ...

One feature that helps us quickly set up a trace on our current connection is new in SSMS 2008, namely “Trace Query in SQL Server Profiler”. Let’s take a look.

SQL Profiler and SQL Trace: These two features are the graphic and textual interface to trace SQL Server performance data by capturing and saving details about a given set of trig­gering “events.” ...

The SQL Profiler has a neat Deadlock Graph feature which is very useful. Let’s take a look…. When SQL Server detects a deadlock, it has to do something about it.

Idera, a leading provider of application and server management solutions, today announced the availability of SQL XEvent Profiler 1.0, a free tool that allows DBAs to create, run and view SQL ...

A recently discovered vulnerability in Microsoft's SQL Server 2000 database allows users to mask their log-in names.

Warnings Information in this article applies to Microsoft SQL Server 2012. The instructions for earlier versions of SQL Server, including versions 2008 and 2005, are similar.