Relational By Default
Should we consider the relational model the default and only after having a good reason look at a NoSQL platform? Steve Jones has a few comments.
2015-11-18
107 reads
Editorial
Private Data
The laws and morals regarding privacy aren't well defined, but Microsoft is making a stand.
2015-11-17
111 reads
Rogue Software Changes
Today Steve Jones wonders if software developers would make changes to software on their own, without direction from management.
2019-10-29 (first published: 2015-11-16)
307 reads
Mind your Database Ps and Qs
Louis Davidson explains why a little database courtesy goes a long way.
2015-11-16
229 reads
2019-11-04 (first published: 2015-11-13)
424 reads
2015-11-12
224 reads
Do You Have Scary Code?
Many organizations have code no one wants to touch. Steve Jones notes that's a bad place to be.
2015-11-10
250 reads
2015-11-09
230 reads
A big thank you
Grant Fritchey shows his softer side, extending his appreciation to all DBAs who work tirelessly to keep our software running in the face of adversity.
2015-11-09
695 reads
The Lost Laptop Crisis
Losing a laptop isn't something most of us would want to deal with, usually because of the expense. However, there may be other implications that concern you. Share your worries with us today.
2015-11-06
121 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