Memory Corruptions, or Why You Need DBCC CHECKDB
DBCC is a mechanism that can protect you against corruptions causing substantial data loss in your database. If you use it.
2014-10-24 (first published: 2012-11-08)
22,091 reads
Paul Randal
- Interests: Doing anything with my wife, Kimberly Tripp: Sailing Scuba diving World travel Hiking Naval history Model building
The Importance of Validating Backups
You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.
2013-12-27 (first published: 2012-09-24)
11,904 reads
My SQL Server Database is Corrupt - Now What?!
How do you recover from corruption if your organization doesn't have a disaster recovery handbook? And how can you prevent the same corruption from recurring?
2013-01-29
8,819 reads
The Perils of Running Database Repair
In a perfect world everyone has the right backups to be able to recover within the downtime and data-loss service level agreements when accidental data loss or corruption occurs. Unfortunately we don’t live in a perfect world and so many people find that they don’t have the backups they need to recover when faced with corruption.
2012-06-25
4,931 reads
Wait statistics, or please tell me where it hurts
How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?
2010-12-16
5,016 reads
2010-06-08
2,925 reads
2010-06-01
3,750 reads
2010-03-10
4,319 reads
2010-03-01
4,159 reads
2010-02-17
3,581 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers