Last week was Professional Development Week at SQL University. Steve Jones talks about the importance of having a professional development plan and the types of things that you could learn this week.
2011-02-28
209 reads
Today we have a guest editorial from Andy Warren. There are changes in the Microsoft Certified Master of SQL Server program and many people are considering trying to earn this certification. Today Andy Warren asks if you want to go down that path.
2011-02-28
341 reads
Interviews can be strange for many reasons, often because interviewers are not well prepared to evaluate candidates. This Friday Steve Jones asks you what weird things you might have encountered in an interview when someone is asking you questions.
2011-02-25
613 reads
What motivates people? What makes them happy at their jobs? Steve Jones talks about Drive, the book by Dan Pink, and the possibility that people actually like doing their jobs and are willing to work.
2011-02-24
211 reads
Did you know that commuting can actually affect your health? Steve Jones talks about an IBM study on this and suggests you talk to your boss about telecommuting or remote work. The option to do so just might be beneficial for your long term health.
2011-02-23
230 reads
How do you decide what to archive? Steve Jones says that you need to come up with a method as our data sizes grow larger and larger all the time.
2011-02-22
282 reads
Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server
2011-02-21
486 reads
Today we have an editorial reprinted from Jan 3, 2006 as Steve is on vacation. What's the quality of your code? Do you measure it? And does it matter?
2011-02-21
271 reads
2011-02-18
143 reads
Today we launch a new series of content aimed at providing basic knowledge to people new to a section of SQL Server. Steve Jones comments on the way this series came about.
2011-02-17
698 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...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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