2018-05-29
8,523 reads
Matthew McGiffen
- Twitter: @MattMcGiffen
- Website: https://matthewmcgiffen.com/
Thoughts on Query Performance with TDE enabled
Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance overhead of 2-4%. That doesn’t sound like very...
2018-05-23
1,217 reads
Hitting my first big blogging milestone – 100k Reads
After blogging about SQL Server for just over a year, at some in the last month I went over 100,000...
2018-05-16
461 reads
T-SQL Tuesday #101 – Some Great SQL Server Tools
This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
I’d...
2018-04-10
1,136 reads
T-SQL Tuesday #101. CMS – Effortlessly run queries against multiple SQL Servers at once
This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
The...
2018-04-10
328 reads
TDE – Regenerating the Database Encryption Key
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,128 reads
Crystal Balls
In the centenary edition of the monthly blogging party that is T-SQL Tuesday, Adam Machanic asks us to look forward...
2018-03-13
312 reads
Recovering a TDE protected database without the Certificate
If you’ve been careful and done everything right when you’re setting up TDE then you shouldn’t run into this problem.
We...
2018-02-21
2,957 reads
Migrating or Recovering a TDE protected Database
When encrypting a database with Transparent Data Encryption(TDE), a vital consideration is to make sure we are prepared for the...
2018-02-14
508 reads
Encrypting an existing database with TDE
As mentioned previously, the process of setting up TDE (Setting up Transparent Data Encryption (TDE)) is the same whether you’ve...
2018-01-26
1,153 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...