In this article, we are going to discuss on what is High Availability and Disaster Recovery in general. Agenda: High Availability Disaster Recovery What is High Availability: In the perfect world, the data should be available no matter what. But, in the real world there are many problems that can cause the data to become [...]
Microsoft Excel is a tool with functionality beyond imagination and ‘data connections’ is one such functionality, which facilitates users with much ease. ‘Data connections’ web part enables storage and maintenance of multiple data connections to rapidly build workbooks. Excel can be effectively used to import data located externally which can be narrowed down using connections [...]
SQL or Structured Query Language is a set of commands that helps interact with RDBMS systems. The syntax of these commands defines how to use SQL commands and how to define the parameters that the commands must use. An RDBMS or relational database management system will contain, in general, more than one database. Any of [...]
Introduction If you want to learn PHP and/or MySQL, there’s no better way to start than by installing a LAMP/WAMP/MAMP stack on your desktop computer. The difference between LAMP, WAMP, and MAMP, as you can easily see, is the first letter which denotes the operating system name: Linux, Windows, and Mac OS X respectively. Installing [...]
Microsoft has several standard editions of the SQL server product. It offers a special SQL developer edition so that development work can be carried out before installation on a production server. This SQL Server edition is also available directly from Microsoft too. If you were to look at the product page (for example, example the [...]
SQL Server is a software product from the Microsoft. It is a relational database or RDBMS product. Microsoft SQL Server is addressed to same users as the other RDMS products from major software product companies such as DB2 from IBM, Oracle from Oracle Corporation and MySQL is an open-source product. Like all of these competitive [...]
SQL Server code base grew out of the product owned by Sybase. The version for OS/2 release in 1989 was a product owned by Microsoft. By the time SQL Server version was released in 2000 the code base was nearly free of Sybase code. The SQL Server code for version 2005 was entirely of Microsoft. [...]