GoorooTHINK

Thought provoking and helpful articles
from the Gooroo community.

Do you have something to say? Contribute or create an article and add it to your Gooroo bio.

  1. Another interesting trick with APPLY operator

    Some years ago, I was reading one book of Itzik Ben-Gan where he explained in depth the use of a new operator: APPLY, I told myself, it just another new feature more. I didn’t understand the relevance and the many versatile applications it had, through time, I have been using APPLY in many scenarios. Saving time and resources it is a fundamental part of each TSQL development, in this short article I would like to explain a simple trick with APPLY operator.The requirement can sound exotic but is...
  2. Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL

    Hi! I wrote these tips after many hours of some ERP system speed optimization. It was very helpful for me and my team. I hope it will be helpful for you too.So, lets go. Read UncommittedRead Committed + read_committed_snapshot off(alter database xxx set read_committed_snapshot off)Read Committed + read_committed_snapshot on(alter database xxx set read_committed_snapshot on)Repeatable ReadSerializableSnapshot(alter database xxx set allow_snapshot_isolation on)Tested on MSSQL 2014.
  3. Visual Studio 2017 Installer Projects

    The one thing that frustrates me a bit is how often the Visual Studio installer projects change from version to version. In fact, as of this writing there is no project template for Visual Studio 2017. It just so happened that the project that I was working on, was originally developed in Visual Studio 2015. It included a setup project that was now no longer available in Visual Studio 2017. It simply displayed the setup project as (incompatible).Some might argue that I should just go back to using...
  4. Using PowerApps: Authoring made simple and powerful

    PowerApps I am glad to bring you up with the latest change in the PowerApps Studio, in the latest version (2.0.660), the enhanced capabilities are showed and discussed in this article, PowerApps Studio had changes in the Properties Panel, Viewing data with the edit form, global variables, and the reset function. what brings thrill drive is the addition of Properties Panel in the right canvas of the PowerApps Studio. the properties panel will the one exposing the common properties that will be...
  5. What is cloud computing?

    Cloud is a central repository where you can put access manage data and services from anywhere, anytime. Cloud computing is simply to put the services of cloud i.e. servers, storage, databases, networking, software, analytics and much more over the internet. the companies that offer such services are known as cloud providers. providers charge you for these services upon your usage, its just likely you charged for electricity, Gas, Water usage every month at your home.Still not clear about what is...
  6. The Path is Null and Full of Squiggles

    I've been using Visual Studio 2017 since the earliest bits were available and I can confidently say, I'm a fan and highly recommend you give it a shot if you get a chance.With that being said, sometimes new features can cause things to blow up and this post is going to be discussing one of those such features, namely Lightweight Solution Load.Recently, I opened up a decently sized solution (~9 projects) and everything seemed in order. All of my dependencies were there, with no warning signs to be...
  7. Sharing is Caring: Using Shared Projects in ASP.NET

    As software developers, copy-pasting some code or a few files and having it in multiple places has always been smelly. There are several different avenues that you can take to avoid this kind of redundancy, but this post will focus on one that it seems isn’t talked about too often: Shared Projects.Prior to the introduction to Shared Projects, I’ll briefly go over why Shared Projects themselves were introduced, and how you might have accomplished similar behavior before their release.With the major...
  8. Glyphfriend 2.1 Released! Now with Library Filtering

    It hasn't been too long since the latest 2.0 release of Glyphfriend, but with the release of Visual Studio 2017 coming around the corner, there were a few things that could use some improvement and polishing off before then.Message received, loud and clear.All of the changes that were made to make the extension more flexible actually resulted in it being more noisy. Glyphfriend would just serve everything it knew about. This has generally been regarded as a bad move, and thus library filtering is...
  9. Resolving Installation Issues with Visual Studio 2017

    I’ve seen quite a few posts online regarding folks having issues installing Visual Studio 2017 after using previous versions of the IDE (such as the various pre-releases and RCs). If this sounds like you, then you might want to follow some of the steps in this blog post to ensure that your next install goes smoothly.Generally, the standard uninstall procedure should work as expected, so definitely try that before moving on. If that doesn’t work and you find yourself unable to install or update...
  10. Spring Cloud and Netflix Ribbon: Client-side Load Balancing

    Eventually you'll reach a point where you need to run multiple instances of an application or a service for high availability or to manage increased load. That's what load balancers are for. There's generally two different types:What many people would call a "load balancer" is actually a server-side load balancer. It can be implemented in hardware or software. The traffic is sent to a dedicated service that decides where to send the traffic, using an algorithm like round-robin, to one of the...
  11. Edit DRAFT Edit

    • updated