Archives: June 2013
Different ways to find FreeSpace in all disk drives of a given server
- Using WMIObject
All three methods are explained below
This post illustrates the simplest way of doing anything with ease using Powershell. I hope everyone agree with it.
Download the code here Code- DiskSpaceUsageDetails
TSQL Read more
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 implementation is as follows
- User defined meta data table…
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. When server hardware or software changes are taking place, it’s… Read more
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.
SQLCMD can be enabled in Query Editor. Go to SSMS Menu -> Query… Read more
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 listed SQL Instances. The output is shown in three different… Read more
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 easier. Different ways of taking cube backup is explained below.… Read more