Edventures in Normalcy

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:

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.  Keep in mind the Version does change as upgrades to SQL server are installed through KB’s and Windows Updates.

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, keep in mind this fluctuates a lot, as well as Memory usage.  In this screen the 2.67 is the memory in use, and the total memory is listed as 3071 (actually 3GB).  Both numbers are useful for reference   Make note of the green bar graphs as they are easy indicators:

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:

This will allow you to continue to use the & character the same as you had in IIS6.

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 all that usable for a 64 bit version of .NET, so I moved the file to

C:\Windows\SysWOW64

and from that folder within a command prompt was able to move forward:

C:\Windows\SysWOW64>c:\Windows\Microsoft.NET\Framework64\v2.0.50727\RegAsm.exe Payflow_dotNET.dll
Microsoft (R) .NET Framework Assembly Registration Utility 2.0.50727.5420
Copyright (C) Microsoft Corporation 1998-2004. All rights reserved.

Types registered successfully

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.

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.

It has been said that “Sys.Master_files is a server-wide view that lists every file in every DB. It’s available from SQL Server 2005 onward.”