Exporting configuration data from SQL Sentry
SQL Sentry is a pretty cool monitoring system but there's a downside to having so many knobs to turn:
it's next...
2018-11-07
186 reads
SQL Sentry is a pretty cool monitoring system but there's a downside to having so many knobs to turn:
it's next...
2018-11-07
186 reads
Up until now I've been enjoying my first PASS Summit and doing my own light networking.
At breakfast and lunch there's...
2018-11-06
130 reads
Updated 2018-11-04: Expanded test code, renamed the
title of the post so it's clearer.
SMO (SQL Server Management Objects) are the .NET...
2018-11-03
726 reads
SQL Server Management Objects (SMO) are the .NET classes underpinning Management Studio and all good PowerShell that interfaces with SQL...
2018-03-20
45 reads
2018-03-13
233 reads
I've been hearing about round-robin read-only routing ever since SQL 2016 came out but whenever I tried to test if...
2018-03-08
271 reads
It's happened to almost everyone. Someone installs Evaluation Edition and now you need to upgrade
it to a licensed copy using...
2017-11-30
855 reads
PureStorage has a pretty cool post that mentions the importance of formatting SQL Server disks with a 64KB clusters and...
2017-10-18
2,139 reads
My favourite way to compare technical experience with others is to ask them about the ways in which something can...
2017-04-26
159 reads
This problem was first flagged by a daily operational validation test I wrote using everything in my recent webinar to...
2017-03-15
202 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Comments posted to this topic are about the item Initial Config of tempdb
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
Everybody (well almost) knows that if you want to learn the design patterns for...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers