Using Change Data Capture and CLR to Transfer Data to the Cloud
We were three: A DBA, a developer and a tester.
Our mission: To develop an ongoing process that will transfer one...
2013-07-23
1,519 reads
We were three: A DBA, a developer and a tester.
Our mission: To develop an ongoing process that will transfer one...
2013-07-23
1,519 reads
My friend Boris Hristov (Blog | Twitter) continues his Google Hangouts initiative, and this week he invited me to talk about...
2013-07-19
3,209 reads
Five months ago, I wrote a post about my love for Podcasts.
At some point, I started to think about starting...
2013-07-15
1,071 reads
SQL Server 2014 is coming. Go ahead and download the public CTP.
I’ve just started getting my hands dirty with the...
2013-06-28 (first published: 2013-06-25)
2,859 reads
New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that...
2013-06-26
1,488 reads
I’m 30 today.
In addition, it’s been 10 years since I started working with SQL Server.
In my twenties, I fell in...
2013-06-11
2,058 reads
I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter).
Boris wants to start using the...
2013-05-29
1,261 reads
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and...
2013-05-06 (first published: 2013-04-30)
7,706 reads
I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation...
2013-04-17
882 reads
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...
2013-04-05
1,013 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
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.
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
exec etl.GettheProduct
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