Self-Service vs. Managed BI
Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.
2010-07-22
369 reads
Editorials
Becoming Highly Productive
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
2010-07-21
253 reads
Incompetent or Malicious
When someone else doesn't do a good job to prove a point, are they incompetent or malicious? Steve Jones comments.
2010-07-20
280 reads
Backup Isn't Enough
When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.
2010-07-19
342 reads
SQLRally
A new event is coming to the East Coast next year that will give people a chance to experience a SQL Server conference at a much lower cost.
2010-07-19
82 reads
Collective Intelligence
Trying to keep up with all the learning going on in the SQL Community can be frustrating. Or is it? Give us your answer in this week's Friday poll.
2010-07-16
136 reads
From “One of the Pack” to “Top Dog”
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
2010-07-15
441 reads
The Private Cloud
Cloud computing is becoming more and more prevalent in technology. However most people think of a public cloud on the Internet. Steve Jones says a private cloud might be a better idea for many companies.
2010-07-13
278 reads
GOSQL vs. NOSQL
If we're getting pulled down a blind alley by acronyms, we may as well make up a more optimistic one.
2010-07-12
312 reads
The Utilty
Is Information Technology a utility service for companies? Steve Jones thinks it can, and should, be, but it can also be a lot more. It can be a strategic part of your enterprise.
2010-07-12
97 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