Data Warehousing Explained
Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...
2017-05-14
272 reads
Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...
2017-05-14
272 reads
Note : Since publishing this I’ve been notified that there are a number of outstanding issues with the SQL Server merge...
2017-05-08
57 reads
Often when trying to pivot data you wont know what the possible values that you need to pivot on, in...
2017-05-07
61 reads
The new JSON bits in SQL Server 2016 give you the ability to pull stuff out of JSON and to...
2017-05-06
93 reads
I’m going to walk through an example that we can build up and improve with a number of the new...
2017-05-05
34 reads
The Pivot and Unpivot features in SQL Server are I find quite underused. For a long time I got by...
2017-05-04
51 reads
CROSS APPLY was introducted as part of TSQL in SQL Server 2005. Origionally it was created as a way to...
2017-05-03
42 reads
SSL All the Things
Browsers are starting to highlight sites without SSL as insecure in a bid to push everyone to...
2017-04-26
131 reads
Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...
2016-04-15
77 reads
.Net CLI is the new tooling that sits in front of .Net Core, allowing you to create and run projects...
2016-02-07
39 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