To easily manage the permissions in our databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals. They are like groups in the Microsoft Windows operating system. Database-level roles are database-wide in their permissions scope. The various types of SQL Server fixed database roles are as follows: · […]

When considering the security and protection of the database engine, one of the first considerations that comes to mind is SQL Server Fixed Server Roles. The Server Roles are named Fixed Server Roles as the user cannot alter these under any conditions. Assigning the appropriate roles to the user helps keep the SQL Server Environment […]

Setting up Transactional Replication in SQL Server 2008 R2. Replication is one of the High Availability features available in SQL Server. Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This change happens […]