SQL Server

Hans-Petter Halvorsen

What is SQL Server?

SQL Server is a Database System from Microsoft. SQL Server comes in different editions, for basic, personal use SLQ Server Express is recommended because it is simple to use and it is free. Latest version is SQL Server 2019.

 

Download Software:

Download SQL Server Express Edition + Management Studio (You need to install both)

SQL Server Installation - Step by Step (In this guide SQL Server 2016 is used, but the installation process is almost identical in SQL Server 2019.

 

Introduction

Introduction to SQL Server:

 

Views and Stored Procedures

Database Views and Stored Procedures:

 

PowerPoint used in the Video

 

Database Development

Database Development:

 

PowerPoint used in the Video

Download Database Script Generator used in the Video. You need LabVIEW or LabVIEW Run-Time Engine (free)

 

Database Scripts

Database Scripts:

 

PowerPoint used in the Video + Database used in the Video

Download Database Script Generator used in the Video. You need LabVIEW or LabVIEW Run-Time Engine (free)

 

SQL Server and Python

Python is a fairly old programming language but has become increasingly popular in the age of Internet of Things.

Python and SQL Server (YouTube) + PowerPoint (PDF)

 

Database and SQL Server Resources

Below you will find more interesting Database and SQL Server resources


ERwin

Database modelling with ERwin

Database Systems

Database Systems resources



Datalogging and Monitoring

Datalogging and Monitoring Examples

Datbase Communication in LabVIEW

You can easily connect and communicate with a Database from LabVIEW