SQL Server 2016 Row Level Security In Action
Row Level security was introduced with SQL Server 2016 and allows us to specify predicates for what rows can be...
2017-06-07
40 reads
Row Level security was introduced with SQL Server 2016 and allows us to specify predicates for what rows can be...
2017-06-07
40 reads
DROP IF EXISTS
This allows us to drop objects without first having to check if they exist. It works on pretty...
2017-06-06
48 reads
If you’re using Windows Authentication then you probably have a database user for each user of your application or at...
2017-06-05
176 reads
I was recently debugging a slow running SQL instance, when checking the wait stats I noticed a lot of BAD_PAGE_PROCESS...
2017-06-03
80 reads
One of the new features SQL Server 2016 introduced is Dynamic Data Masking. This feature allows sensitive data to be...
2017-06-01
70 reads
If you’ve ever searched for SQL Server parameter sniffing you’ve probably read all sorts of bad things about it. In...
2017-05-31
115 reads
What Are Filtered Indexes
Filtered indexes are essentially an index with a predicate on them filtering the data that gets stored...
2017-05-30
60 reads
SQL Server Window Functions were introduced in SQL Server 2005 with a basic set of operators and massively upgraded in...
2017-05-23
71 reads
SQL Server statistics are often thought of as a bit of a black box, this is completely not the case...
2017-05-22
119 reads
When using row level indexes there are two types Clustered and NonClustered both of which are there to make data...
2017-05-16
94 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