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

The file "D:\..StackOverflow2010.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

By Lince Sebastian أبريل 06, 2024 #backup #permissions
The file "D:\..StackOverflow2010.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

While attempting to attach a database on one of my test servers, I encountered an error. Recognizing the potential value in sharing solutions to common database issues, I've decided to document the steps to troubles…

Read Tutorial

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

By Lince Sebastian مايو 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
Older Posts →

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

  • How can I check the failover history of the nodes in Always On availability groups ?
  • Powerful Connections: How to Connect to SQL Server Using PowerShell
  • 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•أكتوبر 21, 2024

بحث هذه المدونة الإلكترونية

  • أكتوبر 2024(1)
  • يوليو 2024(1)
  • يونيو 2024(2)
  • مايو 2024(1)
  • أبريل 2024(1)
  • نوفمبر 2023(1)
  • أكتوبر 2023(3)
  • سبتمبر 2023(2)
  • أغسطس 2023(1)
  • يوليو 2023(4)
  • يونيو 2023(1)
  • مايو 2023(1)
  • أبريل 2023(6)
  • مارس 2023(2)
  • فبراير 2023(1)
  • يناير 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.