2008-05-26
75 reads
Editorial
IT Project Euthanasia
A guest editorial from Phil Factor on the kindest way to dispose of unwanted IT projects.
2008-05-26
158 reads
2008-05-23
68 reads
MatrixDB
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
2008-05-22
345 reads
2008-05-21
554 reads
Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest. This editorial was originally published on May 20, 2008. It is being re-run as Steve is on vacation.
2013-03-11 (first published: 2008-05-20)
407 reads
The Best Way to Find Quality People
How can you find good employees? Steve Jones offers a few tips on what has worked for him in the past.
2008-05-19
256 reads
Database Weekly Update for May 19, 2008
Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.
2008-05-19
28 reads
A Worthwhile Goal
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
2008-05-16
112 reads
2008-05-15
175 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
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.
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
exec etl.GettheProduct
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