Alter Multiple Databases at Once
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2018-07-03 (first published: 2018-06-26)
2,512 reads
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2018-07-03 (first published: 2018-06-26)
2,512 reads
This is my favourite SSMS trick I’ve discovered recently, probably some time towards the end of last year.
Basically, when you...
2018-06-06
1,414 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
424 reads
2018-05-29
9,326 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
2,003 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
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
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
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
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
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers