How to open SQL files in Visual Studio 2012

The default installation of Visual Studio 2012 cannot open SQL documents when you double click on them in Source Control Explorer.  To be able to do that you have to install the SQL Server Data Tools  for Visual Studio 2012 Open the ” December 2012″ update page at http://msdn.microsoft.com/en-us/jj650015 Download and install SSDTSetup.exe by clicking Download …

How to record two instruments simultaneously with Garage Band

My son and his friend wanted to record as they play together on a bass and an electric guitar. To record two instruments simultaneously in Garage Band you need special hardware to connect both to the computer. You can buy a USB Recording Interface for a few hundred dollars, or you can make one for …

Add if conditional statement to the Visual Studio pre-build and post-build events

There are times when you want to execute statements in the pre-build and post-build events of a Microsoft Visual Studio project when certain conditions met. In the next example we will copy the environment specific config file to the web application folder if the configuration is set to “Local”. To edit the pre-buld and post-buld …

How to add the Config folder to a Microsoft Visual Studio project even if the folder is not in the project directory

Corporations maintain multiple server environments for development, testing and production purposes. All of these environments require specific settings to connect to the databases and other resources. When the build master builds the application for the specific environment the build process has to select the appropriate configuration and build it into the installer file for deployment. …

Create a backup of a Microsoft SQL Server database to a location outside of the database server

The Microsoft SQL Server Management Studio 2008 user interface only allows you to create a backup of a database to one of the local drives of the database server. To create a backup of a Microsoft SQL Server database to a location outside of the database server execute the following SQL script: BACKUP DATABASE MyDatabase TO …

How to add sample programming code to a post or page in WordPress

Double quotes When you write a post or create a page you may want to add sample program snippets to it. If your code contains double quotes (“) the WordPress page will display different characters for the opening and closing quotes, like in this   “example”. Unfortunately these characters differ from the quotes you use …

Save the list of folders in a text file

If you receive a portable drive and want to see the list of folders, you can output it to a text file. To save the list of folders in a text file execute the following command in the command window: dir P: /AD /B >> “C:\folderlist.txt” where P: is the drive letter of the portable …

How to remove Windows 8 and install Windows 7 on a Lenovo ideapad z580 laptop

My friend just bought a new Lenovo ideapad z580 laptop with Windows 8 on it. She was not sure if her special statistical programs will run on Windows 8, so she asked me to remove Windows 8 and install her copy of Windows 7  64 bit on it. As it turned out the Lenovo laptop …

How to enable jQuery intellisense in Microsoft Visual Studio

To enable jQuery intellisense in Microsoft Visual Studio Open the _references.js file in the editor by double clicking it Drag the jquery-x.x.x.intellisense.js file into the _references.js file in the editor. The name of the file will be added to the _references.js file

Conditional compilation symbols in Microsoft Visual Studio

If you need to make breaking changes in your source code that will be deployed later to production, but first have to be tested in the development environment you can include conditional compilation symbols to specify which lines will be included in the application for certain environments. This way you can maintain environment specific versions …