Deployment Process

SQLServerCentral Editorial

You Always Have a Software Pipeline

  • Editorial

If you build software for customers, you have a pipeline. It might not be good, but you have one. Steve recommends you work to make sure this is a repeatable, reliable pipeline.

5 (1)

You rated this post out of 5. Change rating

2023-10-13

80 reads

External Article

How do you develop and deploy your database?

  • Article

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.

2015-02-26 (first published: )

17,327 reads

SQLServerCentral Article

Fast Project Rollbacks

  • Article

When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.

4.38 (32)

You rated this post out of 5. Change rating

2008-10-22

3,961 reads

Blogs

My 2024 in Data: Speaking

By

This is my last week of the year working (I guess I come back...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

My 2024 in Data: Travels

By

This is my last week of the year working (I guess I come back...

Read the latest Blogs

Forums

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Big Data or Small Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Big Data or Small Data

Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake

By Sucharita Das

Comments posted to this topic are about the item Level 4 of the Stairway...

Visit the forum

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