Feeling refreshed

I mentioned in my last post that I was feeling a bit burnt out. Applying a lot of pressure to myself, feeling like I had to learn everything right now. I took 6 days off over the 4th of July weekend to go camping and a class on Fly Fishing. It put some things into...

read more

Slacking off a bit

I have to admit, I have been slacking off a bit regarding get a post up on this blog. It's summer time, and well....I'll admit, my interests have been in other places. It's really hard to focus when its hot outside. It's also hard to focus when you'd rather be...

read more

Change Control

This post maybe a little "ranty". It seems in the past few months, I seem to have encountered a number of instances where changes to the database were made without a Change Request. Which has sparked a few conversations with developers over why there is a need for...

read more

Learning System

So after posting yesterday about struggling to keep up with SQL information, I got to thinking about how I could actually solve the problem instead of just complaining about it. I didn't come up with grand, earth shattering Kabooms. What I did come up with is a system...

read more

How I became a DBA

I'm not sure how I ended up on the Dallas DBAs website, but I came across their blog topic How I became a: ________ . The idea of posting up my story resonated with me, so I thought I would share. I apologize for the length in advanced, but it's hard to lay out a...

read more

T-SQL Tuesday #90 – Database Deployments

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

read more

SQL Training

The IT industry moves fast and staying current is tough to do, especially when you have a full time job. Even for those who love their jobs or their positions, it is tough to set aside time to work on new skills. Or even brush up on old skills that haven't been used...

read more

Disable login and kill user SPIDs

Recently came across a situation where reporting logins were interfering with nightly jobs due to blocking. After a number of attempts of trying to resolve the blocking, it was decided that a stored procedure that disabled the login and killed the user sessions was...

read more