Building Bad Software Faster
DevOps doesn't mean just building software faster. Quality matters as well.
2020-11-09
144 reads
Editorials
Automatic Install of Azure Data Studio
Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases […]
2020-11-07
1,220 reads
Going On-Prem?
Is the decision for a new database starting to switch from the default of on-premise to in the cloud? Steve Jones has a few thoughts on when we'll get there.
2020-11-06 (first published: 2016-07-11)
247 reads
The Forever Technology War
The differences in our understanding of technologies can make for some communication challenges.
2020-11-05 (first published: 2016-11-01)
167 reads
Maintaining Data in a Flow
One of the challenges of using scripts is maintaining them and ensuring the adapt over time.
2020-11-04
112 reads
2020-11-03
126 reads
The Separation of Tools
SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.
2020-11-02
513 reads
What is Possible?
There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]
2020-10-31
97 reads
2020-10-30
103 reads
Building Quality In
I heard someone at the 2020 DevOps Enterprise Summit conference say that quality needs to be built in. That's something that many, or hopefully most, of us believe. Everyone ought to do quality work and build it into their daily tasks. However, the person speaking went further and defined this in a way I like: […]
2020-10-29
187 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
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
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
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