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

If the SQL Server crashes, especially if there ... but they are a good start to forming a sound database backup and recovery strategy. Most importantly, they allow for a single DBA to perform ...

Defining Managed SQL Services Managed SQL services are cloud-based solutions that give users access to SQL databases without needing to manage the underlying infrastructure. This means the service ...

SQL Server is at the heart of your company; if it goes down, the results could be catastrophic. However, despite its importance, many IT admins don’t have a solid backup and restore plan in place.

In the absence of a diligently tested and documented strategy, SQL Server disaster recovery ... log records created since the last full backup. It allows point-in-time recovery of SQL Server databases ...

Database backups and restores are a fundamental (and critical) skill-set of any MS SQL Server DBA. A solid backup plan is a requirement for most on-premise instances and things are no different in the ...

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability ...

We currently have a SQL 2008 server running ... if I still need to backup via BackupExec if Veeam is backing it up on a nightly basis. Seems redundant no? If there is a database corruption ...

There are many things to consider when capacity planning for SQL Server. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL implementation or ...

Joey on SQL Server How To Be a Better DBA: 4 Strategies To Improve SQL Server Performance There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version ...