I know this was posted 9 year ago but I had same thing happen to me with BLOB fields from DB2 to SQL Server 2016 and this article came up. ...

You pretty much hit the nail on the head with this list.  These were all issues.

Subscriptions not expiring
Cleanup jobs not running or not running often enough
Retention...

WHAT????

I did not know MS was shutting down CodePlex, that is horrible.  CodePlex is one of the best sites on the net in my opinion.

Looking...

Yes, you are correct but I wrote it this way to make it more understandable and easy to read.  The way I have it may be a bit less efficient...

Here is where I found my list of common passwords.  
          https://github.com/danielmiessler/SecLists/tree/master/Passwords
Most security sites will post lists of most common passwords as well.

While I agree with you in general, in my case the Scalar UDF was the issue.  It was a simple convert INT to DATE (20170101 to 01/01/2017) in the select...

Great catches!  Thank you!

I have been reading about DEVOPS now for a bit and I have to say, it sounds like the synergy concept from the 90's or 2000's.  It sounds a...

This script is meant to be run on the distributor in the distributor database as mentioned above.

I am using the sp_MSforeachDB stored procedure which takes a query as a...

WOW!

That is exactly what I was looking for!!

Thank you so much!!!

Jim

For the below, you would have to do this on each server in you AlwaysOn group.

You can create a DDL trigger to catch and alert you on CREATE_USER and DROP_USER...

All the drives that the files are on are supposed to be spread out across the SAN and are all SSDs.

Jim

The files are pre-sized correctly, with autogrow on. I understand the advantages of the multiple data files but I have always seen the files assigned to different filegroups. ...

I have been thinking about this for a while and would love to hear where you are at with it. My idea is to create a process that goes...

AWESOME!!! thank you so much!

Jim