2009-04-01
1,556 reads
Editorial
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
2009-03-31
151 reads
Are We Wasting Too Much Time Social Networking?
The advent of social networking has excited many DBAs, but is that a good thing? Does social networking help or hurt you in your career?
2009-03-30
173 reads
The Visit of the Recovery Testers.
Phil has a nasty surprise when a team of testers turn up to test an n-tier system
2009-03-30
108 reads
Annoyances
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2020-06-26 (first published: 2009-03-27)
399 reads
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
2013-10-01 (first published: 2009-03-26)
420 reads
It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
2020-06-23 (first published: 2009-03-25)
605 reads
Almost Like a Service Pack
Microsoft recently laid off a number of people and made a mistake that they handled poorly. Steve Jones comments about what could have been done better.
2009-03-24
148 reads
Do DBAs Still Read Technical Books?
Despite my misgivings about the fall from favor of technology books, I was heartened to hear from the developers at Red Gate that the classic books on the art of programming are still important to them. What are the equivalent books for DBAs?
2009-03-23
444 reads
A Better English Query
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
2009-03-23
180 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
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
exec etl.GettheProduct
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