Best author award in 2021

January 3, 2022 by

One more year is behind us, and unfortunately, we are all still in the COVID-19 regime. But SQLShack Community continuous to grow and we are thankful for that to all our readers! SQLShack Community team was diligent this year and make an effort to brought to you the best content on the network. We’d like […]

SQL commands in SQL Server

November 22, 2021 by

Introduction If you are here, it means that you want to learn the SQL commands. This article applies to SQL Server especially, but most of the theory is similar to Oracle, MySQL, MariaDB, PostgreSQL, and other databases. The SQL commands are instructions that we send to the database to get information, manipulate the information or […]

Creating an AWS Athena instance and querying it

Using SQL Server to query data from Amazon Athena

November 5, 2021 by

In this article, we are going to use SQL Server to query data that resides in Amazon S3 buckets with the help of Amazon Athena. SQL Server is one of the most popular relational database management systems developed by Microsoft. SQL Server can be installed on-premises or on popular cloud services like Azure or AWS. […]

The Kusto query language handles joined table columns with the same column names.

Use Kusto Query Language to solve a data problem

July 5, 2021 by

Introduction In the previous article Azure Data Explorer and the Kusto Query Language, we saw how the Microsoft Azure Data Explorer works, and we learned about the Kusto query language (KQL). We’ll build on this here in part two, we’ll learn more about KQL, and we’ll use KQL to solve a real-world data problem.

Different methods to calculate Term Frequencies.

Filter based Feature Selection in Text Analytics

July 1, 2021 by

Introduction As we are well into the discussions of Text Analytics in Azure Machine Learning from the last couple of articles, we will be discussing the Filter based Feature Selection in Text Analytics and how we can build a prediction model from the Filter Based Feature Selection in order to perform text classification.

Database interview questions

June 11, 2021 by

Introduction If you are applying to a new DBA job or a job that requires database knowledge, you probably want to study the most common questions in an interview. If that is your case, this article may be useful. The article contains typical questions about databases. The database interview questions that are typical are the […]

Connecting to the PostgreSQL instance using PGAdmin4

Install and upgrade PostgreSQL to support Spatial Data

May 26, 2021 by

Spatial data deals with data related to geography. In this article, we are going to understand the various concepts related to geographic or spatial data and how PostgreSQL can be leveraged as a database to store such geographic information. As you might be already aware, PostgreSQL is a popular and widely used open-source relational database […]

A dataflow diagram in Power BI

An introduction to Power BI Dataflows

May 7, 2021 by

In this article, we are going to understand what the Power BI Dataflows is all about and how we can get started by building dataflows in Power BI Service. A dataflow can simply be considered as an extract transform and load pipeline that can be used to connect to source data, transform the data by […]