Author Archives: Michael Otey

How to Install SQL Server Containers on Linux Using Docker

Posted on by

Microsoft has officially supported running SQL Server in a container since SQL Server 2017. Today, most support is for SQL Server on Linux containers, and Microsoft only supports SQL Server 2022 on Linux containers for production workloads. In this article, I’ll show you how to configure SQL Server Docker containers on Linux. Why would you…

The post How to Install SQL Server Containers on Linux Using Docker appeared first on Petri IT Knowledgebase.

Continue reading How to Install SQL Server Containers on Linux Using Docker→

SQL Server Essentials: How to Install SQL Server 2022 and Azure Data Studio on Linux

Posted on by

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…

The post SQL Server Essentials: How to Install SQL Server 2022 and Azure Data Studio on Linux appeared first on Petri IT Knowledgebase.

Continue reading SQL Server Essentials: How to Install SQL Server 2022 and Azure Data Studio on Linux→

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

Posted on by

SQL Server Data Tools for Visual Studio 2022 (SSDT) is the modern replacement for Business Intelligence Development Studio (BIDS), which was introduced with SQL Server 2005. SQL Server Data Tools for Visual Studio 2022 is now delivered as a part of Visual Studio 2022, and it enables you to create and modify new projects for…

The post SQL Server Essentials: Downloading and Installing SQL Server Data Tools for Visual Studio appeared first on Petri IT Knowledgebase.

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

SQL Server Essentials: Using SQL COALESCE

Posted on by

When working with SQL Server databases, the SQL COALESCE expression is commonly used to detect null values and provide a fallback or default value when dealing with nullable columns or expressions in SQL queries. It’s like a syntactic shortcut for the CASE expression, and it’s typically used to make subsequent calculations easier. In this article,…

The post SQL Server Essentials: Using SQL COALESCE appeared first on Petri IT Knowledgebase.

Continue reading SQL Server Essentials: Using SQL COALESCE→

SQL Server Essentials: Using the SQL LIKE Operator

Posted on by

The T-SQL LIKE operator is one of the most useful additions to the SQL SELECT statement. The latter retrieves a result set, and you can easily filter the results using equality operators and the WHERE clause to select certain specific conditions. But what about those times when you might want to select rows that are…

The post SQL Server Essentials: Using the SQL LIKE Operator appeared first on Petri IT Knowledgebase.

Continue reading SQL Server Essentials: Using the SQL LIKE Operator→

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

Posted on by

Microsoft’s SQL Server Management Studio (SSMS) is the primary tool…

The post SQL Server Essentials: Installing SQL Server Management Studio and Azure Data Studio appeared first on Petri IT Knowledgebase.

Continue reading SQL Server Essentials: Installing SQL Server Management Studio and Azure Data Studio→