How to recover corrupted database file( .mdf .ldf).

EXEC sp_configure 'allow updates',1

RECONFIGURE WITH OVERRIDE

UPDATE sysdatabases SET status=1073741840 WHRE name='DatabaseName'

CHECKPOINT--shutdown with nowait

DBCC traceon(3604)

DBCC rebuild_log ('DatabaseName', 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\DatabaseName_Log.LDF')


USE DatabaseName
sp_dboption 'DatabaseName', 'single_user', 'true'

ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CHECKDB (DatabaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

USE MASTER

UPDATE sysdatabases SET status = 0 WHERE name = 'DatabaseName'

DBCC CHECKALLOC ('DatabaseName')

DBCC CHECKDB ('DatabaseName')

sp_dboption 'DatabaseName', 'single_user', 'false'

USE MASTER

sp_configure 'allow updates', 0

EXEC sp_resetstatus DatabaseName 

Read More

Top 10 Best CSS Time Saving Tools

The Cascading Style Sheets (CSS) is considered as one of the most popular and widely used development language. CSS is quite easy to learn and use, it also offer some really nice features.

Aside from the fact that CSS is quite fun as compared to other languages, but still some of the tasks in it can be quite irksome. For this reason, various CSS tools were created to help you and make your life easier as a programmer.

We are going to present to you a list of the Top 10 Best CSS Tools to save your Time. This kind of tools will definitely help you do your work more quickly and save your precious time. The most important thing is it will enhance your productivity.

Here's the Top 10 Best CSS Tools: Listed in No Particular Order

1. Quick Form Builder

Accessify’s quick form builder merges two older tools (form builder and form element generator).

2. CSS Text Shadow

It is an amazing CSS tool that generates text shadows.

3. Sencha Animator

Sencha Animator is a powerful CSS3 Tool for creating Animations, text, images, buttons with gradients and embed analytics.

4. CSS Menu Maker

CSS Menu Maker is one of the best tool that provides every freelancer to create custom cross browser compatible CSS menus. You do not need any background of programming because it provides source code for all CSS menus.

5. Patternify

Patternify is a CSS pattern generator.

6. CSS Compressor

An amazing CSS Tool to compress CSS code and and help to speed your website loading time. It can save your server bandwidth as well compressed CSS in a good balance.

7. Prefixr

Prefixr provides Cross-Browser CSS in Seconds! it is also helpful for developers in testing their codes.

8. 3D Transforms

CSS 3D Transforms is an online tool that provides various level of Transforms. This tool is on experimental mode and require specific prefixes in all browsers.

9. CSS3 PIE: Decorations for IE

PIE makes Internet Explorer 6-9 capable of rendering several of the most useful CSS3 decoration features.

10. Layer Style

Layer Style is like graphic editor which creates codes in CSS.

Read More

How to easily fix an overheating laptop

How to easily fix an overheating laptop

I wold like to share my experience in fixing my laptop which use to get over heated.

What happens when laptop gets over heated ?

Laptop turns off suddenly when the laptop is over heated.

Why does it turns off ?

When the laptop gets over heated it gets turned off directly so that it can prevent major problem to other hardwares.

Why does laptop gets over heated ?

Usually its because the cooling fan is not working proper.

What are the chances of cooling fan to not work properly ?

Either the fan is damaged or the common problem i.e. there is a lot of dust over the fan.(My Laptop had the same problem).

How can dust in Fan make the laptop over heat ?

Well, when there is dust over the Cooling Fan, The speed of Cooling Fan gets reduced. This reduces the performance same time, which causes the laptop to get over heated quickly.

Solution to remove dust from cooling fan.

If you can remove the laptop back panel. You can remove it and clean the fan using the brush or blower.
If you want to fix without taking any risk with opening the laptop.
Simply blow the out let of cooling fan using a blower or simply using your mouth as i did ;). You can see a lot of dust coming out of the outlet. Now enjoy using your laptop that use to get over heated for simple reas

Read More

How to add Official Contact Form in Blogger

How to add Official Contact Form in Blogger

Blogger is one of the popular CMS that helps users to have their own blog for free. As always Blogger has been improving and adding many new features to it.

Contact Form is another amazing feature added by Blogger.
Earlier users had to depend on third party contact form providers like email me form. Now blogger officially supports adding contact form widget to blogger domains. Adding contact form is very simple. You can add them like you add other widgets. Follow the below steps to add Official Contact Form to your Blogger site.

Steps:

1. Visit your Dashboard

2. Select Layout and Click Add a Gadget. 

3. Popup page with widgets will be Displayed. Switch the tab from Basics to More Gadgets.

4. Select the Contact Form.

5. Define a Title and Click Save. You are Done.

Contact Form Preview

How will you receive the mail

Mail will be sent to all the owners of the blog. Owners will be receiving mail from noreply@blogger.com id.

Read More