Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
Learn about expressions and date functions in the Power BI Report Builder.
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.
Steve has a few thoughts on building your own PC to help you with work or your career.
Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.
When you have multiple clients in your application, do you want one or many databases?
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.
Matt Gordon is a Microsoft Data Platform MVP and the Director of Data and Infrastructure at Rev.io. In this short video, he talks us through the 3 key reasons database monitoring tools are essential for him as a Director, and how they help him to lead a team successfully and productively.
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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