-
How to send email for free, from SQL Server using Database Mail feature?
No comments on How to send email for free, from SQL Server using Database Mail feature?You can use the Database Mail feature of SQL Server to send emails. Thesse can be ad hoc emails, or could be sent from within
-
How to generate simple or complex passowrds and numeric OTP codes using T-SQL?
Generating random passwords and One Time Passcodes (OTPs) is a pretty common requirement. I am sure you can find several different versions of T-SQL code
-
SQLPing: A PowerShell tool that pings SQL Server rather than a host
As IT professionals and system administrators, we all are familiar with the command line tool Ping. We all use it, all the time, to see
-
How to programmatically check if a port is open from within SQL Server?
As a DBA, you often provision a new database to a user or a team, and provide them with SQL Server connectivity details like the
-
How to check if an SQL Server database is in use?
DBAs often get asked if a particular database is in use, often with a view to dropping any unused databases to save valuable disk space.
