Nov 292016
 November 29, 2016  Posted by at 12:31 pm Not So Stupid Questions, PowerShell No Responses »
(Not so) Stupid Question 296: What are the pros and cons of excluding folders in Defender?

It was late and I was looking through my drafts of future ‘Tip of the Day!’ which I tweet out on daily basis. A colleague had mentioned to me that I could exclude certain folders to improve performance on my computer (at the time a slower computer) and I decided to make that the tip […]

Nov 022016
 November 2, 2016  Posted by at 2:29 pm Databases, PowerShell 2 Responses »
Installation of mongodb on windows as a service with powershell

Yesterday ‘the’ day finally came. The day I got the A-Okay to set up a document database for our system. While I certainly appreciate MS SQL and alike there are different types of databases to cover different types of scenarios. I had not so discreetly made a plea for using a document database for our logging, and […]

Oct 232016
 October 23, 2016  Posted by at 10:36 am JS & TS, PowerShell 2 Responses »
Using PowerShell to execute JavaScript on a page and outputting the result

Earlier this week I was putting together a PowerShell background service to generate some reports. The reports where based on some queries run against our databases in the different environments, as well as schema comparisons that created upgrade scripts and sent warnings if there could be data loss based on the changes. I’ll get to […]

Dec 032015
 December 3, 2015  Posted by at 10:08 am PowerShell 1 Response »
Saving RDP sessions with PoSh

I honestly can’t remember if I blogged this or not, but since I can’t find the blog post I will just assume that I didn’t. I thought I’d share a few lines of PowerShell for something rather handy. I seem to be constantly RDPing and since I mainly work and navigate from a shell it […]

Sep 192015
 September 19, 2015  Posted by at 1:41 pm PowerShell Comments Off on PowerShell: RSS feeds and credentials
PowerShell: RSS feeds and credentials

I’m doing some Uni courses to get a BCS with an international profile and one of the tools we use for coordinating assignments, email, discussions and more is Fronter. I’m not a terrible big fan of the system, I used it for two years when I did my programming degree but I never got comfortable […]

Feb 192015
 February 19, 2015  Posted by at 8:49 am AutoHotKey, PowerShell No Responses »
AutoHotKey: hotstrings and sending input

Cheatsheet Read below (after the cheatsheet) for details and examples. Defining hotstring ::myHotstring:: myActionOrOutput Hotstring options (some): Options defined as :option:myHotstring:: myActionOrOutput ❓ Triggers string inside another word :c: Case sensitive :c0: Not case sensitive :k100: Key delay of 100 milliseconds. Does not work with SendIput :r: Send as raw (not needed when using a […]

Jul 012014
 July 1, 2014  Posted by at 2:02 pm Azure, Hadoop, PowerShell Tagged with:  No Responses »
HDInsight and PoSh: The -Subscription parameter is deprecated, Please use Select-AzureSubscription –Current

The documentation for the cmdlets for HDInsight are not up to date, and therefore neither is the Get-Help on this one (today: July 1st 2014). I’m not sure if I’m misunderstanding something, or if the docs aren’t documented. But, If you run a simple cmdlet such as: Get-AzureHDInsightCluster -Subscription (Get-AzureSubscription -Current).SubscriptionId You will get the […]

May 072014
 May 7, 2014  Posted by at 1:04 pm Azure, PowerShell Tagged with:  No Responses »
Creating and uploading to Azure blob storage with Azure PowerShell

I’ve started a new video and audio series (I guess we can them podcasts?) with ‘(not so) Stupid Questions’, and while I’ve chosen to have the videos on YouTube (for now) the question was where to put the audio file? Azure of course! I’ve been wanting to dig deeper and learn more about Azure ever […]

Feb 242014
 February 24, 2014  Posted by at 9:53 am PowerShell Tagged with:  No Responses »
Example with Speech API: How to use .Net and COM objects in PowerShell & reference assemblies

Using Text-To-Speech in scripts I have some scripts that take some time to run for my virtual machines, so I’ve added speech so I’ll know when they are done. Just as I use speech a fair bit on my phone (having my messages read out and replying) I also use it on my computer. The […]

Jan 312014
 January 31, 2014  Posted by at 11:04 am C# & F#, PowerShell 3 Responses »
Tray notifications in C# and PowerShell

I’m working on a Pluralsight course on continuous integration and to demonstrate the process in the introduction module I made a make believe CI system in PowerShell, When a build step failed I wanted notifications, and tray notifications can be quite handy (emails as well of course).   This is how you create a tray […]

Oct 242013
 October 24, 2013  Posted by at 8:58 am Not So Stupid Questions, PowerShell 5 Responses »
Stupid Question 256-257: What is differential debugging, and how do I compare files in PowerShell?

As I’m becoming a better programmer (my first year as a programmer) I’m also getting better at debugging, and it is one of my favorite things to do. Yes, I said it, I love debugging.  But then again I love pretty much everything about programming. Anyway. One technique I’ve recently learned to appreciate is differential […]

Oct 162013
 October 16, 2013  Posted by at 8:06 am Not So Stupid Questions, PowerShell 36 Responses »
How do I query a SQL Server DB using PowerShell, and how do I filter, format and output to a file? (Stupid Question 251-255)

In the winter darkness the Swedes have become hard to identify (even with the pale blonde hair and strong accent), and we need a list so we can get the invites out for the next ‘Fika’ (Swedish tradition). It would be horrible if we got non-Swedes at the fika, after all nobody can appreciate this […]

Aug 212013
 August 21, 2013  Posted by at 7:52 am Not So Stupid Questions, PowerShell No Responses »
Stupid Question 232-233: What are environment variables, and do I set and use environment variables in Command Prompt and PowerShell?

[To celebrate my first year of programming I will ask a ‘stupid’ questions daily on my blog for a year, to make sure I learn at least 365 new things during my second year as a developer] If you want to save the path of an executable to a permanent variable you can do so […]