2020-09-08
434 reads
Administration
Using Recommendations for MAXDOP and Max Memory During Installation
Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]
2020-09-01
10,343 reads
2020-08-31
610 reads
2020-08-27
595 reads
2020-08-25
435 reads
2020-08-24
599 reads
Admin Challenges Across Scale and Time
The challenges of large scale administration can be complex, but the more we share, the more we help others learn and better manage systems.
2020-08-20
85 reads
2020-08-20
501 reads
2020-08-18
423 reads
2020-08-17
594 reads
Blogs
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers