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

Searching files and file content in Windows

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,…

Read More “Searching files and file content in Windows” »

Tools

HTML AJAX image upload & preview with JQuery and PHP

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

AJAX

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

Posts navigation

Previous 1 … 9 10 11 Next

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

Powered by PressBook Masonry Dark