Online PC Support

OPS Technical Solutions : +1 315-226-4249

Welcome

Appliance collaboration between Microsoft® and HP

HP and Microsoft have submitted a portfolio of four convergences of software and hardware designed to improve employee productivity and improve the decision-making process. According to developers, new hardware and software systems from HP and Microsoft are equally important for both IT professionals and business users.

They ensure the operation of such business-critical applications, business intelligence, data warehousing, OLTP, and e-mail. These software and hardware were developed jointly by HP and Microsoft. In addition, these complexes, compared to traditional integrated systems deliver higher performance and scalability – up to 40% and 25% respectively.

The collaboration of HP with Microsoft, resulted in  decrease in time for the integration of applications. IT staff can reduce the time to configure, deploy and manage integrated business intelligence solution. This hardware- software package includes Microsoft Windows Server, Microsoft SQL Server and Microsoft SharePoint. The solution allows users to work together with analytical data created by PowerPivot for Microsoft Excel and SharePoint 2010. In turn, IT administrators can centrally audit and manage applications from a single panel.

HP and Microsoft also introduced HP Database Consolidation Appliance. This complex will consolidate hundreds of databases into a single virtual environment, providing customers with a solution of private “cloud”: a flexible, scalable and well managed. The complex is optimized for SQL Server 2008 R2 and Microsoft Hyper-V Cloud and will be offered as a pre-configured set of equipment to services for deploying and customizing reported to Microsoft.

In addition, HP and Microsoft offer support and consulting services for hardware-software applications, using which customers can quickly begin to use business applications. Services include assessment, design, testing and deployment, and ongoing technical support. The cost of licensing Microsoft SQL Server 2008 R2 and Microsoft SharePoint 2010 is paid for separately. Solution HP E5000 Messaging System with 3-year hardware and software tech support 24×7 will be available in March 2011.

How To Set or Change the Primary Key in a Microsoft Access Database

Primary key of a relational table is that key which identifies each and every record in a table uniquely. It can be either a normal attribute whose uniqueness is taken for guaranteed like SSN (Social Security Number) etc or can be generated or made available by the DBMS (Database Management System) like GUID (Globally Unique Identifier) in Microsoft SQL Server. It may consist of a single as well as multiple attributes in combination.

Let’s take an example of an EMPLOYEE table that contains a record for every single employee in an organization from lower to higher position. The employee’s unique employee ID number would be a primary key in the EMPLOYEE table. The employee’s first and last name would not be a primary key coz it can’t be taken for guaranteed that no two employees will have the same first name and last name.

Now create all the tables you will need for keeping track of the Employees in an organization. Let the first table be Employee and it will contain the list of all the employees with e-code (Employee code, numbers), employee’s first name and last name along with middle initials (text), gender (text 1), age (number) and mob (number). Second table will differentiate the employees position whether manager, peon etc and let it be e-pos.

As the tables were created its now turn to set the primary or foreign keys. The primary key of the Election table could be the e-code which would be unique code for every employee.

Step 1:

In order to set a primary key, click on the desired field or fields you want to make. To select a field click on the desired field or on the row-selector to select the entire row. As per the example taken above, click on e-code and then on the toolbar and click on primary to make it the primary key.

[Field that already has data or which returns a null value can’t be selected as a Primary Key, coz MS Access will not allow you to do that. It will generate a message at the time you save it.]

Step 2:

If you want to select multiple numbers of fields, then just hold down the ctrl key and click the row selector for each field you want and then on the toolbar and click on primary to make it the primary key.

Step 3:

The primary key is set. If you want to change a Primary key follow the same procedure as in step 1 and 2. But be sure that the field you want to make Primary does not have duplicate or null values. If in-case you face such problems, follow step 4.

Step 4:

Primary key can be set for a field that already has data in it but on doing so at the time of saving MS Access will generate a message if it finds any duplicate or null values in it. To sort out this situation you can either try to find duplicate query so as to locate the duplicate or null values and then edit the tracked field to remove them. Or else you can choose a different field.

How to Link Data From Another Database in Microsoft Access

Microsoft office Access or MS Access is a database management system from Microsoft which is a combination of the relational Microsoft Jet Database Engine and a graphical user interface, with software development tools. On the basis of the Jet Database Engine, MS Access stores data in its own format and can also link or import directly to data stored in other databases and applications. These applications can be Excel, Outlook, XML, HTML, Lotus 1-2-3 and also Oracle and Microsoft SQL Server.

Converting data from a different format and copying it into a new MS Access table is known as importing. The database objects can also be imported into another MS access database or an MS Access project. Linking to the data is a method through which users can connect to data from another application without importing it. This way you can view and edit the data in both an Access file and the original application.

Instructions in Linking Data from another database in MS Access

Linking is a preferable to importing if you are editing the data with another program, or if the data is being accessed infrequently from the MS Access database. Following certain steps would help to link data in MS Access.

Step 1: The first step involves opening or creating the MS Access database which you want to link to another database.

Step 2: Select the File menu. After that select ‘Get External Data’, followed by ‘link Tables’.

Step 3: The type of file that needs to be link has to be decided. This can be done from the Files of Type box.

Step 4: Then proceed to go into the Look in box. Then explore the files and folders on the disk until the one that needs to be linked is located.

Step 5: The file is then selected

Step 6: Link is clicked.

Step 7: This way, the specific data is linked from another database. Additionally, any information that MS Access requests for should be provided. For example, one can be asked to provide passwords or identifying tables, and so on.

There are some additional tips and warnings that should be kept in mind in the process of linking. If the icon to the linked table is deleted, then the table is not deleted. It is only the link which is. The data can be linked from tables that are created in a different version of MS Access, from an HTML table, or from programs such as FoxPro, Excel, Paradox or dBase. Access won’t be able to find the link if you move the external table. You would have to reestablish the link if the external table is moved. Therefore, taking care to follow the above instructions and keeping in the mind the tips would save the trouble for importing data from another program to Access, and going through formatting the same. Providing a link is more convenient for software professionals and users alike.

How to Improve Microsoft SQL Server Database Performance

Response time and the throughput time are the two scales on which any Database server’s performance can be measured and Microsoft’s SQL server is of no difference. We can regularly use some monitoring tools to measure the performance of Microsoft’s SQL sever and it can be measure in Seconds for Response time and Transactions per Second for Throughput time. To describe the Response time is the time which is spent between the initiation and completion of any SQL Query. On the other hand the Throughput time is the number of transactions the server can handle in a given period of time which is usually one second. The performance of SQL server depends upon a number of factors ranging from the hardware to the software. When we talk about the hardware it could be the hard drive on which the database is stored or the server’s processor. It could also be the physical connection and the network speed, and when we talk about the software it could be the way the application is coded. Not only the applications coding but also the SQL queries themselves.

Let us discuss the various factors which could lead to poor performance of Microsoft SQL server and ways to improve the performance. First and the foremost thing to be checked is the Database application. The application code should be efficient and should use clustered indexes in its SQL queries. Ensure that the SQL queries written in the application are in such a way that they can be optimised by the server. Always go for multiple narrow indexes than wider indexes. Ensure that the data types are of same type in the database application and in the database. Make sure that all the tables in the database are clustered. Timely check for fragmentations, and especially for the index fragmentations. Use both SQL queries and Windows defragmenter for defragmentation, both physical and logical. Do not let the table rows to row more than 8000 bytes per row. In Microsoft SQL server 8060 bytes is the maximum page extent size, and anything more than this will result in poor performance.

To improve the performances make sure that the TempDB is located on a separate high performance drive.  Just have 1 physical file per CPU core in the SQL server as this will result in increased and better input/output throughput from the processors.try using RAID 1 or RAID 10 for improving the performance. Check for database and see if it can be further normalised. Set up performance management tools and constantly monitor the performance in real time. Check for time periods in which the performance degrades and find ways to improve the performance in those times. Try upgrading the network, the processors on the server, memory and the cache memory on the server and the disk drives. Try using SSD or the Flash memory type disks in read type environment. Some tools which can be used for monitoring the Microsoft SQL server’s performance are SQL Server Management Studio, SQL Server Profiler, and Dynamic Management Views.

Call Now: +1 315-226-4249
Call Now: +1 315-226-4249
Call Now: +1 315-226-4249