Checking Up on Vendors
Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.
2021-05-10
166 reads
Editorials
Non-Stop Learning
There was a recent discussion in the forums here at SQL Server Central regarding the difficulties presented by the constantly shifting technology landscape. The core question was, how on earth do you master stuff? Especially, how do you master things when they're both new and constantly changing? Honestly, you don't. I mean, you can, but […]
2021-05-08
253 reads
Getting Started Remotely
Today Steve wonders what advice you might give someone starting out their career in technology.
2021-05-07
102 reads
Cloud Database Growth
The use of cloud databases is growing, and Azure SQL Database is one of the more popular ones.
2021-05-05
278 reads
Holding Code in Your Head
Steve has a few thoughts on software development and coding today when working in teams and trying to keep the entire solution in your head.
2021-05-03
525 reads
No-code Software Engineering
The idea that software engineers might be better with no-code tools is a direction Steve thinks is misaligned with the problem. We should help developers learn to be better.
2021-05-01
178 reads
Documentation. The Under Recognised Skill
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
426 reads
Ransomware May Get Worse
Criminal groups using ransomware are working together, which is bad news for all organizations.
2021-04-29
241 reads
2021-04-28
106 reads
A Cloud Database for Statistics
A company decides to move to the cloud and outsource database administration.
2021-04-27
112 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