PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,273 reads
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,273 reads
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy...
2014-01-14
263 reads
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2014-01-07
1,577 reads
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. I only...
2014-01-07
11 reads
If you could give a DBA just one piece of advice, what would it be?
I asked 20 successful and experienced...
2013-12-16 (first published: 2013-12-10)
3,318 reads
If you could give a DBA just one piece of advice, what would it be? I asked 20 successful and experienced SQL Server professionals this exact question. You can...
2013-12-10
13 reads
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.
Those rather nice...
2013-10-30
1,358 reads
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit...
2013-10-30
6 reads
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional.
Courtesy...
2013-10-21
608 reads
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional. Courtesy SQL Server Live! I’ve got an outstanding opportunity for...
2013-10-21
6 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...
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
Comments posted to this topic are about the item JSON Has a Cost, which...
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