Do We Need to Learn Linux?
An announcement on Windows containers has Steve noting that Linux might be a more desired skill in the future for SQL Server professionals.
2021-07-10
203 reads
Career Growth
Learning Intentionally with a List
We're coming up on the middle of the year, and I wonder if you are improving your career this year? Did you make plans and are you sticking to them? I've been tracking progress on my goals, and so far mediocre progress. It's tough to learn, but even tougher to learn when you don't have […]
2021-07-02
139 reads
Evaluting a DBA
Steve has a few thoughts on hiring and the way in which you might want to evaluate a DBA candidate.
2021-06-18
346 reads
Living Life
It's a holiday weekend in the US this weekend. As such, many of you will be taking a break from work and enjoying time with family, as well as remembering some history in the US. If you're in the rest of the world, hopefully you have a holiday coming up soon you can enjoy. One […]
2021-05-29
69 reads
2021-05-28
156 reads
2021-05-22
141 reads
2021-05-14
242 reads
Getting Started Remotely
Today Steve wonders what advice you might give someone starting out their career in technology.
2021-05-07
102 reads
Documentation. The Under Recognised Skill
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
426 reads
When Do We Ask for Help?
When do we ask for help? It's a tough balance to strike between asking too soon or waiting too long.
2021-03-26
122 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