Work with data

Introduction to Synonyms in SQL Server

Database administation, SQL Server, Work with data • One Comment

A synonyms in SQL Server are database objects that give an alternative name to the database objects...
Read More

How to Delete Entire MySQL Database

Database administation, MySQL, Work with data

In some cases, we need to drop the entire database from the MySQL community server. This is simple but irreversible. Thus, the DROP...
Read More

NoSQL vs SQL: Which One is Better for Big Data Management?

Database administation, Work with data

Nowadays, customer behavior becomes more complex and market trends continue to shift rapidly. Thus, businesses need specialized...
Read More

How to Use Array Functionality in SQL Server

Database administation, Work with data

Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to...
Read More

Creation of Pandas DataFrame in Python with Examples

Database administation, Frameworks, Languages & Coding, Work with data

Python is a general-purpose language that can work with various types of data structures and solve data-related problems with the help of...
Read More

SQL Date Format: How to Handle It the Smart Way

Database administation, Work with data

Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric dates, we have month-day-year,...
Read More

SQL Server BIT Datatype – Ultimate Guide

Database administation, Work with data

Introduction to Bit Data Type The data type represents an attribute that stores integer, character,...
Read More

Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function

Database development, Statements, Work with data

Today’s code editors and word processors come with a search and replace feature. It is helpful when you need to change a word or a...
Read More

SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios

Database development, Statements, Tables, Work with data

The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
Read More

Fundamentals of Managing Datafiles in SQL Server

Database administation, Work with data

Introduction Datafiles are physical objects that constitute the most important part of the database...
Read More
Close