Running SSMS 2016 in Read Uncommitted Mode
Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received...
2017-01-25
6 reads
Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received...
2017-01-25
6 reads
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does...
2017-01-18
6 reads
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does...
2017-01-18
2 reads
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re...
2017-01-18
523 reads
Learn how easy the new SQLServer module makes backups of SQL Server databases.
2017-01-12
35,440 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
5 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I...
2017-01-10
435 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
7 reads
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...
2017-01-06
537 reads
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...
2017-01-06
9 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