Slides and Demos for #SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
494 reads
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
494 reads
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols including a rather fun live demo.
The slides and demo...
2015-08-26
5 reads
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
41 reads
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
41 reads
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-21 (first published: 2015-08-17)
1,960 reads
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am doing a publish through visual studio and it doesn't...
2015-08-19
7 reads
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am...
2015-08-19
34 reads
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am...
2015-08-19
43 reads
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on "I am...
2015-08-19
875 reads
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one 2008. The 2012 project referenced the 2008 project as...
2015-08-17
1 reads
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
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...
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