100 Years Ago, What Would You Be?
Today we have a guest editorial from Andy Warren asking what you might have done if you lived in the past.
2010-10-29
238 reads
Editorial
The Growth of Professional Development
Steve Jones talks about the more formal effort that it seems many people are placing to grow their careers.
2010-10-28
430 reads
The Hybrid
Steve Jones talks about SQL Server Connections, the conference that might be the place to be for hybrid IT workers.
2010-10-27
122 reads
Remote Security
As more and more people look to work away from inside traditional networks, security becomes an issue. As a data professional, Steve Jones reminds you to be sure that your data is protected.
2010-10-25
110 reads
SQL Slammer
It's been seven years since SQL Slammer, the worst SQL Server security worm struck. Steve Jones remembers that time.
2010-10-25
178 reads
Efficiency
This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you getting more efficient?
2015-03-26 (first published: 2010-10-22)
311 reads
Cheap Fun
Today we have a guest editorial from Andy Warren that talks about ways to enjoy life without spending a lot of money. Some of these might even be great team building ideas.
2010-10-21
182 reads
Plan for Capacity
It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.
2010-10-20
363 reads
Living Moore's Law
eBay has quite a new data center in Utah, replacing all their hardware on a two year cycle. Steve Jones thinks that would be a challenge, and an exciting one at that.
2010-10-19
128 reads
When Times are Tough, Do You Rise to the Occasion?
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
2010-10-18
257 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