{ Published : October 26, 2017 // Post an Awesome Comment }
During Data migration process I have to restore or drop databases. Sometime I face an error “SQL Server Cannot drop database <dbname> It is currently in use“. Few days ago, I faced the same problem. As you know,  It’s very expensive to restart SQL Services to kill database...
Read More
{ Published : October 25, 2017 // Post an Awesome Comment }
Last night, I was trying to publish a post “Drop Multiple Tables with Common Prefix (SQL Server)“. I faced 403 Forbidden error, every time I pressed Publish button. I tried to publish blank post but failed. I tried to update old post but same error occurred. I faced this error after...
Read More
{ Published : October 25, 2017 // Post an Awesome Comment }
Drop Multiple Tables with Common Prefix (SQL Server)
Few days ago, I was working on huge database and I have to remove 80+ database tables with prefix “Temp_” (tables were created during data migration process). After few minutes of working, I came across the best solution. I found a query  which drops database tables with given prefix...
Read More
{ Published : August 31, 2016 // Post an Awesome Comment }
Dropbox Hacked - More than 68 Million Accounts Leaked
One of the popular cloud storage firm have been hacked. This hack lead the dumping of 68 million account information. Dropbox have confirmed this breach and ask it’s users to change the credentials as soon as possible. They did not announce exact number of affected users. Selection of files...
Read More
{ Published : October 27, 2014 // Post an Awesome Comment }
Send Mail using PHP
Sending mail is very necessary & required feature in almost every website/web application. There are two ways to send mail using PHP. After reading this article you will be able to send mail using both methods.Built-in method Third party library like phpmailer (recommended)I will recommend...
Read More
{ Published : July 10, 2014 // Post an Awesome Comment }
Ajax PHP Login with jQuery Shake effect
How to create Ajax based Login Page in PHP is the question that is frequently asked. In this tutorial We’ll discuss how to create Ajax PHP Login Page with jQuery ui Shake effect. We’ll create a user table, Our Login form will post and check the values of username and password from User...
Read More
{ Published : December 18, 2013 // Post an Awesome Comment }
Create DataTable From SQL Query in C#
DataTable is most commonly used for Data binding. You may need to generate DataTable many times in the whole project. The best practice is to create a method.In this tutorial, we are going to code a method getDataTable . Lets Start! Namespaces required for...
Read More