Postgresql follow up

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 more
Expanding horizons a touch, looking at Postgres

Expanding 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 more

Wait 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 more

DateTime2 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

T-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 more
Space: Unused vs Unallocated

Space: 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 more

A Month of SSMS

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 be...

read more
Garland MacNeill

Garland MacNeill

DBA

Garland is a husband, father, DBA, hiker, camper, motorcyclist, and just some guy living deep in the woods. 

Archives