In this 5-minute video, Doug tells a story about a DBA whose SQL Server got fed up with being misconfigured and decided to do something about it. Topics include CPU settings like MAXDOP and Cost Threshold for Parallelism, memory and disk configuration.
The Day the SQL Server Quit [Video]
When I’m not shooting videos in stunning 70mm Panavision (TM) for Brent Ozar Unlimited, I’m out running or having lightsaber duels with my two marvelous children. You may also spot me in my natural habitat: SQL Server User Group meetings, SQL Saturdays, or the PASS Summit.
Memory and IO in Tempdb: SQL 2014 and SQL 2012 SP1 CU10 Improvement
Tiering kCura Relativity Databases (Or Any SaaS Product)