Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is Ireland’s free, community led, Microsoft Data Platform event. We had a fantastic event this year...
2025-12-16
57 reads
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is Ireland’s free, community led, Microsoft Data Platform event. We had a fantastic event this year...
2025-12-16
57 reads
Following on from my last post about Getting Started With KubeVirt & SQL Server, in this post I want to see if I can improve the performance from the...
2025-12-11
23 reads
With all the changes that have happened with VMware since the Broadcom acquisition I have been asked more and more about alternatives for running SQL Server. One of the...
2025-12-02
13 reads
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieves this is...
2025-11-17 (first published: 2025-10-31)
405 reads
Following on from my previous post about hitting the Kubernetes API from SQL Server 2025 let’s go a little further and deploy SQL Server 2025 to Kubernetes from…SQL Server...
2025-08-25 (first published: 2025-08-01)
321 reads
The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit external rest endpoints…which opens up quite a few interesting options. I was thinking about this...
2025-08-20 (first published: 2025-07-31)
505 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2025 Edition has been announced! We’re kicking off at 1pm UTC on August 21st…here’s the schedule: – N.B. – If...
2025-06-30
36 reads
One of the new features in Kubernetes v1.33 is the ability to resize CPU and memory resources for containers online, aka without having to recreate the pod the container...
2025-06-13 (first published: 2025-05-22)
275 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s all happening on August the 21st! We’ve open our call for speakers, you can submit...
2025-03-28 (first published: 2025-03-17)
260 reads
The other day I came across an interesting repo on github, KubeDiagrams. What this repo does is generate Kubernetes architecture diagrams from Kubernetes manifest files…nice! Deploying applications to Kubernetes...
2025-02-17 (first published: 2025-02-06)
341 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
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...
Comments posted to this topic are about the item Your AI Successes
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