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
193 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
193 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
132 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
731 reads
SQL Server Management Objects (SMO) are the .NET classes underpinning Management Studio and all good PowerShell that interfaces with SQL...
2018-03-20
48 reads
2018-03-13
234 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
273 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
859 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,200 reads
My favourite way to compare technical experience with others is to ask them about the ways in which something can...
2017-04-26
163 reads
This problem was first flagged by a daily operational validation test I wrote using everything in my recent webinar to...
2017-03-15
203 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers