Random PowerShell posts
Having a dictionary is just a small step in the big process. After obtaining the dictionary in a usable format, the data has to be uploaded to a (My)SQL database, because the flat file is not really usefull for individual lookups and the intention is to have word-splitted word-sound file. In addition the individual sylables […]
Put dictionary to usable database Read More »
There are different ways to connect to Microsoft SQL server and they all have their own advantages. For administrative purposes the SSMS (SQL Server Management Studio) is one of the most common ways. It offers GUI with lots of functionalities directly exposed to the GUI. Great for advanced tasks and also for inexperienced users with
Connecting to MS SQL Server DB Read More »
Sometimes it is required to delete files older than a date or older by age. Powershell is excelent tool to perform this. Below is a simple script to delete files by age: despite the comments in the script, some details might need additional clarification. It is advisable to add the starting folder as variable for
Powershell – delete older files Read More »
Despite the XML and HTML similarities, they are really different and parsing them should be approached differently. Let us take following example HTML/XML code As this is valid XML it can be parsed using The browsers open it and display it correctly (if the extension is HTM(L)). So all is nice, but what if the
Powershell parse HTML vs XML Read More »
Sometimes the easiest way to create new web request is to get similar request and modify it. In Edge it is done by finding the web request and resending it (optionally editing it). This is one of the functionalities that I am missing in Crome. This is also available in Firefox (checked only the Dev
Web requests via PowerShell Read More »
