The Overly Complicated Problem I spent about 2 days trying to figure this problem out, until we had some professional help step in to help […]
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The request failed with HTTP status 404: Not Found.
Screenshot of Error in the Report Viewer This error reads: The attempt to connect to the report server failed. Check your connection information and that […]
Easy Way to Start/Stop SQL Server on a Multipurpose Machine
I have been doing a lot of development on my gaming machine and as all gamers know, you want to have as much free RAM […]
How to get Filename and File Extension from a Column with tSQL
I have written this query like 100 times, but this time I am going to document it so I don’t lose it again. This query […]
SQL Server: String or binary data would be truncated.
Msg 8152, Level x, State x, Line x String or binary data would be truncated. What does this mean? This is the equivalent of SQL […]
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 […]
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 […]
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.