Crossing Azure Borders
Steve Jones is pleased to see some changes at Azure that make the database a stronger platform.
2015-11-05
109 reads
Editorial
2015-11-04
139 reads
Virtual Failback
The pressure to move to virtual systems is increasing, but is there a fallback if you have issues?
2015-11-03
91 reads
Secret Software Security
The move to limit disclosure of vulnerabilities continues, with potential issues for many of us.
2015-11-02
101 reads
SQL Injection - The Revenge
As yet more personal details are spilled by preventable security lapses, what's
2015-11-02
275 reads
2015-10-30
324 reads
The Hot Jobs
This week Steve looks at the hot jobs that are going to have pay increases in the coming year.
2015-10-26
261 reads
Positive or Negative
Today Steve Jones wonders if the way you choose to design a database says something about you.
2015-10-23
185 reads
The Dangers of Travel
As data professionals, we might carry lots of information with us that relates to our organization. Will we get caught up in government issues as we cross borders?
2015-10-22
200 reads
An Out of Date CAP
The CAP Theorem talks about the properties of distributed systems, and how you can really only have two of them in any system.
2015-10-21
106 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
Question of the Day
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