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.
2023-03-27
Learn about how you can work with your SQL Server data from C#. A good basic tutorial for beginning C# developers.
2023-03-24
15,770 reads
This article covers the concepts of roles, schemas, grants, privileges, and owners and the similarities and differences in SQL Server, Oracle, and PostgreSQL.
2023-03-24
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.
2023-03-24
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.
2023-03-22
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.
2023-03-22
See how well ChatGPT works with questions on generating PowerShell code.
2023-03-20
14,218 reads
Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.
2023-03-20
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.
2023-03-20
2023-03-19 (first published: 2018-09-24)
22,746 reads
Yes, you’re reading that right, we’re going to download a report that cannot be...
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers