Blog Archives

T-SQL Tuesday #050: Automation, lessons learnt

The topic for the golden jubilee edition is, “Automation”. What is T-SQL Tuesday? T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part

Tagged with: , , ,
Posted in SQL Server

T-SQL Tuesday #46: You did what? Creative hacks to common problems

This whole thing, was put in a store procedure and then called from a job step for a long running job. For example, like a database backup job. And additional logic was written around the return value to write proper error numbers to application log. These event-ids where then picked up by monitoring applications and alerts where raised.

I have mixed feelings about this solution. Although, it worked without a problem (I am secretly proud that I was able to write something like this); I would have loved to just upgrade the servers to SQL 2008 and be done with it.

Tagged with: , , , , ,
Posted in SQL Server

Down the rabbit hole with PowerShell and Windows Azure SQL Database

In this post we look at how we can REST API to interact with the SQL Azure Database Server.

Tagged with: , , , , , , , , ,
Posted in PowerShell, SQL Server

Filtering data from SQL*Server Errorlogs

Select from SQL*server error log with context.

Tagged with: , , , , , , ,
Posted in Fun-Stuff, PowerShell, SQL Server

Detecting Cluster Group Stacking using PowerShell

To Clarify, when I say stacking, all I mean is to find those cluster groups that are not running on the preferred owners i.e. those that are stacked on a different node than the preferred owner.

After the monthly patching cycle completes, we used to spend a considerable amount of time figuring out if all the clustered SQL*Server instances were running on their preferred owners or not. During the latest cycle of patch deployment, I was hard pressed for time and wanted to see if I could put something together, quick and dirty, to display the information easily.

Tagged with: , , , , , , , , ,
Posted in PowerShell

T-SQL Tuesday #040: File and Filegroup Wisdom (Quick Introduction to FILESTREAM)

A quick and generic introduction to FILESTREAM for T-SQL Tuesday #40

Tagged with: , , , ,
Posted in SQL Server

Adding Extended Properties to SQL*Server Databases Using PowerShell

When you are working as part of a team that manages a few hundred SQL*Server instances; sometimes, it becomes hard to keep track of all the people who need to be notified when you plan for database migrations and such. Also, if there is an issue that needs their input ($’s); we do not want to send it to the wrong person now, would we. Maintaining the information in excel sheets is good but, wouldn’t it be nice to have the information available on the DB itself? We can get all the information in one shot and send out e-mails to the concerned (correct) individuals.

Tagged with: , , , ,
Posted in PowerShell, SQL Server