The Dying Administrator
Is the SAN administrator dying out as a job? Steve Jones comments on an article that suggests it might be.
2010-01-27
189 reads
Editorials
The IT Explosion
So many people are joining the IT industry all the time and Steve Jones talks about the attitudes that they bring with them.
2010-01-26
205 reads
Keeping up with Technology
Phil Factor believes that we have become so immersed in the idea that administrators or accountants can run technical enterprises, unaided, that we are in danger of forgetting the vital creative contribution of the technologist.
2010-01-25
114 reads
We'll go no more a' tibbling
Phil Factor points out the limitations and irritations of Hungarian Notation.
2010-01-25
845 reads
Forgetful Databases
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
2010-01-22
256 reads
How Do You Handle the Stress of Being a DBA?
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
2010-01-21
642 reads
Help Others, Help Yourself
There is something to be said for helping others. However it isn't necessarily a selfless act. Guest writer Tim Mitchell talks a little about how helping others has helped him.
2010-01-20
216 reads
Perfect is the Enemy of Good
Today we have a guest editorial from Andy Warren. We all would love to have perfect code, but is always worth the time? Andy Warren notes that cutting a corner or two might make sense at times.
2010-01-19
152 reads
Moving PASS
The PASS Summit has been held in Seattle for a number of years, but recently people have asked to move it somewhere else. Steve Jones talks a little about the issue.
2010-01-18
91 reads
The End of Support
It can be nerve-wracking for a DBA when support for their server ends. This week support for SQL Server 2005 Service Pack 2 ended and Steve Jones talks about your options.
2010-01-18
425 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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
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