Microservices for Databases
The idea of using microservices is gaining traction, but Steve Jones notes that the issues of databases might prevent adoption for many applications.
2018-12-10 (first published: 2015-04-02)
263 reads
Editorial
2015-04-01
312 reads
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
151 reads
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
2015-03-30
103 reads
Software Engineering in Practice
Is there a need for apprenticeships in the data world? Should we consciously seek to view our first year as an apprenticeship? Should companies provide learning paths for new hires?
2018-10-31 (first published: 2015-03-30)
178 reads
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
2019-06-17 (first published: 2015-03-27)
1,253 reads
Mastery – Repetition, Variations, and Depth
Today we have a guest editorial from Andy Warren. Andy look sat the ways in which we might solve problems and become better over time.
2019-05-31 (first published: 2015-03-25)
290 reads
Microservices, SOA and Service Broker
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
2015-03-23
456 reads
First Episodes
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
2015-03-23
121 reads
Common Mistakes
This week Steve Jones is wondering what the common mistakes that T-SQL developers make are.
2018-06-22 (first published: 2015-03-20)
531 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