Tuesday 5 May 2015

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.


Thursday 5 March 2015

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).

Tuesday 3 March 2015

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! :)

Thursday 15 January 2015

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.

"[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