Here, I demonstrate how to delete 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 Delete a Database Mail Profile (T-SQL).
Continue readingDelete a Database Mail Account (SSMS)
Here, I demonstrate how to delete 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 Delete a Database Mail Account (T-SQL).
Continue readingUpdate a Database Mail Profile (SSMS)
Here, I demonstrate how to update 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 Update a Database Mail Profile (T-SQL).
Continue readingUpdate a Database Mail Account (SSMS)
Here, I demonstrate how to update 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 Update a Database Mail Account (T-SQL).
Continue readingHow to Install SQL Server
SQL Server used to be available on Windows machines only. If you didn’t have Windows, you didn’t install SQL Server.
Now, SQL Server is available on Windows, Linux, and even Mac (via Docker containers).
This obviously means that an article titled “how to install SQL Server” is not as simple as it used to be!
Continue readingAdd a Database Mail Account to a Profile (SSMS)
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 readingCreate a Database Mail Account (SSMS)
This 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 readingCreate a Database Mail Profile (SSMS)
This 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 readingHow to Setup Database Mail in SQL Server (SSMS)
This 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 readingMerge Two Partitions into One in SQL Server (T-SQL)
In SQL Server, you can use the ALTER PARTITION FUNCTION to merge two partitions into one partition.
To do this, use the MERGE RANGE argument, while providing the boundary value of the partition to drop.
This operation drops the partition and merges any values that exist in the partition into a remaining partition.
Continue reading