Real-Time Operational Analytics and Non-Clustered Column Store Index
In this article, we will focus on real time operational analytics and how to apply this approach to...
SQL Server Trigger: Understanding and Alternatives
The SQL Server trigger is a special type of stored procedures that is automatically executed when an event occurs in a specific database...
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...
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 hallmark of git is that it does not block...
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...
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 and other databases are objects that...
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...
