2023-11-24
429 reads
humor
The Top 5 Technologists
There's a common party question about which 5 people would you invite to a dinner party? Often this is amended to include living or dead people, and it's often interesting to hear people tell you who they'd invite and why. Since most of the people reading this work in technology in some way, I was […]
2023-02-24
176 reads
2022-10-31
740 reads
2022-05-30
558 reads
Executing Notebooks in a Stored Procedure
Writing notebooks in Azure Data Studio is a great way to keep a number of queries in one place and execute them together. Steve has a way to do this inside a stored procedure.
2022-04-01
618 reads
Power BI in Grafana
An exciting new way of viewing your Power BI visuals. The functionality is a bit limited, but highly desired.
2022-04-01
9,152 reads
2022-04-01
612 reads
2021-04-01
8,496 reads
Expanded Support for Non-Windows SQL Server
Steve is excited that SQL Server is moving to a new platform.
2021-04-01
143 reads
2021-01-01
646 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
How Good Is Pench National Park for First-Time Wildlife Travelers?
Pench National Park is one of the best places to visit for the first...
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...
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
exec etl.GettheProduct
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