Creating an automated database backup by means of SQL Server Agent Job

Task: to create a fully automatic database backup system by means of SQL Server Agent Job with an e-mail fails notification subsystem EXEC [master].[dbo].[sp_addumpdevice] @devtype = N’disk’, @logicalname = N’AdventureWorks2008R2′, @physicalname = N’D:\SqlData\MSSQL\Backup\AdventureWorks2008R2.bak’ GO Source code 1: SSMS -> Object Explorer -> [sql_server_instance] -> Server Objects -> Backup Devices -> AdventureWorks2008R2 EXEC [master].[dbo].[sp_configure] ‘show advanced [...]

A simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism

The SQL professionals know that the built-in MS SQL Server encryption mechanism by means of WITH ENCRYPTION T-SQL keyword is ineffective and easily broken. For much more details see also Google’s results e.g.: search phrase: sql decryptor (approximate number of results: 405 000) search phrase: sql server syscomments decryptor (approximate number of results: 2 850) [...]