In today’s data-driven world, organizations rely on skilled professionals to design, build, and maintain scalable data solutions. The DP-203: Data Engineering on Microsoft Azure certification is your ticket to...
2025-07-16
93 reads
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve ever upgraded a SQL Server instance and something just broke in your application, chances are...
2025-07-16
425 reads
Do you know what happens when you enable zonal redundancy for your SQL managed instance? Lets define it first (in the context of Business-Critical tier) – zonal redundancy is...
2025-07-16
81 reads
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from failure — and why most companies still underestimate what it really takes to turn strategy...
2025-07-15 (first published: 2025-07-14)
18 reads
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature enabling you to distribute read-only workloads such as reporting and analytics across built-in replicated secondary...
2025-07-15
94 reads
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up your first cloud environment is a valuable skill, and you can begin without spending any...
2025-07-15
25 reads
The PASS Summit goes on tour this year, with the final date the first few days of October in the Netherlands, Utrect to be exact. This is the first...
2025-07-15
38 reads
I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance ... Continue reading
2025-07-14
245 reads
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming how we live, work, and interact with technology. From personalized recommendations to AI-generated art, the...
2025-07-14 (first published: 2025-06-23)
390 reads
The internet relies on IP (Internet Protocol) addresses to identify devices and route traffic. Two versions of IP exist today: IPv4 and IPv6. While IPv6 was introduced to overcome...
2025-07-14
30 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