How can SQL code behave differently in or outside procedure and about poor error handling

During refactoring of very old code, I found a ancient/ugly and in the end even totally wrong error handling script. Interesting is that the developer probably tested it outside of procedure and it did "kind a work" for him, ... :)

I'll add details later (or much later).

How can I query remote Microsoft SQL Server using integrated security

How can I query remote Microsoft SQL Server without setting up linked server and not using hardcoded username and password of course! :)

tSQLt FakeTable fails with error "cannot be renamed because the object participates in enforced dependencies"

Table is probably included as part of some "schema binded" view. Use attached script to temporary remove schema binding.

Error:
"[Test] failed: (Error) A .NET Framework error occurred during execution of user-defined routine or aggregate "SuppressOutput":
System.Data.SqlClient.SqlException: Object '[dbo].[SomeTable]' cannot be renamed because the object participates in enforced dependencies."


Source on GIT

How to use Ionic framework with Ripple web browser based emulator

http://ripple.incubator.apache.org/

droid gang (Photo credit: valanzola.t)

First prepare Android platform:

ionic platform add android ionic build android 

Install Ripple emulator with node.js NPM.

npm install -g ripple-emulator 

and run it:

ripple emulate --path platforms/android/assets/www


Last step can be also used in ordinary PhoneGap / Cordova project.

Links:
- Ionic Framework

Backbone model sample (javascript)

Following sample script demonstrates all Backbone.js libraray model related functions:

• attributes
• setting default values
• getting list of attributes
• constructor
• validation 
• methods
• converting to JSON

Additional resources:

• Todos

Chocolatey is incompatible with version 2.1.31022.9038 - How to update nuget client in Chocolatey

I become a big fun of Chocolatey lately! :) While installing some tools I received following error:

Chocolatey (v0.9.8.20) is installing wget and dependencies. By installing you accept the license for wget and each dependency you are installing.

The schema version of 'Microsoft.AspNet.Mvc' is incompatible with version 2.1.31022.9038 of NuGet.

Please upgrade NuGet to the latest version from http://go.microsoft.com/fwlink/?LinkId=213942.

Sollution:

cd C:\Chocolatey\chocolateyinstall
nuget update -Self

And it should work!

Powershell: Create Folder/Directory if doesn't exists

Simple script for creating new folders.

# Create folder if it doesn't exists
function CreteFolder([String]$folderPath)
{
if ((Test-Path $folderPath) -ne $True)
        { New-Item $folderPath -type directory }
}