I happen to notice this in a class recently that I had the rare student - one that could take notes that seemed to have value to them the next day. If you watch people take notes, I think they fall into one of these categories: The Highlighter. They have...
2009-04-24
1,989 reads
I finally finished up reading the Speed of Trust and have to say I struggled with it. I'm a big...
2009-04-23
788 reads
A little further off topic than usual today, something not about technology and work for a change. Woodworking is one...
2009-04-23
1,405 reads
This SQL School video looks at how you add a publication to a replication scenario.
2009-04-23
3,586 reads
I've had a few requests for these, so I'll take orders through May 8, 2009. The polo is a very...
2009-04-23
830 reads
My friend Will Strohl is managing the Day of DNN on June 13, 2009 at the Microsoft office in Tampa....
2009-04-22
707 reads
We'll all heard about or lived with outsourcing, and hopefully we know it's good and bad. Outsourcing the janitorial services...
2009-04-22
974 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-22
562 reads
I was reading a book recently and it equated brand with reputation. My first thought was "aha", that brand is...
2009-04-21
1,018 reads
SQL School expands its replication series with a look at how you can set up a subscriber with MVP Andy Warren.
2009-04-21
2,602 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...
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
Comments posted to this topic are about the item JSON Has a Cost, which...
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