2017-08-21
810 reads
SQLCMD
2017-08-14
938 reads
2017-08-08
835 reads
2016-11-09
1,111 reads
SQLCMD to export data in txt file
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
20,916 reads
SQLCMD and Batch File magic
Execute scripts in a folder with a single click using SQLCMD and a batch file.
2017-07-28 (first published: 2015-11-19)
22,382 reads
2015-10-27
1,487 reads
Mail Fails with SQLCMD Error
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
2015-03-19
9,269 reads
2013-11-05
2,156 reads
An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)
Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.
2015-10-16 (first published: 2013-05-06)
21,600 reads
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Forums
Step by step guide to setup PostgreSQL on Docker
Comments posted to this topic are about the item Step by step guide to...
Backing up the Database Encryption Key
Comments posted to this topic are about the item Backing up the Database Encryption...
Technology Fears
Comments posted to this topic are about the item Technology Fears
Question of the Day
Backing up the Database Encryption Key
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers