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... by Garland MacNeill | Apr 12, 2018 |
Steve Jones (t|b) wrote a blog post talking about the death of the title Database Administrator.Mind you, he was talking about the title of DBA, not the actual job of being a DBA. Semantics, right? If you look across the inter-webs, the death of the DBA has been a... by Garland MacNeill | Feb 7, 2018 |
One of the things that has always frustrated me with Microsoft’s tools like SSMS and Visual Studio, is the sheer depth of the tool. Figuring out how to create an SSRS or SSIS package in Visual Studio the first few times can result in half a day wasted. SSMS can... by Garland MacNeill | Feb 7, 2018 |
This is one of those tools I use all the time. I’m always looking at the version number to see which version of SQL with SP/CU version I am working with. SQL Version numbers and patch...
