Category Archives: Powershell
-
#PowershellBasics: The WHERE clause
Leave a commentNovember 9, 2021 by Kenneth Fisher
Sometimes when you are trying to figure something out you run across something really interesting. In this case I discovered …
Continue reading -
#PowershellBasics: Select the columns in the output.
Leave a commentNovember 4, 2021 by Kenneth Fisher
After my post last week on sorting the list, I now have a list of files, sorted in the right …
Continue reading -
#PowershellBasics: Sort a list
2October 26, 2021 by Kenneth Fisher
In my last post I grabbed a file list but I really need it sorted alphabetically. Now, I’ve been a …
Continue reading -
#PowershellBasics: Get a list of files from a directory.
4October 21, 2021 by Kenneth Fisher
I’ve got a project I’m working on at the moment and it includes a number of elements from my recent …
Continue reading -
#PowershellBasics: Adding data to a string using subexpressions.
7October 14, 2021 by Kenneth Fisher
I’m working on a project right now where I want to add the date/time to the end of a filename. …
Continue reading -
#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 Studies 