The Level of Security These Days
How comfortable are you with your password security? Today Steve asks given some data on the various times it takes to crack passwords.
2022-03-25
84 reads
Editorials
2022-03-23
103 reads
Is CosmosDB the One?
CosmosDB is a flexible, powerful database, but is it the best one? Steve has a few thoughts.
2022-03-21
228 reads
SQLBits Report
Last week I attended my first in-person event in over two years. SQLBits, the largest data platform conference in Europe, was a hybrid event and marked the first time many of us met in person in ages. It was a huge success as folks from around the world gathered to learn...and celebrate! I heard several […]
2022-03-19
102 reads
2022-03-18
142 reads
The Chief Data Officer
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
2022-03-16
143 reads
The Challenges of Changing Software Tools
The way different generations use computers could affect how we built software tools.
2022-03-14
130 reads
2022-03-11 (first published: 2017-05-04)
303 reads
The (Former) Complexity of PowerShell
Steve Jones notes that PowerShell seems to becoming an easier to use language for SQL Server professionals.
2022-03-09 (first published: 2017-01-19)
415 reads
Would You Still Love Linux If Windows Was Free?
A guest editorial today looks at the OS debate: Windows v Linux.
2022-03-07 (first published: 2017-02-07)
416 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