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...
Aspects of Strings in .NET
The string data type is one of the most significant data types in any programming language. You can hardly write a useful program without...
Is string operator “+” so simple?
Introduction A string data type is one of the fundamental data types, along with numeric (int, long, double) and logical (Boolean) ones....
