How to use the SQL WHERE Clause with Examples

With the SQL WHERE clause in SQL Server, users can filter their query results in many ways. In most cases, we do not utilize all the options the WHERE clause provides, so we tend to forget that they exist. In this SQL tutorial, we will look at several examples of how to use the WHERE clause.

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 […]

How Important is Zero Downtime?

Zero downtime used to be more important in Steve's job, but lately it seems customers aren't as concerned.

How to Connect SQL Server and Create C# Objects for Data Management

Learn about how you can work with your SQL Server data from C#. A good basic tutorial for beginning C# developers.

SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners - Part II

This article covers the concepts of roles, schemas, grants, privileges, and owners and the similarities and differences in SQL Server, Oracle, and PostgreSQL.

Thought Leadership resource page

Find the latest insights on digital modernization and the role of the database in it in our new resource page. With articles and webinars from Redgate leaders and friends of Redgate.

Stairway to SQL PowerShell Level 9: Objects For Everyone

This level will show how to create objects including a login, a database, a filegroup, a file a database user and then we’ll end with a table and an index.

What's a Code Smell?

Poor patterns and practices are code smells. Steve Jones notes we have plenty in T-SQL.

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.

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.