A Little Variety
Do we really need to corner the market for our particular business? Steve Jones talks about the need to grow your business at the expense of others.
2008-01-10
49 reads
Editorials
The Backup Myth
Running backups is enough for disaster recovery, right? That's a myth that could get you into trouble. Steve Jones explains there's more that's needed.
2008-01-09
938 reads
Losing Your Job
It's not easy to lose your job, but it can be done if you aren't performing. What concerns Steve Jones is someone recently lost their job for their behavior on their own personal time.
2008-01-08
298 reads
Myths
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
2008-01-07
696 reads
College Life
Life at college is good. It's a time in many people's lives that they'll never forget. Steve Jones asks if you'd want to go back to your adult roots.
2008-01-04
196 reads
Corporate Programming Sucks
Does it suck to be a corporate programmer? Joel Spolsky things so, but Steve Jones takes issue with it.
2008-01-03
355 reads
The Job Outlook for 2008
What will happen in the job market for DBAs this year? Steve Jones gives a few opinions based on what is happening in the industry.
2008-01-02
437 reads
Building a Better Career
It's important that you manage your career and not just leave it to chance. Steve Jones talks about what you might do to ensure that you'll be successful in the IT world.
2007-12-31
581 reads
2007-12-28
102 reads
Not So Anonymous
How anonymous are your ratings and other opinions on the Internet? Not as much as you might think.
2007-12-27
202 reads
Blogs
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.
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...
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