Oracle
Oracle VirtualBox 4.2.18 released!
VirtualBox has a special place in my heart as it comes with a nice graphical user interface and we can try a lot of new software in Windows, Linux, Macintosh, and Solaris hosts. Best of all, VirtualBox supports a variety of hardware and pass on its benefits to virtual machines, so for example, we can …
0
08
Sep
Move DB files to new location
In my opinion, we should perform database migration/movement programmatically in order to achieve an automated task, freeing up human resources from tedious tasks. SQL Server 1) ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 2) ALTER DATABASE <dbname> SET OFFLINE; 3) ALTER DATABASE <dbname> MODIFY FILE 4) ( 5) Name = <dbname>_Data, 6) Filename …
25
May
