lsauer

/*www.technical-programming.com, lo sauer 2013
* description: Step by step process to load or save .bak Database backup files
* credits: RameshVel,Tim Partridge for the @fileListTable; StackOverflow
*/

/* Export/Save a Database Backup 
   See: http://technet.microsoft.com/en-us/library/ms186865.aspx
*/
BACKUP DATABASE logicalnameofthedatabase TO DISK = 'c:\physicalnameofthedatabase.bak'

lsauer

//www.technical-programming.com, 2013 lo sauer
using System;

namespace MyProject.Attributes
{
    public enum CodeAttributeName {
        Author,
        Copyright,
        RevisionHistory,
        License,

lsauer

/* lsauer.com, 2013
 * DECIMAL fields, declared as NOT NULL, cannot be filled by a simple empty string ''
 * Insert '0.0' or '.0' instead
*/
CREATE PROCEDURE GetType(@TableName VARCHAR(100), @FieldName VARCHAR(100)) 
                 AS (SELECT system_type_id FROM sys.columns 
                       WHERE object_id = OBJECT_ID(@TableName, 'U') AND name = @FieldName)
GO
EXECUTE GetType N'MyTable', N'MyTableField'
/*For instance: 106 is DECIMAL*/

lsauer

The APEX rules

check the credibility of socal media pictures

• Author: check the stream/context of the original poster (OP), which conveys intent
• Picture: check if the file is smaller than the norm and if it has metadata, such as Exif
• Enhanced: check if what you are seeing is sensible and in physical agreement with your common sense
• X-reference: check the image against an image datatabase, such as tineye.com

_{source: lsauer.com}

lsauer

/*www.lsauer.com, lo sauer 2013
*/
@media screen {
  blockquote {
    display: block;
    margin: 1.5em 0 1.5em -1.5em;
    padding: .75em .5em .75em 1em;
    background: #fff;
    border-left: 0.5em solid #DDD;
    font-size: 1em;

lsauer

/*might need to be adapted*/
.overview-content .article-footer{
  margin-bottom: 10px;
}

.overview-content .share-controls {
  overflow: hidden;
  text-align: center;
  white-space: nowrap;
  display: inline-block;

lsauer

/*lsauer.com, 2013 - lo sauer*/
div.article-footer a.label {
  display: inline-block;
  padding: 2px 4px;
  font-size: 12px;
  font-weight: bold;
  line-height: 14px;
  color: #fff;
  vertical-align: baseline;
  white-space: nowrap;

lsauer

//www.lsauer.com, lo sauer 2013
//descr: looks for <code tags> and reinjects their content as a <script> Element;
//       allows XHTML compliance with CDATA Containers
//from is-lib: DOMInsertScript

/* add this somewhere in your Blogger template*/
var bloggerplugins = bloggerplugins || {};
bloggerplugins.codetoscript = (function($, allowTextnode){
  return function(){
    var DOMInsertScript = function (str, toel) {

lsauer

// http://www.lsauer.com, lo sauer 2013
//descr: load embedded-gists in Google Blogger's Dynamic View templates
//credits: https://github.com/kares/script.js for 'script.js' a helper to readout script's contents
//depends: jQuery to some extend, but dependence can be easily removed
//usage: e.g. following HTML can be used to load gists: 
//       <code data-src="https://gist.github.com/lsauer/6397381.js">Loading ....</code>
//       <code data-src="https://gist.github.com/lsauer/2836373.js">Loading ....</code>

var timeoutfnLoadgist = function() {
  var out = {};

lsauer

//www.lsauer.com, lo sauer 2013
//see: http://www.lsauer.com/2012/05/javascript-copy-text-to-clipboard.html
var keypressHandlerForwardLocation = function(evt){
    if(evt instanceof KeyboardEvent && evt.target instanceof HTMLElement 
       && evt.keyCode == 99 && evt.ctrlKey==true && evt.target != null 
       && (evt.target.innerText || evt.target.value).Trim().substr(0,4) == "http"){ 
      cancelBubble = true;
      window.location = (evt.target.innerText || evt.target.value).Trim();
    }
}