SQL Server Installation, good troubleshooting skills, Performance tuning (Table Partitioning). Experience in using tools like SQL Profiler, Performance Optimization, Extended Events, DMVs, Activity ...

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

To start a trace automatically after connecting to a server with SQL Server Profiler On the Tools menu, click Options. Select the Start tracing immediately after making a connection check box.

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.

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

Here’s a bit of trivia—due to its Sybase heritage, SQL Server was the only Microsoft product to offer the CPU affinity and affinity masking configuration setting for decades. In those early days of ...

IDERA today announced the availability of SQL Data Profiler, a free tool with a focus on the needs of data architects.