Online analytical processing (OLAP) cube example Hybrid Distributed Data example As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now.

How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure.

You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale.