SQL Server Database Modeling and Design

New & Notable

Download this free guide

Download: 60-Page Expert RDBMS Guide

Trends come and go, but your DB strategy shouldn’t be a flavor of the month. Learn why you shouldn’t get distracted by new DB technology, how Facebook is using a RDBMS to do the data slicing and dicing they can’t in Hadoop, and more.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

SQL Server Database Modeling and Design News

May 16, 2018 16 May'18
Azure Cosmos DB features, pricing morph with new provisioning model

The ability to provision Azure Cosmos DB throughput at the database level could come with pricing sticker shock for some users of Microsoft's multimodel database.
January 17, 2018 17 Jan'18
Meltdown and Spectre fixes eyed for SQL Server performance issues

Microsoft has responded to the Spectre and Meltdown chip vulnerabilities with patches and other fixes. But IT teams need to sort out SQL Server performance issues they may create.
July 27, 2017 27 Jul'17
SQL Server for Linux gets closer -- Windows database adds HA traits

SQL Server for Linux has gained added features on its way to general availability as part of the almost-ready SQL Server 2017. Meanwhile, its Windows-based brother is upping its high availability quotient.
April 21, 2017 21 Apr'17
SQL Server 2017 makes Python a first-class citizen for analytics

Python is no longer a database outsider at Microsoft. The programming language is riding alongside R for analytics uses as SQL Server 2017 moves to its second preview release.

View All News

SQL Server Database Modeling and Design Get Started

Bring yourself up to speed with our introductory content

database replication

Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another so that all users share the same level of information. Continue Reading
What are primary, super, foreign and candidate keys in a DBMS?

Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences between them. Continue Reading
What's the difference between DDL and DML?

What's the difference between DDL and DML? Get the answer and see examples of data manipulation language and data definition language commands for SQL databases. Continue Reading

View All Get Started

Evaluate SQL Server Database Modeling and Design Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

Microsoft Cosmos DB takes Azure databases to a higher level

Azure Cosmos DB brings a new element to the database lineup of Microsoft's cloud platform, offering multiple data models and a scalable environment for distributed applications. Continue Reading
Cloud database services get stronger push from Microsoft, Oracle

Using cloud databases is now more a matter of when than if at many companies. There's also the question of how, as Microsoft, Oracle and AWS square off against one another. Continue Reading
How to use a SQL Server graph database to map data relationships

Here are the basics you need to know to use the graph database features added in SQL Server 2017 to represent the relationships between different data elements in a graph structure. Continue Reading

View All Evaluate

Manage SQL Server Database Modeling and Design

Learn to apply best practices and optimize your operations.

The ins and outs of using R in SQL Server 2016 and 2017

What does the R analytics language offer to users, and how does it fit into SQL Server 2016 and 2017? Get answers to those questions and details on Microsoft's various R technologies. Continue Reading
What SQL Server for Linux says about Microsoft's future plans

SQL Server on Linux may just be the start. After making PowerShell open source, Microsoft can build Linux versions of any of its server technologies. And it has reason to do so. Continue Reading
SQL Server 2016 features boost cloud, security and analytics support

In a podcast, SearchSQLServer's Jessica Sirkin discusses the noteworthy features in SQL Server 2016, reactions from early users and issues to consider in thinking about upgrading. Continue Reading

View All Manage

Problem Solve SQL Server Database Modeling and Design Issues

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

Five tips to avoid a performance bottleneck or other SQL Server snares

Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design. Continue Reading
SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT

In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading
SQL CONSTRAINT clauses: PRIMARY KEY and UNIQUE

In SQL Server, SQL CONSTRAINT clauses let you control the kinds of values that get entered into a column. Learn about two of them here. Continue Reading

View All Problem Solve