2025-12-29 (first published: 2025-12-25)
25 reads
2025-12-29 (first published: 2025-12-25)
25 reads
This script will save your database permissions into a table.
2025-12-29
28 reads
This script is used to generate the output file as CSV format for list of server.
2025-11-03 (first published: 2025-10-20)
579 reads
The script gets the database health check whether synchronized or not from the primary or secondary. This code needs to scheduled through as a job to get alerts.
2025-10-20 (first published: 2025-10-13)
445 reads
Get a list of all user permissions in a database
2025-10-15 (first published: 2025-10-13)
1,844 reads
Two PowerShell scripts to create backup folders and clean up old files.
2025-08-29 (first published: 2025-08-16)
288 reads
This script will help to find orphan users on all databases and will remove them.
2025-05-20
363 reads
2025-05-06
719 reads
This script runs a SQL server Health check for services, databases, Always On, replication, CDC job status.
2025-05-05
835 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 SCSI 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