Category Archives: SQL Server Tools

Running SQLDiag as Agent Job


This was the discussion of last evening, which was started after we receive a similar request from a specific team. The team wanted to start this trace by themselves without involving the DBAs. One of the possibility was to run … Continue reading

Posted in Automation in SQL Server, How To, Just Learned, SQL Server Tools | Tagged , , | Leave a comment

Standard Reports in SSMS 2008 R2


I am using SQL Server Management Studio (2008 R2) for quite some times and found the Standard Reports feature is very helpful. In case you have not tried it so far, there are various reports available when you install SQL … Continue reading

Posted in How To, SQL Server, SQL Server Tools | Tagged | 2 Comments

Loading Data with BCP


BCP or Bulk Copy Program is one of oldest part of SQL Server. BCP is a lightweight software used to import/export data between the SQL Server instances quickly. If you ever want to backup a single table in SQL Server, … Continue reading

Posted in SQL Server Tools | Leave a comment