Serious Hacking
The biggest government hack ever occurred recently. At least until the next one happens.
2019-03-19 (first published: 2015-10-20)
297 reads
Editorial
On Learning from Experience and Misfortune
Phil Factor on learning from mistakes. Preferably other people's.
2015-10-19
135 reads
Bad Management
Bad managers are everywhere, but we can improve and help them with some ideas from other companies. That's if we, as an organization, value our staff.
2019-03-21 (first published: 2015-10-19)
283 reads
Deploying tech to the cloud
There is a world of difference between technology originating in or designed for the cloud and technology that predates but can run in the cloud.
2015-10-12
124 reads
The Reality of Data Governance
Uncovering how the data 'works' in a business is harder than you might think. You can't get this knowledge second-hand from the IT department. You have to speak to the business at large. However, many people are fearful of the 'bod from IT' and the change that their IT initiatives will bring.
2015-10-12
123 reads
Contract to Hire
Today we have a guest editorial from Andy Warren that looks at the way some companies look to hire new workers.
2015-10-09
192 reads
2019-03-28 (first published: 2015-10-07)
176 reads
2015-10-06
209 reads
What's a Code Smell?
Poor patterns and practices are code smells. Steve Jones notes we have plenty in T-SQL.
2023-03-22 (first published: 2015-10-05)
563 reads
What Can You Do?
Security alerts and concerns are serious, but that doesn't mean that everyone will treat them that way.
2015-10-05
90 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