Announcing Preview Release of MOSL
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
458 reads
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
458 reads
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0!
This release is focusing...
2016-11-07 (first published: 2016-11-01)
1,010 reads
I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...
2016-11-03
387 reads
Continuation from the previous 88 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I would like to dedicate this blog...
2016-10-25
522 reads
Continuation from the previous 87 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Getting Data into the Database is one...
2016-10-22
588 reads
Continuation from the previous 86 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A very long time desired feature from...
2016-10-10
502 reads
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...
2016-10-05
536 reads
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017...
2016-09-23
459 reads
Right now one of the hottest topics around the world is the cloud and the successful methods for the migration...
2016-09-18
695 reads
I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on...
2016-09-13
527 reads
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
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...
The thread for the league in 2026. Players from last year have priority.
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...
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