software development

External Article

Five database DevOps practices for boosting team productivity

  • Article

Speed of delivery and protecting data can often feel incompatible, but there are industry-proven database DevOps practices that bring them together in harmony.

Across each of these five key practices, there’s a theme of removing barriers and cognitive load for teams; but crucially, they are also putting safeguards in place to reduce the risks to production environments.

2023-11-06

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

81 reads

External Article

Working around schema drift in SQL Server

  • Article

At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across a large number of sites. Let’s say, pulling or removing information from the Users table, and related tables, across all of our databases.

2023-09-01

SQLServerCentral Editorial

We're Not Faster with AI

  • Editorial

At Redgate Software, we've been trialing Copilot from GitHub with our developers. I managed to get access for this experiment and have tried a few things, though I'm not sure I've found it very useful. I'll continue to work with Copilot, but for now, I just don't find Copilot AI helping me with the types […]

5 (1)

You rated this post out of 5. Change rating

2023-07-31

196 reads

Blogs

SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

By

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...

T-SQL Tuesday #186–Agent Jobs

By

It’s that time of the month again, when the T-SQL Tuesday blog party takes...

T-SQL Tuesday #186 - Agent Job History Visualization

By

I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....

Read the latest Blogs

Forums

How to ask questions and find effective support on SQL Server Central?

By trulycouncil

I am researching and learning about query optimization in SQL Server to improve system...

Execution Plan Operators

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Execution Plan Operators

Merge spans with Dates Logic

By dhanekulakalyan

--for a given member if the startdate and endate is continous we need to...

Visit the forum

Question of the Day

Execution Plan Operators

When looking at an execution plan in SSMS, what types of operators are shown?

See possible answers