Problems With Database Problems
The GitLab crisis has Steve Jones thinking about two things: competence and care.
2017-02-13
117 reads
Editorial
Moving Through Five Years
An updated editorial. The five years are almost up for the prediction that IT departments would be eliminated. Read Steve Jones thoughts on where we are today.
2017-02-10
107 reads
Why Devops? For Better Security
DevOps is supposed to help us build better software, faster. Steve Jones looks at one of the other benefits: security.
2017-02-09
96 reads
2017-02-08
159 reads
Would You Still Love Linux If Windows Was Free?
A guest editorial today looks at the OS debate: Windows v Linux.
2022-03-07 (first published: 2017-02-07)
416 reads
A View of the Cloud
Today Steve Jones looks at how we can better build software by considering the cloud.
2017-02-06
74 reads
Close Encounters of the CEIP Kind
Microsoft's Customer Experience Improvement Program for SQL Server: once easy to avoid, now hard to ignore, but Rodney Landrum sees an upside.
2017-02-06
1,530 reads
Your Favorite Feature that Needs Work
This week Steve Jones asks what parts of SQL Server would you improve and why.
2017-02-03
73 reads
The Great and Powerful Internet of Things
A look at the good, and bad, of the IoT world along with the potential future.
2017-02-02
100 reads
A Wide Variation in Skill
We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.
2017-01-31
128 reads
Blogs
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
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...
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