Monthly Archives: March 2017

SQL Server Database Recovery Process Internals – database STARTUP Command

Posted on March 28, 2017 by Prashanth Jayaram

A database recovery process is an essential requirement for database systems, It can be a tedious job and the process of recovery varies on a lot of scenarios. The desire to improve recovery results has resulted in various procedures but … Continue reading →

Posted in SQL | Tagged , , | Leave a comment

Custom keyboard shortcuts in SQL Server Management Studio (SSMS)

Posted on March 27, 2017 by Prashanth Jayaram

People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of … Continue reading →

Posted in SQL, SQL 2012, SQL 2016 | Tagged , , | Leave a comment

Illustration of an example availability monitoring service Using PowerShell and SQL

Posted on March 23, 2017 by Prashanth Jayaram

This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I’ll use SQL Server with simple PowerShell script and cmdlets which generate JSON data and displays results in HTML … Continue reading →

Posted in JSON, SQL | Tagged , , , | Leave a comment

PowerShell: Managing Service(s) Using WMI, CIM and Get-Service Cmdlet

Posted on March 10, 2017 by Prashanth Jayaram

Abstract A common task of any administrator is to manage and maintain the application availability by checking the various services status, accomplish configuring the services and restarting the service on a local/remote system. There are several components are available to accomplish … Continue reading →

Posted in PowerShell | Tagged , , , , , , | Leave a comment