In SQL Server administration, there are two terms that can easily be confused: SQL Login and SQL User. While SQL Login allows you to manage permissions for server access,...
Reporting services are a feature that you can use starting from the Express edition, and it is a set of services that allow you to create and publish reports....
In the previous two articles, I covered setting up database mail (gmail) and configuring Change Data Capture (CDC), which is the automatic tracking of changes to a table. So,...
DBCC stands for database console commands, which are commands executed on a specific database. The DBCC command set allows you to perform various administrative operations or queries on databases...
SQL Server offers 3 types of database recovery models: simple recovery model, full recovery model, and bulk-logged recovery model. The recovery model defines how SQL Server manages transactions and...
A table without a primary key (clustered index) is referred to as a heap because it’s just a pile of unordered data. In contrast, a table with a clustered...
The Database Mail feature is only available in the SQL Server Standard edition and higher. In the SQL Server Express edition, unfortunately, it is not available. This feature is...
In applications or complex enterprise information architectures, there is often a need to handle historical records and track changes in values for various reasons. Most of the time, it’s...
In SQL Server, there is a system table that stores all possible error states and their severity levels. Error severity ranges from 0 to 25 and defines the seriousness...
xp_cmdshell is a very powerful procedure that allows you to execute commands via the command-line (cmd) in SQL Server. With cmdshell, you can perform various operations on a Windows...
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...
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)...
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...