zommarin

DECLARE @dbname sysname, @days int
SET @dbname = NULL --substitute for whatever database name you want (or just NULL to list all databases)
SET @days = -30 --previous number of days, script will default to 30
SELECT
 rsh.destination_database_name AS [Database],
 rsh.user_name AS [Restored By],
 CASE WHEN rsh.restore_type = 'D' THEN 'Database'
  WHEN rsh.restore_type = 'F' THEN 'File'
  WHEN rsh.restore_type = 'G' THEN 'Filegroup'
  WHEN rsh.restore_type = 'I' THEN 'Differential'

zommarin

Various command line tools that list contents of DLLs etc:

ildasm.exe /text .\bin\OpixTool.exe | clip

zommarin

Command line parsing

https://commandline.codeplex.com/ https://github.com/gsscoder/commandline - NuGetId: CommandLineParser

zommarin

;WITH T AS (
	SELECT 
		STEPNO,
		Row_Number() OVER (PARTITION BY JOBNAME ORDER BY STEPNO) AS RN
		FROM STEP
		WHERE BR = '00'
	)
UPDATE T
	SET
		STEPNO = RN

zommarin

PowerShell
SideBarEnhancements
SublimeCodeIntel

zommarin

https://gist.github.com/leeroybrun/9482703

http://www.fibaro.com/support - Standard support site. Got some materials http://www.fibarouk.co.uk/support/ - UK support site, More materials. http://www.fibarouk.co.uk/support/lua/brief-introduction-lua/ - Intro till Lua https://developer.fibaro.com/ - Registration required. Is in build-up state currently. Have some Lua and JSON API resources. http://www.lua.org/docs.html - Lua docs http://zwave-store.co.uk/about-z-wave/the-fibaro-system/intro-to-fibaro-lua-code

zommarin

/api/panels/event?from=1418655960&to=1424213940&type=time

/api/panels/history?from=1418655960&to=1424213940&type=time

zommarin

#
# Misc good to have commands when using git
#

# Setup user
git config --global user.name "First Last"
git config --global user.email first.last@domain.com

# Setup useful aliases
git config --global alias.ci commit 

zommarin

--
-- Count rows in all tables, display tables with rows
--

CREATE TABLE #T (
	name NVARCHAR(255),
	[rows] INT,
	reserved NVARCHAR(255),
	data NVARCHAR(255),
	index_size NVARCHAR(255),

zommarin

SELECT s.name, o.name, o.type, o.type_desc, s.schema_id
	 FROM sys.objects AS o 
	 INNER JOIN sys.schemas AS s ON o.schema_id = s.schema_id
	 WHERE s.name NOT IN ( 'dbo', 'sys' )