2020-09-10
110 reads
Editorials
Do You Have Big Data?
Data sizes are always growing. Stats on world data are astounding, as are the stats many of us experience in our lives. Plenty of us have moved from MB management to GBs, and I see plenty of people dealing with TB storage at home. Most of that data is likely from images and video, but […]
2020-09-09
152 reads
The Best Security for Database Administrators
Today Steve talks about limiting security issues for administrators.
2020-09-08
185 reads
2020-09-07
67 reads
Mentoring
Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read […]
2020-09-05
191 reads
Emergency Preparedness
Being prepared for things to go wrong is important, more so these days than in much of our past.
2020-09-04
90 reads
Can You Catch SQL Injection?
Steve found an attack against Google's SQL database that their SREs detected.
2020-09-03
208 reads
2020-09-02
166 reads
The Evolution of Windows
Today Steve looks back at Windows, and how Windows 10 might be the last version. Perhaps this is the model we'll see with SQL Server in the future.
2020-09-01
270 reads
The Challenges of Resetting Databases
The challenges of state in databases can impact our development efforts.
2020-08-31
94 reads
Blogs
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...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
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
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
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