You are here

Blogs

Towel Day

Submitted by Mousumi Sepai, Last Modified on 2019-11-08

25th May is celebrated as Towel day every year as tribute to an English Author Douglas Noel Adams (11 March 1952 – 11 May 2001). This commemoration started two weeks after his death, on 25th May 2001.

In this day, fans of Douglas Adams carry a towel publicly with them. This is in remembrance of the author and his famous book The Hitchhiker's Guide to the Galaxy, also known as H2G2. In this book, author demonstrated the importance and usefulness of a towel with world famous phrases and caption.

Ransomware #WannaCry

Submitted by Asif Nowaj, Last Modified on 2019-11-08

Ransomware #WannaCry

Ransomware is a computer malware that has spread across 150 countries and affected 300K computers. Recently, it is successfully infected major institution like NHS system in England and Spanish telecommunications company Telefonica.

The ransomware encrypts users' files and demands $300 (£230) to restore them.

Only about $50,000 (£39,000) has been paid so far, it is paid as internet currency Bitcoin.

It threatens to delete files within seven days if no payment is made.

Errors in the ole db provider

Submitted by Asif Nowaj, Last Modified on 2019-11-22

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

Submitted by Asif Nowaj, Last Modified on 2019-11-22

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

Submitted by Asif Nowaj, Last Modified on 2019-11-22

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

Submitted by Asif Nowaj, Last Modified on 2019-11-22

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

Submitted by Asif Nowaj, Last Modified on 2020-07-29

SQL server find text in stored procedure sql server 2008 r2, SQL server find text in stored procedure sql server 2012, SQL server find text in stored procedure sql server, SQL server find text in stored procedure, SQL server get stored procedure containing text SQL Server, sql server find procedure containing text, sql server find column name in all stored procedures, sql find text in stored procedure, find stored procedure in sql server, sql query to find column name in all stored procedure, search sp containing text, sql query to find stored procedure containing text, stored procedure containing text, search column name in stored procedure sql server, sql server find stored procedure containing text, sql query to find stored procedure using a table, sql find stored procedure containing text

Pages