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

Enlarging a CHAR column

by: admin2020-03-05

Scenario As usual when you don’t do something for a very long time, it is easy to forget what you knew already. I had to […]

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

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

Telerik RadGridView Column Format Calamity

by: admin2012-06-07

Wow… just wow. I lost about an hour trying to figure out a: TargetInvocationException: Exception has been thrown by the target of invocation. This is […]

Uncategorized

Storing null in a Column will compile, but will cause run time exception

by: admin2011-06-22

You can legally store a null in a column from a data row and the code will compile. Don’t do this thought because it will […]

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