PowerShell – Get SQL Server Instance Info from Hosts – With Pipeline input support

There is not much to say except that this supports pipeline input. Take a close look. PowerShell folks don't read text, they just focus on the code...So, here it is. The "Output" column will have an Exception object containing the error if the attempt failed to fetch the instance information. Also, isn't this cool? The …

Advertisement

Oracle or SQL Server – How to Find the Instance Startup Time?

SQL Server A DBA or developer might have a simple question – “Since when has my SQL Server instance been continuously running?”. There are many places to look but the easiest is to look at the creation date of the system “tempdb” database. Now, to the question of why? TempDB is special in a lot …

Oracle (or) SQL Server: Find Row Level Data Differences Using MINUS/EXCEPT – 100 Level

Changes needed for SQL Server The simple SQL illustrations mostly show Oracle code but the final SQL is also shown for SQL Server (simply remove the “FROM DUAL” references and replace "MINUS" with "EXCEPT"). What this post is about? When we need to compare two sets of data to find out which rows are different between the …

SQL Server – PIVOT Data With TSQL

Note: Although I wrote this in year 2012, it is still valid. If you are looking to convert rows to a CSV string and vice versa in Oracle, please read my related post on that here. If you are a serious PIVOT'er, I know that you would use Excel or Power Pivot or Power BI. …

Oracle – Data Dictionary Views – USER vs ALL vs DBA Views – 100 Level Basics

Most of us use data dictionary views on an everyday basis to find things like: In which schema does a table with a certain name exist? What tables use a certain column name? Get the line of code from any and all packages where a string named “EMPLOYEE_NUMBER” is used What privileges does a role …