Database backups and restores are key to developing a secure environment for users’ information. A trusted backup plan is a requirement for on-premise and cloud instances. SQL Server database backups ...

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 ...

Pity the poor modern DBA, now that SQL Server gets attacked by some of the same scripts that PCs do. Pity the poor modern DBA who has to keep building Microsoft SQL Servers because some idiot vice ...

The task is to be able to copy a databases from production (and the source will always be production) down to staging or testing. Finally, all of these tasks need to be scriptable as SQL statements.

Microsoft SQL Server 2000 comes with its own backup and recovery utilities. Though they work, there are a number of annoying limitations. For instance, you can't back up directly to a UNC path, and ...

The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit. In order to back up a database, you need to know how it’s delivered, but you also ...

As mentioned in my post on VLDBs, one of the key pieces of a high performing solution is the use of Read-only Filegroups. If a significant part of your data is not changing, then why not tell SQL ...

So, we're going to start supporting some accounting company, where current situation is terrible. (Server being used as desktop, VNC remote open, pretty much everyone inside and outside knows admin ...

At Microsoft's Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system (RDBMS) ...

What is a Database Administrator and What Do They Do All Day? Your email has been sent A DBA is a technician skilled in SQL and very large databases who is responsible for managing database software, ...