What is Backup & why do we need it: The backup is nothing but snapshot of a database. The purpose of the backup is to create a copy of data that can be recovered in the event of a primary data failure Before we discuss on SQL Server backups, let’s try to understand what backups [...]
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. [...]
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 [...]