seancoyne

SELECT 
	@@SERVERNAME as InstanceName
	, DB_NAME() as DatabaseName
	, ISNULL(s.name+'.'+t.NAME, '**TOTAL**')  AS TableName
	, SUM(p.rows) AS RowCounts
	--, SUM(a.total_pages) * 8 AS TotalSpaceKB
	, SUM(a.total_pages) * 8/1024.0 AS TotalSpaceMB
	, SUM(a.total_pages) * 8/1024.0/1024.0 AS TotalSpaceGB
	, SUM(a.used_pages) * 8/1024.0 AS UsedSpaceMB
	, (SUM(a.total_pages) - SUM(a.used_pages)) * 8/1024.0 AS UnusedSpaceMB

seancoyne

{
	"folders": [
		{
			"name": "Some Name",
			"path": ".",
			"folder_exclude_patterns": [
				"projects/siteName/www/cache"
			]
		}
	],

seancoyne

/* jshint node: true */
(function(){

	"use strict";

	var gulp = require("gulp");

	gulp.task("testbox", function(done){
  
    // NOTE: this example assumes you have a .testbox-runnerrc file holding your config settings

seancoyne

/* global module */
(function(module){

	"use strict";

	module.exports = function(grunt) {

		grunt.loadNpmTasks('grunt-shell');

		grunt.initConfig({

seancoyne

component {

	this.name = "myapp_api_test";

	this.mappings = {
		"/testbox" = expandPath("/myapp/testbox"),
		"/model" = expandPath("/myapp/api/model"),
		"/tests" = expandPath("/myapp/api/tests"),
		'/api' = expandPath('/myapp/api')
	};

seancoyne

git add `git diff -w |grep '^+++' |cut -c7-`

seancoyne

-has:userlabels -in:sent -in:chat -in:draft -in:inbox

seancoyne

select d1.tablename, d1.rowcnt, d2.typename, d2.num from (

SELECT 
ta.name TableName
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa
ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc
ON ta.schema_id = sc.schema_id

seancoyne

#!/usr/bin/env bash

# Compile mod_perl for Apache 2.4 on Mac OS X 10.10 Yosemite
# http://blog.n42designs.com/blog/2014/10/23/compiling-mod-perl-for-apache-2-dot-4-on-os-x-10-dot-10-yosemite/

# NOTE: make sure you have XCode 6.1 & Command Line Tools installed first

# ask for password up front
sudo -v

seancoyne

#!/usr/bin/env bash

# change to proper directory
cd /Applications/OneDrive.app/Contents/Resources/

# back up the files
sudo mkdir icon-backups
sudo cp StatusIcon_*.tiff icon-backups/

# replace all versions with the "selected" icon