One or Many Databases
When you have multiple clients in your application, do you want one or many databases?
2022-06-08
400 reads
Editorials
Are Cubes Dead?
Is the idea of an Analysis Services cube something that is no longer relevant for modern data analysis? Steve thinks it might be.
2022-06-06
1,037 reads
The Nightmare Letter
The GDPR may bring nightmare letters like the one linked to from the editorial.
2022-06-03 (first published: 2018-03-28)
262 reads
Production Subsets
Working with data in development or test environments can be challenging. This week Steve Jones asks how you might deal with the volume of data and whether you like subsets.
2022-06-01 (first published: 2014-08-22)
258 reads
Audit systems: a good idea or a mess to maintain?
Audit systems can be a good idea, but they can also be a mess to maintain.
2022-05-30 (first published: 2018-02-27)
305 reads
2022-05-28
208 reads
2022-05-27 (first published: 2018-02-08)
241 reads
It's Not Yours
We may talk about our databases, but hopefully most of us know we don't own the data.
2022-05-25 (first published: 2018-01-17)
233 reads
It's the Engineers
The staff that build your systems are more important than your choice of technology.
2022-05-23 (first published: 2018-01-08)
244 reads
Moving on but not far
During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]
2022-05-21
102 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