Today I want to talk about a very strange problem found developing a web page and using that web page in Google Chrome. Suppose you…
Improving SQL Server cursor performance
Hi everyone! Today I want to talk about a performance problem I had a few days ago using a SQL Server cursor. Imagine using a cursor…
Failed to decode downloaded font: (your web application address)
Suppose your web application gives this error message in you web browser console: “Failed to decode downloaded font”, followed by the address of the font…
Plesk panel update error on Linux CentOS 7: The GPG keys listed for the “dell-system-update_dependent” repository are already installed but they are not correct for this package
Few days ago, performing a Plesk Panel update, I got the following error: “The GPG keys listed for the “dell-system-update_dependent” repository are already installed but…
Delete all rows from all tables in a Sql Server database
Delete all rows from all tables in a Sql Server database may not be an easy task. This because in a relational database you have…
Lock a Bitlocker drive again after unlocking
In my latest post I explained how to encrypt a drive with Bitlocker to avoid unauthorized access to your data. After unlocking a drive, sometimes you…
Encrypt a Windows drive with Bitlocker
Today I want to show you how to encrypt a Windows drive. Why should you encrypt a drive? Basically to prevent your data from being read…
Search a string in stored procedures, functions and views in a SQL Server database
If you want to search a string in stored procedures, functions and views, maybe you can use some special tools. But, for instance, suppose that…
Dump the content of an array / hash in Perl
While writing software, is sometimes useful to dump the content of a variable. In this post we will see a simple way to do it in…
Load a huge amount of data in a Sql Server table
Last week I had to load a huge amount of data, about 500,000 rows, in a Sql Server table to make some data processing. Using…