Default Credentials
Using default credentials is a poor practice, but people still continue to forget to change them.
2021-01-18
315 reads
Editorials
Who is my customer?
My final job in my previous career was at a hospital. I worked there for five years in the 90s before getting my first position as a developer. While I didn’t love the career I was leaving, I did appreciate what I learned from that last job. Part of the onboarding included a short class […]
2021-01-16
128 reads
Improving Availability Groups
Availability Groups are a good way to use High Availability in SQL Server, Today Steve wonders if you have any improvements you would make to the technology.
2021-01-15
153 reads
Microsoft Fights Back
Microsoft fights back against hackers after a recent vulnerability in a management framework.
2021-01-14
221 reads
2021-01-13
83 reads
Reassess Your Configuration
It's a good idea for anyone managing systems to periodically check them and see if anything needs to change.
2021-01-12
92 reads
The Responsibility for Bugs
Today Steve wonders who should be responsible for software bugs, something of which we have no shortage of in our industry.
2021-01-11
103 reads
Easy Data Access Plus Security
As I type this, I've got my right leg propped up on a stool. That's because if I sit for any length of time with the knee bent, I have a great deal of pain on standing. Seems there's something horribly wrong with my knee. I still don't know what yet. I've had an MRI […]
2021-01-09
62 reads
Picking a Goal for 2021
If you have set any new goals for your career this year, Steve is asking you to let him know.
2021-01-08
112 reads
The Best Way to Protect Sensitive Data
Steve has a thought on the best way to protect sensitive data.
2021-01-07
139 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