Grouping Data using the OVER and PARTITION BY Functions
The OVER and PARTITION BY functions are both functions used to portion a results set according to...
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...
5 Ways to Update Data with a Subquery in Oracle SQL
A subquery is a powerful way to find the data you want to use for another query. They are often used in SELECT and UPDATE statements to...
Using Expressions to Filter Data of Database
I would like to start with a description of the problem that I encountered. There are entities...
32-bit Excel and 64-bit SQL Server
What could be simpler than to get data from an Excel table in SQL Server? There are many ways to accomplish this task. You can utilize...
Upload Documents to Azure Data Lake and Export Data using SSIS
Introduction Azure is growing every day. Microsoft created Azure, which is a Cloud Computing service released on 2010. According to...
How to Automate Data Collection on the SQL Server Database Growth
Introduction Often, there is a need to control the growth of all tables and files of all databases....
SQL Server: The dark side of NVARCHAR
Introduction In this article, we are going to talk about using the nvarchar data type. We will explore how SQL Server stores this data type...
Automatic Data Collection of Database Schema Changes in MS SQL Server
Introduction Have you ever faced a situation when you need to make changes in a stored procedure or a view very quickly? I have, very...
Everything you should know about SQL Server JOINS
The focus of this article is going to be on utilizing JOINs. We will start off by talking a bit...
