If you’re using Database Mail in SQL Server, you’ll probably want to check your configuration settings at some stage.
You can do this by executing the sysmail_help_configure_sp
stored procedure in the msdb
database.
If you’re using Database Mail in SQL Server, you’ll probably want to check your configuration settings at some stage.
You can do this by executing the sysmail_help_configure_sp
stored procedure in the msdb
database.
If you’re trying to check an advanced configuration option in SQL Server, but you get an error, you might find the following helpful.
Continue readingIn SQL Server, you can use a logon trigger to audit and control server sessions, such as track login activity, restrict logins to SQL Server, or limit the number of sessions for a specific login.
This article provides an example of using a logon trigger to limit the number of simultaneous sessions for a specific login.
Continue readingIn SQL Server, you can use the sys.server_trigger_events
catalog view to return a list of server trigger events.
More specifically, this view contains one row for each event for which a server-level (synchronous) trigger fires.
Continue readingIn SQL Server, you can use the sys.server_triggers
catalog view to return a list of server triggers.
More specifically, this view contains the set of all server-level DDL triggers with object_type of TR or TA.
For CLR triggers, the assembly must be loaded into the master
database.
You can use the sys.triggers
catalog view to return a list of triggers in a database in SQL Server.
This view contains a row for each object that is a trigger, with a type of TR or TA.
Continue readingSome database tables include a “last modified” column, which stores the date and time that the row was last updated. Each time the row is updated, the date is updated to reflect the date and time of that update.
In SQL Server, you can use a trigger to perform this update.
A trigger is a special type of stored procedure that automatically runs when an event occurs in the database server.
You can use the CREATE TRIGGER
statement to create a trigger when using T-SQL. This statement can be used to create a DML, DDL, or logon trigger.
In PostgreSQL, you can use the OVERLAPS
operator to test for overlapping time periods.
The function returns true when two time periods (defined by their endpoints) overlap, and false when they do not overlap.
Continue readingTo format a number as currency in Postgres, you can either convert it to the money data type, or use to_char()
to convert it to text that includes the appropriate currency symbol.
This obviously assumes that the number isn’t already stored using the money type.
Below are examples of each of these options.
Continue readingPostgreSQL includes three functions that allow you to delay the execution of the server process. the execution of a statement.
In other words, you can run a statement and have it pause half way through, before continuing on its merry way.
The three functions are:
These are all very similar, but they work in slightly different ways.
Below are examples of each one.
Continue reading