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. 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.
  2. Configure SQL Database on premises with DB files on Azure.

    RequirementsBenefitsSteps
  3. Database migrations with Continuous Delivery in Entity Framework

    Who doesn't enjoy the big term, DevOps? It sounds promising and sounds interesting as well when someone says, they work as a DevOps engineer! But like they say, Similarly, in the case of DevOps, every process, which DevOps exposes has to be handled with a great care or the results are catastrophic. In this post, I am going to talk about the swissknife of continuous delivery, in the terms of database migrations and maintenance. It has been quite a while, since I have joined DevOps practices and...
  4. Removing SQL Azure "Sync" objects manually

    The web based interface for SQL Azure Sync leaves a lot to be desired, often taking hours to submit changes to a sync group. After dealing with this frustration for a period of time, I decided it was time to be done away with it completely.SQL Azure Sync uses triggers to determine when tables have been modified. These can be killed off using the following script:Data Sync also creates a series of tables with names like "%_dss_tracking" for trackign changes to each table. These to can...
  5. Big Data and Databases Index - March 2014

    The following charts show the salary and demand statistics for skills used in Big Data & Database related careers. The data is taken from the Gooroo.io analysis of job advertisements in the United States, Great Britain, and Australia.This month, we have decided to remove some of the more generic terms like SQL and Databases.When reading these charts, the lower the demand for a skill, the less reliable the salary indicators become. It only takes a handful of jobs to shift the average.Job data...
  6. Edit DRAFT Edit

    • updated