What's holding you back?
If you’re not where you want to be in your career, then what do you think is holding you back?
2011-06-13
206 reads
Editorial
The Desire for Control
This Friday Steve Jones asks you if you want more knobs for SQL Server or less? It's a debate that balances the need for the DBA to know more with the resources Microsoft spends to build better tuning into the product.
2011-06-10
94 reads
SQL Safety Nets
Today we have a guest editorial from Andy Warren. Andy talks about the things that help us out when we forget to handle some aspect of server administration. These safety nets can be handy, but should they be there? Should we have more of them? Join the discussion.
2015-11-05 (first published: 2011-06-09)
253 reads
Why Can't We Code?
Today Steve Jones talks about the ways in which we interview new developers. Are they working or do we need a new way? Should we be considering those people that have actually accomplished something?
2015-07-07 (first published: 2011-06-08)
549 reads
Economics
Today we have an editorial from Mar 22, 2006 as Steve is on vacation. Today Steve Jones notes that economics might determine how you are paid, but human nature describes how you behave.
2011-06-07
113 reads
Lessons Learned Pay Off
This week Steve Jones looks at a few notes that show employers are wising up overall about certifications and the value of real world skills.
2011-06-06
152 reads
Ethics
Today we have an editorial reprinted from April 3, 2006 as Steve is on vacation. Ethics are often just as bad at the top of our companies as they are at the bottom. Steve Jones comments today on how this affects IT.
2011-06-06
108 reads
A Live Node
Today we have an editorial from March 29, 006 as Steve is on vacation. Today Steve talks about the problems of constantly being distracted and not focusing on one thing.
2011-06-03
98 reads
A Note to My Fellow Application Developers about Knowing Our Limits
Today we have a guest editorial from Chris O’Connor as Steve is on vacation. Today Chris talks about the responsibilities of application developers in safeguarding the data when there is no DBA.
2011-06-02
182 reads
The Care of Data
Security is a big concern with data, especially when there is another company involved. Steve Jones notes today that cloud vendors need to beef up their work in this area.
2011-06-01
502 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