Skip to main content

Posts

Showing posts from March, 2022

What is Duress Code, how it works?

A duress code is a covert distress signal used by an individual who is being coerced by one or more hostile persons  It is used to warn others that they are being forced to do something against their will. Sometimes referred to as a “ Panic Alarm ,” but technically Panic and Duress are quite different. A duress alarm acts as a silent notification On the other hand, a panic alarm is intended to provide notification not only to local building security and/or a central station but more importantly the personnel in the immediate vicinity.  Duress in Biometrics/Access Control When there is a question, how to make biometric access-control systems more secure? The answer is to get the option of a Duress Code .  In Biometrics and access control Duress is usually used with a finger and it's the main method single that can be used for duress. Some home and property alarm systems have duress PINs too so that the pin can also be used to send the duress signal. A similar mecha...

How to take MS SQL Database Backup All At once | How to take all Database Backup from MS SQL Server

MS SQL is the most used database nowadays, we may have or maybe be in future, faced the issue of database backup, database backup with one by one single database is quite simple, you just have to right-click then go to Task then select backup and follow the instructions. But suppose you have 100s of databases that you need to backup  now one by one process is way difficult because you can't do the selection process every time to take the backup this will take years,  So how to take backup then? Use the below script to take any number of database backups in any MS SQL database. DECLARE @path VARCHAR(500) DECLARE @name VARCHAR(500) DECLARE @filename VARCHAR(256) -- 1. Setting the backup path SET @path = 'E:\Database_Backup_11022021'   -- 2. Defining cursor operations   DECLARE db_cursor CURSOR FOR   SELECT name  FROM master.dbo.sysdatabases  WHERE name  NOT in   ('Master')  --3. Initializing cursor operations OPEN d...