DBMS – Page 386

How to Install SQLOPS on a Mac

November 9, 2020February 27, 2018 by Ian

UPDATE: SQL Operations Studio (SQLOPS) has since been renamed to Azure Data Studio. The steps in this article remain the same though. In any case, I’ve also rewritten these steps (and included the equivalent screenshots) specifically for Azure Data Studio . See How to Install Azure Data Studio on a Mac.

SQL Operations Studio (also abbreviated to SQLOPS) is a free tool that you can use to manage SQL Server. It uses a graphical user interface (GUI) that helps you view the various databases and objects within a SQL Server instance. It can run on Windows, macOS, and Linux, and it’s also designed to be used with Azure SQL Database, and Azure SQL Data Warehouse.

Here I explain how to install SQLOPS onto a Mac, then how to use it to connect to SQL Server.

What is the Third Manifesto?

January 21, 2026October 3, 2017 by Ian

The Third Manifesto is a detailed proposal for the future direction of data and database management systems (DBMSs).

Written by C.J. Date and Hugh Darwen, The Third Manifesto can be viewed as a blueprint for the design of future DBMSs, as well as any language designed to interface with them.

How to Install SQL Server on a Mac

January 16, 2026July 30, 2017 by Ian

Here I’ll show you how to get SQL Server up and running on your Mac in less than half an hour. And the best part is, you’ll have SQL Server running locally without needing any virtualization software.

Back in the old days (prior to SQL Server 2017), if you wanted to run SQL Server on your Mac, you first had to create a virtual machine (using VirtualBox, Parallels Desktop, VMware Fusion, or Bootcamp), then install Windows onto that VM, then finally SQL Server. This is still a valid option depending on your requirements (here’s how to install SQL Server on a Mac with VirtualBox if you’d like to try that method).

But these days you can now install SQL Server directly on to a Linux machine. And because macOS is Unix based (and Linux is Unix based), you can run SQL Server for Linux on your Mac. The way to do this is to run SQL Server on Docker.

How to Export the results of a Query using MySQL Workbench

February 14, 2020June 24, 2016 by Ian

You can use MySQL Workbench to run a query, then export the results of that query to a file.

To do this:

Run the query
Click Export on the Results Grid menu bar

How to Save a MySQL Query Result to a .CSV File

February 14, 2020June 24, 2016 by Ian

You can save a query result to a .CSV file by using the SELECT ... INTO OUTFILE statement.

You specify the name/location of the file as well as other options, such as field terminators, line terminators, etc.

NoSQL Database Types

June 24, 2016 by Ian

NoSQL databases are often categorised under four main types. Some databases are a mix between different types, but in general, they fit under the following main categories.

What is a Column Store Database?

February 14, 2023June 23, 2016 by Ian

A column store database is a type of database that stores data using a column oriented model.

A column store database can also be referred to as a:

Column database
Column family database
Column oriented database
Wide column store database
Wide column store
Columnar database
Columnar store

What is a Document Store Database?

January 1, 2026June 22, 2016 by Ian

A document store database (also known as a document-oriented database, aggregate database, or simply document store or document database) is a database that uses a document-oriented model to store data.

Document store databases store each record and its associated data within a single document. Each document contains semi-structured data that can be queried against using various query and analytics tools of the DBMS.

What is a Key-Value Database?

February 14, 2023June 21, 2016 by Ian

A key-value database (also known as a key-value store and key-value store database) is a type of NoSQL database that uses a simple key/value method to store data.

The key-value part refers to the fact that the database stores data as a collection of key/value pairs. This is a simple method of storing data, and it is known to scale well.

What is NoSQL?

February 2, 2026June 20, 2016 by Ian

NoSQL is a term that refers loosely to a particular type of database model, or database management system (DBMS).

NoSQL is a very broad term that doesn’t refer to one particular database model. Rather, it refers to a whole variety of different models that don’t fit into the relational model.

Although NoSQL databases have been around since the 1960s, it wasn’t until the early 2000s that the NoSQL approach started to pick up steam, and a whole new generation of NoSQL systems began to hit the market.