Monthly Archives: October 2020

Drupal 7, 8: Your Server Does Not Support Installing Modules & Themes

On my Windows 10 machine, I installed Drupal 7 and 8 on IIS Server. When I wanted to install modules, it gave the following error. Error: Your server does not support installing modules and themes. This issue is related to permission only. Windows Configuration Windows 10 IIS Express PHP 7.1 (As FastCGI on IIS) Application […]

TSQL: Split String into Multiple Columns With Built-in Function

split string into multiple columns using hammer

Let’s assume that you are working with SQL Server database and you need to build an ad-hoc report and split the string data into separate columns. Your data contains specific delimiter and you want to parse the data into respective columns. For example, your data column FullName contains “LastName, FirstName”, you would like to parse […]

TSQL: Split Full Name into First Name and Last Name Columns

If you need to create an ad-hoc report and split full name into first name and last name, online search will suggest to create a custom user defined function. Sometimes, it is not possible to create an user defined function for single ad-hoc report because you need to follow change control process of your organization […]