Create and Schedule a Job in SQL Server 2008

SQL Server agent can be used to create JOBS which can be scheduled to execute automatically. SQL Server Agent uses SQL Server to store job information. Jobs can have one or more job steps. Each step contains its own task.Each action in a job is a job step.We can schedule the job based on need as daily, weekly, monthly, hourly etc

For example, Let us create a job to back up a database automatically.

Steps to create Job in SQL Server Agent

1. Expand SQL Server Agent in Object Explorer.(If SQL Server Agent is stopped ,right click and start it)

2.Right click Job->New job.

3.Fill  the Name field with a  name for your job,Give description.

4. On the left side of the New Job window, you’ll see a Steps icon under the Select a page.Next add the individual steps for your job. Click the New button to create a new job step and you will see the New Job Step window.

• Use the Step Name textbox to provide a name for the Step. select the database where the job has to be applied.
• Use the Command textbox to give the Transact-SQL syntax corresponding to the desired action for this job step. Once you have completed entering the command, click the Parse button to verify the syntax.
• Validate the syntax, click OK to create the step.

5.Schedule the job by clicking the Schedule icon in the Select a Page.Then schedule new job.

6.Create alerts for your job by Giving alert name and also select the database.Also select the type of alert and severity of your alert

7.Specify the actions to be performed when the job completes or when job fails.

Read More

How to setup your Blog with GoDaddy

GoDaddy DNS service supports this feature so Let's show you how it's done:
For this demo, I assume you have an existing blog and you have already purchased a domain on GoDaddy.

Step 1: Go to the Settings Tab of your blog in the Blogger UI and click on the "Add a custom domain" link.

Step 2: Enter the URL you would like to use for your blog and press Save. I'm using "www.thisdemoblog.com" but the URL doesn't need to start with www such as "blog.mridey.com" where I published this article.

Step 3: You will get an error. It's expected as you have not configured GoDaddy with the DNS settings required. Now click on the "DNS settings file" link and save the file. Keep this window open, you'll need it later.

Step 4: In a new window, go to GoDaddy, login, go to the Domain Control Panel and click on your domain name.

Step 5: Click on the "DNS Zone File" tab.

Step 6: Click on the Edit button.

Step 7: We need to delete some of the existing records that GoDaddy adds by default. Select all the "A" records with "@" as host as well as the CNAME record "www" (if the URL you want to use starts with www) and press the Delete button.

Step 8: Press the "Save Zone File" button.

Step 9: Press Ok to confirm.

Step 10: Press Ok to confirm again. :)

Step 11: Now let's load the new records. Click the Import/Export button and select "Import".

Step 12: Click "Select File" and find the file you have saved in step 3, then click the "I understand ..." checkbox and press the Ok button.

Step 13: Press Ok to confirm.

Step 14: You should be able to see your new records loaded in GoDaddy. Four "A" records as well as two CNAME records. All good.

Step 15: Go back to the Blogger settings window we kept open in Step 3 and click "Save" again.

Step 16: If like me the GoDaddy DNS server processed the changes really quickly, it should all work fine and the settings should be accepted. You should be back to the main settings with your new custom domain accepted as the blog Address. So click on "Edit".

If Step 16 fails, be patient and retry later. It can take up to 48h for DNS settings to propagate. 

Step 17: Enable the "Redirect ..." checkbox and press Save. This is to allow "naked domain" redirect i.e. when users type your domain name without the www at the beginning.

Step 18: Finally click the "View blog" button at the top of Blogger UI, it should all work fine and your blog should now be enabled with a custom domain.

Read More

How to Remove Blank Lines in Visual Studio

We can use regular expressions to find blank lines and replace them with white spaces.

Following steps are to find blank lines and replace:

In visual studio 2012.

1. Press “ Ctrl+ Shift + H “.

And window shown like:



2. Write regular expression For (vs2012) "^(?([^\r\n])\s)*\r?$\r?\n" or for vs 2010 (^$\n or ^&\n)in find what box.

3. Leave Replace with box as empty.

4. In find check Use Regular Expressions.

Then Replace or Replace all as you want.

These steps will remove all blank spaces from current document or whole project as you choose Look in box.

Other regular expressions are predefined by visual studio as in below image.(or can see by (a)+ button on find what box).

Read More