Do not add flexible database roles as members of fixed roles. This could enable unintended privilege escalation. #SQLTip #SQLServer #SQL2012
— Jens Vestergaard (@vestergaardj) november 10, 2012
A SQL Server backup cannot be restored by a version of SQL Server that is older than the version that created the backup. #SQLTip #SQLServer
— Jens Vestergaard (@vestergaardj) november 11, 2012
New to #SQL2012 TRY_CONVERT Returns a value cast to the specified data type if the cast succeeds;otherwise, returns null. #SQLTip #SQLServer
— Jens Vestergaard (@vestergaardj) november 12, 2012
Full-text indexing is not supported on database snapshots. Full-text catalogs are not propagated from the source database. #SQLTip #SQL2012
— Jens Vestergaard (@vestergaardj) november 13, 2012
To restore an encrypted db, you must have access to the certificate or asymmetric key that was used to encrypt the db. #SQLTip #SQLServer
— Jens Vestergaard (@vestergaardj) november 14, 2012
