@michael-2 , No its not backing the Primary Up...It ignores it (Though I unchecked the option 'Ignore Databases that are  Not Online')..I get the warming you mentioned above ,...

I think the first step would be to understand how most ransomware infects a system.

I'm not sure I've seen a documented case where the entry point for ransomware was a...

they are definitely INTs...

the field only has two values 5 and NULL/empty

The example I gave (,-0.0143,3965.54,3986.34,0,,,,,) are for the record.  the problem areas are the ,, ones.  Excel shows...

These are not integers

-0.0143

3965.54

If you convert these to integers, you will get 0...

Are you saying that the maintenance plan is excluding databases that are part of an availability group, or it's not backing up the databases on the secondary?

I have not used...

An identity will increment when an attempt to insert occurs.  If the insert fails, the identity will still increment.

When SQL is restarted, identities increment by 1000. So, if the last...

How do you want to filter the data?

Can you explain that?

If you have a group by,...

why?? it is such a "wonderful" tool.. and so so easy to deploy and work...

Oh, and have I mentioned how much I am starting to hate Power BI?

Here is what you are looking for

https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

I think parameterized dynamic SQL is going to be you best bet.

Here are a few links

https://sqlinthewild.co.za/index.php/2018/03/13/revisiting-catch-all-queries/

https://www.sqlshack.com/dynamic-sql-in-sql-server/

I've, personally, found that most are happy to accommodate if you reach out. I find more that people aren't willing to try asking,...

A primary key is really just a unique index (clustered or not, depending on how it was created). Microsoft has wrapped it w/ some logic that syntactically implements it...

• This reply was modified 3 years, 10 months ago by Michael L John.

How about this approach?

Parse out the columns that do not contain an embedded delimiter.

Use the REPLACE function to strip out the parsed columns.

What's left, in this example, is the CCC...

It's probably not necessary. It offends our sense of consistency and aesthetics, but the clustered index serves the same purpose. Most SQL Server limitations involving primary key will work...