Friday, May 17, 2013

How to block ads from websites

As you probably see below this post (If it's the latest) and on the right of the page under the "Site History", I have added some ads.

But fret not - For this post shall include how to remove ads such as these! \o/

1.) Download and install Adblock for Firefox, Chrome, or Opera - If you're using IE... Download Chrome ^_^
2.) Subscribe to the recommended filter list - Should be called 'EasyList'
3.) Enjoy an ad-free experience :D
4.) Example With Adblock Installed: Click Me :D
Note: Some of the items in the image (Pencil, Spanner, Etc) only appear for me since I own the page ^_^

Monday, May 6, 2013

Create a SQL Database using an existing MDF File

If you have an MDF file, and you need to create a SQL Database from it using code, do the following:
USE [master]
GO
CREATE DATABASE [insert_database_name_here] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\fileNameHere.mdf' ),
FOR ATTACH ;
GO