Powershell – Search and Replace multiple text strings in file/variable

A common, but not so often, requirement in some scenarios is to search and replace one or multiple text strings in variables or files. This can be quite easily achievied by using a bit of Powershell code. Read More …

SQL Server – SQL Attach DB: Could not open new database [New Question]

A quick question, answered on Heelpbook, about “SQL Server – SQL Attach DB: Could not open new database”, an error quite common while moving or migrating SQL Server databases between servers. Read More …

Python – What is a Dataframe?

A dataframe is a two-dimensional data structure, i.e., data is aligned in a tabular fashion in rows and columns, exactly as you would see in a classic Excel spreadsheet. In other terms, Pandas DataFrame is nothing but an in-memory representation of an Excel sheet via Python programming language.
Read More …

Copy file to remote servers (Powershell)

A common activity, on many IT environments, is to move/copy files from a system to another, usually in a scheduled mode. Let’s see how to do it with Powershell on Windows systems. Read More …