Deploy Dacpacs With PowerShell
Final Addendum – use dbatools!
Addendum – There is a repo on GitHub which I wrote and recommend using for build/deployment of DACPACs....
2017-09-26
7,406 reads
Final Addendum – use dbatools!
Addendum – There is a repo on GitHub which I wrote and recommend using for build/deployment of DACPACs....
2017-09-26
7,406 reads
It’s been a long time coming, but now SQL Server Integration Services is in Public Preview on Azure!
I’ve written about...
2017-09-25
390 reads
Hello!
2 posts in 1 day? When you’re hot, you’re hot!
I’m actually writing this one whilst I’m waiting for a BACPAC...
2017-09-22
355 reads
(AKA how I lost a morning)
Hello!
This morning I needed to update my version of SSDT, but before I could do...
2017-09-22
767 reads
I’ve been using TRUNCATE TABLE to clear out some temporary tables in a database. It’s a very simple statement to...
2017-09-04
1,164 reads
Hello!
One month ago I became a dad for the 3rd time. And so my spare time, which has always been...
2017-09-02
133 reads
As a blogger, one thing that I appreciate greatly is examples of technical features. This is mainly because
technical features can...
2017-09-01
188 reads
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
230 reads
Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...
2017-07-12
281 reads
Aloha!
Recently I’ve revisited one of my GitHub projects, TurboLogShip. I’ve been wanted to write a presentation around what it does...
2017-04-23
276 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
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
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