Steve Jones wonders about the next generations of IT workers. Can we encourage more people to enter this field? With the supposed shortages of talent today and the poor reputation of IT positions, can we change the trend of fewer people entering IT?
2014-08-15
186 reads
How much would you pay for a laugh? Maybe you'll donate to ensure that some of your SQL Server speakers will embarrass themselves at the PASS Summit.
2014-08-14
247 reads
Can a single piece of software work well for most situations? Steve Jones wonders if we're not attacking the problems of large software applications in the right way.
2014-08-13
159 reads
Replication is a great feature in SQL Server, but it seems brittle. When things go wrong, they break quickly, and often severely. It seems that we have many features like this in SQL Server that are useful and handy, but receive very little attention as versions are released.
2014-08-12
238 reads
Most of us say we care about IT and data security. Our actions speak differently.
2014-08-11
547 reads
More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.
2014-08-11
104 reads
2014-08-08
264 reads
2014-08-06
687 reads
Mistakes happen but how can we minimize them and deal with them whey they do happen?
2014-08-05
217 reads
In opera, tragedy or absurdity happens because the characters are incapable of standing back, and making a difficult decision. Instead, at every stage, they just drift towards their fate by taking the easy option. Don't let the same fate befall you, as a DBA.
2014-08-04
114 reads
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item 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