7-Zip command line to zip all the content of a folder

7z a archivename pathtofolder *

SQl SERVER: How to set recovery model to SIMPLE for all databases

Steps on how to set recovery model to SIMPLE for all databases 

Step 1. Run script

SELECT 'ALTER DATABASE ' + [Name] + ' SET RECOVERY SIMPLE'
FROM sys.databases
WHERE recovery_model_desc = 'FULL'

Step 2. Copy output and execute

SQl SERVER: How to set recovery model to FULL for all databases

Steps on how to set recovery model to FULL for all databases 

Step 1. Run script

SELECT 'ALTER DATABASE ' + [Name] + ' SET RECOVERY FULL'
FROM sys.databases
WHERE recovery_model_desc = 'SIMPLE'

Step 2. Copy output and execute

New T-SQl String Functions in SQL SERVER 2016, 2017

1. STRING_SPLIT
2. TRANSLATE
3. STRING_AGG
4. TRIM
5. FORMATMESSAGE
6. STRING_ESCAPE

How to Shrink MS SQL Server Transaction Logs

Using T-SQL

ALTER DATABASE [db name]
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE('log_file_name.ldf', 100)--whatever size you need in MB's 
GO
ALTER DATABASE [db name]
SET RECOVERY FULL

To Find Log file name use below T-SQL

use [db name]
GO
select name as [log_file_name] from sys.database_files

where [type_desc] = 'LOG'