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
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
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,136 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
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,771 reads
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,593 reads
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,134 reads
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
325 reads
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,127 reads
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)
2,996 reads
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
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers