Build It, Buy It, Cloud It? The IT Decision Puzzle
The Never-Ending Question in IT: Which Approach to Take? As a Consultant, I would typically answer with = it depends! Then a typical conversation starts with an expression of...
2025-03-05
27 reads
The Never-Ending Question in IT: Which Approach to Take? As a Consultant, I would typically answer with = it depends! Then a typical conversation starts with an expression of...
2025-03-05
27 reads
Introduction Do you remember the effort of tidying up your BI and reporting systems, only to find yourself facing a labyrinth of inconsistent data, missing values, and unclear ownership?...
2025-03-05 (first published: 2025-02-20)
215 reads
Reflecting on data strategy projects from 2024, key lessons include starting with clear business objectives, prioritizing data ethics and security, and fostering collaboration between business and IT teams. Also,...
2025-02-17
22 reads
Introduction The challenge enterprises face is adopting new technologies to manage data. But, even more importantly, using the latest technologies is not a solution by itself, and companies should think first about adding value to the organization through...
2025-02-16
9 reads
Introduction Growing enterprises or businesses that want to remain competitive must make quick decisions daily. While experience and expertise are essential in that process, making those critical calls is...
2025-02-14
7 reads
Introduction Building a practical data governance framework can feel like building a house: you need a strong foundation, reliable materials, and the right team to make it all work. Data governance is crucial for organizations to manage, protect, and utilize their data effectively. A well-defined framework...
2025-02-13
14 reads
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
2025-01-31 (first published: 2025-01-20)
275 reads
The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.
2025-01-22 (first published: 2025-01-14)
310 reads
The post The pros and cons of self-service BI: What every industry leader should know appeared first on Joyful Craftsmen.
2025-01-20 (first published: 2024-11-04)
699 reads
2025-01-16
4 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
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
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