Restore to a point in time

This week I had to do a point in time restore for an entire instance. The instance had approx 25 databases on it, and all of them had to be replaced to get the information we needed. As this was on a SQL Availability Group, we are backing up the logs every 15 minutes....

read more

DBATools

I don't know why I am slow to take up new tools, but I am. I recently, like back in December, began working with DBATools. In case you're not familiar, DBATools is a powershell module assembled by the community over at DBATools.io. This module, oh this wonderful...

read more
Just fix it

Just fix it

Kids, it's 2020. That it means it way past the time to kick the can down the road. Most of us in IT have been around long enough to see us shift from a centralized CPU (mainframes) to decentralized (client/server) architectures back to a centralized approach again...

read more

I’ve been busy…

I doubt anyone has noticed, or really frequents this blog for much. Maybe a few people swing through to grab saved links, and that's okay. This blog is mainly for me anyway as a place to take notes and save resources so I can find them fast. So maybe this post is just...

read more
Well Bye……Google

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

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

Finishing up and moving on

It's hard to believe this is my last week in Denver. Come Monday I am moving to northern Wisconsin. I'm jumping in the truck alone to head for the Great Lake region with my wife following in December. Which, for me at the moment, maybe the hardest part of this move....

read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close