Yearly Archives: 2013

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

Using verbal expressions to make regex easy in PowerShell

What it means is that, we write ‘Four times X plus 3 equals seven’, and get ‘4x+3=7′. That example, could be a little misleading so let try it again, a valid url would consist of http at the begining of the line, maybe s if you are accessing a secure site, then it will have ://, maybe www. if you are so inclined to type and anything but a space. The aim of verbal expressions is to let you type the above and get a regular expression that matches a URL which is this: this:’^(?:http)(?:s)?(?:://)(?:www.)?(?:[^\ ])$’

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

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

Google search results using REST (custom search api) in PowerShell

Chanced upon Google’s custom search API while trying to see if there was a better way to retrieve the search results programatically.

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

Filtering data from SQL*Server Errorlogs

Select from SQL*server error log with context.

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

Charting and Data Visualization using PowerShell – PSBUG – August 2013

As part of the PowerShell Bangalore User Group meet held yesterday, I had the chance to do my very first session. Although I was quite nervous, I was very excited to talk about PowerShell which is really close to me.

I presented about visualizing data using Microsoft Chart Controls. Most administrators understand the benefits of automation but many fail to showcase the benefits. This is where MS Chart Controls step-in. I believe a visual medium is the most effective way to drive a point; “a picture is worth a thousand words”.

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

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