SQL Server Knockoffs
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
2013-10-29 (first published: 2009-03-17)
284 reads
Editorials
Escape from ETL Hell
What often starts out as a simple, quick process, gradually expands over time, as developers use SQL Agent to schedule new data feeds, add more complex transformations...
2013-10-28
225 reads
What's in a Name?
Today we have a guest editorial from Andy Warren as Steve is speaking at SQL Intersection today. Andy talks about how names can impact our world.
2013-10-28
137 reads
Image is Everything
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
2013-10-25 (first published: 2009-01-09)
564 reads
Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
2013-10-24 (first published: 2009-03-05)
447 reads
Recharge and Relax
Steve Jones has vacation planned for the remainder of the year and encourages you to make sure you are taking your own time off.
2013-10-23
108 reads
Minor Problems
Steve Jones encourages you to write today on your blog. Don't worry about what anyone else writes; share your own stories and knowledge to grow your brand.
2013-10-22
132 reads
Database Queries and Scalability
Does the database limit the scale of your application? Without a doubt, but that doesn't mean you shouldn't use an RDBMS.
2013-10-21
285 reads
Grow Your Family
This Friday Steve Jones asks you to network at your next event and meet more people in the amazing SQL Server community.
2013-10-18
112 reads
Open Arms
Steve Jones looks back at a networking event this week in Charlotte. Networking is valuable to your career and it can be a tremendous amount of fun as well.
2013-10-17
113 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