Stories of daily programming
Searching files and file content in Window seems an easy task: you fill the search textbox of a file explorer window with the content you need to search and Windows start searching. But I have to say I don’t feel comfortable searching files in this way, and this function lacks some options like, for example,…
In this post I will show you how to create a simple HTML form to make an AJAX image upload using jQuery and PHP. In this way you can build a form which doesn’t require postbacks to upload a file. Let’s start creating the main PHP page by placing the necessary markup. I’ll call this…
Read More “HTML AJAX image upload & preview with JQuery and PHP” »
In order to share file in a secure way, I needed to configure an SFTP server on a Windows Server machine (don’t confuse with FTPS!). Since Windows doesn’t come with an SFTP server by default, you have to install a software to do that. To do the job, I choose “Bitvise SSH Server” which I like…
During the creation of a scheduled task using the task scheduler of Windows Server 2008 R2, I got the following error: Error has occurred for task ‘TaskName’. Error message: User account restriction error. The possible reasons are that blank passwords not allowed, or that a policy restriction has been enforced. and I couldn’t save the…
In one of my ASP.NET applications, I was developing a page to extract some data to an xlsx file, and for this purpose I was using the library NPOI. Using Excel to open the xlsx file created by the application, I obtained different results depending on the server where the application was deployed: using some servers…
Read More “NPOI and Excel found unreadable content in ‘[filename].xls’” »
As most of you know, an xlsx file is actually a zip archive containing some xml files. If you change the extension of the file from “xlsx” to “zip”, you can extract the content using a software like 7-Zip. Once extracted the content of the file, you can make some modification and zip to get…
Sometimes is useful to check how a certain query or a stored procedure behaves without cached data, so in this post I will show you how to reset SQL Server cache. To do the job, simply run these statements from SQL Management Studio: CHECKPOINT GO DBCC DROPCLEANBUFFERS GO DBCC FREEPROCCACHE GO
I was deploying an MVC5 application on a web space of the italian provider Aruba. After launching the application I obtained the following error: Server Error in ‘/’ Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your…
Read More “ASP.NET MVC5 Security Exception on Aruba provider” »
During the installation of Sql Server 2016 on a brand new server running Windows Server 2016, in the prerequisites checking phase I obtained the following error: “Oracle JRE 7 Update 51 (64-Bit) or higher is required for Polybase”. I solved the problem installing the following version of Java: Java SE Development Kit 7u79 available at…
Read More “Oracle JRE 7 Update 51 (64-Bit) or higher is required for Polybase” »
During the porting of an application from MySql to MariaDB, I found another curious fact: I get a different ORDER BY behaviour between MySql And MariaDB. Look at this query: SELECT DISTINCT Z.ID FROM ( SELECT Field1, Field2, Field3…. FROM Table1 ORD INNER JOIN Table2 OC ON ORD.OrderCopID = OC.ID LEFT JOIN Table3 NEG ON…
Read More “Different ORDER BY behavior between MySql and MariaDB” »