Retrieve your blog posts from WordPress using REST API


If you own a wordpress blog and are curious as to how many posts you blogged with a particular tag, the Invoke-RestMethod is here to help you.

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

Windows Azure setup for using with PowerShell


In this post we will see how you can create a logical server and database instance on Windows Azure SQL Database and connect to the database using PowerShell.

First things first, we need a Windows Azure subscription. Presently, you can register for a free trail at http://www.windowsazure.com.

Tagged with: , , , ,
Posted in PowerShell

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 #050: Automation, how much of it is the same?


Automation plays a huge part in our lives and the DBA profession is no so different. A couple of years ago this topic was shared by Pat Wright. I would like to revisit this again and see how much of our approach has changed.

Tagged with: ,
Posted in SQL Server

2013 in review


The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt: A New York City subway train holds 1,200 people. This blog was viewed about 7,100 times in 2013. If it were a NYC subway

Tagged with: ,
Posted in Fun-Stuff

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
Follow

Get every new post delivered to your Inbox.

Join 88 other followers