Software for Profit
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-14
75 reads
Editorials
The Database Weekly Update for July 14, 2008
Steve Jones talks about data mining in the drug industry and the advantages of cheap software.
2008-07-14
38 reads
DIY
For this Friday, Steve Jones has a poll about life outside of work and how much you tinker with things.
2008-07-11
105 reads
The Value of an MBA in IT
Do you have an MBA? If so, has it helped you? Is it worth getting one for someone in IT? Ted Pin comments.
2008-07-10
618 reads
What's an MVP?
What does it mean to be an MVP for Microsoft? Steve Jones talks about what the award is and what it means to get the award.
2008-07-09
335 reads
Land Mines
Security can be a hassle, but Steve Jones talks about why we sometimes put up with the difficulties of implementing strong security.
2008-07-08
106 reads
Enough is Enough
When do you decide that enough is enough? When does it make sense to let some bugs go and fix them later? Steve Jones comments on the decisions you sometimes make.
2008-07-07
144 reads
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
2008-07-07
40 reads
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
2008-07-04
252 reads
2008-07-03
196 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