HTTP Error 404.2 – Not Found The page you are requesting cannot be served because of the ISAPI and CGI Restriction list setting on the […]
SQL Server: Attaching a Second Copy of a Database that Exists Already in the Same Server
This was a fun one, I couldn’t find a definitive answer on this so here is mine. Question How can I attach a database (MDF/LDF) to my […]
SQL Server 2008 R2 will not install – Unhandled Exception has occurred in your application.
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 […]