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

4689 Results Found

ARTICLE

Bad Database Design

... Server have our share of bad database design stories. I’ve learned to be more ... years as I’ve managed both the database and developer sides of the effort, but even tolerance ... one came with a twist. Because the product was designed to run on just about any database platform, everything was built for the lowest common ...

ARTICLE

Stairway to Database Design

Designing a database is very easy to do, but hard to do well. There are many databases that have been built in the world that do ... meet the needs of the applications they support. The fundamentals of design are often not taught to developers or DBAs when ... looks to help you understand the fundamentals of the design process. The articles in the series are linked below: Stairway to Database Design - STEP 1: Data Elements - Before ...

ARTICLE

A Database Design Test

I was watching a presentation recently on database design and the speaker talked about how he ... developers. These are full stack developers, for whom the database is a portion of their responsibility. One of the tasks he gives them is a short database design test, designed to get a rough idea of their knowledge of databases. The test is a short story, with a classroom/course ... structures in the test in bold. For someone experienced in databases, this would seem trivial as the entities are listed in bold, and the test is designed to be completed in 5 minutes. Extra points ...

ARTICLE

An Introduction to Database Design

... suggested that perhaps what Bob needed was a database - something like Access, perhaps. She explained that databases were much better at answering the sorts ... he was going to replace his spreadsheet with a database, he might as well use one ... Worse, when Bob used the query designer to show information for customer 123, it showed ...

ARTICLE

Database Design and Reference Tables

article is about smart database design. I have been programming in SQL ... than 8 years. I love the design and analysis phase of a project where you ... software project depends on its initial design. Once a poorly designed database hits production, no one will dare to make ...

ARTICLE

Have You Designed a Database from Scratch?

... I saw recently someone begin their blogging journey with a new post about designing a database. What struck me was this person with a lot ... lot of experience noted they had never designed a database from scratch. I'm sure that most of you have worked with a database, and have even modified various objects ... OLTP tables. However, have you designed a database from scratch? Not a standalone database, but a database the actually has an API or application built ...

ARTICLE

Stairway to Database Design Level 5: Procedures

... subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers. In level one, we named ... feeling of being done. In a very simple database, this is true. But in a real database there are more structures to consider. Among these other ... each table like a file and code as if the database is a procedural file system. You can ...

ARTICLE

Stairway to Database Design Level 9: Normalization

... us to the requirement that any atomic fact in the database (a collection of such tables) can be found by a table ... tracks on a disk. Nope. Wrong. Columnar databases are not contiguous storage. Neither is a hashed database. The first thing you have to do ... declared like this, and wanted to move it to a relational database. I picked Pascal because it is relatively ...

ARTICLE

Designing Cross Database Queries

Design: Working Across Databases I've been working with multiple databases recently in trying to tie a few applications ... I wanted to keep the data within the databases that it resides and perform some cross database work within applications. In doing so ... problem is that not all my data is in one database. When I first started working ...

ARTICLE

Best Practices for Database Design

... office and asks you to put together a database to manage some project they're working ... data or allow other users to access the database directly. This article will not focus on normalization and how ... look at how we name our databases, tables, columns, stored procedures and even ...