Monthly Archives: January 2019

Coding, Windows

Simple script to backup all SQL Server databases

Posted on by Dan Tascher 
DECLARE @name VARCHAR(50) -- database name  
DECLARE @path VARCHAR(256) -- path for backup files  
DECLARE @fileName VARCHAR(256) -- filename for backup  
DECLARE @fileDate VARCHAR(20) -- used for file name
 
-- specify database backup directory
SET @path = 'C:\Backup\'  
 
-- specify filename format
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) 
 
DECLARE db_cursor CURSOR READ_ONLY FOR  
SELECT name 
FROM master.dbo.sysdatabases 
WHERE name NOT IN ('master','model','msdb','tempdb')  -- exclude these databases
 
OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @name   
 
WHILE @@FETCH_STATUS = 0   
BEGIN   
   SET @fileName = @path + @name + '_' + @fileDate + '.BAK'  
   BACKUP DATABASE @name TO DISK = @fileName  
 
   FETCH NEXT FROM db_cursor INTO @name   
END   

 
CLOSE db_cursor   
DEALLOCATE db_cursor
Movies

Order to watch Marvel Cinematic Universe

Posted on by Dan Tascher
21
Jan

Credit to jmsturn

MCU Viewing Order

  • Captain America: The First Avenger
  • Iron Man
  • Iron Man 2
  • Incredible Hulk
  • Thor
  • Avengers
  • Thor: The Dark World
  • Guardians of the Galaxy
  • Guardians of the Galaxy Vol. 2
  • Iron Man 3
  • Captain America: The Winter Soldier
  • Avengers: Age of Ultron
  • Ant Man
  • Captain America: Civil War
  • Black Panther
  • Spider-Man: Homecoming
  • Ant Man & Wasp
  • Dr Strange
  • Thor: Ragnarok
  • Avengers: Infinity War
Coffee

Simple Coffee Pour Over Instructions

Posted on by Dan Tascher
16
Jan


How much coffee and water?

General Rule: Start with 15:1 (water:coffee), adjust from there to preference.

Example:

Standard cup 18g of coffee and 270g of water.

How Hot?

Medium roasts and light roasts I brew at about 185℉, coffee tastes best to drink at 135℉.

How Long?

Total brew time of 3 minutes. With 30 seconds at the start for brew time.

Grinding Notes:

With most coffees I start at around salt sized grind and adjust from there to match the desired brew time. If it brews too fast, go finer. Too slow? Then grind corser.

Steps:

  1. Heat the water (185℉, if you don’t have a thermometer then boil it and remove from heat for 30 seconds).
  2. Put the filter in the cone, and rinse it.
  3. Add the coffee to the filter. Tap side to settle it.
  4. Bloom the coffee (Add twice the amount of water by weight as you are brewing coffee).
  5. Wait 30 seconds, optionally you can stir it during the bloom to be sure you get all of it wet.
  6. Add water, starting from the center and wetting evenly.
    1. First 2 pours to about half the total desired amount.
    2. Then the remainder in 2 – 4 additional pours
    3. Example, for 18g of coffee: 70g, wait (until it moves mostly through), 70g, wait, 65g, wait, 65g. Will get you a total added water of 270g.
  7. Ideally stop at 3 minutes and your expected total weight. Make a note of what you might need to adjust to get to the desired time and weights.
  8. Wait for it to cool to drinking temp.
  9. Enjoy.
    1. Make note of if you need to adjust how extracted it is for next time. If it’s sour, it’s probably under extracted, if it’s bitter it’s probably over extracted.

Adjustment Notes:

Hotter brew water temps will increase extraction. Finer grinds will increase extraction. Use this info to adjust your brew to match the coffee.

Windows

Bypass Bitlocker encryption requirement for removable devices

Posted on by Dan Tascher

disable check 

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Policies\Microsoft\FVE]
"RDVDenyWriteAccess"=dword:00000000

enable check

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Policies\Microsoft\FVE]
"RDVDenyWriteAccess"=dword:00000001