Keeping Fresh
Today Steve Jones talks about how you might be able to help keep your employees excited and happy with their jobs.
2010-08-03
162 reads
Editorials
Houston, we have a problem
Phil Factor takes a sideways look at Houston, a new tool for building SQL Azure applications, and is somewhat underwhelmed by what he finds.
2010-08-02
219 reads
Snoops
A survey shows the majority of IT administrators have snooped for data on their networks. Steve Jones reminds us to be professionals, each and every day.
2010-08-02
143 reads
2010-07-30
1,150 reads
Feedback for IT
Steve Jones thinks we should be building feedback loops into all our systems. Not just for customer service, but also for bugs.
2010-07-29
123 reads
Prevent Outsourcing
Outsourcing is a fact of life, but with the economic issues worldwide, it has also slowed. That will change eventually and Steve Jones has some thoughts about what you can do to prevent it for your job.
2010-07-28
287 reads
High End or Low End
Steve Jones talks about the need to perhaps get more depth and breadth to the information that we present at events like SQL Saturday to help people learn at all levels.
2010-07-27
163 reads
Software Vendor Security
This week Steve Jones finds some issues with the security of third party vendor software.
2010-07-26
99 reads
Thinking Time
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
2010-07-26
346 reads
ROWE
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
2010-07-23
177 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