Category: SQL

InSQL
Have you ever installed an instance of SQL Server onto a new workstation or server and subsequently realised that you forgot to rename the machine first? In these cases, you’ll likely have installed both SQL Server and SSMS (SQL Server Management Studio). After launching SSMS you happen to notice that the ‘Server name’ field is…
InSQL
Setting up SQL Server Database Mail is relatively simple when using SQL Server Management Studio, thanks to the graphical setup wizard it provides for most SQL Server editions. However, SQL Server Express, the free edition of SQL Server, does not offer the facility to configure Database Mail via a user interface. Thankfully, once you understand…
InSQL
Having the facility to send emails directly from your database engine is a hugely useful feature and this is exactly what the Database Mail functionality in SQL Server provides. With Database Mail, you can send email alerts when specific database events occur, or send query results and reports to users automatically on a scheduled basis….