http://www.sqlservercentral.com/Articles tagged Advanced Querying, Strategies posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers. http://www.sqlservercentral.com/articles/Miscellaneous/2875/2008/02/21http://www.sqlservercentral.com/articles/Miscellaneous/2875/Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers. http://www.sqlservercentral.com/articles/Miscellaneous/2875/2008/02/21http://www.sqlservercentral.com/articles/Miscellaneous/2875/Every SQL Server developer has a preferred method of doing things; mine is what I call molecular queries. These are queries assembled from atomic queries; by which, I mean that they address exactly one table. By combing atoms, I can create molecules. http://www.sqlservercentral.com/redirect/articles/2621/2006/10/19http://www.sqlservercentral.com/redirect/articles/2621/SQL Server can grow to encompass hundreds of databases on a single server, each having hundreds or thousands of objects within it. A truly scalable RDBMS. However, how many times have you been searching through the Object Browser in QA or the left pane in Enterprise Manager searching for an object? New Author Ashish Kaushal gives us a method to easily search your server for that long lost object. http://www.sqlservercentral.com/articles/Advanced+Querying/howtofindsqlserverobjects/1446/2004/08/17http://www.sqlservercentral.com/articles/Advanced+Querying/howtofindsqlserverobjects/1446/Storing passwords in SQL Server for authentication by your application is a common practice. But not always a good one. Someone with access could easily see all passwords and perhaps cause mischief inside your application. Imagine the office gossip getting access to your HR application as the HR director! Not a good thing. Dinesh Asanka has written a short piece on how you can use a built in function in SQL Server to encrypt these passwords and use them with a minimum of effort. http://www.sqlservercentral.com/articles/Security/saveyourpassword/1420/2004/07/12http://www.sqlservercentral.com/articles/Security/saveyourpassword/1420/Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more. http://www.sqlservercentral.com/articles/Administering/makinggooduseofsysforeignkeystablepart1displaytabl/1364/2004/06/01http://www.sqlservercentral.com/articles/Administering/makinggooduseofsysforeignkeystablepart1displaytabl/1364/