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 »
SQL Server 2017 was released in October 2017. Many users were still getting accustomed to all the features in SQL 2016, but Microsoft quickly brought in another set of features that are sure to please. Microsoft representatives and user feedback confirm that SQL Server 2017 represents a significant step in development compared to, for example,… Read More »
Are you navigating the IT environment and would like to land your dream job or enhance your personal knowledge portfolio? Bet on the latest certifications from Microsoft. We will focus on the MCSA: SQL 2016 certification. If you have no idea what it is and why this certification should interest you, then you’re in the… 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 »
Running more than 1 procedure at a time may not be as simple a task as it seems, especially if individual procedures have dependencies between them – meaning that a set of procedures relies on the execution of other procedures. So, how can we achieve parallelism when running sql server queries? Let’s recap the options… 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 »