SQL Server

Databases are the primary containers for your SQL Server relational database objects. Some of the main relational database objects that are contained in SQL Server databases include: tables, schema, indexes, views, logins, security and roles. You can create a SQL database plus there are a number of built-in SQL system databases including the master, model, msdb and tempdb databases. Technically, SQL Server supports a…

Michael Simmons serves up five simple steps for getting started with SQL Server as an IT administrator in his new article series.

Once you have created a user database, you can begin to create tables using the SQL CREATE TABLE statement. Databases typically have many different tables. If you haven’t yet created your first database in SQL Server, check out this article on Petri about how to create a SQL database using the SQL CREATE DATABASE statement. Tables are structures…

Tables are one of the core components of every relational database system and SQL Server is no different. Tables store the data that the relational database engine uses for queries, reports, and other operations. In this article, I’ll show you how to modify data from a SQL Server table using T-SQL INSERT, T-SQL UPDATE, T-SQL…

SQL Server is Microsoft’s premier enterprise database platform. But in today’s world of rapid-fire releases and continuous updates, the new SQL Server 2022 release seems like it has been a long time in coming. But it includes some great new features. SQL Server 2019 was the last major release of SQL Server. With every release,…

In this SQL Server Management Studio tutorial (SSMS), I will show you the primary database management and development capabilities provided by the tool. Microsoft SQL Server Management Studio (SSMS) is the primary management and development tool for SQL Server and has been since its release back with SQL Server 2000. SSMS provides a graphical interface…

SQL Server sample databases can be very useful for learning new techniques or trying out various samples of code. In this article, I’ll detail what you can do with the main SQL Server sample databases including Northwind, AdventureWorks, and WideWorldImporters. I’ll also show you how to find these SQL Server sample databases and install them….

Microsoft’s SQL Server Management Studio (SSMS) is the primary tool for working with SQL Server databases. In this article, I’ll guide you through the steps you need to follow to download and install SQL Server Management Studio on your PC. What is SQL Server Management Studio? SQL Server Management Studio provides an integrated environment that…

Starting with SQL Server 2017, Microsoft has supported SQL Server on Linux, which has the same underlying database engine as the Windows version. In this article, I’ll show you how to install SQL Server on Linux, as well as Azure Data Studio. The most recent release of SQL Server is SQL Server 2022, which offers…