Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

Configuring an SFTP server on Windows Server

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…

Read More “Configuring an SFTP server on Windows Server” »

SFTP

Error message: User account restriction error

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…

Read More “Error message: User account restriction error” »

Task scheduler

NPOI and Excel found unreadable content in ‘[filename].xls’

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’” »

ASP.NET

Zipping xlsx file correctly

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…

Read More “Zipping xlsx file correctly” »

Excel

Reset Sql Server cache

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

Sql Server

ASP.NET MVC5 Security Exception on Aruba provider

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” »

ASP.NET MVC

Oracle JRE 7 Update 51 (64-Bit) or higher is required for Polybase

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” »

Sql Server 2016

Different ORDER BY behavior between MySql and MariaDB

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” »

MariaDB

phpMyAdmin: #2014 – Commands out of sync

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…

Read More “phpMyAdmin: #2014 – Commands out of sync” »

MariaDB

Hello world!

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…

Read More “Hello world!” »

MySql

Posts navigation

Previous 1 … 9 10

Copyright © 2023 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark