In this post, I will tell you a great way to convert your favorite youtube video to audio.And one interesting thing is here, you don't need kind of software to do this.This can be done just like my previous post, you got it now... Yes! just by modifying your video URL...


Let's see how to do this....

Play your favorite video on youtube and Go to URL...



Replace the prefix upto youtube with pwn....


As soon as you hit enter, you will be redirected to a webpage.Now, click any of the link from the highlighted region....


I have clicked on YouTueb-mp3....


Click on Convert and your video will be converted in few seconds.Now, just click Download..


If you have integrated your browser with some downloader then it will do the downloading otherwise your default browser will do this task...


That's it !! done !!!
I have already covered how to download videos from youtube using different ways.So, You would be thinking why another post on the same topic ? And also, I know that you already have your favorite way to download videos from youtube.. But there is something special in this trick..You don't need to use any software or ad-ons...

Let me show you how....

You know where to go first, Go to Youtube...

Now, Look for your favorite video and let it be playing...

Go to the URL and we have to modify this URL a bit..

Suppose, my youtube URL is this :

https://www.youtube.com/watch?v=1iYUQW6RovY

Now, just add ss in the URL :

https://www.ssyoutube.com/watch?v=1iYUQW6RovY and hit enter.

It will redirect you to other page with Download option.


As soon as you click on Download option, you will be able to see a lot of different format options.


Click on More...

 As soon as you click on one of the formats, it will start downloading your video...











We all have been extensively using torrent files, mainly to download movies, files, games and some other stuffs.But we can also use it to share our large files.In short, just don't download the torrent files, create your own too...

Let's see the step by step flow...

First , choose your file.In my case, I want to share a pdf file.

Now,  open your torrent client (BitTorrent in my case.) and Go to File -> Create New Torrent.


A window will pop up. Here, you can add your files or a directory...
I am adding a directory here....


Once done, click Create ....


Click on Save and you are done...



Now, you can share this torrent to your friends..As soon as they add this file , this file will get downloaded on their system.To reach large mass, just add this torrent file to any of the torrent hosting sites like (extratorrent etc.....)

In this post, I will explain how you guys can install MDX sample files and attach it to database. I was having some hard time while installing these sample file and I don't want you guys to go through it..
So, here are the details...

You can download E-book from here : MDX E-book

Now, once you have downloaded the e-book, you need sample files for exercise..

So, you can download sample files from here : Sql Server 2008 Sample Files

Next thing is to install these sample files.Once you have extracted the zip file, you will have all these
files in your folder...


Double click StartCD.exe.



Click on install Sample files.. It will install all these files in your system...

Once you start reading this book, the first thing you  have to do ,is to attach the database (mentioned on Page 20 of this ebook)......

Here, you may face a problem as mentioned below:

One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.  If this is an existing database, the file may be corrupted and should be restored from a backup.
Log file 'C:\Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepByStep_log.LDF' does not match the primary file.  It may be from a different database or the log may have been rebuilt previously.
 So, what you have to do in this case, delete the log file and put the mdf files on the path as mentioned in the below screenshot and run the commands again...


 That's it !!



In this tutorial, I am going to cover how to bcp out the table data into a delimited file. The delimiter can be pipe ,comma anything. As I am going to use Sql Server Integration Service Tool for this, it is going to be very easy..

Initial steps are same as mentioned in the this post... Load Single Text File Using SSIS

So once you have created a project, follow below mentioned steps..

Drag a Data Flow Task....

Double Click on it and from the Toolbox select OLE DB Source ( As our table will be source in this case) and File Destination (As we are going to dump data into a file).



Now, we have to create a connection string for OLE DB connection and File Connection.

OLE DB Connection :

It's a pretty straightforward....




 File Connection :

 As soon as you click on the New button, You will be greeted with a pop up. Just select what kind of file
you want to generate.



Next, Click on the browse button. Go to the location where you want to generate this output file and give your output file a name.


Choose your file's delimiter type.


Once all above steps are done, just execute your package.

So, the output file is created successfully and 5 rows have been copied in the output file.


Let's check the output file...






This is going to be an interesting post for the guys who are avid users of Youtube or some other video sites.I had been trying to search for a tool to create HD videos to upload on Youtube.I was amazed to know that  I could create HD videos using Windows Movie Maker (by default comes with windows OS).
Just some setting changes and you can convert your normal video to HD video....

With normal settings in Windows Movie Maker:

This went horribly wrong...

Watch here : Average Video Quality


Let's jump to the process....

Now, how to convert it into HD...

Open Windows Movie Maker.

Select your video.
 

Go to Tools -> Options -> Advanced



Select Aspect Ratio 16:9 in place of 4:3 and place OK.


Now, just go to Edit - >Publish Movie...


Click Next...


Now, this is important step..
Go to More settings -> Windows Media HD 720p...


Now, click Publish and you are done !!





See, how  it looks on Youtube : HD Video Quality


© 2015 Techie's House. Designed by Bloggertheme9