Here, I demonstrate how to add a Database Mail account to an existing Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Add a Database Mail Account to a Profile (T-SQL).
Continue readingThis article demonstrates how to create a Database Mail account in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see How to Create a Database Mail Account in SQL Server (T-SQL).
Continue readingThis article explains how to create a Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see How to Create a Database Mail Profile in SQL Server (T-SQL).
Continue readingThis article shows you how to setup Database Mail for the first time on a new SQL Server installation.
As with many things SQL Server, you can configure Database Mail via the SSMS GUI, or you can do it using T-SQL code.
This article covers the SSMS GUI option. If you’re interested in the T-SQL option, see How to Send Email in SQL Server (T-SQL).
Continue readingAzure Data Studio is a graphical tool for managing databases.
It is available on Windows, MacOS, and Linux. On Linux it’s available on Red Hat (RHEL), SUSE Linux Enterprise Server, and Ubuntu.
Below is a step-by-step guide to installing Azure Data Studio on Ubuntu 18.04 via the GUI. Screenshots included.
I’ve also provided the commands for installation via the command-line in case you prefer that method.
Continue readingYou can install Azure Data Studio on to Red Hat either via the GUI or command-line.
This article outlines both methods. I’ve included screenshots for the GUI installation.
Continue readingIf you’ve installed SQL Server on your Red Hat machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are a couple of good options for helping you perform the most common tasks.
Continue readingIf you’ve installed SQL Server on your SUSE machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are good options for performing the most common tasks.
Continue readingIf you’ve installed SQL Server on your Ubuntu machine, you’ll need some sort of tool to connect to it.
Installing the sqlcmd and bcp utilities is good place to start.
Continue readingSSMS (SQL Server Management Studio) is a graphical tool that you can use to administer SQL Server.
SSMS used to be bundled with SQL Server, but that is no longer the case. You must now install it separately.
This article shows you how to install SSMS (including screenshots).
Note that SSMS is only available for Windows machines. If you’re using a non-Windows machine (such as Mac or Linux), try Azure Data Studio or perhaps DBeaver.
Also note that Azure Data Studio is now included when you install SSMS (starting with SSMS 18.7).
Continue reading