Azure SQL Database Compatibility with SQL Server
A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure...
2020-10-02 (first published: 2020-09-27)
2,094 reads
A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure...
2020-10-02 (first published: 2020-09-27)
2,094 reads
I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...
2020-08-28 (first published: 2020-08-17)
199 reads
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
121 reads
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
19 reads
Connect() is a yearly, Microsoft-hosted developer event that is broadcast live from New York City to developers worldwide.
The Connect(); 2017...
2017-11-13
270 reads
External USB drives should be safely detached from Windows instead of just unplugging them from the computer. Most of us...
2017-11-01
382 reads
It’s official: the next version of SQL Server, planned to be released this year, will be called SQL Server 2017....
2017-04-19
3,382 reads
It’s quite easy to hit the PrintScreen key and capture the whole screen. But how do we quickly capture a...
2017-04-07 (first published: 2017-03-22)
2,398 reads
About two years ago I wrote my first blog post.
About a year ago I paused my blogging activity. That’s when...
2017-03-21
292 reads
Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses,...
2016-03-04 (first published: 2016-02-29)
2,101 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
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
exec('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