Buggy Installers This is a fun installation problem it almost made me pull my hair out trying to figure it out. Concerning installations I honestly […]
Straight to the Point: Query for Database and Table Sizes
I love how I have to search too much to find simple information, one liners, it is just like in College where my college course […]
Query SQL Server using PowerShell
I don’t understand why it was so difficult for me to find an example on this, so I compiled one from three posts so I […]
Selecting Random Date Between a Date Range with tSQL
I had a very interesting experience recently trying to figure out how to select a random date between a date range using tSQL, it was […]
Remoting Servers 101
Before I jump into this, I just want to explain that Remoting is an old .Net v1.1 technology and it is no longer supported. However […]
Adventures In Web Service and Remoting Server Craziness
I don’t think there are that many people out there that still have to deal with more than one .Net Framework, but I have to […]
Remoting Server Troubleshooting
If you are having trouble with getting remoting to function properly and you know you have everything configured properly then it is more than likely […]
SQL Server: Tips on Declaring a Decimal Data Type
One of my pet peeves about SQL Server is the decimal data type. Declaring it once in a table where you don’t have to do […]
HTTP Error 500.19 – Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. Error Code: 0x8007000d
This is probably one of the more annoying errors I have ever encountered with IIS7. All the information I was finding for it online was […]
How to connect to a remote SQL Server
I posted about this on Stackoverflow.com http://stackoverflow.com/questions/2486610/how-to-connect-to-sql-server-from-another-computer/6765184#6765184 I think I will revisit this later to find the correct 1 way solution to this problem.