Certifications: What are they good for?
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
618 reads
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
618 reads
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
694 reads
This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam....
2013-09-08
699 reads
This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...
2013-09-01
540 reads
This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables...
2013-08-31
1,208 reads
More than running sp_who2, which gives you more information than the good ol’ sp_who, or querying sys.dm_exec_sessions to check all...
2013-08-24
809 reads
When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to...
2013-08-24
669 reads
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
697 reads
This review topic is still covered under the Optimize and Troubleshoot SQL Server lesson which covers 14% of the exam....
2013-08-13
583 reads
Prior to building and deploying your SSIS project to the SQL SSIS server, you need to build and create a...
2013-08-02
891 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