Introduction Just like everything that requires coding with (or against?) TFS API – this was not a small task. This took a while for me […]
SSRS Windows Integrated Security: Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’
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 […]
How to Kill all Processes for a Specific Database
Usually you would just use the Activity Monitor like shown below… The mundane repetition of right click each process and selecting Kill Process becomes annoying […]
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 […]
WSE: Server unavailable, please try later
This is an amazing gotcha that had me almost throw my computer off the sixth floor of my building. First to narrow down the steps […]
HTTP Error 404.2 – Not Found, Error Code 0x800704ec
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 […]