Introduction to Synonyms in SQL Server
A synonyms in SQL Server are database objects that give an alternative name to the database objects...
SQL Server Replication Monitor: Scripts for Checking Replication Status
Replication is one of the oldest technologies on MS SQL Server, loved by every database administrator. It is a great and reliable...
How to Delete Entire MySQL Database
In some cases, we need to drop the entire database from the MySQL community server. This is simple but irreversible. Thus, the DROP...
SQL Server Transactional Replication Internals
SQL Server Transactional Replication is one of the most common Replication techniques used to...
NoSQL vs SQL: Which One is Better for Big Data Management?
Nowadays, customer behavior becomes more complex and market trends continue to shift rapidly. Thus, businesses need specialized...
Implementing Error and Transactions Handling in SQL Server
Introduction No matter how hard we try to design and develop applications, errors will always occur. There are two general categories –...
How to Connect Python to SQL Server to Automate Backend Process
Automating backend processes in your SQL Server instance is a common task. Whether it is refreshing...
MS SQL Server on Linux vs Windows Performance Test to Spot the Difference
Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game. It enabled a whole new world of...
In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples
What if 1 second of a transaction process is too long? You can tune your queries. But what if it’s not enough, can you still step up...
How to Use Array Functionality in SQL Server
Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to...
