Monthly Archives: August 2013

A Quick Tutorial for Auditing DML Actions in a Database

I was recently asked to “capture” which account made a possible delete/truncate operation regularly against a table in a specific database. And I landed on this article through google and found it a very useful tutorial for setting up an … Continue reading

Posted in SQL Server | Tagged | Leave a comment

Two Ways to Control Services on a Remote Computer in Powershell

I am just making a note here about the two alternatives that I found via Google. The first one is on Hey! Scripting Guy’s blog post and the second one is here. To wrap up, I am summing up the … Continue reading

Posted in Powershell | Leave a comment

SQL Server Service Stuck in ‘Starting’ Status

Bumped into this problem today with MSSQLSERVER service stuck at “starting” status. Here is the original article with illustrative screen shots, I am going a bit “roughly speaking” below: Open a command window by pressing windows key + R Type … Continue reading

Posted in SQL Server | Tagged | Leave a comment

T-SQL Stored Procedure to Get the Number of DB Connections and Logins per Database

Posted in SQL Server | Tagged | Leave a comment

T-SQL Stored Procedure to Get the Time and Backup File Location of the Last Data Restore

Posted in Backup and Restore, T-SQL Script | Tagged , | Leave a comment