JosiahSiegel

SELECT 
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server, 
msdb.dbo.backupset.user_name,
msdb.dbo.backupset.database_name, 
cast(msdb.dbo.backupset.backup_start_date as datetime2(0)) as 'backup_start_date', 
cast(msdb.dbo.backupset.backup_finish_date as datetime2(0)) as 'backup_finish_date', 
cast(msdb.dbo.backupset.expiration_date as datetime2(0)) as 'expiration_date', 
CASE msdb..backupset.type 
WHEN 'D' THEN 'Database' 
WHEN 'L' THEN 'Log' 

JosiahSiegel

SELECT  
   A.[Server],  
   B.user_name,
   A.last_db_backup_date,  
   B.backup_start_date,  
   B.expiration_date, 
   B.backup_size,  
   B.logical_device_name,  
   B.physical_device_name,   
   B.backupset_name, 

shark0der

# install java
apt-get install -y software-properties-common
apt-add-repository -y ppa:webupd8team/java
apt-get update
apt-get install -y oracle-java8-installer

# download latest android sdk
# http://developer.android.com/sdk/index.html#Other
cd /opt
wget http://dl.google.com/android/android-sdk_r24.4.1-linux.tgz

mattantonelli

# Generate your SSH key pair with the RSA algorithm
ssh-keygen -t rsa -C [email protected]

# Add the key pair to ssh-agent, if you are using it (optional)
ssh-add

# Copy public key to SSH destination
ssh-copy-id login@destination

# Show your public key

mattantonelli

Good Commit Messages

A good commit message helps both you and your collaborators better understand your code. A series of good messages will create a well-documented history as your code evolves. This also makes it easier for someone to pick up where you left off.

Jump to:

1. Summary
2. Description
3. Full message
4. Branch

JosiahSiegel

SELECT DB_NAME(database_id), name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
GO

JosiahSiegel

Grafana MySQL & Linux Monitoring - No Docker

Server Install

Install Prometheus

wget https://github.com/prometheus/prometheus/releases/download/v1.3.1/prometheus-1.3.1.linux-amd64.tar.gz

tar xvfz prometheus-1.3.1.linux-amd64.tar.gz
sudo mv prometheus-1.3.1.linux-amd64 prometheus

ernsheong

Access macOS localhost from IE or Edge within Parallels Desktop

This issue is so infuriating that I'm going to take some time to write about it.

1. MOST IMPORTANT. Your local development server must be bound to IP address 0.0.0.0. Some do this by default, but many don't. You need to make sure that you run your local server with correct IP bindings. You may need to provide additional flags to your serve commands e.g. polymer serve --hostname domain.local, hugo serve --bind 0.0.0.0. If you use a named domain like domain.local, it has to be defined in /etc/hosts and pointing at 0.0.0.0.

2. My Parallels setting is using Shared Network, nothing special there.

3. Open macOS Terminal and type ifconfig. Look for the value under vnic0 > inet. It is typically 10.211.55.2.