Monthly Archives: June 2013

PowerSQL – Different Approaches to Find Free Space in all disk drives

Posted on June 27, 2013 by Prashanth Jayaram

Different ways to find FreeSpace  in all disk drives of a given server T-SQL Using WMIObject Counters All three methods are explained below This post illustrates the simplest way of doing anything with ease using Powershell. I hope everyone agree … Continue reading →

Posted in PowerShell, SQL, T-SQL | Tagged , , , , | Leave a comment

SQL- SP_PROCOPTION – AutoNotification to App Owners – When SQL Instance Restarts

Posted on June 24, 2013 by Prashanth Jayaram

We had a situation where Application owners automatically notified whenever server restarts.  The SP_PROCOPTION do have a facility to perform this activity. The SP_PROCOPTION built-in stored procedure being used to invoke the user defined stored proc automatically. The details of this … Continue reading →

Posted in SQL, T-SQL | Tagged , , | 4 Comments

SSAS – Automatic Inventory Generation – 24 Columns – HTML Attachment

Posted on June 18, 2013 by Prashanth Jayaram

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage. This inventory can take any number of forms but, ideally, will allow some aggregation of information. … Continue reading →

Posted in SSAS | Tagged , , , , , , , , | 1 Comment

The scripting variables can be defined explicitly by using the setvar command or implicitly by using the sqlcmd -v option. Also, this is very helpful in Replication to check rowcount across publisher and subscriber articles. Explicit Call- SQLCMD can be … Continue reading →

Posted on June 12, 2013 by Prashanth Jayaram | Leave a comment

PowerShell – Identify Service Account & Other Details of SQL Services – Multi Server Script

Posted on June 10, 2013 by Prashanth Jayaram

One of my friend requested me to give a mutli server script to pull SQL Service related details. Here is a quick PowerShell script to find Name, ServerName, Status, StartupMode, Service Account and other details of SQL Services across all … Continue reading →

Posted in PowerShell, SQL | 5 Comments

SSAS Cube Backup strategies and Step by Step approach to setup and configure backup

Posted on June 5, 2013 by Prashanth Jayaram

There are different ways to take Cube database backups. SQL Agent Job XMLA script for backup ROBOT job ASCMD command SSIS Package SSIS package AMO (Analysis Management Objects) PowerShell Scripts I feel AMO (Analysis Management Objects) does our job much … Continue reading →

Posted in SSAS | Tagged | 8 Comments