SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
767 reads
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
767 reads
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
1,394 reads
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
608 reads
SQL Server Export to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some...
2014-02-28 (first published: 2014-02-24)
5,036 reads
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-27
2,022 reads
I’ve created a script which gives details of Disk, Memory and Process and its represented graphically.
Here, the scripts are enclosed in...
2014-02-20
1,713 reads
This Powershell GUI tool is used to list Top 10 memory consumption process of a given computer[local /Remote]. In the...
2014-02-07
949 reads
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-04
2,052 reads
This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter...
2014-01-31 (first published: 2014-01-27)
2,657 reads
This Powershell script list all the installed application on both 32 and 64 bit applications, particularly useful for people managing...
2014-01-20
1,050 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Comments posted to this topic are about the item Step by step guide to...
Comments posted to this topic are about the item Backing up the Database Encryption...
Comments posted to this topic are about the item Technology Fears
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