Category Archives: T-SQL

SQL Server High Availability and Database Recovery Model Relationship

There are four types of high availability options available in Microsoft SQL server. All the options are different from each other. For example, Log shipping, Mirroring and Always On works on database level while Replication works on database objects level. … Continue reading

Rate this:

Posted in Always on, Database Administration, Replication, Sql Server, T-SQL | Leave a comment

Introduction to Microsoft Azure

Microsoft Azure is an open, flexible, enterprise-grade cloud computing platform. Azure was announced in October 2008 and released on February 1, 2010. It provides Software as a service (SaaS) Platform as a service (PaaS) Infrastructure as a service (IaaS) Why … Continue reading

Rate this:

Posted in Azure, Database Administration, T-SQL | Tagged , , , , , , , , , , | Leave a comment

How to add and remove a database to an availability group in Always On

How to add and remove a database to an availability group in Always On Rule: Connect to the server instance that hosts the primary replica. Use the T-SQL statement as below After you add a database to an availability group, you … Continue reading

Rate this:

Posted in Always on, Clustering, Database Administration, T-SQL | Tagged , , , , , , , , , , | Leave a comment

Always On in SQL Server 2017 (Read-Scale Feature)

Always On in SQL Server 2017 (Read-Scale Feature) SQL server 2017 has introduced new feature and technology (read-scale availability group) with Always on. Now, Always On availability groups provide high availability, disaster recovery and read-scale balancing. Read-Scale Availability Group: This … Continue reading

Rate this:

Posted in Always on, Clustering, Database Administration, T-SQL | Tagged , , , , , , , , , | Leave a comment

SQL Injection

SQL Injection (SQLi) refers to an injection attack wherein an attacker can execute malicious SQLstatements (also commonly referred to as a malicious payload) that control a web application’s database server. Such attack affects any website or web application. An attacker can bypass a web … Continue reading

Rate this:

Posted in Database Administration, Other, Security, Sql Server, T-SQL, Uncategorized | Leave a comment

SQL Server 2012 Features:3: Pagination

In continuation of previous blog: Pagination: This feature focuses on the result set of T-sql. It divides the result set into different parts to view easily. We can do pagination by using ‘OFFSET’ and ‘FETCH’ commands. We can pull only … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature, T-SQL | Leave a comment