Posts grid page

Backup Database to the Cloud…
May 12, 2015

Yes, it's possible... using SQLBackupAndFTP!


creates MS SQL Server database backups. Zips, Encrypts and sends backups to a folder, FTP, Dropbox, Google Continue reading
Converter ntext em nvarchar(max)
April 25, 2015
SELECT AS table_name, AS column_name, ( 'alter table [' + + '] ' + 'alter column [' + +'] ' + case Continue reading
Delete all Stored Procedures
March 6, 2015

Depois de testar o .net membership, apercebi-me que foram criados vários stored procedures. E agora como apaga-los todos de uma Continue reading

Master database in Full recovery model? Maybe not!
February 4, 2015

Even though is possible to change the recovery model of the master database to FULL as we can see with Continue reading

Move user databases using xp_cmdshell
February 3, 2015
An example for using xp_cmdshell... moving user databases. See the script... Continue reading
Rebuild and Restore Master Database
January 27, 2015
The problem

It all starts with this error when we try to connect to SQL Server instance:

At SQL Server Configuration Manager, Continue reading

January 21, 2015

Do it once, do it twice, write a script...

Continue reading
SQL Server and Windows Firewall (GUI way)
January 14, 2015
A step-by-step guide about how to create a new rule in Windows Firewall for SQL Server. Continue reading
Enabling Hyper-V on Windows 8.1 PRO
January 11, 2015
Unleash Hyper-V on Windows 8.1 Pro. See how! Continue reading