In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use. This service is used to backup SQL ...

Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...

There are many backup options for databases, but here are recommendations for Cassandra, DB2, DynamoDB, MongoDB, MySQL, Oracle, and PostgreSQL. There are many options for backing up databases, and ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...