SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our ...

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.” ...

A Sharper Profile An old SQL tool you probably won't recognize in its SQL 2005 incarnation is the SQL Server Profiler, shown in Figure 1 below.

SQL Trace is the heart of SQL Server 2000’s auditing capabilities. In fact, Microsoft resurrected SQL Trace, which had been downplayed in SQL Server 7.0, specifically to facilitate auditing.

When SQL Server Management Studio is already open, the easiest way to open SQL Profiler is to click on the Tools dropdown menu. Then select "SQL Server Profiler" from the menu.

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

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

A relational database server offering tools for data storage, management, analysis, and reporting, SQL Server Enterprise Edition provides all of these. Business Intelligence Edition and the Enterprise ...