DBA Scrolls - SQL Stories from the Trenches

Welcome to my blog about SQL Server database administration! As a SQL DBA, I've worked with databases for many years and have learned a lot about best practices, common pitfalls, and new features. On this blog, I'll be sharing my insights, tips, and tricks related to SQL Server administration, performance tuning, data analysis, and more. Whether you're a beginner or an experienced SQL DBA, you'll find valuable information and practical solutions to real-world challenges. Join me on this journey

SQL Server - Securing Your Backup: A Step-by-Step Guide to Database Backup Encryption in SQL Server

By Lince Sebastian May 05, 2023 #backup #encryption
SQL Server - Securing Your Backup: A Step-by-Step Guide to Database Backup Encryption in SQL Server

Securing sensitive data is crucial for protecting the integrity and confidentiality of your SQL Server databases. One important aspect of data security is encrypting database backups to prevent unauthorized access to ba…

Read Tutorial

How to BackUp and Restore a Certificate in SQL Server

By Lince Sebastian April 02, 2023 #encryption #Security
How to BackUp and Restore a Certificate in SQL Server

Certificates are an essential component of SQL Server's security infrastructure. They are used to protect sensitive data, secure connections, backups and authenticate users. In this article, we will explore how to b…

Read Tutorial

Securing Your SQL Server with Transparent Data Encryption (TDE)

By Lince Sebastian April 01, 2023 #encryption #Security
Securing Your SQL Server with Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) is a feature of SQL Server that provides encryption at the database level. TDE encrypts the data and log files of a database so that sensitive information is protected from unauthorized…

Read Tutorial
Older Posts →

Search

Tags / Labels

  • backup (2)
  • Blocking (1)
  • disk (1)
  • encryption (3)
  • HA&DR (1)
  • non labeled (2)
  • performance (11)
  • permissions (4)
  • Powershell (3)
  • qureystore (5)
  • Security (4)
  • SQL users (3)
  • TSQL (11)

Popular Tutorials

  • Powerful Connections: How to Connect to SQL Server Using PowerShell
  • How can I check the failover history of the nodes in Always On availability groups ?
  • How to Find Users and their AD groups in SQL Server - SQL Server DBA

SQL Server Access Audit: A Comprehensive Script - Azure SQL Compatible

byLince Sebastian•October 21, 2024
  • October 2024(1)
  • July 2024(1)
  • June 2024(2)
  • May 2024(1)
  • April 2024(1)
  • November 2023(1)
  • October 2023(3)
  • September 2023(2)
  • August 2023(1)
  • July 2023(4)
  • June 2023(1)
  • May 2023(1)
  • April 2023(6)
  • March 2023(2)
  • February 2023(1)
  • January 2023(1)

Main Tags

  • backup
  • Blocking
  • disk
  • encryption
  • HA&DR
  • non labeled
  • performance
  • permissions
  • Powershell
  • qureystore
  • Security
  • SQL users
  • TSQL

© DBA Scrolls - SQL Stories from the Trenches - SQL Stories from the Trenches. Built with modern Blogger layout.