Active August - Are You Onboard?
Thanks to Mike Walsh for really getting this started. Active August is similar to Fit February where folks endeavor to...
2009-07-28
995 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Security Basics: Physical Security
In IT security, we spend so much time trying to protect servers and computers on the wire (or on wireless) that we look at OS patches, firewalls, anti-malware, etc., to protect our systems. We typically assume our physical security is sufficient. But...
2009-07-27
855 reads
Security Basics: Physical Security
In IT security, we spend so much time trying to protect servers and computers on the wire (or on wireless)...
2009-07-21
1,251 reads
File/Folder/Share Permissions for DBAs and Database Developers
Every so often I run into a fellow DBA or database developer who isn't crystal clear on how file/folder and share permissions play together. If you're an MCSE or an experienced system administrator, this should be old hat for you. However, given...
2009-07-21
2,545 reads
Rant: Updating Application Databases the Right Way
Recently, a fellow DBA showed me a set of documentation on a commercially available product. This is a product people pay money for to license and use. It's not an in-house developed application or a community released free sample.
2009-07-17
2,589 reads
File/Folder/Share Permissions for DBAs and Database Developers
Every so often I run into a fellow DBA or database developer who isn't crystal clear on how file/folder and...
2009-07-16
5,990 reads
[Off-Topic] Looking Beyond the Technology
I've been quiet as of late, pretty much ever since i went to Bethany Summer Youth Camp (BSYC) as a...
2009-07-15
742 reads
Rant: Updating Application Databases the Right Way
Recently, a fellow DBA showed me a set of documentation on a commercially available product. This is a product people...
2009-07-15
1,778 reads
Best Thing I Learned at PASS Summit
If you haven't heard, PASS is running a contest where you could win conference registration to this year's PASS Community...
2009-06-19
1,267 reads
Mentors and Perspective
We had my organization's semi-annual combined IT and financial meeting this morning. At the end of these meetings awards and...
2009-06-12
668 reads
Blogs
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...
An LLM Saved My ATtiny85 From Certain Death
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
Forums
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...
Your AI Successes
Comments posted to this topic are about the item Your AI Successes
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