Google
 
Discovered Topics
 sql  tips  programming  database  sqlserver  tsql

Discover From This Page & Topic: [] sql
 [] A Sane Approach To Choosing Primary Keys http://database-programmer.blogspot.com/2008/01/database-skills-sane-approach-to.html (sql relational design database)
 [] Coding Horror: A Visual Explanation of SQL Joins http://www.codinghorror.com/blog/archives/000976.html (sql tutorial join joins)
 [] RockStarApps » How do you store a tree in a database table? http://www.rockstarapps.com/wordpress/?p=88 (tree sql database mysql)
 [] Tips for Optimizing MySQL Queries (That don’t suck) | 20bits http://20bits.com/2007/04/10/10-tips-for-optimizing-mysql-queries-that-dont-suck/ (mysql optimization database performance)
 [] SQL Injection Attacks by Example http://www.unixwiz.net/techtips/sql-injection.html (sql injection programming hacking)
 [] RockStarApps » How do you store a tree in a database table? Part 2 http://www.rockstarapps.com/wordpress/?p=92 (database tree sql algorithms)
 [] Top 15 free SQL Injection Scanners - Security-Hacks.com http://www.security-hacks.com/2007/05/18/top-15-free-sql-injection-scanners (sql injection database security)
 [] SQL Injection Cheat Sheet http://ferruh.mavituna.com/makale/sql-injection-cheatsheet/ (cheatsheet sql security injection)
 [] When Not to Normalize your SQL Database - Dare Obasanjo http://www.25hoursaday.com/weblog/2007/08/03/WhenNotToNormalizeYourSQLDatabase.aspx (optimization database scalability sql)
 [] Tombatron: Intro to MySQL Stored Procedures. http://tombatron.blogspot.com/2008/01/intro-to-mysql-stored-procedures.html (tutorial database sql mysql)
 [] A Gentle Introduction to SQL http://sqlzoo.net/ (reference tutorial sql database)
 [] SQuirreL SQL Client Home Page http://squirrel-sql.sourceforge.net/ (sql database tools java)
 [] Data belongs in your tables -- not in your code http://weblogs.sqlteam.com/jeffs/archive/2006/02/10/9002.aspx (sql design programming data)
 [] SQLAlchemy - The Database Toolkit for Python http://www.sqlalchemy.org/ (python sql orm database)
 [] Library of Free Data Models http://www.databaseanswers.org/data_models/ (database sql design resources)
 [] Ten Common Database Design Mistakes http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/ (design database programming tips)
 [] Database Solutions for Microsoft Access Database Recovery Downloads | Database Normalization ... http://www.databasedev.co.uk/database_normalization_process.html (database tutorial programming reference)
 [] The Database Programmer: Database Skills: First Normal Form http://database-programmer.blogspot.com/2007/12/database-skills-first-normal-form.html (database sql programming tutorial)
 [] Creating Recursive SQL Calls for Tables with Parent-Child Relationships at Webinade http://www.webinade.com/web-development/creating-recursive-sql-calls-for-tables-with-parent-child-re ... (database mysql sql hierarchical)

 [] me talking out loud http://www.khankennels.com/blog/index.php/archives/2007/04/20/getting-joins/ (database sql reference visualization)
 [] When to use join and when to use subselects http://www.codeassembly.com/When-to-use-join-and-when-to-use-subselects/ (sql optimization database rdms)
 [] firstworks: sql relay - sqlrelay persistent database connection pool pooling proxy load balance ... http://sqlrelay.sourceforge.net/ (sql php database pooling)
 [] Think Before You Normalize | iface thoughts http://ifacethoughts.net/2007/08/04/think-before-you-normalize/ (database sql db denormalization)
 [] ActiveRecord: the Visual Basic of Object Relational Mappers at Pervasive Code http://www.pervasivecode.com/blog/2007/10/04/activerecord-the-visual-basic-of-object-relational-mapp ... (rails sql orm problems)
 [] xkcd - Bobby Tables http://xkcd.com/327/ (comics humor funny sql)
 [] The Myth of Stored Procedures Preference - Developer Pills http://bloggingabout.net/blogs/adelkhalil/archive/2008/01/06/the-myth-of-stored-procedures-preferenc ... (sql database development programming)
 [] The Developer Cheat Sheet Compilation by Fuzzy Future http://www.fuzzyfuture.com/programming/the-developer-cheat-sheet-compilation/ (reference programming cheatsheet development)
 [] How to Break a MySQL Left Join | Code Spatter http://codespatter.com/2008/02/19/how-to-break-a-mysql-left-join/ (sql database/mysql database/sql mysql)
 [] Dynamic Search Conditions in T-SQL http://www.sommarskog.se/dyn-search.html (sql dynamic programming search)
 [] Techniques for Uniquely Identifying Database Records - 4GuysFromRolla.com http://www.4guysfromrolla.com/webtech/110806-1.shtml (sql database design tips)
 [] Everything you wanted to know about SQL injection | Hiveminds Magazine for web publishers and ... http://www.hiveminds.co.uk/node/3104/ (sql security database injection)
 [] Rondam Ramblings: Why storing (too much) data in tables is a Really Bad Idea (tm) http://rondam.blogspot.com/2007/07/why-storing-too-much-data-in-tables-is.html (design database data sql)
 [] Carl J » Selecting Random Records With SQL http://www.carlj.ca/2007/12/16/selecting-random-records-with-sql/ (sql mysql howto random)
 [] SQL Designer http://ondras.zarovi.cz/sql/demo/ (sql database tools design)
 [] Query Processing at Light Speed http://monetdb.cwi.nl/ (database sql db opensource)
 [] Database Programming and Design http://www.dbpd.com/vault/9801xtra.htm (sql programming database reference)
 [] SchemaSpy http://schemaspy.sourceforge.net/ (tools visualization database schema)
 [] Deleting Duplicate Records in a Table - Postgres OnLine Journal http://www.postgresonline.com/journal/index.php?/archives/22-Deleting-Duplicate-Records-in-a-Table.h ... (sql database webdesign database/mysql)
 [] ConnectionStrings.com - Forgot that connection string? You will find it right here! http://www.connectionstrings.com/ (connection reference programming .net)
 [] ScottGu's Blog : Tip/Trick: Guard Against SQL Injection Attacks http://weblogs.asp.net/scottgu/archive/2006/09/30/Tip_2F00_Trick_3A00_-Guard-Against-SQL-Injection-A ... (security injection sql asp.net)
 [] Selecting random rows from various databases http://www.petefreitag.com/item/466.cfm (sql database random tips)
 [] Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1) - ScottGu's Blog http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hostin ... (apps .net generator tutorial)
 [] Partitioned Tables and Indexes in SQL Server 2005 http://technet.microsoft.com/en-us/library/ms345146.aspx#sql2k5parti_topic7 (sql performance)
 [] Storing Hierarchical Data in a Database [PHP & MySQL Tutorials] http://www.sitepoint.com/article/hierarchical-data-database (programming tree mysql php)
 [] Simple Talk: SQL Server and .Net articles, forums and blogs http://www.simple-talk.com/ (sql programming tools database)
 [] Roland Bouman's blog: Intelligent SQL JOIN syntax? http://rpbouman.blogspot.com/2006/04/intelligent-sql-join-syntax_09.html (sql tips mysql)
 [] SQL Myth: Truncate Cannot Be Rolled Back Because It Is Not Logged - Chris Breisch http://geekswithblogs.net/cbreisch/archive/2007/07/06/SQL-Myth-Truncate-Cannot-Be-Rolled-Back-Becaus ... (sql programming database tips)
 [] SQL Server Code,Tips and Tricks, Performance Tuning: The Sad State Of Programmers Part 1 : The ... http://sqlservercode.blogspot.com/2007/12/sad-state-of-programmers-part-1-phone.html (programming sql sqlserver database)
 [] The Saguaros - things you will never need from people you've never heard about http://www.thesaguaros.com/beta/newsag/products/dbtoyfs/ (browser sql linux relationap)
 [] The United Nations Serving Malware - Dancho Danchev http://ddanchev.blogspot.com/2008/04/united-nations-serving-malware.html (exploit sql webserver hacks)
 [] Free tools : Products : Idera http://www.idera.com/FreeTools/ (sql tools software free)
 [] SELECT Hints, Tips, Tricks FROM Hugo Kornelis WHERE RDBMS = 'SQL Server' : Can you trust your ... http://sqlblog.com/blogs/hugo_kornelis/archive/2007/03/29/can-you-trust-your-constraints.aspx (tips sql)
 [] Hide a SQL Server 2005 Instance http://demiliani.com/blog/archive/2007/02/06/5035.aspx (tips sql sqlserver)
 [] SQL Server Information at SQLTeam.com http://www.sqlteam.com/ (database sql programming dba)
 [] SQL Server Error Handling Workbench http://www.simple-talk.com/sql/t-sql-programming/sql-server-error-handling-workbench/ (tips sql errorhandling sqlserver)
 [] Marcelo's WebLog : Where did my database go? http://blogs.msdn.com/marcelolr/archive/2007/01/19/where-did-my-database-go.aspx (tips sql)
 [] Billy McCafferty : Common SQL Scripts and Tips http://devlicio.us/blogs/billy_mccafferty/archive/2006/10/24/Common-SQL-Scripts-and-Tips.aspx (sql)
 [] oreilly.com -- Online Catalog: SQL Cookbook http://www.oreilly.com/catalog/sqlckbk/ (sql books)
 [] Automating SQL Server version control with Visual SourceSafe at BrentOzar.com http://www.brentozar.com/archive/2006/01/automating-sql-server-version-control-with-visual-sourcesaf ... (continuousintegration sql)
 [] techbook.info http://techbook.info/reviews/MolinaroSQLCookbook.html (sql books)
 [] Welcome to SQL Server Central http://www.sqlservercentral.com/ (sql sqlserver programming articles)
 [] SQL Protocols : Understanding "login failed" (Error 18456) error messages in SQL Server 2005 http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx (reference sqlserver sql database)
 [] Dave Balzer : Passing an array as a paramater to a stored procedure... A.K.A. I love XML http://dotnetjunkies.com/WebLog/dbalzer/archive/2006/08/25/144695.aspx (sql xml code mmxcode)
 [] SQL Server Database Performance Tuning And Optimization Articles http://www.sql-server-performance.com/articles_performance.asp (sql tutorial windows sqlserver)
 [] SQL Server 2005 Paging Results - The Code Project - C# Database http://www.codeproject.com/cs/database/PagingResults.asp (sql development)
 [] General SQL Server & Access Articles http://databases.aspfaq.com/general.html (database sql)
 [] The ADO Guy: Using the Visual Studio Connection String Dialog http://adoguy.com/viewrant.aspx?id=2193 (brownbag utilities sql)
 [] Troubleshooting Performance Problems in SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx (performance sql sqlserver database)
 [] Best practice when optimizing indexes on SQL Server 2005 http://demiliani.com/blog/archive/2007/02/16/5058.aspx (performance microsoft sqlserver database)
 [] Vikram Kamath: Deleting User/Group Hierarchies in SQL http://vikramkamath.blogspot.com/2005/06/deleting-usergroup-hierarchies-in-sql.html (sql hierarchies)
 [] » Write custom trace files in TSQL | Servers and Storage | TechRepublic.com http://blogs.techrepublic.com.com/datacenter/?p=159&tag=nl.e046 (sql tips)
 [] Essential SQL Server Date, Time and DateTime Functions http://weblogs.sqlteam.com/jeffs/archive/2007/01/02/56079.aspx (programming tools database microsoft)
 [] LDBC Liberty Database Connectivity http://ldbc.sourceforge.net/ (database jdbc java sql)
 [] Retrieving the Date From a SQL Server DateTime :: BlackWasp Software Development http://www.blackwasp.co.uk/SQLDateFromDateTime.aspx (sql tips shortdate)
 [] NewSQL http://newsql.sourceforge.net/ (database sql)
 [] Craig Freedman's WebLog http://blogs.msdn.com/craigfr/default.aspx (sqlserver sql microsoft blog)
 [] Force recompile of Sql Server stored procs [sql] [sql_server] [recompile] http://www.bigbold.com/snippets/posts/show/2132 (sql)
 [] Cleaning up imported data in SQL Server http://articles.techrepublic.com.com/5100-9592_11-6156253.html?tag=nl.e046 (tips sql performance)
 [] » See SQL Server graphical execution plans in action | Servers and Storage | TechRepublic.com http://blogs.techrepublic.com.com/datacenter/?p=198&tag=nl.e046 (sql)
 [] Database Solutions for Microsoft Access Database Recovery Downloads | Database Normalization ... http://www.databasedev.co.uk/database_normalization_process.html (database tutorial programming reference)
 [] Setting up Transactional Replication from a back up http://weblogs.sqlteam.com/dinakar/archive/2007/04/02/60158.aspx (sql)
 [] General SQL Parser: sql engine for various databases http://www.sqlparser.com/service.php (sql parser)
 [] Database daily build reporting with XSLT - The Code Project - C# Database http://www.codeproject.com/cs/database/SQLDailyBuildReporting.asp (database sql continuousintegration)
 [] Citrix MetaFrame, SQL Server, and the DBA http://www.sqlservercentral.com/columnists/bkelley/citrix_metaframe.asp (sql sysadmin)
 [] TSQLNet Weblog - Cihangir Biyikoglu http://blogs.msdn.com/cbiyikoglu/ (sql)
 [] What is SQL Injection? http://www.windowsecurity.com/whitepapers/What-SQL-Injection.html (tips sql windows sysadmin)
 [] Extending DateTime to include dates less than 1753-01-01 in SQL Server 2005 with CLR UDT http://weblogs.sqlteam.com/mladenp/archive/2006/12/16/52754.aspx (sql datetime)
 [] James Snape - Uniqueidentifiers as primary key columns redux http://www.jamessnape.me.uk/blog/UniqueidentifiersAsPrimaryKeyColumnsRedux.aspx (sql)
 [] James Snape - User/Group Hierarchies in SQL http://www.jamessnape.me.uk/blog/UserGroupHierarchiesInSQL.aspx (sql hierarchies)
 [] ADO SQL Database Connection Strings - SQL Server, MS Access, MySQL, Oracle, PostgreSQL, DB2, ... http://www.sqlstrings.com/SQL-Server-connection-strings.htm (sql database connection programming)
 [] Database eLearning http://db.grussell.org/index.html (sql tutorial database learning)
 [] Date/Time Conversions Using SQL Server http://www.mssqltips.com/tip.asp?tip=1145 (sql datetime)
 [] SQL Server DateTime Formatting :: BlackWasp Software Development http://www.blackwasp.co.uk/SQLDateTimeFormats.aspx (date sql server database)
 [] Billy McCafferty : Netflix Memoirs: Using the Pearson Correlation Coefficient http://devlicio.us/blogs/billy_mccafferty/archive/2006/11/07/netflix-memoirs-using-the-pearson-corre ... (algorithms sql filtering similarity)
 [] SQL Server forums: development, administration, security, performance tuning tips http://www.sqlmonster.com/ (sql forum portal relational)
 [] Help for stored procedures - SQL Server, Oracle, XML, DB2 http://www.sswug.org/searchresults.asp?keywordstofind=stored%20procedures (sql)
 [] Microsoft SQL Result Paging http://blogs.wdevs.com/bn/archive/2004/09/29/692.aspx (sql)
 [] Simplify SQL Server 2005 queries with a Dates table | Servers and Storage | TechRepublic.com http://blogs.techrepublic.com.com/datacenter/?p=326&tag=nl.e046 (sql datetime)