Content

How do I find the installed .NET versions?

There is an easier way to get the exact version .NET version installed on your machine from a cmd prompt. Just follow the following instructions; Other command lines:

Add IDENTITY or Unique number to a table – T/SQL

I want to update my table records. However, my existing table does not have any unique columns. So, I need to append Identity column and update all the records based on that Identity column. For example, If my temp table has 1000 records without any unique column values. I need to number all these 1000 records and update the values. There is no need to do an UPDATE. The identity column is going to be populated when it is created. All you need is: or when you create a table: It…

MySQL my.ini Performance and Optimization Tips

The major advantage of identifying the performance-driving factor for a database is that it allows you to avoid over-provisioning and reduce costs by right-sizing your servers. It also gives you insights into whether moving data storage or adding server capacity will improve performance and, if so, how much it will be. The tuning database for MySQL query performance optimization doesn’t come with pale challenges. However, once tuned properly, the database gives worthwhile performance results with great functionalities. It lowers unwanted task load and optimizes the MySQL database for faster data…

How to Install an SSL/TLS Certificate In Microsoft IIS 7

The following instructions will guide you through the SSL installation process on Microsoft IIS 7. If you have more than one server or device, you will need to install the certificate on each server or device you need to secure. If you still have not generated your certificate and completed the validation process, reference our CSR Generation Instructions and disregard the steps below. What You’ll Need 1. Your server certificate This is the certificate you received from the CA for your domain. You may have been sent this via email. If not,…

How to run .msi files as an administrator

Starting in Windows Server 2012 the “Run as administrator” option no longer appears when right-clicking a .msi file. This may be a required step when installing certain applications onto your Windows Server. Below are some options to be able to run a .msi file as an administrator. As a single-use solution, you can run the .msi as an administrator from the Windows command prompt. Open elevated Command Prompt. To do so, type “CMD” in the Start menu or Start screen search box, and then simultaneously press the Ctrl+Shift+Enter keys. Alternatively, you can also…

MSSQL – Query to Find Column From All Tables of Database

How many tables in the database AdventureWorks have column names like ‘EmployeeID’? It was quite an interesting question and I thought if there are scripts that can do this would be great. I quickly wrote down the following script which will go return all the tables containing specific columns along with their schema name.

Check If IEnumerable<> or List<> Type is Empty / Null

There are three ways to check whether IEnumerable<> or List<> type is empty / null or not. == NULL .Any() .Count() In any case, you always want to combine “== null” and, either “.Any()” or “.Count()”, with OR (“||”) operator. In addition, you want to put “== null” before the other condition. The reason for this is, “if” condition goes from left to right. So, if the list object is null, it will not go to the second check, which will result in “Object reference not set to an instance…

How to search in Outlook

Outlook provides you with a number of built-in search filters. To use the built-in filters, click in the Search box. Based on your preference, you can use Advanced Search by clicking the filter button on the right side of the search box. Alternatively, the Outlook ribbon will change to show the Search tab and you use any of the options in the Refine group to refine your search results. You can find the search box at the top of the screen whether you are using the Simplified Ribbon or the…

Visual C# Code Snippets

By default the following code snippets are included in Visual Studio. Name (or shortcut) Description Valid locations to insert snippet #if Creates a #if directive and a #endif directive. Anywhere. #region Creates a #region directive and a #endregion directive. Anywhere. ~ Creates a destructor for the containing class. Inside a class. attribute Creates a declaration for a class that derives from Attribute. Inside a namespace (including the global namespace), a class, or a struct. checked Creates a checked block. Inside a method, an indexer, a property accessor, or an event accessor. class Creates a class declaration. Inside a namespace (including the…

SQL Time Zone Conversion Functions

I did a lot of research on Microsoft’s website, and the only time zone conversion functions that I could find were relative to analysis services, and would not provide me with a solution to my problem. So, my options were to pay someone to modify our application, or create a process in the database environment to perform the conversions as data is inserted into the common database environment.