nebulom

This is just a document in case I forgot to restore data files to MSSQL. I had this problem before when a colleague gave me a .dat files to be restored to SQL server. I had a 2008 version of the server and had no trouble restoring it. The problem is, I forgot how I did it when I had a new PC and I upgraded it to 2012 SQL server. But this is a simple task (although I had a full day remembering how I did it and I had no luck finding the solution from google). First off, click restore, like so I had trouble with the database whether or not to add a new database and restore the file to it, or not. Simple answer is no need. With the next image you can see that the configuration is very simple. Just set it to device as the source and find the .mdf file. It automatically displays a suggestion for the database name and you're done. Click OK and wait a couple of minutes for SQL server to restore the data. [EDIT] In case you are restoring a backup file without an extension. You c...

Better late than never. I really planned to have a home-based web server so that I can explore a little bit of systems administration, just simply. I'm not really much of an administrator but it would be cool if I know a bit about this stuff. I had a little background with PHP and web development so I think I can handle it. Gladly it's not that difficult. With a little bit of installations and configuration, and we're done. First off, install XAMPP . Download the application from their website and install. Just accept the default options and we're good to go. I got a little info with XAMPP and Lithium for further exploration here . So accessing the host where you install the XAMPP will get you the web server's default page. In my case, it's localhost and it displays the XAMPP default page. Things are looking good. I'll give details on installation of XAMPP later in my other blog post. And now for the port forwarding bit. Port forwarding means you forwa...

I use this method to share some files with my friends across the internet that is too large for Dropbox to handle. I tried hosting SQL data that's around 3G in size so I wanted to try FTP approach. I installed XAMPP and it has useful stuffs for HTTP and FTP projects. I use it once with my PHP development, but that's it -- nothing FTP related. This is a tutorial on how to basically set-up FTP server locally to host data to be shared by friends, etc. Once XAMPP is installed, we can directly go to the Control Panel. Clicking the Admin for FileZilla FTP Server administration might alert you with Security Warning, just allow access to it. Click OK to Connect to Server. We are now presented with the FileZilla server Administration interface. Go to Edit->Users to add users. I usually just add temporary users who can access specific files to be shared periodically, that means I'll disable it once I'm done with the file share and also I don't usually leave FTP s...

Well, I like smaller fonts and I've tried Elementary OS Luna. I like it and I'm searching a way to make the default fonts smaller. Just so I have more spaces to work on, especially when I code and read. Luckily I found a solution to download the tweak and make the fonts/icons custom sizes in Elementary Luna. This is how I did it. Hope you guys find it useful. Run this in your terminal. sudo apt-add-repository ppa:versable/elementary-update sudo apt-get update sudo apt-get install elementary-tweaks And if anyone is interested in my setting, here's my screenshot. You can find it in System Settings/Tweaks btw. Thanks everyone!

Just found this tutorial on trying out LAMP in ElementaryOS here. Might as well be blogged here so I can get back at it when trying it in the future.