SQL Shack
1,435 FOLLOWERS
SQL Shack is a new SQL server blog with articles about database auditing, server performance, data recovery and more.
SQL Shack
3d 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
1M 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
2M 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
3M 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
4M 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
5M 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
6M 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
7M 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
SQL Shack
8M ago
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework. Introduction Unit testing is a testing technique that allows us to the test functionality of the smallest and programmable part of the software. Our goal to write unit tests ..read more
SQL Shack
11M ago
This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases. What is database monitoring? Database monitoring consists of a set of techniques and operations that aims to maintain the health and performance of a database management system. Monitoring tools collect information related ..read more