In this post we look at how we can REST API to interact with the SQL Azure Database Server.
Down the rabbit hole with PowerShell and Windows Azure SQL Database
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
Setting SCOM console polling rate
It is known that having a number of consoles open slows down the SCOM environment. So if you have more than a few consoles open continuously you might consider lowering the refresh rate of the consoles.
Tagged with: Powershell, SCOM, SCOM Console, SCOM Console Polling interval, SCOM Console Refresh Rate
Posted in general, PowerShell
Posted in general, PowerShell
Shuffle the deck using PowerShell
Generate a random permutation of a given set of elements. Power-shell implementation of the ‘Fisher-Yates Shuffle’.
Tagged with: Fisher-Yates Shuffle, gaming, Powershell, Random Number Generators, Random Numbers, technology
Posted in Fun-Stuff, PowerShell
Posted in Fun-Stuff, PowerShell
An attempt at Conway’s Game of Life using PowerShell
While watching ‘Stephen Hawking’s Grand Design’ couple of weeks ago on Discovery channel. Stephen Hawking was talking about how conscience evolves and how simple cells could evolve into complex beings. As an example, I saw the game of life come up and show how simple starting states can evolve into complex self-sustaining groups. This got me thinking, and while investigating how we code this game of life; I found that the rules are pretty simple. So, I started looking at doing this in PowerShell.
T-SQL Tuesday #39: Getting Installed Instances, querying logs
This week’s T-SQL Tuesday is being hosted by Wayne Sheffield, and the topic is to blog about anything PowerShell related to SQL Server.
Today I am going to write about a few things:
-Getting a list of installed instances on a particular box.
-Reading the SQL*Server error logs using SMO.
-Querying the Windows event logs for errors.
Tagged with: ErrorLog, EventLog, Get-Item, Get-ItemProperty, Powershell, Registry, SQLServer, T-SQL Tuesday
Posted in PowerShell, SQL Server
Posted in PowerShell, SQL Server
SqlChow 