Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 1 Introduction The businesses make practice of web system each and every time they want their information to be accessible by the different users distributed over countless sites. The web systems practice some particular definite services, identified as the WEB SERVICEs, which offer program writing help plus benefits the...
Standard Members
Some tips for using views in SQL Server 2014
Some tips for using views in SQL Server 2014 Consider using indexed views. Indexed views can significantly improve the performance of an application because the result set of the indexed view is stored and indexed in the database. You do not need to modify your existing applications to take advantage of the performance improvements with indexed views. The indexed view...
Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 4)
Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 4) Autor: Basit A. Farooq Installing instance of SQL Server 2014 on Windows Server 2012 In the part-1 of this five part article series, we discussed the SQL Server 2014 installation prerequisites and the steps that we must perform for the installation of SQL Server 2014 instance. In...
3 Ways Project Managers Can Anticipate, Avoid and Mitigate Problems
3 Ways Project Managers Can Anticipate, Avoid and Mitigate Problems Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they...
Analysis of Service Broker in line of Message Based Communication – Part 3
Analysis of Service Broker in line of Message Based Communication – Part 3 Building Contracts Any contracts are a settlement in the middle of two services which requires communicating with one another. The contracts stipulate the nature of message which will be there in a conversation among the two services. An individual can form a message by means of the...
Some tips for using ASP.NET with SQL Server 2014
Some tips for using ASP.NET with SQL Server 2014 If you use ADO to access SQL Server data in your ASP.NET, avoid creating transactions using ADO methods. Try to create transactions inside a stored procedure on the SQL Server. By doing so, you can reduce network traffic and boost overall ASP.NET performance. When building a web page based on SQL...
Working with Someone You Hate
Working with Someone You Hate Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to learn...
Analysis of Service Broker in line of Message Based Communication – Part 2
Analysis of Service Broker in line of Message Based Communication – Part 2 Applying Service Broker The minute an individual starts applying Service Broker, the individual must head for forming the Service Broker items for an instance messages, services, queues, contracts. Afterwards one can start a conversation. Once the conversation is taking place, the items can converse with one another...
Some tips for using jobs in SQL Server 2014
Some tips for using jobs in SQL Server 2014 Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs and locate any problems. Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can...
Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 3)
Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 3) Author: Basit A. Farooq In the first two parts of this three part article series on "Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design", we discussed how to design and implement logging into your SQL...