Tag Archives: powershell

PoSh Everywhere

This week we had an announcement that PowerShell has been released as an open source project and is available on some Linux platforms as well as OSX. I was actually talking with someone else that had been informed prior to … Continue reading

Posted in Editorial | Tagged , | Leave a comment

PoSh on Ubuntu

I heard about the PowerShell announcement recently where the platform is porting over to Linux and OSX. I think this is part of the SQL Server on Linux project, where I assume we’ll start to see the functionality that we … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Open Source SQLPS

I first saw PowerShell in 2007 or 2008 at TechEd. I was both fascinated and excited, finding the idea of using command line tools both nostalgic as well as handy. Certainly there have been a number of file based operations I’ve wanted … Continue reading

Posted in Editorial | Tagged ,

PowerShell–Don’t Use Write-Host

I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return output. To me, it’s been like “Print” in various languages where I can get output of a program. Often I’ll … Continue reading

Posted in Blog | Tagged , | 2 Comments

Quick Folder Size with PowerShell

This is a fairly simple idea, and one I’m sure many people have done in the past. Personally, I have tended to just hover a mouse over a folder when I want a size. That seems to work fairly well, … Continue reading

Posted in Blog | Tagged , | 2 Comments

Hash Tables in PowerShell–Advent of Code Day 3

I continue to work on solving the Advent of Code puzzles in both PowerShell and T-SQL after completing them in Python. When I hit day 3 in PowerShell, it was a few new tricks to learn, one of which was … Continue reading

Posted in Blog | Tagged , ,

Advent of Code Day 1, Puzzle B

As I continue through the Advent of Code, albeit slowly, I’m solving each puzzle 3 days. I worked through 6 of them in Python before moving on to other languages, and this is my chance to catch up with both … Continue reading

Posted in Blog | Tagged , , , ,

Advent of Code Day 1, Puzzle A

I have been working my way through the Advent of Code series across the last few weeks. This is a side project, allowing me to use some Python skills to solve the various puzzles. I also started to use PowerShell … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Running Powershell with Task Scheduler

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers. One of the things I needed to do with my SQL Saturday download process was run this automatically. I don’t … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Ending My Loop in PowerShell Early

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers. I was modifying my PowerShell (PoSh) script to download SQL Saturday files recently to not re-download files. However when I … Continue reading

Posted in Blog | Tagged , , | 3 Comments