The Importance of ORDER BY
Everyone, at the beginning of their SQL career, get’s told that it is important to include an ORDER BY if...
2018-05-30
418 reads
Matthew McGiffen DBA
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,214 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
Database Files Down The Wrong Path
I manage a few servers used to host SQL Instances for development and test purposes. Each of those instances hosts...
2019-04-26 (first published: 2018-04-24)
2,827 reads
RDS encryption vs TDE
If you’re starting to use cloud services, the number of options available can be confusing. Particularly when they may seem...
2019-04-26 (first published: 2018-04-17)
5,795 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
Rotating TDE Certificates without re-encrypting data
I talked previously about why we have each of the layers in the encryption hierarchy used to support TDE (Transparent...
2019-04-26 (first published: 2018-03-28)
3,037 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
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)...