Stories of daily programming
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 may want to lock the drive again. I couldn’t find any option in the user interface to do this (the only way seems to be reboot the PC). Searching in…
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 by unauthorized persons, that may happen for example if your laptop or external USB drive is stolen. So if you want to encrypt your drive, Bitlocker is your friend. But…
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 you can only use SQL Server Management Studio. Is there a way to do this? Yes…. You could use the following query: SELECT DISTINCT OBJECT_NAME(id) AS [OBJECT_NAME] FROM sys.syscomments WHERE…
Read More “Search a string in stored procedures, functions and views in a SQL Server database” »
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 Perl. If you want to dump the content of a string variable, there are no problems as you could simply do the following (throughout this post I will use “die”…
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 “Sql Server Import and Export Data” tool this was an easy job. After processing data in my own Sql Server, I had to reload the data to another Sql…
Read More “Load a huge amount of data in a Sql Server table” »
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 by Sql Server Management Studio, and I got the following error “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine”. The error persisted even after the installation of the…
Read More “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine” »
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 an application of mine, and making some tests, the application started to automatically log out me after inserting my credentials in the login page. In the log generated by Fuel,…
Try to answer this riddle: What is the result of this SQL Server query: PRINT LEN(‘ ‘) I would answer 1, since I passed a string with one space…. but it’s the wrong answer. In this case the LEN function returns 0! Why this behavior? If you check the Sql Server documentation at https://docs.microsoft.com/en-us/sql/t-sql/functions/len-transact-sql?view=sql-server-2017 this…
Read More “SQL Server LEN function return 0 passing a string with one space” »
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 tablet, a Galaxy TAB S2, and instead working as usual, it started an endless reboot… I describe below the solution that worked in my case… First start your tablet in…
Suppose to switch on your PC on a frosty morning, try to connect to a remote server using Windows remote desktop, and get the following error message: “Remote desktop computer: an authentication error has occurred…. This could be due to CredSSP encryption oracle remediation”. Searching on the internet it seems that the problem is due…
Read More “Remote desktop computer: an authentication error has occurred” »