Here I’ll show you how to get SQL Server 2017 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.
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.
Starting with SQL Server 2017, 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.
So let’s go ahead and install Docker. Then we’ll download and install SQL Server.
Continue reading “How to Install SQL Server on a Mac”
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
Continue reading “How to Export the results of a Query using MySQL Workbench”
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.
Continue reading “How to Save a MySQL Query Result to a .CSV File”
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.
Continue reading “NoSQL Database Types”
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
Column store databases are considered NoSQL databases, as they use a different data model to relational databases.
Continue reading “What is a Column Store Database?”
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.
Continue reading “What is a Document Store Database?”
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.
Continue reading “What is a Key-Value Database?”
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.
Continue reading “What is NoSQL?”
In database systems, ACID (Atomicity, Consistency, Isolation, Durability) refers to a standard set of properties that guarantee database transactions are processed reliably.
ACID is especially concerned with how a database recovers from any failure that might occur while processing a transaction.
An ACID-compliant DBMS ensures that the data in the database remains accurate and consistent despite any such failures.
Continue reading “What does ACID mean in Database Systems?”
This article lists the SQL
DROP TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
Continue reading “SQL DROP TABLE Syntax – Listed by DBMS”