I've written quite a few posts lately on networking and a very common question is - where's the results? What do I get out of all the effort, and so far my best (if lame) answer is that networking is an investment based on faith that...
2009-04-30
1,511 reads
Learn how to get started integrating mail with your SQL Server in this SQL School video. MVP Andy Warren shows how to set up Database Mail.
2009-04-28
5,243 reads
A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth reading), and I had a comment posted to the blog by author Don Gabor. I like that kind of follow up, so I sent Don a note and a ...
2009-04-28
1,528 reads
I happen to notice this in a class recently that I had the rare student - one that could take notes that seemed to have value to them the next day. If you watch people take notes, I think they fall into one of these categories: The Highlighter. They have...
2009-04-24
1,989 reads
This SQL School video looks at how you add a publication to a replication scenario.
2009-04-23
3,586 reads
SQL School expands its replication series with a look at how you can set up a subscriber with MVP Andy Warren.
2009-04-21
2,602 reads
Time has flown by since my last update, busy time at work and struggling to get that done and find a few hours for PASS too. Here's a short version of what I've been working on lately: Added the Top 10 List page and have some starter lists from...
2009-04-20
1,208 reads
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a few hits for opening up my Linked In network to include those of you who read my blog regularly and want to connect. The essence ...
2009-04-17
1,523 reads
Replication can be a complicated undertaking for many people. Learn how to get started by creating a publisher in this SQL School video from MVP Andy Warren.
2009-04-16
2,600 reads
As I've covered in my two earlier posts I've been investing a little time to figure out how to make LinkedIn work for me. This time I wanted to talk about some extra tools they provide that you may find useful. One that I mentioned previously...
2009-04-13
3,192 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