Backup and restore

SQLServerCentral Editorial

Scripting Makes Mistakes Easier Than Ever

  • Editorial

A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.

You rated this post out of 5. Change rating

2022-04-22

181 reads

Blogs

The Cost of Not Having a DBA

By

Does skipping a DBA save money? Wait until your system grinds to a halt,...

Who are you? Building an identity map.

By

I admit that until I read the article, Who are you as a Leader?,...

Call a Fabric REST API from Azure Data Factory

By

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...

Read the latest Blogs

Forums

How to update a history table with changes.

By bswhipp

Good morning to all.  I am a novice when it comes to SQL so...

How to check if credential password for TDE matches the secret key of Key Vault

By Micuen Tabazura

Hi all, In my company we have many databases encrypted with TDE and there...

Create Raw Zone Tables using Generative AI: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Create Raw Zone Tables using...

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers