SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag relational databases Rss

Search for any content tagged relational databases

   Items 1 to 5 of 5   
 

Mixing MongoDB and Relational Databases in the Enterprise

Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rapidly-evolving the data design for their domain or do you embrace the joys of NoSQL unconditionally? If you accept a polyglot database environment, where the NoSQL lambs coexist with the relational lions, how do you provide tools and common database concepts that everyone can use and understand?  Read more...
By Additional Articles 2017/11/10 | Source: SimpleTalk | Category: mongodb
Rating: (not yet rated)  Rate this |   Briefcase | 2,838 reads

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,327 reads

The Road To Hell - new article from the DBA Team

Joe Celko & Chris Date guest as the sinister Relational Police in this new DBA Team adventure. Can the DBA Team save another doomed database? Find out.  Read more...
By Additional Articles 2014/08/07 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 11,711 reads

Applying The Scientific Method to SQL Server Performance Tuning

A relational database is a complex machine that is asked to deal with intricate problems. When things go wrong, it usually takes knowledge, deduction and a systematic approach to track down the root core of problems and to determine the best fix, Joshua Feierman illustrates how this can be done.  Read more...
By Additional Articles 2014/03/31 | Source: SimpleTalk | Category: problem solving
Rating:  Rate this |   Briefcase | 6,584 reads

The Longevity of the Relational Database

Waves of NoSQL hysteria come and go but the relational database remains, and Phil Factor admires its sheer ubiquity, and ability to provide data integrity and accessibility for a vast tapestry of data categories.  Read more...
By Phil Factor 2012/09/17 | Source: SQLServerCentral.com | Category: database weekly
Rating: |  Discuss |   Briefcase | 226 reads
   Items 1 to 5 of 5