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, … Continue reading SQL Server: Detach/Attach Gotchas!
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 … Continue reading SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!
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 … Continue reading PowerShell: Resolve Partial File Paths To Full Paths
Search and activate PowerShell ISE tabs using partial search strings
Today a good friend of mine, Damu asked for a function that could copy files from a source to destination based on modified date criteria. Although it could be easily accomplished in the command-line itself, I took upon myself as an exercise to create a wrapper function to do the same in case he wants to … Continue reading PowerShell – Get Files Modified In A Certain Date Range And Copy/Delete/Zip…whatever