PowerShell: How To Reverse Alphabetical File Names & Rename

Recently I had shot a bunch of videos on a Video App on my iPhone. By default it saves the videos/photos within the App itself. Later, I can move them to iPhone "Photos". Why are file names in reverse order of how I shot them? In the case of this app, I just did "Select …

Advertisement

SQL Server: Detach/Attach Gotchas!

Please checkout my post on "Moving Datafiles" which is very related to this method but is preferred more. One would think that detaching and attaching databases is one of the simplest things to do. It is. However, there are so many things that can break by that simple operation by itself and nothing more. Recently, …

SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!

If the SQL Server databases being manged are a few GB in size each, then having a single .mdf file for data is fine. However, if the size is anywhere in the hundreds of GB or more, then a single .mdf file is certainly not the way to go. Related to this, please checkout my …

PowerShell: Resolve Partial File Paths To Full Paths

My Use-case: I am building a continuous integration tool using PowerShell for deploying scripts/database files (like .sql, .rdl, .xmla etc) to SQL Server/Oracle with all the bells and whistles (over a hundred PowerShell functions so far 🙂 ). It needed a file path resolution functionality that is somewhat flexible. I decided to share the file …

PowerShell – No Mouse, Search & Activate A Tab In ISE With Partial String Search – e.g.: “Popt register”

Search and activate PowerShell ISE tabs using partial search strings