Recent Posts - page 2

  • SSMS 17: Built-in Performance Dashboard Reports

    SQL Server Performance Dashboard Reports are used to monitor and resolve performance issues in your Database Server. They are generally targeted towards a Database Administrator, and enabling them to quickly identify any performance bottlenecks in the system, gather diagnostic information that can potentially help to resolve the issue.

  • Speaking at Atlanta Code Camp 2017

    Atlanta Code Camp is the largest developer community event in Atlanta. This is a great opportunity to hear from the best speakers around, including many Microsoft MVPs and networking with the awesome developer community in and around Atlanta.

  • SSMS 2017 – Number of affected rows

    SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. SSMS 17.2 is the latest version of SQL Server Management Studio. It provides support for almost all features on SQL Server 2008 through SQL Server 2017.

  • Diagnosing a SQL Performance Issue in Production

    We bumped into a Performance issue last week for one of our web application in Production. After doing some research and looking at Logic Monitor reports for web servers and database servers, we figured out that the Deadlocks and Lock Timeouts in the Database have increased considerably.

  • Generate millions of rows of test data for SQL Performance Analysis

    Your application is bound to grow over a period of time. Sometimes it is critical to test your changes with a bigger workload than your current table size to identify any performance bottlenecks, well ahead of time. Leveraging automated tools to generate a workload for you to test your application makes your lives much easier.

  • Identify SQL Blocking Issues using Activity Monitor

    Blocking in SQL Server occurs when a transaction in a database session locks resources that another transaction requires to read or modify. If your application has long term blocking, then you have a problem in your hands to resolve.

  • Identifying Missing Indexes in SQL Server

    Having an effective Database Indexing Strategy is a key to your application performance. When we think about optimizing SQL query performance, generally the first thing which comes to our mind are ‘Indexes’. And rightly so, because Indexes tremendously help in fetching your data faster from SQL Server.

  • Lock Escalations in SQL Server

    “Lock Escalation” is an optimization technique used by SQL Server and it is basically how it handles locking for large updates. When SQL Server is going to modify a large number of rows – it is more efficient for the database engine to take fewer, larger locks (table lock) instead of dealing with a large number of individual locks (row locks).

  • Dynamic Toggle Functionality – Knockout and JavaScript

    Knockout is a powerful Javascript library which provides a simple two-way data binding mechanism between your data model and UI- which means that any changes to data model is automatically reflected in the UI and similarly any changes to the UI  are automatically reflected in the data model.

  • Speaking at PASS Summit, Seattle 2017

    I am honored and super excited to have been selected to speak at this PASS Summit 2017 – the world’s biggest conference in the Microsoft Data Platform. This will be my first PASS Summit experience. I consider myself very fortunate to have got this opportunity, knowing very well that there are so many experienced and better speakers around.

  • SQL Saturday Chattanooga 2017

    SQL Saturday Chattanooga was held on 24th June at UTC Chattanooga EMC Building. I have been to multiple SQL Saturdays earlier, but this was my first time in SQL Saturday Chattanooga. I was humbled to get the opportunity to present two sessions during this event.

  • Speaking at SQL Saturday 617 Pensacola

    I am excited to announce that I have been selected to speak at SQL Saturday Pensacola on 3rd June, 2017. I have heard so many good things about this event from my peers, that I feel humbled to be part of the event this year. SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.

  • Microsoft Build 2017 Recap – Day 1 announcements and highlights

    The Day 1 of the Microsoft annual developer Build Conference started at the Washington State Conference Center in Seattle. There were over 5000 attendees and the place looked all jam packed by 7AM, as people started to come in for the Keynote. In this blog, I will recap the Top 12 announcements during the Day 1 of the Build Conference.

  • 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.

  • Use custom colors to differentiate between environments

    During my SQL Saturday Birmingham Presentation on SQL Tips and Tricks, one of the productivity feature which got lot of love from most of the attendees was the use of custom colors to differentiate between SQL environments. SSMS provides us with an ability to set different colors for connection to separate environments.

  • 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.

  • Find all References in Visual Studio 2017

    The Find All References feature has been upgraded in Visual Studio 2017 and looks much better now – both visually and from a functionality perspective.

  • SQL Saturday Birmingham 2017

    SQL Saturday Birmingham 2017 was held on 18th March at Samford University. This was my first SQL Saturday as an Organizer. I also presented on Productivity Tips and Tricks in SSMS.

  • Fixing Build Errors with Database Unit Test Projects in Visual Studio 2017

    Database Unit Test project seems to not build in Visual Studio 2017. In this article, I will show how to handle this error, and get your database unit tests back to a running green state.

  • Automatic Performance monitoring of Extensions in Visual Studio 2017

    Are you tired of the sluggish performance, frequent IDE crashes, high memory consumption and slow solution load time of Visual Studio IDE? Read this article to find out how to overcome these pain points with Visual Studio 2017.

  • 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.

  • SQL Saturday Nashville 2017

    On 14th January, 2017 I attended SQL Saturday Nashville held at Middle Tennessee State University (MTSU), Murfreesboro. I have been to multiple SQL Saturdays before, but this was my first SQL Saturday as a Speaker.

  • Save connection information of frequently accessed servers

    As a developer, when you are working in a project, you tend to have a number of servers which you need to constantly shift between. What can you do to manage or organize these frequently accessed servers in a better way?

  • 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.

  • Double your Coding Speed using SQL Code Snippets

    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.

  • Windows Workflow is now an individual component in VS 2017 RC

    With the initial release of Visual Studio 2017 RC, there were multiple issues reported related to Windows Workflow Foundation in the VS Developer Community site . The latest update to VS 2017 RC however has a great news for Workflow Foundation users.

  • New Installation Experience with Visual Studio 2017 RC

    In the recently concluded Microsoft Connect 2016 Conference, Microsoft made a number of big announcements. One of them was the availability of the next version of Visual Studio -Visual Studio 2017 Release Candidate. In this article, I will be explaining the new installation experience with Visual Studio 2017.

  • Searching Data in SQL Tables – Impact on Performance

    In this article we will evaluate the Performance Impact of searching data in SQL Tables. We will understand how the Query Optimizer processes such queries and things we need to be aware of, from a performance standpoint, by using any toolset.

  • Searching made easier with SSMS 2016

    In this article, we will go through one of the features in SSMS 2016 – ‘Quick Launch’. Quick Launch greatly helps in making the developers productive in the IDE by helping them to search features and options inside SSMS.

  • 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’.

  • Automatic Check for Updates in SSMS 2016

    Since the initial release of SQL Server 2016 in May 2016, there has been monthly updates to SSMS which includes enhancements, new features and bug fixes. This has been a big step in ensuring that the SSMS IDE is up to date and provides a superlative user experience. But how do you know that a new version of SSMS has been released?

  • 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.