Is this the type of thing you're looking for?

https://discuss.elastic.co/t/continuous-data-from-sql-server-into-logstash/159929

LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.

Now my FIL, I'm not...

Shifting gears a bit, today's editorial on Routine has a broken discussion link.  The editorial is all about the changes people are having to make because of recent world...

Not sure if you like cooking, but it's something that's...

Good catch. Added the quotes to the SELECT.

That example doesn't need quotes for the connect.  However, in selecting a value, it needs to be valid. In this case, the original...

When we had our cyber attack back in June 2017, everything was offline and it was reported internally that it was costing the business $50m p/h. We were offline...

Going up or down? I wonder these days. For the supermarket,...

I think that query from scdecade might not work with multiple of the same. If I add two rows of  (5,4), I get a return.

This requirement (

"there should only be...

There are quite a few people losing data because they've put up an open data source on the Internet. No hacking, not really, just someone stumbling across data. Customers have...

Compression is separate from partitioning. You can create a PK and have that index be compressed. If I read this correctly, you're asking if the nonclustered index will be compressed...

You want all alerttype=[4,6] records or the first or last one? That's not a very good requirement statement.

Be careful of having exact numbers in the ROWS clause if your data isn't clean. You can partition by some datepart(hour), but be aware this might not run quickly. If...

Look at ConCat(), but what Scott did was escape out the single quotes with extras. That's a common technique for adding them to strings.

Error. No one put in the URL.

It's here: https://www.red-gate.com/hub/product-learning/sql-compare/build-and-fill-a-sql-server-database-using-sql-compare-cli-and-a-batch-script?topic=database-builds

Good catch on CDC. I've altered the question to remove this.