I ran across a tip on MSSQLTips from Joe Gavin recently, and it got me thinking about hardware and disks. For a lot of us, we deal with servers and storage, and not disks. While we might have a disk on a laptop or desktop, most of the production systems just attach to remote storage. […]
2021-11-03
291 reads
DataOps is another DevOps term for the modern management of data. It's not just the daily work of a DBA, however, as Steve notes in this piece.
2021-11-01
166 reads
I’m sure you’ve heard the adage that people are more afraid of public speaking than they are of death. On the other hand, some folks can’t get enough public speaking and look forward to opportunities to get up in front of a group and talk. Writing is not so scary since it’s a solitary activity, […]
2021-10-30
208 reads
What's the future of the Internet? A lot might depend on how we decide to value and handle data.
2021-10-29
271 reads
We often misconfigure public access for data, which might contain sensitive information. Steve notes that we could do better, but it requires the effort to classify data.
2021-10-27
202 reads
2021-10-25
324 reads
It might be DNS is the problem more often in the future. Steve notes the attacks on this system are rising.
2021-10-23
112 reads
More complex searching is likely to be a requirement in the future, but for many of us, this won't require us to learn much.
2021-10-22
207 reads
Lots of organizations are moving to the cloud, but having different levels of success. This change can be powerful and create tremendous opportunity, but it can also be a disappointment.
2021-10-20
250 reads
Trying to keep up with technology is a losing game. Better to continue to grow and learn, balanced with the rest of your life.
2021-10-18
223 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