PowerShell & WPF: Marry Them For Reusable Scripts & Beautiful GUI!

This post is just to give you an idea of what is possible with PowerShell and WPF. It is not a complete solution that is ready to use. I do give you the key functions necessary to make it all work for your scenario and choices you want to make. As an Admin and an … Continue reading PowerShell & WPF: Marry Them For Reusable Scripts & Beautiful GUI!

PowerShell & SQL Server: Search & Find Indexes By SchemaName, TableName, IndexName Or ColumnName Across Instances/DB’s

Necessity is the mother of new PowerShell code :-)! Today, I received an email request to get the list of all indexes in a given TableName but the requester did not specify the DatabaseName although the SQL InstanceName was specified. It would be too easy to ask the person for the DBName and script it … Continue reading PowerShell & SQL Server: Search & Find Indexes By SchemaName, TableName, IndexName Or ColumnName Across Instances/DB’s

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.

PowerShell: Puzzle Night At the User Group!

My PowerShell Usergroup: As I said before, I am a regular at my local PowerShell user group. I keenly look forward to our monthly meetings. We share a lot of PowerShell code/tips/tricks among ourselves. It is a small but close-knit group. Yesterday, one of the members, Jason Walker came up with coding puzzles for the group. This blog … Continue reading PowerShell: Puzzle Night At the User Group!

Oracle: Resolve “ORA-01704: string literal too long” and/or Non-ANSI Language Character Display Issues

You may experience issues when it comes to special characters. It could be DML (Insert/Update/Delete) where the data is not stored properly (or) display related (SELECT) where the characters do not display correctly as they are stored in the database. You could resolve both. Please continue reading on how to. Straight-forward case: The error "ORA-01704: … Continue reading Oracle: Resolve “ORA-01704: string literal too long” and/or Non-ANSI Language Character Display Issues