Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

PowerSQL By Prashanth Jayaram

Technology enthusiast with 7+ years of experience in Database Technology. I am Microsoft Certified Professional with certificates of OCA, MCP, MCTS, MCITP developer, MCITP administration and backed with a degree in Master of Computer Application. My expertise lies in T-SQL programming, Replication, PowerShell and Performance Tuning. Hobbies are Drawing, playing soccer and listening to Melodies songs.

Archives: May 2013

SQL- Setup and Configure Backup Report – Step by Step Approach – All listed SQL Instances

One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying to give more information with this post also including Step by Step procedure to setup and configure backup report.

This is going to be a continuation of my previous post… Read more

0 comments, 382 reads

Posted in PowerSQL By Prashanth Jayaram on 30 May 2013

SQL – SQL Server Script to Iterate and Pull Data from All SQL Instances – Database Backup

This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to centralized server. As I’ve already mentioned in my previous post PART1,  I’m explaining how to pull the  DATABASE BACKUP information from all listed instance

In order to execute the… Read more

1 comments, 435 reads

Posted in PowerSQL By Prashanth Jayaram on 24 May 2013

SQL – SQL Server Script to Iterate through All SQL Instances – Example Transaction Log Shrinking

There are many ways to execute SQL’s or T-SQL’s across listed SQL Instances. Most of us might have faced and handled this scenario. A script or SQL’s need to be executed across ‘N’ number of instances. This example which does just one way activity. In my upcoming post, I’ll explain… Read more

4 comments, 816 reads

Posted in PowerSQL By Prashanth Jayaram on 20 May 2013

Bill Gate’s speech

One of my friend shared this content. I’m just sharing with you all.
Good one and I like it pretty much!!!!
Bill Gates recently gave a speech at a High School about eleven (11) things they did not and will not learn in school.

Rule 1 : Life is not…

Read more

0 comments, 294 reads

Posted in PowerSQL By Prashanth Jayaram on 16 May 2013

SSAS – Find Cube Database Name, Size,Status and Total Size of SSAS Server

We are planning to take SSAS cube database backup since our backup tool does full file system backup in case of recovery, restoration is taking more time and hence as a first step we are started gathering the number of cubes,status and total size of cube databases .

SQLAS provider… Read more

2 comments, 1,836 reads

Posted in PowerSQL By Prashanth Jayaram on 15 May 2013

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers

We came across a scenario where database bak files being created from long time which are no more in use and hence cleanup those files since we’ve backup tool is in place. We’ve many *.BAK (database backup files) created across ‘N’ number of servers. We have decided to cleanup all… Read more

0 comments, 1,281 reads

Posted in PowerSQL By Prashanth Jayaram on 13 May 2013

PowerSQL – SQL Inventory Generation – Email – High Level Details

Inventory allows anyone to quickly and easily assess any environment. For few servers, answering  Inventory questions might not be so difficult.  But if you’re managing ‘N’ number of SQL Server instances then its going to be tedious job and you’re going to need an organized system for tracking this kind… Read more

0 comments, 403 reads

Posted in PowerSQL By Prashanth Jayaram on 9 May 2013

PowerSQL – Identify a Head of the Database Blocks and Generate Automated Alert across all listed SQL Instances

This is going to be a simplest way of capturing and sending some useful information via an email of ‘N’ number of servers. With a little modification, you can implement various database related automation and capture very useful information.

To Identify the SPID (Session ID) of a head of the… Read more

1 comments, 354 reads

Posted in PowerSQL By Prashanth Jayaram on 6 May 2013

PowerSQL - List SQL Server instance configuration details and sending an automated email

Reblogged from Prashanth Jayaram :

This article walks through how to list SQL Server configurable and non-configurable  instance settings using PowerShell and sending an automated email to a listed users. The  Function SendEmail has MailServerName as one of its parameter. Please change accordingly.The following code loads the SMO(SMO Server Objects)…

Read more

0 comments, 828 reads

Posted in PowerSQL By Prashanth Jayaram on 1 May 2013