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,523 reads
Matthew McGiffen
- Twitter: @MattMcGiffen
- Website: https://matthewmcgiffen.com/
Cycle Through Your Clipboard History In SSMS
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,427 reads
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
451 reads
2018-05-29
9,592 reads
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,115 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
476 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,980 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,190 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,160 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
349 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers