added note when creating the xfs drive it won't allow any size above 4k per ubuntu documentation

Thanks I guess this might be more of a Ubuntu forum question but ty for any response -

Based on MS documentation they are allocating the 64k chunk by implementing software...

Thanks for the follow-up.  Yeah it definitely is super cheap did some comparisons today.  Talking hundreds vs thousands of dollars.  I'm assuming it runs on a finite range of IPs...

Any recommendations on any vendors?  I implemented this with townsend security and they caused a few outages and have since been removed as my vendor.  I was debating Azure Key...

Disregard looks like EFS may stop hash editing!

I'm still curious about your results thanks.  Ultimately I think all that does is check a box for compliance cause someone I think can still copy those files from the...

Our PDF storage MicroService actually lives in AWS and the link stored on Aurora now but I see where your concern would be if it wasn't.

I ended up not going this direction because of this and storing not in filestream.  Now we post blob data to S3 instead.

Thanks for the replies - we are a software company and fairly small(500 people).  We all somewhat share each others duties as well at this point - 6 person team...

I just changed my code to invokeSQL 🙁 I'll test it out on my local and get back to you later this week early next.

Thanks very much the Paul Randal led me to a stray process that didn't show up as an active transaction. Issue resolved!

I ended up writing a function in PowerShell to do this. Only caveat currently is if you have multiple Secondary Replicas it doesn't have logic to pick which one....

Yeah I am restoring the TDE cert sorry for not mentioning. Unless I am crazy when migrating from 2008 to 2012 you have to back up the database in...

1) SQL by default will see and use all the CORES and you would be out of compliance.

2) Each workload is different but in simple terms and because of high...

Pending if your connection string level is recent enough that may not be possible and you will need to change RegisterAllProvidersIP to 0.

http://blogs.msdn.com/b/alwaysonpro/archive/2014/06/03/connection-timeouts-in-multi-subnet-availability-group.aspx

This will require DNS changes on...