Sequence Contains No Elements

Sequence contains no elements

I came across this “Sequence contains no elements” error when using Always Encrypted a while back and wanted to write a quick post. In this case, I was trying to encrypted a computed column. Here’s the underlying error message: The full list of supported columns are found here. I can clearly see ‘Computed columns’ as … Read more

Thoughts on the VividCortex Acquisition

VividCortex and SolarWinds

Last month, SolarWinds completed the purchase of VividCortex, a database performance monitoring solution for popular open source systems such as PostgreSQL, MongoDB, MySQL, Amazon Aurora, and Redis. I was fortunate to visit Austin about a week after the purchase. During my visit I met with members of the VividCortex team. We had deep discussions about … Read more

Using SQL Server Performance Objects

SQL Server performance objects are found inside the Performance Monitor tool, also known as perfmon. If you are using Performance Monitor for gathering resource metrics for SQL Server then you are familiar with a screen such as this one: You can see I have navigated to the SQL Server Plan Cache counter, selected Cache Hit … Read more