Skip to content

Instantly share code, notes, and snippets.

View papsl's full-sized avatar

Peter A. Pirc papsl

11 followers · 33 following
View GitHub Profile
@papsl
papsl / MSSQLRemoteServerQuery.sql
Created March 3, 2015 07:55
How can I query remote Microsoft SQL Server without setting up linked server
-- Using OPENROWSET
SELECT m.name, m.database_id
FROM OPENROWSET('SQLNCLI', 'Server=RemooteServerName;Trusted_Connection=yes;','SELECT * FROM master.sys.databases') AS m
-- Using OPENDATASOURCE
SELECT name, database_id
FROM OPENDATASOURCE('SQLNCLI','Data Source=RemooteServerName;Integrated Security=SSPI').master.sys.databases
@papsl
papsl / svg sample pipe.html
Created February 13, 2015 11:39
<!DOCTYPE html>
<html>
<head>
<title>Simple SVG "pipe"</title>
</head>
<body>
<canvas id='canvas' width='1024' height='800'></canvas>
<script>
var ctx = document.getElementById("canvas").getContext("2d");
@papsl
papsl / tSQLt.PrepareTableForFaking.sql
Last active May 28, 2019 09:51
tSQLt prepare table for faking
/*
Source: http://harouny.com/2013/04/19/tsqlt-taketable-indexed-view/
Description: With small modifications on REPLACE part and code style improvments
*/
CREATE PROCEDURE [tSQLt].[PrepareTableForFaking]
@TableName NVARCHAR(MAX),
@SchemaName NVARCHAR(MAX)
AS
BEGIN
@papsl
papsl / designer.html
Created July 21, 2014 19:24
designer
<link rel="import" href="../core-scaffold/core-scaffold.html">
<link rel="import" href="../core-header-panel/core-header-panel.html">
<link rel="import" href="../core-menu/core-menu.html">
<link rel="import" href="../core-item/core-item.html">
<link rel="import" href="../core-icon-button/core-icon-button.html">
<link rel="import" href="../core-toolbar/core-toolbar.html">
<link rel="import" href="../core-menu/core-submenu.html">
<polymer-element name="my-element">
@papsl
papsl / UpdateChocolateyNuget
Created May 12, 2014 12:41
How to update NuGet client in Chocolatey
C:\cd C:\Chocolatey\chocolateyInstall
C:\Chocolatey\chocolateyinstall>nuget.exe update -self
Checking for updates from https://nuget.org/api/v2/.
Currently running NuGet.exe 2.1.0.
Updating NuGet.exe to 2.8.2-beta.
Update successful.
@papsl
papsl / Backbone-Tutorials-Model.js
Last active August 29, 2015 14:00
Backbone Tutorials - Model
Person = Backbone.Model.extend({
// default values of attributes
defaults:{
age:0,
children: []
},
// validation
validate: function(attributes){
if(attributes.age<0){
console.log("Validation error, person can't be negative age!");