Problemstellung: Daten sollen mittels “Invoke-SqlCmd” aus einer SQL-Server Datenbanke geholt werden. Sofern das “SqlServer”-Modul für die Powershell installiert ist, kann das auf bequeme Weise mit dem Commandlet “Invoke-SqlCmd” erfolgen. Beispielsweise so: Wie aus dem Code-Block ersichtlich, werden die Ergebnisdaten in der Variable “$result” gespeichert. Wenn […]
You’re about to finish work and you don’t know what to watch tonight. The International Movies Database and the Powershell script printed here will help you with your decision: Have fun!
Somtimes you have to check the network connection state of the devices you want to connect to. Here are two little functions that might do what you want. Check a particular host if it is reachable by ICMP: This function returns “false” if the host […]
Today I took some first steps to control my Shelly 2.5 device. Actually, it’s about developing a class library for the Shellys in C # for my little smart home broker. In order to understand how the device works, an efficient script language such as […]
In order to check the speed of the disk storage connected to my SQL Server at defined intervals, I wrote a powershell wrapper for diskspd. If diskspd is not yet installed on the server to be checked, it will be downloaded from github and copied […]
“Format strings” are used in the measures and other objects so that a predefined representation can be enforced for certain values. Problem: By default, in many languages the “thousands” digit is shown with a “” (space). If another thousands separator is to be used, this […]
Doing a “SELECT COUNT(*) FROM [TableName]” can be a long running task.Thanks to William Durkin for his example on Twitter to count the rows of a table using the system table “sys.partitions”. To use it in my daily busines, I have wrapped this up in […]
Yesterday during lunch break I thought about building a binary clock with an ESP32. Since I don’t have a corresponding development environment on my device, I quickly prescribed the function for converting the time into a binary string in Powershell. The next step then is […]
Once upon a time in daily business there is only two things you have: A powershell and no internet / no media to install a appropriate module to query the Active Directory. Thank you god it`s LDAP-time. First we need to connect to the Active […]
