SQL Server

LATEST

• 

  • SQL Server
  • Linux

  How to Install SQL Server Containers on Linux Using Docker

  Microsoft has officially supported running SQL Server in a container since SQL Server 2017. Today, most support is for SQL…

  • Michael Otey
  • Aug 11, 2023
• 

  • SQL Server

  SQL Server Essentials: Downloading and Installing SQL Server Data Tools for Visual Studio

  SQL Server Data Tools for Visual Studio 2022 (SSDT) is the modern replacement for Business Intelligence Development Studio (BIDS), which…

  • Michael Otey
  • Last Updated: Jun 07, 2025
• 

  • SQL Server

  SQL Server Essentials: Using SQL COALESCE

  When working with SQL Server databases, the SQL COALESCE expression is commonly used to detect null values and provide a…

  • Michael Otey
  • Last Updated: Jul 19, 2023
• 

  • SQL Server

  SQL Server Essentials: Using the SQL LIKE Operator

  The T-SQL LIKE operator is one of the most useful additions to the SQL SELECT statement. The latter retrieves a…

  • Michael Otey
  • Jul 03, 2023
• 

  • SQL Server

  SQL Server Essentials: Installing SQL Server Management Studio and Azure Data Studio

  Microsoft’s SQL Server Management Studio (SSMS) is the primary tool for working with SQL Server databases. In this article, I’ll…

  • Michael Otey
  • Last Updated: Oct 04, 2023
• 

  • SQL Server

  SQL Server Essentials: Using SQL Cross Joins

  SQL CROSS JOIN queries are used to generate a paired combination of each row of the first table with each…

  • Michael Otey
  • Jun 07, 2023
• 

  • SQL Server

  SQL Server Essentials: How to Create a Simple Backup Job in SQL Server

  Creating backups is one of the most important duties of an SQL Server database administrator, and there are a number…

  • Michael Otey
  • Last Updated: Jun 06, 2025
• 

  • SQL Server

  SQL Server Essentials: Using SQL Joins

  In relational databases like SQL Server, the SQL JOIN statement is used to query, connect and retrieve data from multiple…

  • Michael Otey
  • Last Updated: Jun 12, 2023
• 

  • SQL Server

  SQL Server Essentials: Using SQL SELECT and the WHERE and HAVING Clauses to Retrieve Data

  In this article, I’ll cover the basics of using the SQL SELECT statement to retrieve data from one or more…

  • Michael Otey
  • Last Updated: Aug 24, 2023
• 

  • SQL Server

  SQL Server Essentials: SQL Server Sample Databases

  SQL Server sample databases can be very useful for learning new techniques or trying out various samples of code. In…

  • Michael Otey
  • Last Updated: Jul 29, 2025
• 

  • SQL Server

  How to Install SQL Server 2022

  SQL Server 2022, the latest release of Microsoft’s relational database product is nearing the finish line. In this guide, we’ll…

  • Michael Reinders
  • Last Updated: Jun 27, 2025
• 

  • SQL Server
  • Information Security

  Microsoft Introduces SQL Server Information Protection Sensitivity Labels

  Microsoft has announced a new data protection feature for its SQL Server tool. The new capability enables organizations to classify…

  • Rabia Noureen
  • Last Updated: Jul 22, 2022