SQL Server Trigger: Understanding and Alternatives
The SQL Server trigger is a special type of stored procedures that is automatically executed when...
Implementing Incremental Load using Change Data Capture in SQL Server
This article will be interesting to those who often have to deal with data integration. Introduction Assume that there is a database where...
Dynamic SQL vs Stored Procedure
Dynamic SQL and stored procedures are among the most important SQL Server components. Both have advantages and disadvantages. That’s...
Git: A Modern Approach to Code Management
In this article, I would like to share my knowledge and experience of working with git. The main...
Using Indexes in SQL Server Memory-Optimized Tables
Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
Creating Simple Linear Regression in Azure Machine Learning
In today’s world, it is not enough to simply analyze data, create reports or develop business intelligence projects. To discover the...
Example of Improving Query Performance with Indexes
In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle...
Implementing a Common MS SQL Server Performance Indicator
Introduction There is often a need to create a performance indicator that would show database activity related to the previous period or...
50 Shades of Oracle Database Certification Exam
In this article, I would like to talk about one of the basic certifications from Oracle – Oracle Database SQL Certified Expert....
Missing Indexes in MS SQL or Optimization in no Time
When executing a query, the SQL Server optimizer tries to find the best query plan based on...
