Skip to content

Instantly share code, notes, and snippets.

### Keybase proof
I hereby claim:
* I am bdunnette on github.
* I am bdunnette (https://keybase.io/bdunnette) on keybase.
* I have a public key ASDIoA4-Rp8zLIKLNq4I_5ea2RXJ6hJydm4uS5sZKrhyFgo
To claim this, I am signing this object:
net localgroup Administrators Aperio /add
net stop MSSQLSERVER
net stop ApDataService
net start MSSQLSERVER
net start ApDataService
net localgroup Administrators Aperio /delete
function postToot(text) {
host_instance = 'https://botsin.space'
token = 'your-token-goes-here'
var data = {
'status': text,
'visibility' : 'public'
};
var options = {
go get -u -v github.com/therecipe/qt/cmd/...
FOR /F "tokens=* USEBACKQ" %%F IN (`go env GOPATH`) DO (
SET GOPATH=%%F
)
ECHO %GOPATH%
mkdir %GOPATH%\src\github.com\muesli
cd %GOPATH%\src\github.com\muesli
git clone https://github.com/muesli/telephant.git
cd telephant
go get -u -v
@bdunnette
bdunnette / bioformats-extract-tile.py
Last active March 17, 2022 09:02
Example of extracting a tile from a BioFormats-readable file (e.g. Zeiss CZI) using python
# Requires both javabridge and python-bioformats:
# pip install python-bioformats
# On e.g. Ubuntu you may need to add JAVA_HOME to /etc/profile:
# JAVA_HOME=/usr/lib/jvm/default-java
# PATH=$PATH:$HOME/bin:$JAVA_HOME/bin
# export JAVA_HOME
# export JRE_HOME
# export PATH
#!/bin/sh
sed -i "/^AWS_ACCESS_KEY_ID*/d" ${PWD##*/}/settings.py
sed -i "/^AWS_SECRET_ACCESS_KEY/d" ${PWD##*/}/settings.py
'''Example script to generate text from Nietzsche's writings.
At least 20 epochs are required before the generated text
starts sounding coherent.
It is recommended to run this script on GPU, as recurrent
networks are quite computationally intensive.
If you try this script on new data, make sure your corpus
has at least ~100k characters. ~1M is better.
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [Core].[Stain] WITH (NOLOCK)" > S:\Images\stains.csv
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [Core].[DataGroup] WITH (NOLOCK)" > S:\Images\datagroups.csv
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [dbo].[Case] WITH (NOLOCK)" > S:\Images\cases.csv
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [dbo].[Project] WITH (NOLOCK)" > S:\Images\projects.csv
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [dbo].[BodySite] WITH (NOLOCK)" > S:\Images\bodysites.csv
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [dbo].[Specimen] WITH (NOLOCK)" > S:\Images\specimens.csv
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [dbo].[Slide] WITH (NOLOCK)" > S:\Images\slides.csv
sqlcmd -S . -d Aperio -E -s, -W -Q "SET NOCOUNT ON; SELECT * FROM [dbo].[Image] WITH (NOLOCK)" > S:\Images\images.csv
USE Aperio
SELECT *
FROM [dbo].[Image]
JOIN [dbo].[Slide] ON Slide.Id=Image.ParentId
LEFT JOIN [dbo].[Specimen] ON Slide.ParentId=Specimen.Id
LEFT JOIN [dbo].[Case] AS CaseStudy ON Specimen.ParentId=CaseStudy.Id
LEFT JOIN [Core].[Stain] ON Slide.StainId=Stain.Id
LEFT JOIN [dbo].[BodySite] ON Slide.BodySiteId=BodySite.Id
WHERE Specimen.DataGroupId = 62
AND Image.CompressedFileLocation != ''
AWS_ACCESS_KEY_ID='id'
AWS_SECRET_ACCESS_KEY='key'
AWS_STORAGE_BUCKET_NAME='zappa-12345678'
AWS_WEBHOST='98765432.execute-api.us-east-1.amazonaws.com'