Category: Code or Hosting
-
Obtaining Usage Information on *nix Systems
When obtaining usage information, there are primarily 3 details you want to look at (for my needs, yours may vary) being CPU, RAM, Hard Disk. On many systems you can use the below commands: cat /proc/cpuinfo | grep processor | wc -l free df -h On newer machines ( I think RHEL 6 and newer)…
-
Faulting application name: cygrunsrv.exe, version: 0.0.0.0, time stamp: 0x40826252 Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp: 0x4ec49b8f
Okay, ran into this issue and had errors in numerous places, errors consisted of 2 Information items in the event viewer: Faulting application name: cygrunsrv.exe, version: 0.0.0.0, time stamp: 0x40826252 Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp: 0x4ec49b8f Exception code: 0xc0000005 Fault offset: 0x00033de8 Faulting process id: 0x1864 Faulting application start time: 0x01ce3154ee337ce8 Faulting…
-
Adding the Administrators group within SQL Server
If you want to add the group Administrators to SQL so that any user of the Administrators Group can use SQL server, the below code, once executed, will perform this for you: CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH DEFAULT_DATABASE=[master] GO EXEC master..sp_addsrvrolemember @loginame = N’BUILTIN\Administrators’, @rolename = N’sysadmin’ GO
-
Testing dotDefender using URL String
Okay, I keep ‘forgetting’ how to test if dotDefender is in place and able to block requests. Long story short, a URL can be fashioned as such: http://example.com/?id=variable’or1=1 in order to be able to trip the expected response:
-
Determining Microsoft SQL Server Version
Open up SQL Server Management Studio and connect to the Database Engine (connection not pictured) Right click on the instance and choose Properties from the menu. Here you can see the Product and the Version, as both are important details. If you are noting this for future reference I recommend noting the entire line of each.…
-
Checking current CPU and RAM (Memory) usage on Windows 2008
If you need to check the current CPU and RAM usage on Windows 2008, Windows 2008 R2 as well, it is a matter of right clicking on the Task Bar (Usually found on the bottom of the display) and selecting ‘Start Task Manager’: Here on the Windows Task Manager you can see current CPU usage,…
-
HTTP Error 400.0 – Bad Request ASP.NET detected invalid characters in the URL from ampersand
To resolve the error of HTTP Error 400.0 – Bad Request ASP.NET detected invalid characters in the URL , whether you are using Helicon Ape for url rewrites or not, is to make the following registry additions: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET] “VerificationCompatibility”=dword:00000001 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\HTTP\Parameters] “AllowRestrictedChars”=dword:00000001 This will allow you to continue to use the…
-
RegAsm : error RA0000 : Unable to locate input assembly ‘c:\Windows\System32\Pay flow_dotNET.dll’ or one of its dependencies.
I was getting the error of RegAsm : error RA0000 : Unable to locate input assembly ‘c:\Windows\System32\Pay flow_dotNET.dll’ or one of its dependencies. when following instructions from installing the Payflow_dotNET.dll dll for .NET to use. As I was running this command: C:\Windows\System32>c:\Windows\Microsoft.NET\Framework64\v2.0.50727\RegAsm.exe c:\Windows\System32\Payflow_dotNET.dll There is an issue here, is that the dll, although there, was not…
-
Solved: rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1039) [sender=3.0.6]
rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1039) [sender=3.0.6] So, apparently I had not become root just yet. Whoops. Once I had ‘sudo su -‘ed, I could run the command no problem. If this did not solve your problem, please post a comment.
-
Calculating Disk Space in Use by All Databases within a Given MSSQL Instance
If you are trying to calculate total disk space in use by all databases within a given MSSQL instance, you can use the following script to determine this space. SELECT CONVERT(DECIMAL(10,2),(SUM(size * 8.00) / 1024.00 / 1024.00)) As UsedSpace FROM master.sys.master_files It has been said that “Sys.Master_files is a server-wide view that lists every file in…