Skip to content

Obscure Problems and Gotchas

If you couldn't find your answer to your weird problem, you might find it here.

  • About
  • Application Errors Hall of Shame
  • DyslexicApps
Uncategorized

Sql Server tSql: DELETE statement executes but won’t delete

by: admin2016-07-17

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. […]

Uncategorized

I have no words for how bad this is

by: admin2015-02-26

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 […]

Uncategorized

How to use Excel and tSQL to help you Generate Code

by: admin2014-11-20

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 […]

Uncategorized

Simple Class Creator and DTO Generator

by: admin2014-05-25

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 […]

Uncategorized

SSRS Windows Integrated Security: Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’

by: admin2013-06-13

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 […]

Uncategorized

How to Kill all Processes for a Specific Database

by: admin2012-10-24

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 […]

Uncategorized

Easy Way to Start/Stop SQL Server on a Multipurpose Machine

by: admin2012-09-10

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 […]

Uncategorized

Entity Framework: Executing SQL Strings

by: admin2012-09-01

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 […]

Uncategorized

How to get Filename and File Extension from a Column with tSQL

by: admin2012-08-07

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 […]

Uncategorized

SQL Server: String or binary data would be truncated.

by: admin2012-04-30

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 […]

Posts navigation

Older posts
Newer posts

Search posts

Happy find? Help me buy the coffee that fuels these articles!

Like what you are reading?

It takes time to write these quality blog posts and sometimes software. Maybe something I have written has benefited you? Blog posts can take anywhere from a few minutes, to a couple of hours, to several days to construct. Software is a constant work in progress. Want to help me buy my next bag of coffee?

Anything is appreciated

Categories

Recent Comments

  • admin on Replacing the CyberPower EC850LCD battery
  • wil blake on Replacing the CyberPower EC850LCD battery
  • admin on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • IG on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • Unable to connect to database with .NET Core 3.1 File System Publish to IIS on DotNet Core EF migration not working

Archives

Search posts

Search posts

SSL Secure

Copyright © All rights reserved. Theme Creativ Mag by Creativ Themes