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

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

I'm doing some web development contract work this summer, and my scenario/task is this. The environment is broken up into Production / Staging / Testing / Local Dev All environments are running MS SQL ...

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

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