Category Archives: Powershell
-
#PowershellBasics: Bulk insert.
Leave a commentSeptember 21, 2021 by Kenneth Fisher
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql …
Continue reading -
#PowershellBasics: Finding a common AD group for a set of users.
3June 17, 2021 by Kenneth Fisher
A while back (almost 7 years 😲) I wrote a post on finding the common AD groups of a set …
Continue reading -
#PowershellBasics: Writing to the screen
8May 20, 2021 by Kenneth Fisher
Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is …
Continue reading -
#PowershellBasics: Comments and comment based help
5May 13, 2021 by Kenneth Fisher
I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the …
Continue reading -
#PowershellBasics: Setting a variable vs a comparison.
1April 27, 2021 by Kenneth Fisher
In SQL Server both the set and equality functions are handled by the equals sign (=). For example: Set Equality …
Continue reading -
SQL Homework – December 2020 – Participate in the Advent of Code.
Leave a commentDecember 3, 2020 by Kenneth Fisher
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect …
Continue reading -
Non-SQL Tips and tricks – #tsql2sday 127 Rollup
3June 16, 2020 by Kenneth Fisher
I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now …
Continue reading -
#PowershellBasics: Using environment variables ($env:ProgramFiles)
3April 6, 2020 by Kenneth Fisher
The other day Kendra Little (blog|twitter) mentioned that she was trying to get a command in Powershell working. Specifically one …
Continue reading -
#PowershellBasics: Run a file and pass it a parameter.
Leave a commentFebruary 17, 2020 by Kenneth Fisher
I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional …
Continue reading -
#PowershellBasics: Get input using Read-Host
Leave a commentFebruary 5, 2020 by Kenneth Fisher
Conditions are the life blood of programming. This condition is met so now I need to do this task. That …
Continue reading
SQL Studies 