Converting to (and from) Julian Date (YYDDD) format in T-SQL

I often get asked how to convert a datetime into Julian Date format in T-SQL. People have differing opinions about what Julian means, but the one I got asked about most recently meant YYDDD, as often used by mainframe systems (I think this is Julian Date, as opposed to Julian Day which is the number … Continue reading Converting to (and from) Julian Date (YYDDD) format in T-SQL

A review — Microsoft Windows PowerShell Step By Step (Ed Wilson)

Another book review, and another giveaway for the Adelaide SQL Server User Group. This time, it’s Microsoft Windows PowerShell Step By Step. Last month I had picked up the Windows PowerShell Scripting Guide, wondering if it was going to be a good recommendation for people who were interesting in getting into PowerShell. Even though I … Continue reading A review — Microsoft Windows PowerShell Step By Step (Ed Wilson)

Things You Know Now

This blog meme is doing the rounds… I’ve been tagged at least twice now (Jason Strate and Greg Linwood), so I suppose subconsciously I’ve been thinking about this stuff for a few weeks already. Since I do a lot of training, I tend to explain these things to my students anyway. I have a lot … Continue reading Things You Know Now