Create AT&T Network Hierarchy Diagrams using SQL Server Data
Diagrammatic support for large, complex hierarchical data structures in SQL Server.
2020-10-09 (first published: 2018-09-04)
3,254 reads
Diagrammatic support for large, complex hierarchical data structures in SQL Server.
2020-10-09 (first published: 2018-09-04)
3,254 reads
A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.
2019-06-14 (first published: 2017-10-19)
4,902 reads
Read about the Restore Genie and the new support for fork points, Azure and Multiple Concurrent Restores.
2016-09-13
1,815 reads
An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.
2016-02-04
3,512 reads
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
2015-06-15
3,676 reads
Restore Gene is a simple 2-script framework, one PowerShell script and one SQL stored procedure, which will speed up the production of restore scripts for manual disaster recovery, as well help automate log shipping.
2014-08-14
10,138 reads
Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
2014-05-22
2,519 reads
Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.
2014-01-07
4,379 reads
Read about Paul Brewer's Framework (Version 2) for Database Restore Automation.
2013-11-04
5,381 reads
A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.
2013-07-01
4,593 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