SQL Server Transactional Replication Internals
SQL Server Transactional Replication is one of the most common Replication techniques used to...
Simple SQL Server Functions to Solve Real-World Problems
Introduction Today’s article comes from a scenario we experienced in practice some time ago. We managed a card transaction system...
SQL DEFAULT Constraint to Insert Column with a Default Value to SQL Server Table
To insert data into a table having columns with default constraints, we can use the DEFAULT constraint to a default value in a table. This...
Implementing Error and Transactions Handling in SQL Server
Introduction No matter how hard we try to design and develop applications, errors will always...
Power BI Date Table Template Tutorial
What is the right way of using Date Templates in Power BI reports and dashboards? This article will clarify the question and help to...
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 the statistics, rebuilding indexes,...
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...
Installing Ubuntu 18.04 for SQL Server 2019 on Virtual Machine Using VMware Workstation
Microsoft has been supporting SQL Server for Linux-based operating systems since the SQL Server 2017 release. The current article will...
What is SQL Server Express? Definition, Benefits and Capabilities
SQL Server Express is a free lightweight edition of SQL Server with limited functionality, available for all versions starting from SQL...
Understanding of SQL Server UPPER Function
There are many cases of SQL lowercase that we need to change for our purposes. For instance, we...
