Category Archives: Auditing

How to Export SQL Profiler / Trace to SQL Server as table ?

Posted by Mahesh Gupta on December 28, 2011 0 comments

I am running a running a SQL Server Profiler, a graphical tool to track SQL Server Activities, I am done with my analysis but prior to close SQL Server Profiler Tool, Can I save the result in SQL Server or in Excel ? Can I export SQL Server Profile / Trace file data to SQL [...]

Find All SQL Servers in your Local Network

Posted by Mahesh Gupta on September 21, 2010 2 comments

Today, somebody asked me, how can I find what all are SQL Server Instances are running in my local network. I was shocked, I thought every DBA must know, what SQL servers are running in your network. This question was being asked by a sys admin guy, who wanted make an inventory list by finding [...]

"Black Box" in SQL Server 2008

Posted by Mahesh Gupta on September 13, 2010 0 comments

In SQL Server 2008, the Default trace is enabled by default during the installation and this default trace in SQL Server 2008 acts as a Black box for the SQL Server. Hence it is also called as "Black Box" in SQL Server 2008 and  the default trace cannot be stopped by using the Query "Exec sp_trace_setstatus 'Trace_id',0 –0 [...]

SQL Monitoring with DDL Triggers

Posted by Mahesh Gupta on September 7, 2010 2 comments

We can create a DDL trigger to audit operations such as creating or dropping tables. DDL triggers are a very powerful tool for monitoring the actions that occur in a database. The other category of trigger is standard triggers, which can only respond to changes in data, data definition language (DDL) triggers can be used [...]

New Features of SQL Server 2008

Posted by Mahesh Gupta on August 12, 2010 2 comments

Here is the list of top 51 features of SQL Server 2008 which are present in SQL Server 2008 sales Boucher. My objective to cover all new features of SQL Server 2008 with detailed concept delivery with videos. Policy-Based Management Policy-Based Management is a policy-based system for managing one or more instances of SQL Server [...]

Default Trace in SQL Server

Posted by Mahesh Gupta on July 12, 2010 0 comments

SQL Server 2008 and 2005 has a default trace running. As BOL states: “Default trace provides troubleshooting assistance to database administrators by ensuring that they have the log data necessary to diagnose problems the first time they occur.” The default trace provides auditing on schema modifications such as table creation and stored procedure deletion etc [...]

SQL Server 2008 Enterprise and Standard Feature Compare

Posted by Mahesh Gupta on July 7, 2010 0 comments

The question frequently asked, which features are supported in which editions of SQL Server. The table below provides a high level comparison of the key capabilities between SQL Server 2008 Enterprise and Standard: Detailed Feature Comparison SQL Server 2008 Enterprise SQL Server 2008 Standard Scalability & Performance Number of CPUs OS Maximum 4 x32 hardware [...]