You Can Telecommute
Today Steve Jones tells you can implement telecommuting at your job and gives you a few ideas how to get it approved.
2011-07-28
236 reads
Editorial
Time for a ROWID?
Steve Jones looks to the future of SQL Server and wonders if we ought to add a rowid to the internal structures.
2011-07-27
231 reads
NewSQL Can Save the World
A new breed of products use the relational model and address the scalability concerns of many RDBMSes. Today Steve Jones talks about NewSQL databases.
2011-07-26
221 reads
Patches for SQL 10 and Techniques for SQL 11
Steve rounds up the patch news for SQL Server this week along with a look forward to the next version of the platform.
2011-07-25
121 reads
Leave Developers Alone
Interruptions are the enemy of productivity for creative people, like software developers. Steve Jones talks today about the need for quiet time.
2015-10-29 (first published: 2011-07-25)
521 reads
The Market
This Friday Steve Jones asks about the market price for your skills. Do you know what it is?
2016-01-22 (first published: 2011-07-22)
334 reads
Be Reasonable
Be reasonable. That's how Steve Jones thinks managers ought to behave towards their employees.
2011-07-21
156 reads
I Want Stupid Employees
Why don't employers want to fund training? Steve Jones has a few thoughts after a great piece that shows the lack of wisdom in withholding training.
2011-07-20
319 reads
Fitting In
Today we have a guest editorial from Andy Warren that talks about fitting in at work and conforming to the expectations of the group and that environment.
2011-07-19
223 reads
Being an extremely productive DBA
In order to gain better support for learning and training opportunities, the DBA needs to prove a direct link to productivity and results, in words and numbers the CEO will understand.
2011-07-18
265 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