by Garland MacNeill | Nov 22, 2018 |
It’s Thanksgiving Day and before we know it, Christmas and New Years will be upon us. 2018 hasn’t worked out as I planned last year. In fact, 2018 has been a difficult year for me personally. The first half of the year Jan – April was rough for a...
by Garland MacNeill | Sep 14, 2018 |
One of the hardest things to do when looking to start out in the SQL world, is to find quality sources to learn from, or just not get overwhelemed with information. To help alveiate that, I have assembled a list of resources that I use to continue learning and...
by Garland MacNeill | Jul 19, 2018 |
I have worked in an office environment for a long time. Going on twenty years in fact. I have worked in a number of different types of environments, but cubicles have been the standard. In fact, in my career I have only had a walled office a couple of times –...
by Garland MacNeill | May 26, 2018 |
Six months ago, I accepted a new position in Duluth, MN and moved to house we already owned in Wisconsin not too far from Duluth. And by not too far, my commute is about an hour, depending on the weather. It’s about the same drive time I had in Denver, except...
by Garland MacNeill | May 9, 2018 |
Every so often you come across one of those tools that just changes everything. When it comes to troubleshooting tools, this is one of those defing tools. Paul Randal has assembled the greatest library of SQL wait statistics known to man – well to me anyway. If...
by Garland MacNeill | Apr 20, 2018 |
I came across an article on SQL Server Central written by Claudio Silva (b/t) discussing that you can’t do arithmetic operations on DateTime21 like you can with DateTime. For example: Old Way Transact-SQL OrderDate < GETDATE() -1 1 OrderDate < GETDATE() -1...
