In Case of Breach
Do you know what to do in case of a data breach? Steve Jones talks about the importance of having a "runbook" for security that covers the same types of things you might need to know for disaster recovery.
2011-01-05
149 reads
Editorials
Welcome to 2011
After the holidays, Steve Jones welcomes everyone in the SQLServerCentral community to the new year and talks about goals and your career.
2011-01-04
174 reads
Being Careful with Power
It's good to be careful with your power consumption, especially as the power cost of computing continues to grow. However with your SQL Server, you don't want to be too careful, as Steve Jones notes.
2011-01-03
295 reads
Clouds Are In our Future
Today we have a guest editorial from Andy Warren looking at the future of cloud computing and SQL Server.
2011-01-03
184 reads
Enjoying the New Year
For the last Friday poll of the year, Steve Jones has a fun one. Add your input and give everyone an idea of how to spend the last part of this holiday season.
2010-12-31
63 reads
The Year of the Community
Steve Jones looks back at 2010 and dubs it the year of the community. Join him for a look back at some events in the SQL Server world from 2010.
2010-12-30
90 reads
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
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
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
2010-12-24
100 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