Lorenz Lo Sauer lsauer

View austria-citylist-letter-abbreviation.json
1 2 3 4 5 6 7 8 9 10
{
"B": "Burgenland",
"K": "Kärnten",
"N": "Niederösterreich",
"O": "Oberöstereich",
"S": "Salzburg",
"St": "Steiermark",
"T": "Tirol",
"V": "Vorarlberg",
"W": "Wien"
View 1-merging-or-extending-arrays-in-csharp.cs
1 2 3 4 5 6 7 8 9 10
//www.technical-programming.com, lorenz lo sauer, 2013
//description: extending C# for fast and easy string extension
//note: part of a larger Open-Source Project-Codebase
//see: http://stackoverflow.com/questions/59217/merging-two-arrays-in-net
 
//resides in IEnumerableStringExtensions.cs
public static class IEnumerableStringExtensions
{
public static IEnumerable<string> Append(this string[] arrayInitial, object arrayToAppend)
{
View tsql_update_field_when_conditional_value_is_set_trigger.sql
1 2 3 4 5 6 7 8 9 10
/*www.technical-programming.com, lo sauer 2013
Target: MS/Microsoft SQL Server 2005 or higher
description: Upon update, the rows's timestamp field is set to the current unix-timestamp,
unless the timestamp is NULL or Empty. If the timestamp field is supplied in the update
statement, the supplied value is set as is.
 
The tstamp field is defined as:
[__unixtimestamp] INT NULL
The primary key is defined as:
[ID] INT IDENTITY (1, 1) NOT NULL
View 1backup_and_export_or_restore_and_import_bak_database.sql
1 2 3 4 5 6 7 8 9
/*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'
View CodeAttribute.cs
1 2 3 4 5 6 7 8 9 10
//www.technical-programming.com, 2013 lo sauer
using System;
 
namespace MyProject.Attributes
{
public enum CodeAttributeName {
Author,
Copyright,
RevisionHistory,
License,
View check-data-type-of-a-field.sql
1 2 3 4 5 6 7 8 9 10
/* 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*/
View fake-picture-is-that-image-real.md

The APEX rules

check the credibility of socal media pictures

  • **A**uthor: check the stream/context of the original poster (OP), which conveys intent
  • **P**icture: check if the file is smaller than the norm and if it has metadata, such as Exif
  • **E**nhanced: 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

View best-css-blockquote-styles.css
1 2 3 4 5 6 7 8 9 10
/*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;
View blogger-footer-label-tags-design-on-top.css
1 2 3 4 5 6 7 8 9 10
View blogger-footer-label-tags-design.css
1 2 3 4 5 6 7 8 9 10
Something went wrong with that request. Please try again.