Despite the fact DBAs are essentially protectors of an organization’s knowledge, and privy to much confidential information, there is no clearly defined set of rules and standards to help govern and guide their ethical behavior. Brad McGehee thinks it's time for some action on this issue.
2009-02-05
438 reads
The furore surrounding the recent release of MySQL 5.1 makes Tony Davis wonder if more than a few web 2.0 developers might be peering over the SQL Server Express fence and wondering if the grass doesn't look slightly greener over here.
2009-02-04
195 reads
In which Phil Factor's attention wanders whilst reading some software product announcements and imagines what would have happened if the current IT Bloggers had been in charge of the White Star Line at the time of RMS Titanic.
2009-02-03
129 reads
In which Phil Factor responds to the muse and writes a poem in the style of a School Song, in which he tries to give a mention to all the top writers and forum-posters.
2009-02-02
83 reads
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
2009-01-30
91 reads
Steve Jones reminisces a bit and comments on reaching one million members in the community.
2009-01-29
84 reads
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
2009-01-28
374 reads
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-27
148 reads
How does a DBA go about "pitching" for money for a software tool, or any other resource? And what factors affect the likelihood of success? We all think we know, but could we do this part of the job more effectively?
2009-01-26
89 reads
Would you want to have your pay docked for time spent rebooting? It seems some companies are trying to do just that.
2009-01-26
244 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
Comments posted to this topic are about the item JSON Has a Cost, which...
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