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: Read-Host On Steroids – Enhancements To Jeff Hicks Version
A better Read-Host - by Jeff Hicks Read-Host is very useful but it is too simplistic to write "good" code using it. Jeff Hicks (Twitter: @JeffHicks, Blog: jdhitsolutions.com/blog/) who needs no introductions in the PowerShell world (and whose books I read to learn PowerShell), created a better Read-Host. I love his version. Please checkout the nice … Continue reading PowerShell: Read-Host On Steroids – Enhancements To Jeff Hicks Version
PowerShell – Hate The Error Text And Warning Text Colors? Change It!
How could such a nice tool have such a terrible choice of colors for errors and warnings? I am talking about the ISE and the unreadable contrast of colors. You can fix it. Open and update your profile by running this from your ISE (which opens your profile in NotePad) notepad $profile Add the above … Continue reading PowerShell – Hate The Error Text And Warning Text Colors? Change It!
Oracle – Join Tables Without Stating Any Join Columns – NATURAL JOIN
We saw how using USING clause in the joins simplifies the JOIN conditions. We use it like this NATURAL JOIN clause: Today, let us take a look at another less known join clause – NATURAL JOIN. All it does is on the two tables/views that are joined, it looks for all the matching column names … Continue reading Oracle – Join Tables Without Stating Any Join Columns – NATURAL JOIN