16 December 2016

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)
image
2.Right click Job->New job.
image
3.Fill  the Name field with a  name for your job,Give description.
image
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.
image
  • 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.
image
5.Schedule the job by clicking the Schedule icon in the Select a Page.Then schedule new job.
image
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
image
7.Specify the actions to be performed when the job completes or when job fails.
image

8 December 2016

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.

1 December 2016

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:

replace

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).

expressions

30 November 2016

What is IIS - Internet Information Server

Internet Information Server (IIS) is one of the most popular web servers from Microsoft that is used to host and provide Internet-based services to ASP.NET and ASP Web applications. A web server is responsible for providing a response to requests that come from users. When a request comes from client to server IIS takes that request from users and process it and send response back to users.

Internet Information Server (IIS) has it's own ASP.NET Process Engine to handle the ASP.NET request. The way you configure an ASP.NET application depends on what version of IIS the application is running on.

Internet Information Server (IIS) includes a set of programs for building and administering Web applications, search engines, and support for writing Web-based applications that access databases such as SQL Server. With IIS, you can make your computer to work as a Web server and provides the functionality to develop and deploy ASP.NET Web applications on the server. You can also set security for a particular Website for specific Users and Computer in order to protect it from unauthorized access.

IIS helps organizations to increase Web sites and application availability while lowering system administration and cost of deployment. IIS 7.5 supports HTTP, HTTPS, FTP, FTPS, SMTP and NNTP.

Slow Visual Studio Performance ... Solved

I had an odd performance-related issue today. My Microsoft Visual Studio seemed to be taking far too long to perform even the simplest of operations. I Googled around and tried a few ideas that people had such as disabling add-ins or clearing Visual Studio's recent projects list but those suggestions didn't seem to solve the problem. I remembered that the Windows Sys Internals website had a tool called Process Monitor that would sniff registry and file accesses by any running program. It seemed to me that Visual Studio was up to something and Process Monitor should help me figure out what it was. I downloaded the most recent version, and after fiddling around a bit with its display filters, ran it and to my horror, I saw that Visual Studio was so slow because it was accessing the more than 10,000 folders in 
C:\Users\krintoul\AppData\Local\Microsoft\WebSiteCache 
on most IDE operations. I'm not sure why there were that many folders and moreover, wasn't sure what Visual Studio was doing with them, but after I zipped those folders up and moved them somewhere else, Visual Studio's performance improved tremendously.