Is Ransomware Fading?
There is a report that less ransomware ransom is being paid. Perhaps that's a good sign for all of us.
2025-02-19
80 reads
Editorials
The Change Failure Rate
The number of times that you have a failure when deploying changes is a good metric to watch.
2025-02-17 (first published: 2019-06-03)
1,305 reads
Limits, Not Goals
I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]
2025-02-15
125 reads
How Much Linux Do You Need?
With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.
2025-02-14
120 reads
2025-02-14 (first published: 2025-02-12)
804 reads
Extended Event Comfort
Steve wants to know if you're using Extended Events and what you think of it.
2025-02-10
128 reads
No End to Programmers
The idea of chat-oriented programming has led some people to think that AI LLMs will reduce the need for programmers. Steve disagrees.
2025-02-08
134 reads
Unreliable Narrators
Steve has a few thoughts on a interview with Grady Booch, an icon in our industry, who have a great quote on AI technology.
2025-02-07
103 reads
Building a Data Center
A data center is a complex beast. Is it worth building and maintaining your own? Steve has a few thoughts on a data center versus a cloud.
2025-02-05
153 reads
Words vs Data
Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.
2025-02-03
91 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
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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