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
Development, SQL Server

Small date time is garbage and you should stop using it

by: admin2020-02-18

Smalldatetime has been obsolete for a long time now get with the program A major pet peeve of mine is the smalldatetime datatype from SQL […]

Development, Gotcha, IIS

IIS application pool exploit

by: admin2020-02-15

What? That’s what I said too when I first discovered the exploit. I didn’t think it was so easily possible to extract usernames and passwords […]

Development, SQL Server

Error: The SQL command requires a parameter named “”, which is not found in the parameter mapping.

by: admin2020-02-04

Gotcha This is a problem I have encountered a few times already when using SSIS with an OLE DB Source and a stored procedure. All […]

.net core, Development, Uncategorized

Adding assembly version information to dotnet core projects

by: admin2020-02-01

Gotcha In dot net framework the assembly information was located inside of a Properties folder where you would find the “AssemblyInfo.cs” file and you could […]

Development, SQL Server

SSIS loop and container continue on error

by: admin2020-01-27

Obscure and not straight forward This is one of those things I can never remember because it doesn’t come up that often. This is usually […]

C#, Development

LinqPad quick reference

by: admin2020-01-24

This is a quick post for my own ignorance. On occasion I use LinqPad to make changes in a database and I find the stock […]

Development, SQL Server

Visual Studio 2017 SSIS unable to start debugging

by: admin2020-01-20

Microsoft’s handling of SSDT isn’t good I have criticized Microsoft about this before here – and I am going to continue to wag my finger […]

Development, SQL Server

Pivoting data without an aggregation column

by: admin2019-10-18

Don’t use PIVOT for non-aggregate-able data I ran into a rather displeasurable experience where a separate team of people built some very important tools for […]

ASP.Net, Visual Studio

Could not load file or assembly System.Web.WebPages.Deployment

by: admin2019-09-16

I encountered this problem when moving from an old machine to a new machine. I vaguely recall having this problem once before, but it was […]

.net core, Development, NuGet, NUnit, Unit Testing

Dot net core NUnit unit test won’t start

by: admin2019-09-02

I was hoping this problem would resolve itself, but it hasn’t so I am writing about it to document it to refer to in the […]

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

  • Paloma on DataGridView Loses Formatting and Columns After Setting DataSource a Second Time
  • Caleb on MVC CSHTML partial view loses all syntax highlighting/color during rename operation; then copy, cut or paste operations cause Visual Studio errors to be thrown
  • Rilwan on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • admin on Biases in naming database objects
  • Alberto D. Sarubbi on Biases in naming database objects

Archives

Search posts

Search posts

SSL Secure

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