SQL Server Management Studio provides a cool feature called ‘Code Snippets’ which can help you to considerably increase your coding speed. Code Snippets are ready made snippets of code, which you can insert into your T-SQL code. As a result, you can type less and generate more code.
How many times have you come across a scenario when you execute a TSQL Query and it just runs and runs, without displaying any results and you wonder what’s going on – and finally end up cancelling the executing query?
In this blog, we will look at a very cool Visual Studio 2015 extension called ‘CodeLens Code Health Indicator’ and its features. This extension shows the current value of the Maintainability Index for our code and provides us insight into code quality. Once we have this extension installed, all the methods in our code base […]
In this blog, we will try to understand the importance of code reviews, classify types of design flaws and identify the code smells using Visual Studio Code Metrics. Why is Code Review important? In a development life cycle, Code Reviews play an essential role to gauge the quality of a product. There are multifold benefits […]
Are you worried about ‘Technical Debt’ in your project? In this blog, we will try to understand what Technical Debt is, what causes it, how to measure it and ultimately bring it down. What is Technical Debt? Everybody wants to write good quality code and adhere to coding standards. However in the pursuit of delivering a […]
What is a Covering Index? An index that contains all required information to resolve the query is known as a “Covering Index” – it completely covers the query. Covering Index includes all the columns, the query refers to in the SELECT, JOIN, and WHERE clauses. Key Columns and Non-Key Columns – Key columns are columns […]
Code Snippets are one of the coolest features of Visual Studio, which can help us to increase our coding speed multi-fold times. Good Developers generally use shortcuts and tricks to type less and generate more code in less time. Code snippets are ready-made snippets of code which we can quickly insert into your source code. […]