PowerShell: Drop All SQL Server Tables, Views, SP’s, Functions, Types etc.

I hope this script does not become infamous for the wrong reasons! Please use caution. I had to help a team recreate everything in a database and test their scripts but leave the roles and role grants in place. Basically, this meant that I could have scripted out the permissions and recreated the database but … Continue reading PowerShell: Drop All SQL Server Tables, Views, SP’s, Functions, Types etc.

Oracle – Easy Date Strings (and NOT)

Whenever I type in a date strings in Oracle, I convert the strings to Date data┬átype in my code as well as my queries without relying on the session setting for date format. I will explain why. Session date format setting: Session date format settings govern how date strings should be converted into dates (the … Continue reading Oracle – Easy Date Strings (and NOT)

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