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
220 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
220 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
135 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
53 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
285 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
870 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,436 reads
My favourite way to compare technical experience with others is to ask them about the ways in which something can...
2017-04-26
171 reads
This problem was first flagged by a daily operational validation test I wrote using everything in my recent webinar to...
2017-03-15
211 reads
By Rohit Garg
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...
By Rohit Garg
🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
We're currently on SQL 2019 and will likely be looking to migrate to a...
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers