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