About me

I’m Gabriel Köhl – SQL Server DBA and PowerShell enthusiast. After years in in-house IT, where everything became increasingly predictable, I moved into consulting at the beginning of 2021. Here there are new challenges every day in different environments.

What I do

SQL Server administration, performance tuning, migrations – the full spectrum. PowerShell for everything that can be automated. And yes, sometimes that creates new problems which then need to be solved.

Why this blog?

The community lives from sharing. Tools like dbatools or sp_Blitz have helped me many times. Now I’m giving something back – with practical solutions instead of theoretical treatises.

Despite the quality of these big solutions, for special requirements beyond standard administration I often prefer my own approaches. sp_Blitz is excellent, no question, but for certain cases I often only need five percent of the hundred percent of metrics – but those with more depth. Similar with dbatools: the overhead is sometimes too big, so I’d rather write it myself. That way a lot more knowledge sticks, too.

What to expect

Real stories from everyday DBA life. No perfect solutions, but ones that work. Sometimes elegant, sometimes pragmatically put together – but they get the job done.

If you’ve become an accidental DBA or are simply looking for pragmatic approaches: you’re in the right place.

AI and stuff

Of course I use AI tools. They make me more efficient. But it takes time until new knowledge really sticks and is production-ready. Experience still beats hype. By the way, the articles are also translated into English with AI. 🙂

Contact

Questions, feedback or just talking shop? LinkedIn or GitHub – I’d love to hear from you.

Do you have SQL Server challenges in a business environment or want to automate processes? Feel free to drop by Opitz Consulting – that’s where you can book me.