Just a note: If you need to work regularly with log files, consider looking at the Microsoft's log parser toolkit. This is a stand-alone EXE with a small footprint. Uninstall...

You corrupted your data (at least for a relational model). You made it non-atomic, since that column now contains two pieces of info (type and id#), not one (just id#).

Instead...

I completely agree with Celko.

At my place of work we had to import some employee data that came from 2 completely separate systems, one for temporary and one for permanent...

Something has been superseded for a good reason, purge it!

The purging of legacy stuff will require code changes and thus introduce risk, while keeping the (now non-functional stuff) around may...

Something I also tend to do:

If the script uses any hard-coded values (for example how many times to re-try after a likely failure, or the format definition of an output...

• This reply was modified 4 years, 10 months ago by  mosaic-287947.

In order to practice writing some code, it's not just the documentation (or lack thereof) that can be a challenge, but also the sheer number of layers you need to...

If you install Docker, minimum, you don't need to be a server admin to figure things out. Microsoft has a great guide on using containers with SQL Server...

I have been aware of containers for quite a while and started to look into them several times now. The idea is to experiment in a small way, just to...

I once had to update an ancient Visual Basic 4 (yes, that is not a typo) application. The code had gone through many versions and was littered with comments about what each...

A case of wishful thinking?

Another useful blog is http://www.troyhunt.com/

Gary Varga (2/19/2015)

call.copse (2/19/2015)

Gary Varga (2/19/2015)

Given that I have learnt to avoid using third party tools wherever possible and stick to what the majority of my clients use. This means...

I have been told off for doing others a favour, because of politics between departments that I was not aware of. The more unknowns there are (who's asking, which department,...

It would be fascinating to follow the adventure and there will be much to learn by all concerned. But my guess is that you will end up maintaining two systems...