Work with data

Implementing Incremental Load using Change Data Capture in SQL Server

Database administration, Work with data

This article will be interesting to those who often have to deal with data integration....
Read More

5 Ways to Update Data with a Subquery in Oracle SQL

Database administration, Work with data

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...
Read More

Using Expressions to Filter Data of Database

Database administration, Work with data

I would like to start with a description of the problem that I encountered. There are entities in the database that need to be...
Read More

32-bit Excel and 64-bit SQL Server

Database administration, Work with data • One Comment

What could be simpler than to get data from an Excel table in SQL Server? There are many ways to...
Read More

Upload Documents to Azure Data Lake and Export Data using SSIS

Business intelligence, Database administration, SSIS, Work with data • One Comment

 Introduction Azure is growing every day. Microsoft created Azure, which is a Cloud Computing service released on 2010. According to...
Read More

How to Automate Data Collection on the SQL Server Database Growth

Automation, Database administration, Work with data

Introduction Often, there is a need to control the growth of all tables and files of all databases. In this article, we are going to...
Read More

SQL Server: The dark side of NVARCHAR

Database administration, Work with data

Introduction In this article, we are going to talk about using the nvarchar data type. We will...
Read More

Automatic Data Collection of Database Schema Changes in MS SQL Server

Database administration, Work with data

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...
Read More

Everything you should know about SQL Server JOINS

Database administration, Work with data

The focus of this article is going to be on utilizing JOINs. We will start off by talking a bit about how JOINs are going to happen and why...
Read More

Aspects of Strings in .NET

Database administration, Work with data

The string data type is one of the most significant data types in any programming language. You can...
Read More
Close