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…
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
I was trying to load the content of an xlsx file into a Sql Server database using the “Sql Server import and export wizard” provided…
FuelPHP session storage
Hi everybody! As already mentioned in one of my previous posts, I base my PHP web applications on the FuelPHP framework (www.fuelphp.com). I was working on…
SQL Server LEN function return 0 passing a string with one space
Try to answer this riddle: What is the result of this SQL Server query: PRINT LEN(‘ ‘) I would answer 1, since I passed a…
Samsung Galaxy TAB S2 endless reboot
It’s been a while since we last heard…. So today I want to tell something new that happened. Few days ago I switched on my…