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, … Continue reading SQL Server: Detach/Attach Gotchas!

Advertisements

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 … Continue reading SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!

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 … Continue reading PowerShell: Resolve Partial File Paths To Full Paths

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

PowerShell – Get Files Modified In A Certain Date Range And Copy/Delete/Zip…whatever

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