External Article

Using SQL Backup in Development Work

For a development team, SQL Backup provides a simple way to restore development or test databases, if required, while minimizing the tedium of the task of taking, managing, and restoring the backups. We can generate the required backup commands in the GUI and then use them to construct a SQL script that backs up all the required databases. We can even use the backup commands in a beforeMigrate SQL callback, in Flyway, to make sure the current version is safely backed up before we run migration.

SQLServerCentral Article

SQL Server 2022 Build List

This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]

Blogs

Daily Coping 6 Dec 2022

By

Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout

By

I was given 4.5 months notice this past June and was fortunate to find...

InvalidAbfsRestOperationException in Azure Synapse notebook

By

Problem The first issue that developers in my team noticed was when they tried...

Read the latest Blogs

Forums

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Multitenant architecture

By mto89

Hi all, i have to refactor an existing database multi-tenant. All tables should be...

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers