SQL Server Database Modeling and Design
New & Notable
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.
SQL Server Database Modeling and Design Get Started
Bring yourself up to speed with our introductory content
-
DBMS keys: Primary, super, foreign and candidate keys with examples
Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences among them. Continue Reading
-
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
-
Get to know Microsoft Azure Cosmos DB use cases
Organizations can deploy Cosmos DB for a range of important applications. Learn how to bolster Azure workloads with this Microsoft database service that is highly distributed and multi-model. Continue Reading
Evaluate SQL Server Database Modeling and Design Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
How SQL Server DevOps processes help break down data silos
DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos with cross-functional teams. Continue Reading
-
What is the difference between DBMS and RDBMS?
A relational database management system is the most popular type of database management system for business uses. Find out how RDBMS software differs from DBMS technology in general. Continue Reading
-
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
Manage SQL Server Database Modeling and Design
Learn to apply best practices and optimize your operations.
-
SQL Server performance tuning best practices for DBAs
Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading
-
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
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.
-
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
-
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