Postgresql 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 [crayon-5b29e1b73160e485477190/] You need to do something like this:...
read moreDatabase Administration is changing
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...
read moreT-SQL Tuesday #101: Tools I forgot
The 101st addition to the SQL monthly blog party is being hosted by Jens Vestergaard (b/t). For the topic this month, Jens has asked which tools are essential to our daily job. Or rather, which tools do I depend on as a DBA. Interesting Topic I would love to say I...
read moreSpace: Unused vs Unallocated
I had previously blogged about working on a SQL job that deleted data older than 13 months. Today I thought I would follow up with the database and check to see how much space was available in the database. So I ran a disk usage report out of SSMS and got the...
read moreGetting whipped by GetDate()
I have recently been working on tuning a job that purges data out of various tables that are older than 13 months using getdate. Pretty straight forward right? Well originally the job consisted of 6 different statements like so: [crayon-5b29e1b7323c7969807824/]...
read moreTSQL Tuesday #99 – Outside Interests
This month, Aaron Bertrand (b/t) is hosting the TSQL Tuesday topic. And this month, the topic of choice is either 1) an outside hobby or 2) bad habits found/used in TSQL. I somehow think by the time I’m done with this post, I’m going to blur the two together....
read more