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)

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.

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.

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

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.

TFS Installation Steps

How to: Install Team Foundation Server Using the Advanced Configuration

If you want to change the default installation options for Team Foundation Server, use the advanced configuration, which lets you configure Team Foundation Server on multiple servers and change many other options.

Why use advanced? The standard installation might not fit your needs. You might want to customize a single server installation or install Team Foundation Server and its configuration database on different servers. Perhaps you already have SQL Server or SharePoint Products running in your organization and you'd like to use one of these installations to host team projects or the data for Team Foundation Server. If you use the optional features that require prerequisite server software, these installations can also be hosted on different servers. If you use multiple servers, you can distribute the load between Team Foundation Server and the configuration database, or you can ensure that prerequisite server software for features such as reporting or the portal site is running on capable hardware.

System Requirement

You can install Team Foundation Server on a server that is running one of the following operating systems:

Server operating systems:

64-bit version of Windows Server 2008 with SP2
64-bit versions of Windows Server 2008 R2 ¹ with SP1
64-bit versions of Windows Server 2012

IIS Requirement
IIS should be configured on Windows Server machine

SQL Server Requirements for Team Foundation Server

Supported editions	SQL Server 2008, R2 Express¹ SQL Server 2008, R2 Standard Edition¹ SQL Server 2008, R2 Enterprise Edition with SP 1 CU1 (Aug 25, 2011)² SQL Server 2012, Express¹ SQL Server 2012, Standard Edition¹ SQL Server 2012, Enterprise Edition
Required for Team Foundation Server	Database Engine Services Full-Text Search (or Full-Text and Semantic Extractions for Search in SQL Server 2012)

Accounts Required for Installation of Team Foundation Server

Component	Sample user logon name	Requirements
Team Foundation Server	TFSSERVICE	You can specify a built-in account or a user account. If you specify a user account, it must have the Log on as service permission. You must not use the account that you use to install Team Foundation Server as the account for TFSSERVICE.
Team Foundation Build	TFSBUILD	You can specify a built-in account or a user account. If you use a user account, it must have the Log on as a service permission.
Team Foundation Server Proxy	TFSPROXY	You can specify a built-in account or a user account. If you use a user account, it must have the Log on as a service permission.
Reporting	TFSREPORTS	You must specify a user account that has the Allow log on locally permission. Default: You are prompted for this account. You cannot use a built-in account for the report reader account.
SharePoint Products	WSSSERVICE	You must specify a user account. Default: If you install Team Foundation Server with the default options, the account that you specified as the report reader account is also used for this account.

The Steps for IIS are for understanding. In Reality starting with TFS 2012 you dont need to configure IIS manually. TFS installation takes care of this step

Configure IIS 7.0 on Windows Server 2008 R2
Select Server manager and Web Server Role to Configure IIS

Select asp.net and IIS 6 Management compatibility from the Role services Option

SQL Server 2008 R2 Installation with SP2

We need Database Engine Services and Full Text Search Feature for TFS installation

For Reporting Services We could select Report service and Analysis Service. Client Connecting tools Connectivity with SQL Management tools are important for tool like SQL Management Studio.

Important: If SQL administrator is not specified below than SQL will get looked and had to be used with SA login to update information.

For TFS 2012 with SQL Server 2008 R2 SP1 with Cumulative update 1 is mandatory, I have installed SQL SP2 to meet TFS requirement

Follow the wizard and complete the SQL server 2008 R2 SP1 Installation.

TFS 2012 Installation and Configuration

In the Team Foundation Server Configuration tool, choose Advanced, and then choose Start Wizard.

The Advanced Configuration wizard appears.

2. Read the Welcome screen, and then choose Next.

In SQL Server Instance, type the name of the server that is running SQL Server or the named instance that will host the configuration databases, and choose Next.

4. Under Service Account, choose Use a system account to use a built-in account or Use a user account to use a domain or local account. If you are using a user account, you must type the password. To test the user account and password combination, you can optionally choose Test.

Under Authentication Method, choose NTLM or Negotiate (Kerberos), and then choose Next.
- If you choose NTLM, NTLM authentication is used. This option is the default setting.
- If you choose Negotiate (Kerberos), Kerberos authentication is attempted first. If that attempt fails, NTLM authentication is used.

Under Web Site, type a name in Web Site Name and a port number in Port. This is the name that appears in Internet Information Services (IIS) and the port number used to connect to Team Foundation Server.

The default values for Web Site are Team Foundation Server and 8080.

Under IIS Virtual Directory, you can use the default value of tfs or optionally type a virtual directory name.

Under Web Site, note the Team Foundation Server site URL, which is dynamically assembled based on your input in Web Site and IIS Virtual Directory. Clients use this URL to connect to Team Foundation Server. Choose Next

Use the Configure Reporting for Team Foundation Server page to opt in or out of using reporting. Select the Configure Reporting for use with Team Foundation Server check box to use reporting, or clear the check box to skip reporting, and then choose Next.

If you specified a user account for the service account of Team Foundation Server in step 4, you must select the Use a different account than the Team Foundation Server service account for the report reader account check box to use a different account

Use the Configure SharePoint for Team Foundation Server page to opt in or out of using SharePoint Products. Clear the check box to skip SharePoint Products. Choose Next.

If you selected the check box to configure SharePoint Products, perform one of the following procedures:

Install and configure SharePoint on this machine.
1. Choose Install and configure SharePoint on this machine and choose Next.
2. Choose the big Install SharePoint Foundation 2010 button. Once the install completes, choose Next.
3. Type a user account and password for the service account forSharePoint Foundation 2010 (WSSSERVICE). If you specified a user account for the service account of Team Foundation Server in step 4, you must select the Use a different account than the Team Foundation Server service account for the SharePoint farm check box to use a different account.
4. Choose Next.