Database

/Database

Getting started with Azure SQL

Azure SQL: Azure SQL database is a fully managed platform-as-a-service database that handles most of the database management functions such as backups, patches, and monitoring etc.. SQL database can be a right choice for modern application as it enables you to process relation and non-relations database functions History of Azure SQL: In 2008, Microsoft has [...]

By |2021-01-24T20:16:21-06:00January 21st, 2021|Categories: Azure, Azure SQL, Database|Tags: , |Comments Off on Getting started with Azure SQL

Microsoft SQL Server Database Backup Types

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

By |2021-01-24T20:27:14-06:00December 4th, 2020|Categories: Database, Microsoft SQL Server|Tags: , |Comments Off on Microsoft SQL Server Database Backup Types

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