Learn to Use Books Online
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...
2012-08-06
2,094 reads
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...
2012-08-06
2,094 reads
I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...
2012-07-30 (first published: 2012-07-26)
2,744 reads
This seemed appropriate to cross-post from Goal Keeping DBA given the editorial for today:
One of the first pieces of advice...
2012-07-25
1,092 reads
If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...
2012-07-11
953 reads
In a blog post F-Secure's Chief Research Officer, Mikko Hypponen (blog | twitter), indicated that with the US participating in cyberattacks...
2012-06-11 (first published: 2012-06-05)
2,386 reads
I'm hitting 3 venues in 5 days giving 4 different talks. If you plan on making one of these, I'd...
2012-06-07
1,049 reads
I mentioned in a post over at my Goal Keeping DBA blog that I was not planning to attend the...
2012-05-31
2,108 reads
I took my boys to a game design workshop on Saturday that was sponsored and put on by an organization...
2012-05-14
1,279 reads
SQLRally is a week away (pre-cons start on Tuesday, conference starts on Thursday). I have the privilege of two sessions to...
2012-05-02
845 reads
I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...
2012-04-30 (first published: 2012-04-24)
5,827 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