Database administrators are reinventing themselves. Data roams freely, AI is advancing, and governance is lagging behind. Yet ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...

Community driven content discussing all aspects of software development from DevOps to design patterns. If you plan to do database development with Java and MySQL, the first thing you’ll need to do is ...

If you’re working for a small company and want to build a client portal or an internal tool, it can be difficult to find the budget and resources to allocate a developer to that small project. That’s ...

Even after 50 years, Structured Query Language, or SQL, remains the native tongue for those who speak data. It’s had impressive staying power since it was first coined the Structured Query English ...

Like a shot to your dome piece, I'm back to hit you with my annual roundup of what happened in the rumble-tumble game of databases. Yes, I used to write this article on the OtterTune blog, but the ...

--This script gives you a per-table count of non-clustered indexes for all databases on an instance, sorted descending by the highest number of indexes. --This is helpful when looking for excessive ...

Join the event trusted by enterprise leaders for nearly two decades. VB Transform brings together the people building real enterprise AI strategy. Learn more AI has transformed the way companies work ...

Below is a cheat sheet that can be used for configuring SQL Server audit policies to log and detect potentially malicious behavior. It also includes some TSQL cheats for viewing the current audit ...

When you encounter the “Network-related or instance-specific error” in SQL Server, it usually happens when trying to connect to a database, and the connection ...