Queues in Databases
The idea of using a queue in a database is one that some people try to avoid, preferring to use a messaging service. However, Steve Jones notes that this isn't always necessary.
2016-02-03
189 reads
Editorial
Maybe Security is Harder than Rocket Science
It's hard to build strong security over time, but it's worth the effort. Steve Jones notes that even smart people have problems implementing strong security.
2016-02-02
115 reads
Bogging Down in the Minutia of Minutes
Rodney Landrum gets lost in the fourth dimension, while coding the infinite possible combinations of SQL Server dates and times.
2016-02-01
80 reads
What is the True Version of Code?
What version of your code is the true one? Steve Jones talks some version control today.
2016-02-01
190 reads
Too much information can be counter-productive
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
2019-09-02 (first published: 2016-01-29)
375 reads
Training at the Top
Today Steve Jones looks at security training and the need for understanding from upper management.
2016-01-28
94 reads
DeveloperBall
Steve Jones looks at the challenges of putting a team together of wildly different skill levels.
2016-01-26
118 reads
Crafting Your Resume
Today Steve Jones talks about how you can present yourself better within the confines of a resume.
2016-01-25
188 reads
Design a Better SQL Server Pricing Model
Today we have a guest editorial from Andy Warren that talks about SQL Server the no one's favorite topic: licensing.
2016-01-21
167 reads
Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
424 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