Database

/Database

Best Cloud Storage Services for Individuals and Businesses

The way that individuals and businesses store their data has changed very rapidly over the past twenty years. Cloud services allow individuals or businesses to store their data online and access it anywhere they have an internet connection. Businesses used to store their data on the hard drives or memory cards found in their computers. [...]

By |2020-08-08T22:22:50-05:00August 23rd, 2019|Categories: Cloud Computing, Database, File Sharing|Comments Off on Best Cloud Storage Services for Individuals and Businesses

What is High Availability and Disaster Recovery

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 [...]

By |2020-05-15T08:07:15-05:00January 14th, 2019|Categories: Database, Windows|Tags: , |Comments Off on What is High Availability and Disaster Recovery

Creating open data connection files on Microsoft Excel and using SharePoint

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 [...]

By |2018-04-19T19:55:43-05:00May 17th, 2015|Categories: Database, Microsoft Excel, SharePoint|Comments Off on Creating open data connection files on Microsoft Excel and using SharePoint

How to Use SQL – Structured Query Language

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 [...]

By |2018-04-19T19:55:43-05:00October 31st, 2014|Categories: Database, Programming, Windows|Tags: |Comments Off on How to Use SQL – Structured Query Language

Installing Apache, MySQL, and PHP in Windows

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 [...]

By |2018-04-19T19:55:43-05:00October 19th, 2014|Categories: Database, Programming|Tags: , , |Comments Off on Installing Apache, MySQL, and PHP in Windows

SQL Server Developer – A handy edition of SQL Server

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 [...]

By |2018-04-19T19:55:44-05:00September 7th, 2014|Categories: Database, Programming, Small Business|Tags: , |Comments Off on SQL Server Developer – A handy edition of SQL Server

What is SQL Server ? Compare different SQL Versions

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 [...]

By |2018-04-19T19:55:45-05:00March 30th, 2014|Categories: Database, Programming|Tags: |Comments Off on What is SQL Server ? Compare different SQL Versions