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 SQL Server Express is recommended because it is simple to use and it is free.

 

Download Software:

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

SQL Server 2022 Express Installation (YouTube)

 

Note! Select "Custom" installation when installing SQL Server Express and then it is important that you select "Mixed Mode" during the installation wizard, and make sure to remember the "sa" Password (write it down). "sa" is short for System Administrator.

 

Introduction

Introduction to SQL Server:

 

Structured Query Language (SQL)

SQL Server and Structured Query Language (SQL) (YouTube) + PowerPoint (PDF)

 

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