{ Published : June 28, 2018 // Post an Awesome Comment }
Sometime we need to convert DataTable to generic List. Suppose we want to convert a DataTable (containing data of Employee table) to generic List of custom data type Employee (Employee Model). We can achieve this by looping through rows of DataTable and add object of custom class to generic...
Read More
{ Published : June 28, 2018 // Post an Awesome Comment }
How to Get Size of All Tables in SQL Server
Sometime there is simple solution to a complex problem. Few days ago, I have to find each database table sizes (disk space used by every table) and number of rows for database optimization purpose. When we think about such kind of problem, we may think that could be difficult to find disk space...
Read More
{ 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