PostgreSQL Basics: Getting started with psql

PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on psql to help them quickly connect to databases, examine the schema, and execute SQL queries.

Knowing how to install and use basic psql commands is an essential skill to have for anyone that will connect to PostgreSQL.

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

It can be a daunting task for new users to get to grips with PostgreSQL documentation, particularly if you are not from a developer background.

If you are not sure where to start, we are here to help break down the different resources available so you can make the most of them.

In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover:

- How to navigate PostgreSQL documentation
- The essential things you need to know about PostgreSQL documentation
- Other useful learning resources to help make your journey to using PostgreSQL easier

Register to join us on September 19th at 11am CT (5pm BST)

SQL Server Execution Plan Issues when using TOP Clause and Various Parameters

A query is sometimes super fast and sometimes very slow. One of the main reasons for this problem is Parameter Sniffing. There are several approaches to addressing the Parameter Sniffing issue and this article discusses effective methods for handling Parameter Sniffing in SELECT statements containing a TOP clause.

Yet Another Reason to Not Use sp_ in your SQL Server Object Names

In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with using the sp_ prefix. Procedures prefixed with sp_ have special powers when placed in the the master database in that it can be executed anywhere on the server after that.

Generate Test Data Sets for Testing SQL Server Database Applications

In this tip, we will discuss the process of generating test data to verify query logic without relying on real-life data, along with some helpful guidelines. We will also cover various scenarios and their corresponding solutions.

Arrays and Lists in SQL Server

Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods.

One use case for NOT using schema prefixes

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.

In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of your T-SQL code, because the schema prefix is important and useful most of the time. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial.

Working with NULL Values in SQL

In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell.

Decision Tree - Credit Card Fraud Detection

Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.

PASS Data Community Summit 2023 - Sessions are available to view!

As hosts, Redgate are delighted to announce PASS Data Community Summit 2023 sessions are now live and available to view!