SQL Server Restore to LSN
For this post I want to show you how I recovered to a LSN where I did do this on...
2016-11-24
640 reads
All About SQL
Task Manager is a liar
I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try...
2016-11-21
575 reads
CHECKDB’s Hidden Snapshot
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
463 reads
SQL Server – RECONFIGURE
When you want to change configuration settings for your SQL Server you would either do it via Management studio (under...
2016-11-08
711 reads
Copying your SQL Database
If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...
2016-11-07
402 reads
Always Encrypted Column Encryption
I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...
2016-11-04
725 reads
SQL Server Backup Compression
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
476 reads
SQL Server DMA v2.0 – Migration Time
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
589 reads
SQL Server DMA – Data Migration Assistant V2.0
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
677 reads
SSMS 2016 Bug
I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...
2016-10-27
649 reads
Blogs
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)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
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