Stories of daily programming
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” »
Hello everyone, another day, another error…. I was migrating a MySql database from one server to a new server. In the new server, calling one of the stored procedures of the database from the phpMyAdmin interface I obtained the following error: #2014 – Commands out of sync; you can’t run this command now Two were…
I want to start this new blog talking about a problem I faced few days ago, working with a web application developed using PHP and MySql. Using the application users experienced unexplained and random slowdowns in the production environment running on a dedicated server of the italian provider Aruba. The same application with the same database…