News

Here, Knowledge Center contributor Brent Ozar outlines seven actions database administrators can perform to build a sound database backup and recovery strategy.
PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.
In part 1, we looked at generating T-SQL style code. In part 2, let's get this thing to run!
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.
You've overwritten your "BACKUP DATABASE" command with the "DBCC SHRINKDATABASE" command. Put an "EXEC (@SQL)" in between the two.
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.
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.