SQLServerCentral Editorial

Review Early and Often

Several years ago, I was brought in on a project to review a database design. I was provided a time for a meeting. No written requirements were available, but I generally knew what the system was supposed to do. No before/after schema images showed what was being changed were available. Still, I was assured that […]

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

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

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

Read the latest Blogs

Forums

Tsql query to show currently running sql agent jobs

By vsamantha35

Hi All, Using Tsql query I want to know currently running sql agent jobs...

SQL Agent Job schedule

By vsamantha35

Hi All, Want to know what are the SQL Agent Jobs scheduled for today...

Need an alert for a sudden increase in data

By vsamantha35

Hi All, Today, all of a sudden the size of the data file (.mdf)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers