It’s that time of the month, and I’m late. My apologies. I had a mix-up with a host and was…
Browsing: SQL
Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly. If you want the speed without the face-palm…
For decades, enterprises have approached data management with the same mindset as someone stuffing everything into a single attic. The…
If you open SSMS under the same Windows identity you use for email, browsing, and chat, you bring all that…
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful, cross-platform GUI for interacting with PostgreSQL…
There are moments in technology when the ground shifts beneath our feet. Moments when the tools we once thought of…
7 reasons—and exactly what to do insteadIt can feel “faster” to hand developers sysadmin. In reality, it’s like giving them…
The New Arena of LeadershipThe role of the Chief Data Officer is no longer about governance alone. It is about…
After setting up dozens of Internet of Things (IoT) smart home devices, I started to wonder: how hard could it…
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily create database snapshots.This new version fixes…