Fear Fear
Do you let your fear drive you in how you work with technology? Steve Jones thinks you should be cautious, but not paralyzed.
2013-06-05
136 reads
Editorials
2013-06-04
155 reads
How Do We Learn?
With a huge increase in the number of online learning frameworks, Dave Convery wonders how comfortable people are with this new way of polishing their skills.
2013-06-03
216 reads
Relying on Algorithms
Today Steve Jones looks at the way software affects the world and how we might be worried about how things might change in the future.
2013-06-03
124 reads
The Bicentennial
Tomorrow is the bicentennial SQL Saturday event. SQL Saturday #200 takes place in Philadelphia, and Steve Jones has some thoughts as he travels to the City of Brotherly Love.
2013-05-31
77 reads
The Speed of Azure
There isn't a lot of acceptance of Azure from DBAs. Steve Jones talks about some of the advantages of Azure and thinks that we should be working to ensure that our internal systems respond at the same speed as people can get from Azure.
2013-05-30
173 reads
Data Will Drive the World
Data and software will impact our lives more and more in the future. Steve Jones talks about some of the potential ways in which both of these have changed the world.
2013-05-28
159 reads
2013-05-27
49 reads
Trusting Systems
The trust we build by ensuring our computer systems work is important. If we can't maintain that trust, Steve Jones sees a problem for our careers.
2013-05-23
102 reads
Understanding HA
Dealing with disaster situations or trying to maintain an HA environment can be stressful. However knowledge about your goals and the capabilities of each technology, along with practice, can make things much easier.
2013-05-22
231 reads
Blogs
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.
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...
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