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
215 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
215 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
134 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
736 reads
SQL Server Management Objects (SMO) are the .NET classes underpinning Management Studio and all good PowerShell that interfaces with SQL...
2018-03-20
52 reads
2018-03-13
238 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
283 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
868 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,365 reads
My favourite way to compare technical experience with others is to ask them about the ways in which something can...
2017-04-26
169 reads
This problem was first flagged by a daily operational validation test I wrote using everything in my recent webinar to...
2017-03-15
210 reads
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
When Covid took out the PASS organization, I had someone say to me, “Well,...
Comments posted to this topic are about the item The Table Backup
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Monoliths and Microservices
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers