Working with EPPlus and PowerShell

Difference when there are empty cells in worksheet

I recently worked on a requirement, where the end user wanted to convert Excel files into tab-delimited text files. In my head I was like, this is easy: “PowerShell FTW! Yay!”. The reason for the excitement was because we already have two repositories that I know work well with Excel and fit my requirement.
◾Doug Finke’s – ImportExcel module.
◾Warren F’s – PSExcel module

Tagged with: , , ,
Posted in PowerShell

Connecting to SAP HANA from PowerShell

Getting HANA backup details

Connecting to SAP HANA using #PowerShell. We will discuss a simple example scenario and will be getting backup details.

Tagged with: ,
Posted in PowerShell

2015 in review


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

Posted in Fun-Stuff

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