In this article, we will review SQL Server MERGE statement, alternatives to MERGE statement, different clauses and examples of MERGE statement in SQL Server.
Read more »
Ranga Babu
SQL Server DBA, Developer with good experience in SQL Server administration, development, performance tuning, monitoring, high availability and disaster recovery technologies
Latest posts by Ranga Babu (see all)
- Geo Replication on Transparent Data Encryption (TDE) enabled Azure SQL databases - October 24, 2019
- Overview of the Collate SQL command - October 22, 2019
- Recover a lost SA password - September 20, 2019
AWS RDS – SQL Server Administration
May 30, 2019In this article, we will review common database administration tasks for AWS RDS (Relational Database Service) SQL Server instance. RDS does not provide access to some of the system procedures and tables that require advanced privileges. So, we cannot perform all the administration tasks on the RDS SQL Server instance.
Read more »
SQL Server in Kubernetes Cluster using KOPS
May 24, 2019In this article, we will review how to create a Kubernetes cluster in AWS using KOPS, provision Elastic Block Store (EBS) as persistent volume to store the database files and deploy SQL Server in the K8s cluster.
Read more »
SQL Server in Azure Kubernetes Service (AKS)
May 22, 2019In this article, we will review how to create a Kubernetes cluster in Azure Kubernetes Service, provision the persistent volume to store the database files and deploy SQL server on Kubernetes cluster.
Read more »
Triggers in SQL Server
May 15, 2019In this article, we will review triggers in SQL Server, different types of trigger events, trigger order and NOT FOR REPLICATION in triggers. A trigger is a database object that runs automatically when an event occurs. There are three different types of events.
Read more »
AWS RDS SQL Server migration using native backups
May 10, 2019In this article, we will review how to migrate database from on-premises SQL Server instance to AWS RDS SQL Server instance and between AWS RDS instances using native backup, restore and amazon simple storage service(S3).
Read more »
SQL Server cursor attributes
May 8, 2019A SQL Server cursor is a database object that is used to process the data in a set row by row. In this article, we will review how to create a cursor and different attributes used while declaring a cursor.
Read more »
AWS RDS SQL Server Migration using AWS Database migration service
April 30, 2019In this article, we will review how to migrate database from on-premise SQL Server instance to AWS RDS SQL Server instance using AWS Database migration service. There are different ways to migrate the database to the AWS RDS instance:
Read more »
AWS RDS SQL Server – Monitoring database instances
April 9, 2019In this article, we will review how to monitor AWS RDS SQL Server database instances and setup email notifications using event subscriptions and CloudWatch alarms.
SQL Foreign key
April 5, 2019In this article let us review different ways to create a SQL foreign key, rules on updates and deletes, enabling foreign key constraints, disabling foreign key constraints and not for replication in foreign keys.
Read more »
AWS RDS SQL Server – Launching a new database instance
March 29, 2019This article will review on how to launch an AWS RDS SQL Server instance and how to connect the instance and modify the properties of database instance.
Read more »
AWS RDS SQL Server recovery models, backups and restores
March 29, 2019This article will review about the recovery models backups and restore options in available AWS RDS SQL Server.
Read more »
Log shipping on a mirrored database
March 26, 2019Both log shipping and mirroring are high availability and disaster recovery options available in SQL Server. This article will review on how to configure log shipping on a mirrored database.
Read more »
SQL Server Replication on a mirrored database
March 26, 2019This article will review on how to configure SQL Server Replication along with mirroring on a database.
Merge SQL Server replication parameterized row filter issues
February 19, 2019In this article we will discuss about SQL Server Merge Replication Parameterized row filter issues while replicating incremental data changes post initial snapshot.
Read more »
SQL Server Replication (Merge) – Performance Issues in replicating schema changes
January 30, 2019This article will review performance issues in replicating schema changes on tables involved in SQL Server Replication (Merge).
Read more »
SQL Server Replication (Merge) – What gets replicated and what doesn’t
January 24, 2019This article will show how triggers, indexes, constraints and foreign keys will replicate in snapshot and after snapshot in SQL Server replication.
Read more »
Disabling triggers in SQL Server for a specific session
January 18, 2019This article will focus on the various ways to disable triggers in SQL Server so they won’t interfere with certain operations like bulk inserts.
Foreign key issues while applying a snapshot in SQL Server merge replication
January 16, 2019This article will review specific SQL Server merge replication issues related to foreign keys and schema snapshots
SQL Server Replication with a table with more than 246 columns
January 14, 2019Problem
In our environment we use SQL Server merge replication to replicate data to multiple subscribers. We had a situation where a table needs to be part of merge replication and the table has more than 246 columns. Merge replication supports tables with maximum of 246 columns. In this article let us see how to replicate a table with more than 246 columns.
SQL Server Code simplification using synonyms
January 4, 2019Problem
In our environment, we use different DB servers and these servers are linked via Linked servers for cross server transactions. We use these linked servers in our stored procedures. The server names are different in different environments and we had to change the server names manually when we promote the stored procedures to other environments. There is a chance of errors while changing the server names manually. In this article let us see how can we eliminate changing the code manually.
Read more »