Live Monitoring
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
2010-11-11
350 reads
Editorial
Automated Driving
Could we ever have computers automating our cars and handling the driving for us? Steve Jones doesn't think so, despite some ongoing projects.
2010-11-10
118 reads
Code of Conduct for Software Maintenance
A number of companies came together to develop a code of conduct recently for software vendors. Steve Jones thinks this is a good idea.
2010-11-09
218 reads
Should You Write Down Your Passwords?
Today we have an older editorial by Steve Jones being republished. This piece talks about security and why it might be a good idea to write down those passwords.
2010-11-08
276 reads
Enterprise Management
This Friday Steve Jones asks the question about how you manage large numbers of SQL Server instances.
2010-11-05
215 reads
One Time Passwords
Facebook has implemented a new security feature that Steve Jones thinks might work well for SQL Server as well.
2010-11-04
266 reads
Swarms
Steve Jones talks about the workplace of the future, and a prediction from the Gartner Group that it will include swarms.
2010-11-03
143 reads
Life Without a Net
Today we have a guest editorial from Rodney Landrum that talks about life in the past, when we couldn't look up everything on the Internet.
2010-11-02
220 reads
Can I really drop that index?
You believe that an index is unused and so could be removed, and yet, your finger hovers nervously over the metaphorical "delete" button. You can't quite bring yourself to do it. Is it really safe to drop this index? Tony wonders if "invisible indexes" might solve this dilemma.
2010-11-01
389 reads
Happy Halloween 2010
Steve Jones has a day off before SQL Server Connections and brings us a blooper reel for Halloween.
2010-11-01
103 reads
Blogs
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Using Prompt AI to Help Setup Data Analysis
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Forums
Simplifying WHERE Condition with LIKE test on multiple columns
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Which Table I
Comments posted to this topic are about the item Which Table I
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
Comments posted to this topic are about the item Using Python notebooks to save...
Question of the Day
Which Table I
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
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