Strike Force
Would you want to be part of a Strike Force or "A-Team" in IT? Steve Jones thinks most of us would rather just do a good job and go home.
2010-12-28
109 reads
Editorial
The Professional Student
This week Steve Jones talks about the need for people working in technology to be professional students. Get a few ideas of what you can learn this week from Database Weekly.
2010-12-27
171 reads
Resolve to Plan Your Year
Today we have a guest editorial from Andy Warren that asks you to look forward to the next year and think about your future.
2010-12-27
237 reads
2010-12-24
100 reads
Call in the Experts
Today we have an editorial from Feb 1, 2006 that is being reprinted as Steve Jones is on vacation. Steve talks about the need to call in a friend to check on the performance of the SQLServerCentral servers.
2010-12-23
92 reads
Calling Out Bad Advice
Today we have a guest editorial from Tim Mitchell that asks how we should handle bad advice given on the Internet.
2010-12-22
540 reads
64 bit
Today we have a guest editorial from November 26, 2005. Steve Jones talks about the transition to 64 bit architectures.
2010-12-21
173 reads
The Twelve Days of SQL
As we approach the holidays, Steve Jones talks about the latest blog theme, and how nice it is to see these types of things from the community.
2010-12-20
175 reads
The Institute for Backup Trauma
Today we have an editorial reprinted from April 27, 2005. Steve Jones is on vacation, so we are reprinting this look at backup strategies and media.
2010-12-20
224 reads
Under Appreciated Features
This Friday we have a guest editorial from Andy Warren that asks about those features in SQL Serve that you find very useful, but perhaps aren't as well known.
2010-12-17
594 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