An Awesome Job
Life is awesome, and Steve Jones things everyone can find something awesome in their jobs.
2011-10-05
445 reads
Editorials
How do you learn the advanced stuff?
Today Steve Jones talks about learning those advanced features that you don't get the chance to use in your daily work.
2011-10-04
328 reads
Staying High
Today we have a guest editorial from Tim Mitchell. Tim talks about the need to stay motivated in your career after an event ends.
2011-10-03
108 reads
Closing Out Replies
This editorial was originally published on Oct 17, 2006. It is being republished as Steve is at SQLBits 9 today. Should we change the way we deal with posts and replies? Answer today.
2011-09-30
72 reads
What’s In Your (Junk) Drawers?
Today we have a guest editorial from Andy Warren. Andy talks today about he various items that collect around your work space. Are they useful? should you be cleaning things up? What does this say about you?
2011-09-29
115 reads
Bits Bound
Steve Jones talks about his trip to SQL Bits 9: Query Across the Mersey, which begins today.
2011-09-28
86 reads
Know when to hold 'em
It's time for the SQLServerCentral Party at PASS and Steve Jones talks about the event.
2011-09-27
78 reads
Probabilities and Disaster Recovery
Today Steve Jones talks about the probabilities of different types of disasters occurring in your enterprise. He reminds you that the effort spent on disaster recovery ought to be related to the cost of the disaster, and the risk of it actually occurring.
2011-09-26
215 reads
Where are all the MVBs?
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?
2011-09-26
136 reads
Big Gaps
Today Steve Jones talks about the gaps in our knowledge and our skill sets. He asks which things you think that all data professionals should be learning.
2011-09-23
362 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