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

Improving SQL Server cursor performance

Hi everyone! Today I want to talk about a performance problem I had a few days ago using a SQL Server cursor. Imagine using a cursor in the following classic way: DECLARE @ID INT DECLARE @ITEM_CODE VARCHAR(50) DECLARE MY_CURSOR CURSOR FOR SELECT ID, ITEM_CODE FROM MY_TABLE T LEFT JOIN A_TABLE T1 ON T.ID = T1.ID LEFT…

Read More “Improving SQL Server cursor performance” »

Sql Server

Failed to decode downloaded font: (your web application address)

Suppose your web application gives this error message in you web browser console: “Failed to decode downloaded font”, followed by the address of the font with the problem. This is something similar to error messages you see in the image below. What you can do?Searching the internet about this problem you can find several solutions,…

Read More “Failed to decode downloaded font: (your web application address)” »

ASP.NET

Plesk panel update error on Linux CentOS 7: The GPG keys listed for the “dell-system-update_dependent” repository are already installed but they are not correct for this package

Few days ago, performing a Plesk Panel update, I got the following error: “The GPG keys listed for the “dell-system-update_dependent” repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository.” It was quite strange, since Plesk update always worked with problems until…

Read More “Plesk panel update error on Linux CentOS 7: The GPG keys listed for the “dell-system-update_dependent” repository are already installed but they are not correct for this package” »

CentOS

Delete all rows from all tables in a Sql Server database

Delete all rows from all tables in a Sql Server database may not be an easy task. This because in a relational database you have foreign keys between tables, and to empty all tables you have to write delete statements in the correct order to avoid foreign key violations. I know that there are scripts…

Read More “Delete all rows from all tables in a Sql Server database” »

Sql Server

Lock a Bitlocker drive again after unlocking

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…

Read More “Lock a Bitlocker drive again after unlocking” »

Bitlocker

Encrypt a Windows drive with Bitlocker

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…

Read More “Encrypt a Windows drive with Bitlocker” »

Bitlocker

Search a string in stored procedures, functions and views in a SQL Server database

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

Sql Server

Dump the content of an array / hash in Perl

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

Read More “Dump the content of an array / hash in Perl” »

Perl

Load a huge amount of data in a Sql Server table

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

BCP

The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

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

Excel

Posts navigation

Previous 1 … 7 8 9 … 11 Next

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

Powered by PressBook Masonry Dark