Technicals

Create related content block in Drupal 7 using Contextual filter

If you are looking for “how to create a related content block in Drupal 7”, you are at the right place. I have successfully created a block for displaying related content using Taxonomy, Contextual filter with views.

You can check out right sidebar at the top of my website is showing all my contents related with PHP.

Now I am going to explain step by step how I have created related content blocks in Drupal 7 with views.

I am assuming you are already logged in as administrator.

How to count number of occurrences of a certain char in a string in Delphi

Below is the function, using which you can find out the number of occurrences of a certain character in a string in Delphi.
For instance, assume that you have the following string and would like to count the number of commas in it:
Str := 'A,B,C';
Then you would like to obtain 2 as the result. Use below function.

Count number of times a string occurs in another string in Delphi

A simple way of counting the number of times a string occurs in another string in Delphi. For an example, “of” occurs twice in “How to count the number of occurrences of a string” where as “within” occurs once in “SubString occurrences within a string”.
The below function will return the number of occurrences of a string within another string. You can use the below function to count occurrences of a substring.

SQL SERVER - Find Most Expensive Queries Using DMV

While you are worry about the performance of your application or your database, you can use this performance tips for SQL SERVER and find out most costly queries running from your application. This will help you find out expensive queries to tune them up and increase performance.

Recover sa password or gain sysadmin access to a database

Recover sa password or gain sysadmin access to a database

Please do not re-install SQL server if you forgot/don’t know the sa password or you do not have sysadmin access to the database but you want to have. Try one of the below to recover the access.

Errors in the ole db provider

I have encountered this below error while I was trying to connect SQL Server Analysis Services cube using Microsoft Excel 2010.
Errors in the ole db provider: an error occurred while loading the connection dialog box component for prompting.
I remember it was working fine couple of month ago.
Now, this is how I have resolved the issue by re installing SQL server 2008 AS OLEDB drivers:
1. Go to https://www.microsoft.com/en-us/download/details.aspx?id=6375
2. Click “Download”

How to automate deployment using msbuild through command prompt

Pre-requisite is .NET framework

Assuming that .net framework is already installed in your machine.

Now follow the below instruction whether MSbuild command is working or not.
1. Open command prompt
2. Write msbuild /? and hit Enter

If you are getting below message, then it is certain that correct path is not configured to recognize the command.
'msbuild' is not recognized as an internal or external command, operable program or batch file.

Microsoft SQL Server - Find all the executed queries related with a table

Microsoft SQL Server - Find all the executed queries related with a table

In this tutorial, we’ll discuss on how to find all the executed queries related with a table in one database.

To get the all the queries that are executed in the database and related with a particular table, use below script.

Microsoft SQL Server - Find Row Count of all the tables

In this tutorial, we’ll discuss on how to find row count of all the table in one database.

To demonstrate this topic, SQL Server 2008 R2 Express version is being used. The exact version information is

Microsoft SQL Server - Find a particular text within Stored Procedure, View and Function or as Column name in a table

In this tutorial, we’ll discuss on how to find Stored Procedures, Views and Functions which contain a particular text in it. Also, we’ll discuss on how to find tables which has a column name with a particular text.

Pages