- 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 :
Your Android smartphone can be affected by Heartbleed. Check it with Heartbleed Detector.
Android is also affected by heartbleed bug. Confirm whether your android smartphone is affected or not with heartbleed detector.
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.
Paper - a beautiful new app by Facebook to explore and share stories from friends and the world around you
Facebook has about to launch their most awaited new app called “Paper” on 3rd Feb 2014 in US. At current, this app is available only for iPhone in the US. With Paper, Facebook is near to redefine itself for the Mobile Age.
How to take screenshot in android (Ice Cream Sandwich 4.0 and above)
Know how you can capture screen in your android smartphone. Take screenshot in your android version 4.0 (Ice Cream Sandwich) and above.
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.