News

For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...
Here, Knowledge Center contributor Brent Ozar outlines seven actions database administrators can perform to build a sound database backup and recovery strategy.
In part 1, we looked at generating T-SQL style code. In part 2, let's get this thing to run!
If a web-based GUI is better suited to your admin skills, Jack Wallen wants to show you how to back up and restore your MySQL/MariaDB databases with one of the easiest tools on the market.
You've overwritten your "BACKUP DATABASE" command with the "DBCC SHRINKDATABASE" command. Put an "EXEC (@SQL)" in between the two.
Setting up database replication is one of the most reliable means of getting a real-time backup of your MariaDB data. See how easy this is to achieve.
Dokkat appears to think that databases are overused. "Instead of a database, I just serialize my data to JSON, saving and loading it to disk when necessary," he writes.