Restore MS SQL Database with Move

RESTORE DATABASE bsc
FROM DISK = ‘e:\bsc.bak’
WITH REPLACE

RESTORE DATABASE bsc
FROM DISK=’e:\bsc.bak’
WITH
MOVE ‘bsc’ TO ‘c:\TSQL\bsc.mdf’,
MOVE ‘bsc_log’ TO ‘c:\TSQL\bsc_log.ldf’, STATS=5

Counting records based on Condition

SELECT PCPNO,IPA,[Provider Name], COUNT(DISTINCT MEMBNO) as “Number_Of_Members”
FROM PCP
GROUP BY PCPNO, IPA, [Provider Name]
HAVING COUNT(DISTINCT IPA) = 1
ORDER BY Number_Of_Members desc

Using Conditional Split

This article describes the Conditional Split Process

http://www.programminghelp.com/database/sqlserver/sql-server-integration-services-dealing-with-bad-data/

Controling the look of Datagridview

http://www.solovb.net/index.php/2009/01/06/datagridview/

Analysis Services Stuff

MS-Analysis Services 2008 Part I
http://www.youtube.com/watch?v=yawq4SGoRoY

Comparing Relational Databases to Multidimensional Databases in SQL Server 2008/R2 Analysis Services
http://www.youtube.com/watch?v=q8p_2j5yTHI

What is Business Intelligence?
http://www.youtube.com/watch?v=LhZX0MAYKp8&feature=mfu_in_order&list=UL

Wonderwall by Oasis- Another Stumming aproach lesson

Wonder Wall Song Tutorial Video

Free Guitar lesson Video

Very handy Video lesson

Guitar Lessons Online Free

This site have a very nice amount of resources for guitar learning people.

http://www.guitarlessons.com

Good Music Tabs Source (But…)

http://www.e-chords.com/

This site has a lot of Chords and options, but everything push you to be a premium user.

The Work Around: Find the Song you like and for print it you need to make a little stuff but it works

1.Go to Page Source

2.Copy the Song Tabs (is going to easy to find)

3.Pass it to any HTML Editor

4.Paste the design view to any notepad or text editor.

Ready

Enjoy:)