Steve’s tweets
- @SQLSoldier do it, they are in source control, right? 2 days ago
- Loading All CSV Files with PowerShell voiceofthedba.com/2017/06/23/loa… https://t.co/8BbCuMSMau 2 days ago
- Nice to see security is a popular developer topic at @denverdevday https://t.co/Chu8Pwm4fC 2 days ago
Speaking at VS Live – Austin
Register with AUSPK14 and save $400
Tags
administration auditing Azure backup Backup/Recovery big data blogging bloopers business Business Intelligence career career cell phone Cloud Computing computers conferences continuous delivery continuous integration data analysis database design databases Database Weekly deployment Dev Connections DevOps disaster recovery DLM encryption Filetable Friday Poll hardware high availability Humor hyper-v life mcm Microsoft misc monitoring networking NoSQL PASS patching Performance powershell presentations Redgate sabbatical security software development software development speaking SQL Bits SQL Connections SQL Intersection SQL in the City SQLNewBlogger SQL Prompt SQL Saturday SQLServer sql server SQLServerCentral syndicated T-SQL T-SQL Tuesday testing TopTenSkills training travel tsqlt vacation version control virtualization windows work
Tag Archives: encryption
New Solutions for Old Problems–T-SQL Tuesday #87
This is an interesting T-SQL Tuesday this month. For #87, we have an invitation from Matt Gordon. The topic is using new tools to solve old problems. The “new” cutoff is SQL Server 2014, so we’d looking at a way … Continue reading
Using a DMK in TDE
When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t exist. This key forms the basis of a chain of protection for your data inside of the SQL Server instance. … Continue reading
Posted in Blog
Tagged encryption, security, sql server, syndicated
What’s a Database Encryption Key (DEK) in TDE
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran across a few people struggling to understand, so I decided to cover the concepts in a series of posts. This … Continue reading
What is a Database Master Key?
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran across a few people struggling to understand, so I decided to cover the concepts in a series of posts. This … Continue reading
Do I have a Database Master Key in a database? #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How can I tell if I have a Database Master Key in a database? It’s actually easy. I query … Continue reading
Posted in Blog
Tagged encryption, security, SQLNewBlogger, syndicated
Checking Permissions for Keys–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got a call from someone wanted to check how permissions were stored for encryption objects. I ran a … Continue reading
Posted in Blog
Tagged encryption, SQLNewBlogger, syndicated
Post TDE–Getting Unencrypted Backups
I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup. This doesn’t seem like that should be an issue, but it can be. A little testing shows how. Let’s assume … Continue reading
Encryption Keys Matter
Perhaps the importance of protecting encryption keys is even greater than we realize. It appears that the NSA and the US Government have been able to read encrypted traffic for some time on the Internet, perhaps for most of the last … Continue reading
Learning All About Always Encrypted at DevConnections
Like the alliteration in the title? I almost removed it, but decided it had a nice ring. Maybe that should be the title of my IT/DevConnections (Oct 10-13, 2016) session other than End to End Always Encrypted in SQL Server … Continue reading
Posted in Blog
Tagged Dev Connections, encryption, speaking, syndicated
Crack that Encrypted Data
Ransomware appears to be gaining some traction as a new trend. For awhile in my career, it was virus programs designed to send to all your contacts. Then it was infections to use your computer as part of a bot … Continue reading
Posted in Editorial
Tagged encryption, security
