Connecting to SAP HANA using #PowerShell. We will discuss a simple example scenario and will be getting backup details.
Blog Archives
Working with EPPlus and PowerShell
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
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.
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: Azure, Powershell, SQL Database, Windows Azure, Windows Azure SQL Database
Posted in PowerShell
Posted in PowerShell
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: Powershell, Regex, Regular Expressions, RegularExpressions, Verbal Expressions, VerbalExpressions
Posted in Fun-Stuff, PowerShell
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: google search results, Invoke-RestMethod, Invoke-WebRequest, Powershell, REST, SQL Database, sql database server, SQL Server, Windows Azure, Windows Azure SQL Database
Posted in PowerShell, SQL Server
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: Exploration, Fun, Google Custom Search API, Inovke-RESTMethod, Powershell, REST
Posted in Fun-Stuff, PowerShell
Posted in Fun-Stuff, PowerShell
Filtering data from SQL*Server Errorlogs
Tagged with: Context, Error Log, ErrorLog, ErrorLogPath, Powershell, Select-String, SMO, SQL Server
Posted in Fun-Stuff, PowerShell, SQL Server
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: Charting, csv, Data visualization, MCC, Microsoft Chart Controls, perfmon, Powershell, PSBUG, SeeShell, Visualization, XML
Posted in PowerShell
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: ASSOCIATORS OF, Cluster, cluster groups, Get-WMIObject, gwmi, MSCS, Powershell, SQL Server, WMI, WSFC
Posted in PowerShell
Posted in PowerShell
SqlChow 