Author Archives
I am a passionate software developer.
I have nine years of experience in IT industry, working on large-scale enterprise applications involving complex business functions, web integration, and data management in various domains like Insurance, Manufacturing and Publishing.
Currently I am working as a .NET Developer in EBSCO Industries, Birmingham, Alabama.
-
Searching Data in SQL Tables in a Single Click
SSMS does not provide any tools/utility to search for a value/data inside a particular database.This kind of surprises me a bit, since it is a needed functionality and would be a very popular feature to be built into the SSMS IDE. So the question is, how do you search for a particular value/data in your SQL Database?
-
{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.
-
Making Developers lives easier with SQL Server 2016
In this video session, we will learn about the rich set of capabilities of SQL Server 2016 and the new & improved features relating to Performance, Productivity and Security.
-
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.
-
DROP IF EXISTS Statement in SQL Server 2016
Currently one of the most irritating things in SQL, is to explicitly check if an object exists before dropping it.The DROP IF EXISTS is a simple T-SQL Enhancement in SQL Server 2016, but I am sure it would be one of the most frequently used syntax in a T-SQL developer’s day to day life.
-
Dynamic Data Masking in SQL Server 2016
From a security standpoint, sensitive data in the database needs to be protected against unauthorized access. Personal information of an individual like phone number, email, credit card details, bank account number, social security number needs to be stored safely in a database table.
In this article, we will look at a new security feature in SQL Server 2016 called as ‘Dynamic Data Masking’, which will now provide a database driven technique to mask sensitive data. -
Time Travel in SQL Server 2016 with Temporal Tables
Historical data are a key source for trend analysis and are considered critical to business success. Traditional databases don’t provide insights into how data has changed over a period of time.As a developer, imagine if SQL Server provides this information out of the box, and there is no need to write any custom code to achieve this functionality. Wouldn’t it be awesome?
-
Built-in JSON Support in SQL Server 2016
Lot of web services and Web APIs are using JSON these days, primarily as their data interchange format. The inability of the current versions of SQL Server to parse, store and process JSON data has been a hindrance. This makes the integration of JSON into SQL Server as one of the most awaited feature of SQL Server 2016.
-
Generating SQL Insert Scripts in just 2 clicks
Sometimes we might need to populate our SQL tables with reference/ look-up data. There are other scenarios when we need to copy table data from one environment to another. In both these cases, we require to create bulk scripts for Inserting data into our destination table. In this article, I will mention about a quick way to generate the SQL Insert Scripts using SQL Server Database project with just 2 clicks.
-
Compare Execution Plans in SQL Server 2016
With technology evolving this fast, I hate that we still have to deal with manually comparing execution plans. Things get worse when we have big plans. While working on a SQL Performance issue, it is often required to compare execution plans, before and after making a change. Wouldn’t it be nice to have a tool which would compare execution plans side-by-side and automatically present to you the similarities/differences?
-
Query Store in SQL Server 2016
How many times have you tried to troubleshoot a TSQL performance issue and wished you had more statistical/historical information on how the query ran over a period of time?
How many times have you faced performance issues after server/application upgrades? How many times have you bumped into a temporary performance issue with a TSQL and you wonder what is causing the query to run slow all of a sudden? -
Live Query Statistics in SQL Server 2016
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?
-
10 Best Practices for Code Commenting
Comments play an integral role in determining an application’s readability.In this article, I will be sharing few of the best practices of writing code comments.
-
Code Analysis Improvements in Visual Studio 2015 Update 1
Static Code Analysis has been present in Visual Studio IDE since the earlier versions, and has been evolving with each release. In this article, we will look at few usability issues of the Code Analysis in Visual Studio 2013 and how it… Read More ›
-
Improve Your Code Quality using Live Code Analyzers
The importance of Code Quality has grown multi fold times over the past few years. Gone are the days, when meeting deadlines used to be the sole measure of success. In today’s world, just delivering code is not enough –… Read More ›
-
Enhance Developer Productivity with CodeLens Code Health Indicator
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… Read More ›
-
Increase your Code Review efficiency with Visual Studio Code Metrics
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… Read More ›
-
Manage your Technical Debt with Visual Studio 2015 and SonarQube
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… Read More ›
-
Improving SQL Performance using Covering Indexes
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… Read More ›
-
Increase your Coding Speed using Code Snippets in Visual Studio
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… Read More ›
-
Performance Analysis using PerfTips in Visual Studio 2015
Troubleshooting Performance issues has always been a topic of discussion. As and when a performance problem is highlighted, developers tend to run a profiling tool, at their disposal, to diagnose the issue. Not having access or license for a profiling… Read More ›
-
Debugging Lambda Expression in Visual Studio 2015
One of my favorite features in Visual Studio 2015 is the support for debugging lambda expressions. This is a big productivity improvement for developers who spend a lot of time writing LINQ queries. Till Visual Studio 2013, if we tried… Read More ›
-
Deferred Execution vs Immediate Execution in LINQ
LINQ provides two different behaviors of Query Execution – Deferred Execution Immediate Execution Deferred/Lazy Operators Immediate/Greedy Operators Query is not executed at the point of its declaration. Query is executed at the point of its declaration. Projection Operator – Select,… Read More ›
-
Continuous Integration using SSDT in Visual Studio
What do you mean by Continuous Integration? Continuous Integration is the practice of frequently integrating one’s code changes with the existing code repository. The primary goal of CI is to provide quick feedback, so that if a defect is introduced,… Read More ›
-
Unit Testing vs Integration Testing
Unit Testing – It is the practice of testing discrete units of functionality, typically individual functions/methods, in isolation. If your test uses some external resource, like a service call or a database call, it’s not a unit test. Generally we mock… Read More ›
-
Abstraction vs Encapsulation
Abstraction and Encapsulation are the two basic features of Object Oriented Programming. Abstraction – Refers to the process of exposing only the relevant and essential data to the users without showing unnecessary information. It lets you focus on what the object does, instead… Read More ›
samirbehara 