Today, I want to blog about something I have only limited knowledge of … confidence. Okay, I understand what confidence is, and I have seen it before in the real world and not just in biographical movies. In fact, I have met quite a few highly confident people. In almost every case, it was immediately […]
2023-10-07
84 reads
2023-10-06 (first published: 2017-01-30)
458 reads
Over the years I've had the chance to work in a lot of companies, and I've seen a lot of different team-building attempts take place. In restaurants, these were often nights out with too many adult beverages. At a power station, we had some large outdoor BBQs, where again, sometimes there were too many adult […]
2023-10-04
111 reads
DevOps is great, but Steve thinks we need to ensure we include security is a part of what we do when building and deploying software.
2023-10-02
136 reads
Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]
2023-09-30
47 reads
An Azure datacenter had a failure after an incident, partially because they didn't have enough people. Steve notes that staffing is a challenge in many ways.
2023-09-29
170 reads
The way we view our jobs might change how we do them. Steve has some advice on how to think about the work you do.
2023-09-27
107 reads
Many people are worried for their future career prospects with the growth of Artificial Intelligence (AI) in many situations. Steve doesn't think that AI is going to take over the world, but it might affect your future opportunities.
2023-09-25
154 reads
I was on the road for just over two weeks. I was able to travel around to a few places and present some sessions. But, better than that, thanks to SQL Konferenz, I was able to go to a couple of sessions and learn some stuff. I'm lucky/cursed in my position at Redgate. We have […]
2023-09-23
98 reads
Microsoft built SQL Server on Linux. Are people coming to use it? Are you?
2023-09-22
154 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...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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