Microsoft SQL Server is a relational database management system that Microsoft has created. It is a database server, which is a software product whose principal
Apache Impala – Step by Step
Throughout the year, “Big Data & SQL” published a number of articles about Apache Impala. It covers the majority of its features and functions. It’s
HDFS Tutorial
Here are all of the HDFS articles that have been published on this website so far. It’s basically a collection of information organized in a
Apache Pig Tutorial
This page combines all Apache Pig related posts into a single to make it more helpful and beneficial to learners. It is presented in a
Apache Sqoop Course Contents
This page combines all Sqoop-related topics into a single article to make it more helpful and beneficial to learners. It is presented in a hierarchical
Apache Hive Course Contents
Apache Hive is built on top of Apache Hadoop, which is a distributed, fault-tolerant, and open source data warehouse platform for reading, writing, and handling
BigDataNSQL Back Online.
Announcement: Bigdata & SQL is back online.
Alternative of DBCC CHECKDB Repair Allow Data Loss
DBCC CHECKDB is executed on the SQL Server database to check the physical and logical integrity of the database’s integral components. These objects include tables,
USE of GO in SQL Server
GO is interpreted by SQL Server utilities as a signal to deliver the current batch of Transact-SQL statements to a SQL Server instance. All statements
Can we convert TIMESTAMP to date time?
The short answer is, NO. Let’s consider the following example. USE testDB GO CREATE TABLE tbOrders ( iOrderID INT IDENTITY(1,1) PRIMARY KEY, dtOrderDate DATETIME, dcPaidAmount
Stored Procedure – RAISERROR
Here’s an example of how to make a user-defined error message and raise it in the event that something goes wrong. — Creating the procedure
MySQLDump Backup and Restore All Databases at once
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
Big Data & SQL 