SQL Server – Temporary Tables

SQL Server temp tables are very useful for temporary modifications or transformations to data that we do not need to keep rather than manipulate or work with permanent tables. Let’s say you want full DDL or DML access to a table, but don’t have it. You can use your existing read access to pull the data into a SQL Server temporary table and make adjustments from there. Read More …

Powershell – Check and find the product GUID of an installed MSI setup

The product code is the unique GUID of identifying an application or product release; In other words, different versions and languages of Product must have different product codes. Also, ProductCode can be used to query feature state, and product state. For example, installer API “MsiQueryFeatureStateEx()” and “MsiQueryProductState()”, etc. Read More …