The question of encryption seems to be coming up a lot recently. I've had a number of people asking me about how to go about encrypting SQL Server. SQL can encrypt our data at a number of different levels and gives us a quite a few options when doing so. I want to use this... Continue Reading →
Encryption in SQL Server #1 – Column Level Encryption
For one reason or another data security and encryption has been coming up quite a bit in my day to day work recently and I've started to realise that it seems to be one of those things that people aren't all that aware of. As I've been meaning to write a little series on encryption... Continue Reading →
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup files https://www.youtube.com/watch?v=Q0UdX04fHQo&feature=youtu.be
SQL Server Encryption, What’s The Key Hierarchy All About?
I'm sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt our data and like with all encryption techniques, that data is encrypted using keys. In SQL Server we've got a number of different keys, we've got the Service Master Key, Database Master Keys, Symmetric... Continue Reading →
Encrypting SQL Server Database Backups
We all go to great lengths to make sure that our databases are secure (or at least I really hope that we do), we make sure that only authorised users have access and then only to the databases and levels that they need. We're careful that all our passwords conform to crazy complexity rules. We're... Continue Reading →
GroupBy Slides and Demo Script is Now On GitHub
The slides and demo scripts from today's GroupBy session are now available on our GitHub repository https://github.com/SQLUndercover/UndercoverToolbox/tree/master/GroupBy Many thanks again for watching, I really hope that you found it useful 🙂
Secret Codes And SQL Server, Part 2: Pimp Your Encryption Algorithms.
We had a little play around writing our own encryption algorithms and cracking them in Secret Codes And SQL Server, Part 1: Writing Our Own Encryption Algorithm and Cracking it. I thought I'd see if we can go a step further and start having a look at how we could take those basic ideas and try... Continue Reading →
Secret Codes And SQL Server, Part 1: Writing Our Own Encryption Algorithm and Cracking it.
After my last post on The Arcane Science of Bitwise Logic and SQL Server I was asked a couple of questions on where it's used so I thought I'd write a follow up post. At first I was going to write something on bitmaps but then a thought of another area where bitwise logic is... Continue Reading →