SQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server
First off, it will increase SQL coding almost instantly. There is very little to learn, you are not just memorizing codes to “cheat” off of. DbForge Studio provides code completion options and automatic SQL formatting, so that you know your code will work. One of my favorite feature is “snippets,” which stores parts of code that you use over and over to cut down on typing and searching – because you know there always a few commands you use again and again! Another time saver is the hint option, which will show you information about objects, and the navigation tool that allows toggling between items using only the F12 key.
SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani
SQL SERVER – Auto Complete and Format T-SQL Code
Some people call it laziness, some will call it efficiency, some think it is the right thing to do. At any rate, tools are meant to make a job easier, and I like to use various tools. If we consider the history of the world, if we all wanted to keep traditional practices, we would have never invented the wheel. But as time progressed, people wanted convenience and efficiency, which then led to laziness. Wanting a more efficient way to do something is not inherently lazy. That’s how I see any efficiency tools for auto complete.
SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies
Let us learn in this blog about sys.sql_expression_dependencies.
A very common question which I often receive are:
How do I find all the tables used in a particular stored procedure?
How do I know which stored procedures are using a particular table?