Power BI in SSRS – T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-02-21 (first published: 2017-02-14)
6,951 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-02-21 (first published: 2017-02-14)
6,951 reads
This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build...
2017-02-06 (first published: 2017-02-02)
7,732 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-01-09
555 reads
This is the sixth part in the series: SQL Server and Continuous Integration. This post will illustrate the power of ReadyRoll when...
2017-01-03 (first published: 2016-12-23)
1,285 reads
Last Wednesday I got very excited by Microsoft’s announcements about the addition of features to standard edition and the public preview...
2016-11-23
916 reads
They finally did it! Finally SQL Server for Linux was announced. I’ve been waiting for this for quite a while, so...
2016-11-16
1,061 reads
This is part 5 in the series named SQL Server and Continuous Integration. This post will cover the steps I follow...
2016-10-26
1,207 reads
This is the 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need...
2016-10-03 (first published: 2016-09-21)
1,348 reads
I recently configured a backup job to run on the principal server of a mirrored pair. The idea was to backup...
2016-09-08 (first published: 2016-09-05)
2,111 reads
This is the 3rd post in the series: SQL Server and Continuous Integration. This time I’ll cover the prerequisites of using ReadyRoll...
2016-08-16
788 reads
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
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...
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
hi , i know this is a sql server forum but i think my...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
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