Stefan Steiger ststeiger

😎

Back from holidays

¡ slᴉɐɯǝ ɹnoʎ pɐǝɹ I

ststeiger / Create_FileStreamDb.sql

Last active August 29, 2015 14:13

Create a FileStream-Enabled database


	CREATE DATABASE [Archive] -- CONTAINMENT = NONE
	ON PRIMARY
	(
	NAME = N'Archive'
	,FILENAME = N'C:\data\Archive.mdf'
	-- ,FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MS_SQL_2014\MSSQL\DATA\Archive.mdf'
	,SIZE = 4288KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB
	)
	,FILEGROUP Archive_FileStreamGroup1 CONTAINS FILESTREAM DEFAULT

ststeiger / Create_FileStreamTable.sql

Last active December 30, 2017 11:30

CREATE or ALTER table - FileStream-Enabled


	-- http://msdn.microsoft.com/en-us/library/cc645583.aspx

	CREATE TABLE dbo.MyDataFile
	(
	-- MyUID uniqueidentifier NOT NULL
	-- A table that has FILESTREAM columns must have a nonnull unique column with the ROWGUIDCOL property.
	MyUID uniqueidentifier ROWGUIDCOL NOT NULL UNIQUE
	,MyFile VARBINARY(MAX) FILESTREAM NULL
	);

ststeiger / elementsFromPoint

Last active August 29, 2015 14:15 — forked from osartun/elementsFromPoint

	(function ($, document, undefined) {
	$.extend({
	/**
	* A static jQuery-method.
	* @param {number} x The x-coordinate of the Point.
	* @param {number} y The y-coordinate of the Point.
	* @param {Element} until (optional) The element at which traversing should stop. Default is document.body
	* @return {jQuery} A set of all elements visible at the given point.
	*/
	elementsFromPoint: function(x,y, until) {

ststeiger / elementsFromPoint_SVG.js

Last active August 29, 2015 14:15

elementsFromPoint_SVG


	function elementsFromPoint(x,y, until)
	{
	// until \|\| (until = document.body); // Stop traversing here
	// if (until instanceof $) until = until[0];

	// http://stackoverflow.com/questions/1569775/how-do-i-find-the-dom-node-that-is-at-a-given-x-y-position-hit-test
	if(!until)
	{
	until = document.elementFromPoint(x,y);

ststeiger / Center_Screen.htm

Created March 23, 2015 09:15

Center Text Horizontally & Vertically

	<!DOCTYPE html>
	<html lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
	<meta http-equiv="content-type" content="text/html; charset=utf-8" />
	<meta charset="UTF-8" />
	<title>Redirect to new test portal</title>

	<meta http-equiv="cache-control" content="max-age=0" />
	<meta http-equiv="cache-control" content="no-cache" />

ststeiger / SearchBox.htm

Created April 27, 2015 18:18

A nice search box

ststeiger / Quarters.sql

Created July 1, 2015 08:03

List quarters from/to in year-range

ststeiger / fu_RPT_OverlappingDateRangesDays.sql

Created July 1, 2015 15:15

Overlapping number of days in two date ranges


	IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fu_RPT_OverlappingDateRangesDays]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
	DROP FUNCTION [dbo].[fu_RPT_OverlappingDateRangesDays]
	GO




	-- ======================================================================================================================
	-- Author: Stefan Steiger

ststeiger / fu_get_ISOWeekBegin.sql

Created July 1, 2015 15:18

Get begin of ISO week from a date


	IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fu_get_ISOWeekBegin]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
	DROP FUNCTION [dbo].[fu_get_ISOWeekBegin]
	GO




	-- PRE: Valid year and week no#
	-- POST: First day of ISO week no#

ststeiger / fu_get_ISOWeekEnd.sql

Created July 1, 2015 15:19

Get the end of an ISO week from a date


	IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fu_get_ISOWeekEnd]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
	DROP FUNCTION [dbo].[fu_get_ISOWeekEnd]
	GO





	-- PRE: Valid year and week no#


	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
	<meta charset="utf-8" />
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta http-equiv="cache-control" content="max-age=0" />
	<meta http-equiv="cache-control" content="no-cache" />
	<meta http-equiv="expires" content="0" />