Tag: How to
This tag groups together all the SQL Server “How to” artciles.
-
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
-
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.
Latest Articles
