Working with dates correctly gives us a lot of power. Dates are a surprisingly complex part of databases, especially if we take into consideration the general complexities in calendars. SQL Server has a lot of subtleties, and some formatting nuances which can be difficult to remember. This is the first in a short series of articles…
I’m a big fan of being able to roll my own tools for some simple tasks. JavaScript gives many options and opportunities for creating simple tools to make life easier for people. Occasionally I’ll have a mathematical formula which I need to use a few times, or I might need to do some repetitive string…
Often when running a script, or a stored procedure (with many distinct sections) it’s handy to be able to have the classic “I’m here and the time is X” Logging. I often use this when first looking at monitoring and optimisation of processes. I thought, for my first post , while I get things a…