I recently had a few questions about how to quickly check the buckets on a particular partitioned table before performing a manual split or merge to make sure there will be no data movement and came up with the code below.
This article shows how to force SQL and Web Developers to not use SA account while other services are already deployed to connect to SQL Server via SA account. So we will not touch existing services and applications only developers must be prevented.