Ars Technica

SQL server bulk copy - can you make it ignore duplicates copying into table?

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So as ...
Infosecurity-magazine.com

How to Backup and Restore Database in SQL Server

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...
Ars Technica

SQL server/database backup solution via Veeam and Backupexec?

We currently have a SQL 2008 server running as a VM. We backup nightly using Veeam and my consultant also advise we backup on top of that via BackupExec. Lately, our Backupexec jobs have been running ...
Visual Studio Magazine

New for Devs in SQL Server 2022: Ledger for Blockchain-Backed Security

The new ledger feature in SQL Server 2022 provides blockchain-based security to ensure data isn't tampered with. The ability to cryptographically guarantee the integrity of data is especially useful ...