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 […]
SSRS Logical Flaws of IIF
Déjà Vu It isn’t very often when I have to build reports for SSRS, it usually happens in bursts. I will write like 2-5 reports […]
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 […]
Visual Studio’s Immediate Window – C# vs VB.Net
I am primarily a C# developer, I will admit up front that I dislike VB.Net and will avoid using it when I can. I am […]
Visual Studio Macros
I just wanted to share some very basic things that you can do with Visual Studio Macros. This explanation will be valid for both Visual […]
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 […]