SQL Server Errorlog: Not Just for Errors!
A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get overlooked, until something breaks. But if you know how to use them, they can tell...
2025-07-02
74 reads
A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get overlooked, until something breaks. But if you know how to use them, they can tell...
2025-07-02
74 reads
Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server instance but don’t live and breathe licensing, you’re not alone. Many IT managers and sysadmins...
2025-07-09 (first published: 2025-06-25)
421 reads
Things your cloud vendor may not tell you Here’s a common theme I hear from small IT teams: “Our SQL Server is in the cloud now. We don’t...
2025-06-18
28 reads
Useful tips to make your jobs more stable Too many IT teams treat SQL Server Agent jobs like a coffee timer “Set it and forget it!” Unfortunately, that mindset...
2025-07-02 (first published: 2025-06-11)
560 reads
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk drawer – everyone uses it, nobody monitors it, and eventually it becomes a bottleneck you...
2025-06-23 (first published: 2025-06-04)
810 reads
The Two-Layer Model Explained “We added them to the database, but they still can’t connect.” Sound familiar? That’s the kind of confusion SQL Server’s two-layer security model creates when...
2025-05-28
106 reads
If your SQL Server has both SQL and Windows logins and you’re not sure why, you’re not alone. Many IT teams without a dedicated DBA bump into this sooner...
2025-06-11 (first published: 2025-05-21)
496 reads
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index. No questions asked. Here’s the truth: if you’re doing this daily on indexes smaller than...
2025-05-26 (first published: 2025-05-14)
667 reads
Early Warnings of a Meltdown (and How to Catch Them) Most SQL Server crashes don’t come out of nowhere. They leave breadcrumbs – red flags that something’s not right....
2025-05-07
91 reads
Ever tried to request SQL Server funding from the CFO? Your systems, your data, your customer experience – they all rely on that “invisible” database engine humming along behind...
2025-05-01
44 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers