Always On in SQL Server is new high availability disaster recovery feature in SQL Server 2012. Initially it named as HADRON. HADRON means High availability Disaster Recovery Always On. Always On uses clustering technology for failover and mirroring in keeping multiple mirrored copies of the database. In Always On we can failover multiple databases at …
Clustering in SQL Server is a Windows level high availability option to increase the availability of physical server hardware, operating system, and SQL server instances. If any of these three fails on one server, The Other server in cluster automatically takes task of failed SQL server instance Clustering in SQL Server is Service level …
Replication in SQL Server is a object level high availability feature. Normally in other high availability technologies we replicating entire database but in this we can replicate database objects like tables, stored procedures, triggers, functions etc. Do you want to replicate your data from one server to another server? Or do you want to migrate …
SQL Server is one of the RDBMS products in the market. Every application requires one database server like Oracle, SQL Server, MySQL, HANA, DB2 etc. SQL Server is second most used database server in the world because of its features and functionalities. It is easy to navigate graphical user interface application, even layman can learn …
What is Log shipping in SQL Server? Log shipping means Shipping transaction log files from the Primary Server database to one more secondary servers to get both databases in continuous synchronization. SQL Server log shipping is a database level high availability feature, whenever primary database down due to any reason like natural calamity or software …
Triggers in SQL Server are mainly used for implementing complex business rules. A trigger is a named T-SQL block executed implicitly. Triggers in SQL Server are created To implement complex business rules and validations To provide security To do auditing Business rules are of 2 types Declarative rules – Implemented with the help of Integrity …