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.

SQLServerCentral Article

SQL Server 2022 Build List

This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]

Blogs

Resources for Architecting Zero Downtime Deployments

By

I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...

Daily Coping 23 Mar 2023

By

Today’s coping tip is to focus your attention on the good things you take...

SQL Bits 2023 Recap

By

I had an amazing time adventuring to Wales with other members of the data...

Read the latest Blogs

Forums

Best way to ETL on large tablle with columnstore index

By SQL_Surfer

I have a table with 489M rows and growing. The reason we had to...

Unable To Create Transactional Replication - Microsoft SQL Error 20026

By maroju1

Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...

Grouping the first letter in a string

By sathishkm

Hi All, I have the column of data in SQL Server. Here  I need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers