Page Inspect

SQL Shack - articles about database auditing, server performance, data recovery, and more

# SQLShack

Skip to content

- SQL Server training
- Español



# Understanding PostgreSQL SUBSTRING function

September 21, 2024 by Rajendra Gupta

PostgreSQL is an open-source, object-oriented relational database system with reliability, performance, and robustness. It supports SQL (relational) and JSON (non-relational) queries.PostgreSQL’s popular features include Multi-Version Concurrency Control (MVCC), point-in-time recovery, granular access controls, tablespaces, and asynchronous replication.

Read more »

Development, PostgreSQL

# How to create and query the Python PostgreSQL database

August 15, 2024 by Haroon Ashraf

This article is all about creating and querying Python PostgreSQL database in a simple and easy way.

Read more »

PostgreSQL, Python

# Different ways to identify and change compatibility levels in SQL Server

July 22, 2024 by Nisarg Upadhyay

Compatibility level in SQL Server refers to a database property that determines the syntax and behavior of the database, allowing it to be compatible with earlier versions of SQL Server. Each version of SQL Server introduces new features, improvements, and changes to the query optimizer, which may affect how queries are executed and how results are returned.

Read more »

Development, General database design

# Oracle Substring function overview with examples

June 19, 2024 by Gauri Mahajan

In this article, we will learn how to set up an Oracle instance, create sample data and understand the use of the substring function.

Read more »

Oracle

# Configure backup storage redundancy for Azure Cosmos DB account

May 15, 2024 by Manvendra Singh

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 also protect those backup copies from accidental deletes or corruption and ensure their proper resiliency should be in place to keep backups safe from any unforeseen circumstances. It depends on the criticality of your data whether you want to keep them locally to want to replicate them in other locations or regions to ensure their resiliencies.

Read more »

Azure Cosmos DB

# SQL Performance Tuning tips for newbies

April 15, 2024 by Esat Erkec

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.

Read more »

Monitoring, Performance

# Understanding the SQL IN operator with examples

March 19, 2024 by Arindam Mondal

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, and PostgreSQL.

Read more »

T-SQL

# Finding Duplicates in SQL

February 7, 2024 by Rahul Mehta

This article will provide an understanding of identifying duplicate values in SQL.

Read more »

T-SQL

# Difference between SQL SELECT UNIQUE and SELECT DISTINCT

January 16, 2024 by Manvendra Singh

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 like TSQL, PLSQL, etc. These query languages are based on ANSI standard SQL language which can also be used in these database systems to perform any transaction.

Read more »

T-SQL

# An overview of SQL Server monitoring tools

December 12, 2023 by Hadi Fadlallah

This article explains some of the popular SQL Server monitoring tools and techniques.

Read more »

Monitoring, Performance

# PostgreSQL tutorial to create a user

November 12, 2023 by Daniel Calbimonte

## 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.

Read more »

PostgreSQL

# MySQL substring uses with examples

October 14, 2023 by Rahul Mehta

This article will provide an understanding of different ways to use substring in MySQL.

Read more »

MySQL

# An introduction to PostgreSQL Data Types with examples

September 15, 2023 by Arindam Mondal

This article will show PostgreSQL Data Types with various examples.

Read more »

Data types

# SQL Unit Testing reference guide for beginners

August 11, 2023 by Esat Erkec

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.

Read more »

SQL unit testing, Testing

# How to install PostgreSQL on Ubuntu

July 13, 2023 by Rajendra Gupta

This article covers the different methods to install Postgres on Ubuntu.

Read more »

Development, PostgreSQL

# Different methods for monitoring MongoDB databases

June 14, 2023 by Hadi Fadlallah

This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases.

Read more »

Monitoring, Performance counters

# SQL Machine Learning in simple words

May 15, 2023 by Haroon Ashraf

This article is about SQL Machine Learning which is one of the most interesting topics equally attractive to both beginners and professionals of different areas of expertise.

Read more »

Machine learning, Python

# Introduction to the SQL Standard Deviation function

April 21, 2023 by Gauri Mahajan

In this article, we will learn about one of the important statistical functions, the SQL Standard Deviation function. Read more »

Functions, T-SQL

# How to do a group by clause

April 12, 2023 by Manvendra Singh

Today, I am going to explain how to do a group by clause in your SQL queries. SQL (Structured Query Language) is a very popular query language that is widely used to access and manipulate records stored in a database. The GROUP BY clause is also a SQL statement that is used to group identical values. Let’s first understand this clause what it does and why we use this clause in SQL queries.

Read more »

T-SQL

# PostgreSQL Tutorial for beginners

April 6, 2023 by Daniel Calbimonte

## Introduction to the PostgreSQL tutorial

In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4th most popular database in the world (the other ones are Oracle, SQL Server, and MySQL). That is why we think it is an important DBMS to learn.

Read more »

PostgreSQL

# MySQL group\_concat() function overview

March 28, 2023 by Rahul Mehta

This article will provide an understanding of how to effectively use group concatenation in MySQL.

Read more »

MySQL, String Concatenation

# Understanding Substring in Oracle SQL

March 22, 2023 by Arindam Mondal

The Oracle SQL database provides many useful functions to use with your query or programming. The SUBSTR function is one of the most used string functions in the Oracle SQL database. I will also discuss a few important string functions TRIM, UPPER, and LOWER which can be used along with substring functions. In this article, we will discuss substring in Oracle SQL.

Read more »

Oracle

# PostgreSQL vs MySQL: Understanding their differences

March 13, 2023 by Manvendra Singh

Today, we will compare the two most popular database products PostgreSQL vs MySQL, and explain the differences between them in this article. There are many database systems based on the relations database management system (RDBMS) concept in the market. Some of them are Oracle, SQL Server, MySQL, PostgreSQL, etc. It’s really important to understand the differences between them before selecting any database product for your application. Keeping this in mind, I am writing this article to explain these two database systems i.e., PostgreSQL vs MySQL, and compare them from various aspects so that you can understand them before taking any decision for your requirements.

Read more »

MySQL, PostgreSQL

# Understanding the Scalability in Oracle Database

March 9, 2023 by Randheer Parmar

When an application grows the associated database grows automatically. It needs to be scaled to a larger machine or server and overall configuration needs to be increased to handle the application and database performance requirement.

Read more »

Database development, Oracle

# Learn SQL: Insert multiple rows commands

March 6, 2023 by Hadi Fadlallah

This article explains the different approaches used to insert multiple rows into SQL Server tables.

Read more »

T-SQL

Page 1 of 10512345...102030...»Last »



### Follow us!

### Popular

- SQL PARTITION BY Clause overview
- SQL Variables: Basics and usage
- SQL Server table hints – WITH (NOLOCK) best practices
- SQL Convert Date functions and formats
- How to identify and resolve SQL Server Index Fragmentation
- Overview of SQL RANK functions
- The Table Variable in SQL Server
- SQL WHILE loop with simple examples
- Understanding the SQL MERGE statement
- SQL CROSS JOIN with examples
- How to UPDATE from a SELECT statement in SQL Server
- SELECT INTO TEMP TABLE statement in SQL Server
- Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses
- Learn SQL: Naming Conventions
- SQL percentage calculation examples in SQL Server
- How to create and configure a linked server in SQL Server Management Studio
- Recover a lost SA password
- SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries
- SQL multiple joins for beginners with examples
- Understanding the SQL Decimal data type

## Trending

- SQL Server Transaction Log Backup, Truncate and Shrink Operations
- Six different methods to copy tables between databases in SQL Server
- How to implement error handling in SQL Server
- Working with the SQL Server command line (sqlcmd)
- Methods to avoid the SQL divide by zero error
- Query optimization techniques in SQL Server: tips and tricks
- How to create and configure a linked server in SQL Server Management Studio
- SQL replace: How to replace ASCII special characters in SQL Server
- How to identify slow running queries in SQL Server
- SQL varchar data type deep dive
- How to implement array-like functionality in SQL Server
- All about locking in SQL Server
- SQL Server stored procedures for beginners
- Database table partitioning in SQL Server
- How to drop temp tables in SQL Server
- How to determine free space and file size for SQL Server databases
- Using PowerShell to split a string into an array
- KILL SPID command in SQL Server
- How to install SQL Server Express edition
- SQL Union overview, usage and examples

## Solutions

- Read a SQL Server transaction log
- SQL Server database auditing techniques
- How to recover SQL Server data from accidental UPDATE and DELETE operations
- How to quickly search for SQL database data and objects
- Synchronize SQL Server databases in different remote sources
- Recover SQL data from a dropped table without backups
- How to restore specific table(s) from a SQL Server database backup
- Recover deleted SQL data from transaction logs
- How to recover SQL Server data from accidental updates without backups
- Automatically compare and synchronize SQL Server data
- Open LDF file and view LDF file content
- Quickly convert SQL code to language-specific client code
- How to recover a single table from a SQL Server database backup
- Recover data lost due to a TRUNCATE operation without backups
- How to recover SQL Server data from accidental DELETE, TRUNCATE and DROP operations
- Reverting your SQL Server database back to a specific point in time
- How to create SSIS package documentation
- Migrate a SQL Server database to a newer version of SQL Server
- How to restore a SQL Server database backup to an older version of SQL Server

Helpers and best practices

- BI performance counters
- SQL code smells rules
- SQL Server wait types



©  Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy