Community Circle
Search this blog
Steve’s tweets
- Still a few days: Take a few minutes on this survey and you could win a $500 gift card if you take the state of da… twitter.com/i/web/status/1… 5 hours ago
- Logical Functions - GREATEST now in the cloud: docs.microsoft.com/en-us/sql/t-sq… 5 hours ago
- @anotarian @sqlmal I started with a 79 Pontiac Bonneville. Got good at it, but don't really practice anymore. 5 hours ago
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career
- cell phone
- Cloud Computing
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- tools
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Tag Archives: encryption
Secure Enclave Concerns
We worry about security as data professionals. It’s a constant issue, though it seems that so many of the data breach issues come from simple mistakes. We have lots of automation, configuration as code, and more. These days we should … Continue reading
Backwards Compatible Symmetric Keys in SQL Server 2017+
I discovered recently that there was a change made in SQL Server 2017 to the way that symmetric key passphrases are hashed. There’s a KB article that notes the fix, but basically the passphrases used to be encrypted with SHA1. … Continue reading
Restoring an Expired Certificate–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One common task that you might need to handle if you work with encryption is dealing with a certificate. … Continue reading
Posted in Blog
Tagged Backup/Recovery, disaster recovery, encryption, SQLNewBlogger, syndicated
Comments Off on Restoring an Expired Certificate–#SQLNewBlogger
High Prices for High Security
I was excited to see the new Secure Enclave technology come to Always Encrypted (AE) in SQL Server 2019. I’ve thought that the way Microsoft implemented the AE technology in SQL Server 2016 was a start and a good step … Continue reading
Posted in Editorial
Tagged Always Encrypted, encryption, security
Comments Off on High Prices for High Security