This article shows you how to view the history of a SQL Server Agent job in Azure Data Studio.
Continue readingCategory: Database Tools
Install the SQL Server Agent Extension on Azure Data Studio
One of the cool things about Azure Data Studio is that you can install extensions to extend its capabilities. One of those extensions is the SQL Server Agent extension.
This extension allows you to do stuff like create jobs, view jobs, view job history, stop/start jobs, etc.
This article shows you how to install the SQL Server Agent extension on Azure Data Studio.
Continue readingWhat Do I Need to Run SQL?
I get it. You’re trying to learn SQL, but they won’t even tell you the most fundamental part – what you need to run SQL!
You’ve got the SQL code… but where do you actually run it? What software program do you need before you can run your SQL query against a database?
If that’s you, all is about to be revealed!
Continue readingHow to Install Azure Data Studio on Ubuntu 20.04
Azure Data Studio is a neat little graphical tool for managing databases.
It’s available on Windows, MacOS, and Linux. On Linux it’s available on Red Hat (RHEL), SUSE Linux Enterprise Server, and Ubuntu.
This tutorial shows you how to install Azure Data Studio on Ubuntu 20.04 via the GUI. Screenshots included.
I’ve also included the commands for installation via the command-line in case you prefer that method.
Continue readingCheck/Change the Compatibility Level of a Database in SQL Server (SSMS)
Here’s a quick tutorial that demonstrates how to check or change the compatibility level of a database using the SQL Server Management Studio (SSMS) graphical user interface (GUI).
If you want to see how to do it in T-SQL, see How to Change the Compatibility Level of a Database using T-SQL.
Continue readingSet a Default Public Profile for Database Mail (SSMS)
When you create a profile in Database Mail, you have the option of making it a private profile or a public profile.
You also have the option of setting it as the default profile.
Continue readingChange the Priority of an Account within a Database Mail Profile (SSMS)
Here, I demonstrate how to change the priority of a Database Mail account within a 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 Change the Sequence Number of an Account in Database Mail (T-SQL).
The priority and the sequence number are the same thing (when you change it with T-SQL you use the @sequence_number parameter).
Remove a Database Mail Account from a Profile (SSMS)
Here, I demonstrate how to remove a Database Mail account from 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 Remove a Database Mail Account from a Profile (T-SQL).
Continue readingDelete a Database Mail Profile (SSMS)
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 reading