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

Database protection goes far beyond backups; ensuring the quality and consistency of those backups is equally important. Here are the maintenance tasks that will make sure your databases stay in top ...

Microsoft has been releasing newer versions of SQL with greater frequency, prompting DBAs to constantly ask themselves: “Is it time to upgrade?” Once that answer is yes, they have a lot of information ...

I am getting a lot more unsolicited questions these days such as this one: “My co-workers tell me there is no future for SQL Server DBAs. Will I have a job in the long-term? I’m confused and ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...