Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
117 reads
Ed Elliott's Sql Developer Blog
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
81 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
208 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the dacpac and database has been deployed. The process looks...
2015-07-20
2 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
509 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
29 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
35 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a...
2015-07-17
1 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
1,328 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
34 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
Forums
Windows could not start the SQL server (SQLEXPRESS) service (macOS)
I have a common problem that I just cannot figure out after scrolling through...
Adventureworks data does not load
Hello, I am a new member here so forgive me if I am not...
Restore Procedure not working
I created a small procedure that reads the backup file and restores the DB...
Question of the Day
Function Defaults
I have created this function in SQL Server 2022:
CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
RETURN @one + @two
END
How can I call this and invoke the default value for @two? See possible answers