- Posted On 29 October 2015
- In Technology
After long time this post is to introduce SQL Search tool with you. I have been using this tool since long but when I come to know that many of the developers are still not aware of this awesome tool then I decided to share the information about the same here at my blog.
SQL Search is a free add-in for SQL Server Management Studio which enables you to quickly search text across your all SQL databases. It makes our life easy while writing SQL procedures, finding column name across all tables of all databases and many more. E.g. you want to rename one of your table columns but aren't sure what stored procedures referencing it then you can use SQL Search and you will get all the list of procedures.
The best example can be suppose you want to search "select *" in all your queries throughout all your databases and want to replace them with a correct list of columns to improve performance and prevent future bugs, then this can be very easy job with SQL Search.
Below are some more features of SQL Search
- Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more
- Quickly navigate to objects wherever they happen to be on a server
- Search across multiple object types and multiple databases
- Find all references to an object
- Search with booleans and wildcards
- Search in specific or all databases.
You can download SQL Search from below link.
Hope you have benefited from this simple post. Let me know your opinion about this tool in comment section below and do not forget to share this post with your friends. Thanks.
- Tags :
Secure your Facebook profile data with these simple settings
You may already aware about "Facebook Data Breach" news, which is impacting the Facebook user's privacy and trust. Though there is a problem in data handling with Facebook, it also provides many settings you can make sure your data is protected, lets check what are those.
What is Bitcoin? An Emerging Open Source Digital Currency. Bitcoins in India.
This post will introduce you with digital currency named "Bitcoins" which was founded in 2009 and not issued by any central bank or other centralised authority but by an open source software through a process called 'mining.'. It has very bright future and if you gain a more knowledge about it you can book profit too.
How to prepare your android for an emergency situation
Know how to prepare your android Smartphone for emergency situations by adding emergency information on it which is usable in lock screen too.
What is Heartbleed vulnerability. Why it is recommended to change passowords of social and banking sites.
What is Heartbleed vulnerability. Since last week I am frequently hearing a word "Heartbleed" in news,on internet so today I thought lets check what is it actually and here is what I found.