2014-11-04
94 reads
Editorial
Normalizing Performance
Determining the best performance value you can get for your effort is not as straightforward as you might think.
2014-11-03
208 reads
The Geek Costume
This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.
2014-10-31
172 reads
Have You Been Hacked?
Security is a big deal, and Steve Jones wonders if most data professionals would be aware that they had been hacked.
2018-07-31 (first published: 2014-10-30)
224 reads
Stuck in a Rut
What do people do when their job doesn't require a lot of technical skills? Steve Jones has a few thoughts.
2014-10-29
167 reads
Triple Digits
Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.
2014-10-28
232 reads
Managers: who needs them?
Managers, look away now. Patrick Index wants to get something off his chest...
2014-10-27
323 reads
CI and CD Aren't Magic
The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.
2018-08-01 (first published: 2014-10-27)
150 reads
When Work Gets in the Way of Work
Work sometimes gets in the way of work. Steve Jones notes this can cause stress and problems over time.
2018-06-27 (first published: 2014-10-21)
216 reads
Why Would You Move?
Most people prefer to work with the platforms that they are familiar with, but there is always pressure to try new, exciting technologies when others have success. Steve Jones explores the idea of switching platforms.
2014-10-20
162 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