External Article

PostgreSQL Constraints: Learning PostgreSQL with Grant

One of the most important aspects of data management is the ability to ensure that the data in your database is well defined and consistent. Some aspects of that are ensured through the relational data structures you design. Another piece of control is using the correct data type. Then, we get to constraints. A constraint is a way to validate data prior to adding it to your database. This is one more tool in the toolbox that helps you maintain good data.

External Article

The future of AI in solving database challenges

The conversation around Artificial Intelligence (AI) is not a new subject to the database space, but the recent rise in machine learning tools like ChatGPT have sparked increased focus on new ways to simplify existing DBA challenges.

Join Redgate’s own DevOps Advocate, Steve Jones, along with webinar guests Kellyn Pot’Vin-Gorman (Principal Cloud Solution Architect, Microsoft) and Brian Randell (Product Marketing Director, Github) to discuss how AI could help manage complex database ecosystems.

Blogs

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Daily Coping 24 Mar 2023–The Final Tip

By

Today’s coping tip is to discover the joy in the simple things in life....

Experimenting with RedisGraph on Docker and Windows

By

I have been experimenting a bit with graph databases, trying to learn more about...

Read the latest Blogs

Forums

Slow performance when processing a JSON file in Azure

By Weegee71

We have a stored procedure that can load up a JSON file and process...

dbatools - Connect-DbaInstance

By rothj

I have my SQL servers name, UserID (UID) and Password (PWD) in a table...

Extracting the string before and after the given character

By sathishkm

Hi All, I want to extract the string before and after the given characters....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers