SQL GROUP BY- 3 Easy Tips to Group Results Like a Pro
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to...
Understanding the Database Level Collation and Impact of Changing it for a Database
When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and...
10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL
Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow someone to take over your database. Plus,...
SQL Server Transactional Replication Configuration
Transactional Replication in SQL Server is one of the most commonly used Replication techniques to...
A Simple Use Case for Indexes on Primary Keys
Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Introduction to Synonyms in SQL Server
A synonyms in SQL Server are database objects that give an alternative name to the database objects existing locally or on the remote...
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML...
DevOps Solutions for Database Development Automation
What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating the development, deployment,...
Dynamic SQL vs Stored Procedure
Dynamic SQL and stored procedures are two of the most important components of SQL Server. In this article, we will look at the advantages...
SQL Server Index Backward Scan: Understanding and Performance Tuning
Table indexing strategy is one of the most important performance tuning and optimization keys. In...