Redmond Magazine

SQL Server Design: No Code Necessary

In the growing landscape of database management, SQL Server stands as a pillar for enterprises, bustling with robust features and functionalities. For database designers, understanding SQL Server's ...
Ars Technica

SQL schema design help: generic attachments

tl;dr - see last paragraph. CREATE TABLE [dbo].[AttachedFiles]( [ID] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ReferenceLocation] [varchar](255) NOT NULL, [FileName ...
Ars Technica

SQL Server: table design for international addresses

I'm currently working on a database that includes a table to keep track of customers. This table holds (among other things) the customer's address. To date, these addresses have all been located ...
Network World

Get the Most Out of phpMyAdmin’s Visual Query Designer

Database programmers and administrators often need to design SQL queries against database structures with which they’re not intimately familiar. By using a visual query designer, programmers and ...
Electronic Design

What’s the Difference Between SQL, NoSQL, and NewSQL?

Many embedded applications require a database of sorts, but the type can vary widely from ISAM (Indexed Sequential Access Method) to SQL (structure query language). While SQL is readily available on ...