SQL Server Agent is a tool integrated into SQL Server that is primarily used for automating and scheduling tasks. Through SQL Agent, you can create Jobs and schedule individual tasks within those Jobs, such as executing scripts, running SSIS packages, using PowerShell, and much more. However, SQL Server Agent is only available in the Standard… Read More »
In the previous article (see Index Fragmentation), I described how to detect index fragmentation using a script that utilizes system tables. According to Microsoft’s recommendations, we should reorganize (REORGANIZE) indexes with fragmentation between 5 – 30% and rebuild (REBUILD) indexes with fragmentation above 30%. We will use the script from the previous article and create… Read More »
SQL Server offers several backup methods. These backup types can be combined to create various backup strategies for SQL Server. Types of Backups in SQL Server Full Database Backup This is the classic method of performing a full backup, where all objects (including system objects) are included in the backup. Transactions (changes) that occur during… Read More »