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 …

SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

SQL Server – Performance Best Practices

Talking about SQL Server optimization, query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level Read More …

Tipografia Responsive (HTML)

La stragrande maggioranza degli articoli che trattano di Responsive Web Design, sono focalizzati su due aree principali: layout e griglie Read More …

DNS Poisoning

Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) DNS cache poisoning, also Read More …

Triggers – SQL Server

In SQL Server, a trigger is a special type of stored procedure which will run automatically in response to some Read More …

Create New User and Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a Read More …

Common WMI queries

Below are some common WMI Queries that we have used, both during OSD (Operating System Deployment), startup/logon scripts or similar Read More …