![visual studio and sql server 2012 r2 visual studio and sql server 2012 r2](http://ilikesqldata.com/wp-content/uploads/2015/03/SSDT.jpg)
![visual studio and sql server 2012 r2 visual studio and sql server 2012 r2](https://blog.matrixpost.net/wp-content/uploads/2020/11/data-workload-2019.png)
IntelliSense is enabled by default but can be disabled by going to Tools ➜ Options ➜ Text Editor ➜ Transact SQL ➜ IntelliSense.įigure 1: Default configuration for IntelliSense IntelliSense for SQL Server Management Studio which was first introduced in SQL 2008 is an intelligent code completion mechanism which increases development productivity by making code snippets, definitions and syntax checking available to you without having to leave the editor.
![visual studio and sql server 2012 r2 visual studio and sql server 2012 r2](https://blog.sqlauthority.com/i/b/setkeyboard3.jpg)
Visual studio and sql server 2012 r2 how to#
In this article I would like to do a quick overview of IntelliSense, how to use it and also shed some light on those moments when IntelliSense just doesn’t seem to be working. I am happy to report however, that there has been great strides in IntelliSense to such an extent that if I suddenly had to live without it, I would be really really sad and my productivity would probably be affected somewhat as well. From issues like just not popping up at all, to not working on remote servers and sometimes picking incorrect entries could make it a bit tedious to use and for those of us who started out on SQL Server before the advent of IntelliSense it was easier just to revert back to good old fashioned typing from memory. Much to my disappointment the initial version of IntelliSense left a lot to be desired. When I first heard that Microsoft was going to introduce IntelliSense for SQL Server I could hardly contain my excitement.