Year end review and thankful
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 number of reasons. It...
read moreWell Bye……Google
I've been in IT a long time, coming up on 20 years. When I begin Yahoo was a titan, Excite was still around, and I felt snobbish with Ask Jeeves (they had a butler as a logo....hence the snobbish feel...) but the search engine that I ended up gravitating to was...
read moreDBA/Developer learning resources for Microsoft SQL Server
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...
read moreOffice Conditions
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 - shared...
read moreK. Fisher’s Homework – Create db
In December the topic of the month for #Tsql2sday was to talk about our learning goals for 2018. One of the goals I put forth was to get better at SQL development. As part of that goal, I also realized I have to get more familiar with Visual Studios. So to help with...
read morePostgresql follow up
A couple of weeks ago I was given the task of helping a developer figure out why his Postgresql cluster wouldn't fail over. The specific problem was to test failover prior to launching the Postgresql cluster in to Production. Sounds easy enough,, right? Setting things...
read moreUpdate: Six Months later
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 there's...
read moreExpanding horizons a touch, looking at Postgres
This week I got asked to help a developer figure out why a failover wasn't working on a Postgres cluster. Interesting enough I guess. Especially because I don't know anything about Postgres. Good time to learn I guess? I don't know. Anyway, I accepted the directive...
read moreWait Stats Library
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 you...
read moreDateTime2 not like DateTime
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 OrderDate < GETDATE() -1 You need to do something like this: OrderDate...
read more