Quite often I just guess, and almost equally as often I guess wrong. But, I enjoy the exercise, plus, eventually I learn the correct answer. I'm very pleased to just...

This filled 2 gaps in my knowledge store, the first being a chance to see an example of the MERGE statement, which is a statement I still know little about, and...

I really have to start reading the whole problem before I answer. Thanks for keeping me humble.

Luther

Fun is solving the problem. Its even more fun if an approach is found that is new, and sustainable, with emphasis on sustainable. If I can't re-use it and improve...

The description "version number" vs "an optional integer that is used to group procedures of the same name" has a bit of a semantic disconnect that took me several minutes to reconcile...

I would love to work with someone like that, and I would like to be more like that person as well. I see that type of person as an asset...

this I have to investigate more thoroughly. I have a number of subqueries in a long running query where I am trying to retrieve the first, the last or the...

Since you are traversing all the folders within \\srvfil01\Claims Autoload, why not just set your file mask as *.xlsx and then check the returned value for "\Pending\"  before processing? It...

I like your idea of a session on starting a blog. I find myself wanting to start a blog, partly because I think here and there I have found a...

If you haven't already, you might try  and use Task Manager to see what processes are running. It would let you know, maybe, if your job is leaving unclosed IE...

Thank you for the link. Since I am looking for a solution to install multiple systems on a laptop, the Hypervisor sounds like way too much for my "simple" needs.

I usually just tell them I am responsible for moving data around between files, databases, and devices. If they ask what my company does, I ask them when was the...

definitely an issue of use case, I will agree. 
My brain boggles at even how I would find a data situation that would require much past 4th normal form, and...

The only thing I was sure of was that it was not T-SQL. Now I'm going to have to consider learning R as well as Python and Powershell.
Always fun...