SQL Shack
1,462 FOLLOWERS
SQL Shack is a new SQL server blog with articles about database auditing, server performance, data recovery and more. Share SQL knowledge, help you learn about SQL and communicate with people from SQL world.
SQL Shack
1M ago
In this article, we will learn how to set up an Oracle instance, create sample data and understand the use of the substring function. Introduction Structured data is hosted typically in relational database management systems in data objects like tables. Tables have attributes that have a data type associated with them to accommodate various types ..read more
SQL Shack
2M ago
This article will explain backup storage redundancy for Azure Cosmos DB. Backups are a critical feature to keep copies of our data to ensure data protection and recoverability in case of any accidental deletion, updating, or any kind of disaster. But this is not enough to run backups only to save its copies. We must ..read more
SQL Shack
3M ago
The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server. Introduction The performance tuning aims to optimize and reduce the response time of the queries so that we can provide fast and reliable access to data for the ..read more
SQL Shack
4M ago
Today we will learn about the SQL IN operator. The RDBMS systems are very popular today in terms of data storage, data security, and data analysis. SQL stands for Structured Query Language which is used to create, update, or retrieve data in RDBMS or Relational Database Management Systems like SQL Server, Oracle, Microsoft Access, MySQL ..read more
SQL Shack
6M ago
This article will provide an understanding of identifying duplicate values in SQL. Introduction SQL Server is one of the most widely used databases at the current time. Many huge organizations have been using it for decades now. Many Datawarehouse banks on storing data in SQL and processing it for advanced analytics and insights. Even visualization ..read more
SQL Shack
6M ago
Today, we will learn the difference between SQL SELECT UNIQUE and SELECT DISTINCT in this article. As we all know that SQL is a query language that is used to access, create, delete, and modify data stored in a database system like SQL Server, Oracle, MySQL, etc. All these database systems have their query language ..read more
SQL Shack
8M ago
This article explains some of the popular SQL Server monitoring tools and techniques. Database monitoring: a quick reminder Database monitoring is a set of tools and techniques used to create and maintain an application infrastructure that is highly available and performs at high speed. It helps track the resource consumption, such as the amount of ..read more
SQL Shack
9M ago
Introduction to the PostgreSQL tutorial to create a user In this article, we will show a PostgreSQL tutorial to create a user using PgAdmin and PL/PgSQL. Requirements PgAdmin installed. In this example, the PgAdmin 4 version 6.12 was used. PostgreSQL installed. Tutorial to create a user in PGAdmin Open PGAdmin and connect to the server ..read more
SQL Shack
10M ago
This article will provide an understanding of different ways to use substring in MySQL. Introduction MySQL is an open-source relational database management system. It is a widely used relational database management system in the entire world. MySQL like any other database can store different types of data. One of the most used data types is ..read more
SQL Shack
11M ago
This article will show PostgreSQL Data Types with various examples. Data Types are an important part of a database. It represents values associated with it. Choosing the right data type for a table is one of the most important tasks because it determines the kind of data we want to store in a table. While ..read more