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.
The post PostgreSQL Constraints: Learning PostgreSQL with Grant appeared first on SQLServerCentral.

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.
The post The future of AI in solving database challenges appeared first on SQLServerCentral.

See how well ChatGPT works with questions on generating PowerShell code.
The post ChatGPT and PowerShell – Some practical examples appeared first on SQLServerCentral.

Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.
The post New functions in SQL Server 2022 - LEFT_SHIFT and RIGHT_SHIFT appeared first on SQLServerCentral.

The multi-million-dollar question for you and your business is... what is the real business value of frequent deployments? Part one of three in this series on the value of database DevOps.
The post The business value of frequent deployments appeared first on SQLServerCentral.

Learn the basics of views in PostgreSQL.
The post The Basics of PostgreSQL Views appeared first on SQLServerCentral.

As part of a recent Redgate Summit which focused on data modernization, Grant Fritchey interviewed Pramod Sadalage, a Director at Thoughtworks. They discussed data and DevOps, and the typical challenges organizations come across in their digital transformation efforts. Grant Fritchey shares this Q&A.
The post What are the biggest challenges organizations face in their digital transformation efforts? appeared first on SQLServerCentral.

Learn about the SQL Server .WRITE function along with how to use this to update data in VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.
The post SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types appeared first on SQLServerCentral.