Labor Day Bloopers
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
2008-09-01
435 reads
Editorials
One Milly-yon IOPS - Database Weekly (Sept 1, 2008)
IBM is testing a new hardware disk array that vastly outperforms any current arrays. What does this mean for the database world?
2008-09-01
242 reads
Un-Wired
This Friday's poll looks at vacation and how you prepare to be unwired. Steve Jones talks about some of the things you can do.
2008-08-29
74 reads
The August 2008 Energy Update
This bi-monthly update on energy news covers quite a bit of wind-related power generation happening around the world.
2008-08-28
93 reads
The Million Message System
Sun Microsystems built a database application that processes a million messages a second. Steve Jones talks about the achievement.
2008-08-27
161 reads
Working Under Pressure
A time of crisis means a lot of things to people in technology, but Steve Jones talks about something that's often forgotten.
2008-08-26
183 reads
Believe in Your Data - Database Weekly (Aug 25, 2008)
As DBAs we must secure and protect data, but what can we do when there are fundamental issues with the way the systems are designed. Steve Jones comments on problems with voting machines.
2008-08-25
64 reads
If You Ain't Cheatin'
Gaining recognition or an award without earning it is something Steve Jones thinks is a problem in society in general, and it's filtered into the IT industry.
2008-08-25
226 reads
Managing Security
This Friday Steve Jones comments on the practice of using Active Directory to help manage your SQL Server and what the best practice should be.
2008-08-22
318 reads
The Brainstorm Zone
There are times we all struggle finding solutions to the issues at work. Steve Jones talks about how to make that breakthrough in solving problems when you are stuck.
2008-08-21
176 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