Author: Vyas Kondreddi
-
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.
Latest Articles
