SQL Server – Counting the rows in a table
SQL ServerCounting the rows in a table If you need to find how many rows there are in a table the simplest method that works across most databases is to use the “select count(*) from <table name>”. The way Microsoft’s SQL Server manages the request is to find the narrowest index or the table and […]
Unix Solaris Linux – Directory failing to backup – ‘ls’ error ‘not enough memory’
Netbackup failed to backup a Solaris directory. Running the ls command resulted in the error not enough memory. The problem was that was about 10 million files in the directory. Using the find command I removed half of the files.
IIS & ColdFusion 2018 configuring mime types & Java Config Part 2 of 2
IIS & ColdFusion 2018 configuring mime types & Java Config Part 2 of 2 Still under constructionMime Types After successfully migrating from an ancient version of ColdFusion to a ‘new’ Windows Server 2019 with ColdFusion 2018 the users started having issues.The problem turned out to be we were missing a ‘msg’ mime type on the […]
SQL Server on VMware 6.7 – configuring controllers & disks
What is the best controller disk configuration to run SQL Server on VMware 6.7? Preamble I had to build some SQL Server VMs on VMWare 6.7 hosts. I searched for good articles on VM configurations and I struggled to find enough and they all seemed to contradict each other. The company I work for are […]
Installing and patching ColdFusion 2018 on Windows Server 2019 Part 1 of 2
The issues I had patching ColdFusion 2018 on a Windows Servwe 2019 and how I managed to manually patch and get the server to work in Production.