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
424 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
2,003 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
472 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...
2018-05-02 (first published: 2018-04-24)
2,960 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...
2018-04-26 (first published: 2018-04-17)
6,148 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,152 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
338 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,145 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...
2018-04-04 (first published: 2018-03-28)
3,394 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
324 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers