C#

SonarQube – Issues with Cyclomatic Complexity Metrics

We have been using SonarQube for inspecting code quality of our applications for a long time now. We have integrated SonarQube with our CI/CD Pipeline and configured Quality Gates — hence with every code check in we perform a static code analysis of the changes. This provides developers an early feedback of their code changes. If the code changes does not meet quality standards, the code check-in is rejected.

Keeping your Technical Debt in check with NDepend

During the past month, I have been blogging about SonarQube – an open source static code analysis tool. We recently started using SonarQube in our projects to ensure high code quality, automate our code review process and also manage our technical debt. In this article I will provide an overview on another very popular and powerful Static Code Analysis tool – NDepend.

SonarQube SQL Error – String or binary data would be truncated

The SonarQube Scanner for MSBuild – Begin Analysis task contacts the SonarQube server to retrieve the quality profile, and dynamically produces rulesets to be applied during the static analysis. If there are issues in the process, I would recommend to go the Administration section in your SonarQube server, and navigate to the background Tasks tab to find the error log.

Menace of Trim function usage in Entity Framework

When a column is wrapped around in a function call in the WHERE clause, the query processing speed can be extremely low because of the potential resultant scan operation. We should avoid using functions on columns in predicate. Especially on large tables, it can create a noticeable performance overhead by preventing the Query Optimizer to use available indexes.

Attach to Process in Visual Studio 2017 not working

I started seeing a weird issue while working in Visual Studio 2017 few days back. I was not able to attach to running processes with the Visual Studio debugger. The IDE used to freeze/hung each time I tried to do so. The ‘Attach to Process’ window used to come up but it was blank and all I saw was the spinner – eventually the screen became unresponsive after some time.

Microsoft AI Immersion Workshop 2017 Recap

One of the events which I was lot excited to attend was the pre-Build event – ‘Microsoft AI Immersion Workshop’. The event promised to be a great opportunity for developers to learn about building intelligent applications using Microsoft and open source technologies. Now that the event is over, I must say that it did live up to its expectation.

Issues with Lightweight Solution Load in Visual Studio 2017

One of the coolest feature in Visual Studio 2017 is the ‘Lightweight Solution Load’ which greatly reduces the Visual Studio startup time and the overall memory consumption.
However I have bumped into multiple issues working with Lightweight Solution Load feature turned ON in VS2017. In this article, I will list down few of my observations, so that you are aware of these limitations.

Upgrading from Visual Studio 2015 to Visual Studio 2017

Visual Studio 2017 comes with a lot of new capabilities and productivity enhancements. This was good enough reason to start moving from VS 2015 to VS 2017, and leveraging all the new features. In this blog post, I will mention about couple of issues which I bumped into during the migration process and the action items I took to resolve those.

Redgate Data Tools in Visual Studio 2017

Visual Studio 2017 now includes Redgate Tools to increase productivity while doing database development work. I use the VS Enterprise edition at work, so am pretty excited to leverage the productivity benefits of these tools, within Visual Studio IDE itself.

Lightweight Solution Load in Visual Studio 2017

When you have a large solution comprising of multiple projects, you must have experienced a delay while loading the solution for the first time. One of the coolest feature in Visual Studio 2017 is the ‘Lightweight Solution Load’ which greatly reduces the Visual Studio startup time and the overall memory consumption. In this article, we will understand all the details around this new feature.

Celebrating 1 year of DotNetVibes

A year back on this very day, I decided to start my own blog and that’s how dotnetvibes.com came into existence. Today on 1st January, 2017 – exactly a year later – I must admit that it has been an eventful journey with lot of excitement, learning, challenges and acquaintances.

Atlanta Code Camp 2016

On 15th October, 2016 I attended the Atlanta Code Camp held at the Kennesaw State University, Marietta, GA. I was quite humbled to get an opportunity to be a speaker this year and presented in the Database Development category on ‘Making developers lives easier with SQL Server 2016’.

{DEV = DATA} DAY BIRMINGHAM 2016

Working as a .NET Developer in the Southern City of Birmingham, I feel the last 6 weeks has been pretty awesome for the Birmingham Technology community. There were 3 excellent full day tech events – starting with Sloss Tech held by TechBirmingham, dotNetConf and then devdataDay held by Steel City SQL Group and BHM .NET Meetup.

DOTNETCONF 2016, BIRMINGHAM – DISCOVERING THE NEW .NET WORLD

Birmingham is surely growing fast as a technology hub and the overwhelming response to the dotNetConf event was a testimony to that. On 4th August, 2016 – the Birmingham .NET Meetup group organized a full day local extension event to the virtual dotNetConf conference, which Microsoft holds annually, to promote and educate developers about the .NET framework.

Troubleshooting random failures with Coded UI Tests

Coded UI Automated Tests run fine locally but randomly fails when run on the server. The functionality which you are trying to verify works fine, but the tests does not consistently pass on the test agents. In this article, we will look at a simple way by which we can analyze/debug these randomly failing tests and get more understanding on how to resolve it.