Problem I ran into the most puzzling issue recently where I was executing a DELETE statement inside of a transaction among other statements inside of a stored procedure. […]
I have no words for how bad this is
I think this should win the “Most Horrible Sproc Parameters” contest if there were such a thing. And then people wonder why I get mad […]
How to use Excel and tSQL to help you Generate Code
Introduction It’s amazing to me the reactions I get when I show people seemingly simple tricks on how to automate or generate code and/or script […]
Simple Class Creator and DTO Generator
What? A long time ago back around the middle and towards the end of 2012 I decided to create a console application that would help […]
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 […]
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 […]
Entity Framework: Executing SQL Strings
I’ve griped about this before, not sure why everything has to be so complicated with EF at times, but holy hell executing just a simple […]
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 […]