Mr. Clippy is in a bad mood

Made by my youngest, she had no idea why I'm laughing at her creation.

Mr. Clippy is in a bad mood today

Some (n)unit tests run on TFS are failing with System.OutOfMemoryException

Symptom:

- some tests are failing with "----> System.OutOfMemoryException : Exception of type 'System.OutOfMemoryException' was thrown." error

Solution:

- add "/platform:x64" to VSTest step

Additional info:

under the hood, TFS is running "vstest.console.exe" and it looks that is run as a 32bit application by default

Migrating Mercurial (Hg) repository to GIT

Here a just a few random notes to get you starting with the migration of existing Mercurial Hg repository to GIT without loosing history.
Read:

• http://www.mehdi-khalili.com/migrating-from-mercurial-to-git/
• http://guides.beanstalkapp.com/version-control/git-on-windows.html

Install:

• Git Windows client
• python install
• fast-script (hg-fast-export.sh)
• mercurial lib for Python (pip install https://pypi.python.org/packages/55/c0/167c90e51d2bad39d466950a60c490d02c64128e787ecae6ef293c919763/mercurial-4.0-cp27-cp27m-win32.whl#md5=81b9e77d74907812cba53b811452561e)
• run in new Git repository (use Git Bash)
  – …/fast-export/hg-fast-export.sh -r c:/projects_HG/tfs/pixi-tools.hg/ --force
  – git checkout HEAD
  Done :)

How to use Visual Studio’s 2015 Android Emulator in Android Studio or Eclipse

Microsoft introduced Android Emulator in Visual Studio 2015, which is currently available as Release Candidate, this emulator uses Hyper-V with virtual machines running on Android x86 platform. So emulator is super fast and has a lot of nice features previously known just to Windows Phone emulators, like zooming, easy location mocking, simulating camera with real images, drag and drop APK files etc, ...

But the best part is, that this great emulator with all its nice features can be also used when developing Android applications with Android Studio or Eclipse. Just with two additional steps:

1.) Prepare and run desired VS Android emulator in Visual Studio, for detail read this article

2.) Check IP address of Android emulator device Settings \ WiFi \ Advanced\ Ip Address

Getting current IP address of Android device

3.) Run Command "ADB connect ipaddress"

4.) Now VS Android emulator should be available for running and debugging Android applications in either Eclipse or Android Studio.

Enjoy!

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