SQL Server Quick Tip 6 – 10

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…

Read More

SQL Server Quick Tip 1 – 5

Here’s my first five SQL Server Quick Tips: Shrink database or shrink file operations CANNOT be run during a database or transaction log backup #sqltip #sqlserver #sql2012 — Jens Vestergaard (@vestergaardj) november 2, 2012   To edit an alert,you need to be either member of the sysadmin server role orSQLAgentOperatorRole db role in the msdb…

Read More