Here’s a quick post to remind myself and others, to check ALL of the permissions when working with replication. For the past couple of days, I’ve been working on getting transactional replication set up between a couple of servers in between other projects I’ve been working on. For the last day I kept running into the following error: “The remoter
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 up wasn’t too bad, but finding answers quick was a challenge. Setting up The last
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 and started trying to get familiar with the new RDBMS system. The dev sent
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 noticed the invitation last week and had an idea
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 following result: Wait, what? I was looking at
DevOps has been a buzzed word in the IT space for a while now. In case you are unfamiliar, DevOps is the conceptual marriage between Developers and IT Operations. The idea behind DevOps is to facilitate communication and collaboration via cross department integration, which is a crude way of saying the barriers between operations and developers are being broken down/stripped. While the concept of DevOps is not new, bringing databases into DevOps is (or rather, maybe to me it is).
A while back I was working on setting up a new Availability Group (AG), which required working with tempdb. It was a bit of an advanced setup in the sense that it was a five node cluster, four nodes set up in a standard AG – two active/passive AGs. The fifth node was a participant in both AGs as a