Computerworld

Auditing in SQL Server 2000

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...
Network World

Universal Health Care for SQL Server? SQL Profiler – 2008 style…

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 current ...
GitHub

set-a-maximum-file-size-for-a-trace-file-sql-server-profiler.md

Discover how to limit the size of the trace file in SQL Server Profiler and how to specify whether the file rolls over when it reaches maximum size. [!INCLUDE SQL Server] Use the following procedure ...
Computerworld

SQL Trace: Back again, and better than ever

One of the more essential SQL Server tools is its trace utility. With it you can view the activity occurring against a SQL Server for diagnostic, informational, and other purposes. Because it lets you ...
Network World

SQL Profiler keeps an eye on those Wizards

In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...