SQL Server Database Modeling and Design
New & Notable
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.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
SQL Server Database Modeling and Design News
-
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.
-
March 22, 2017
22
Mar'17
Redgate tools help bring database DevOps to Visual Studio 2017
So far, data has been left out of the DevOps discussion. But DevOps for databases could grow if tools like Redgate's bundle embedded in Visual Studio 2017 carry through on their promises.
SQL Server Database Modeling and Design Get Started
Bring yourself up to speed with our introductory content
-
Why running SQL Server on Docker is no longer frowned upon
Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers. Continue Reading
-
Cloud-based database software adds new IT options for users
The increasing adoption of cloud database services has captured the attention of Oracle and Microsoft as they try to hold their spots at the top of the database market. Continue Reading
-
foreign key
A foreign key is a column or columns of data in one table that connects to the primary key data in the original table. Continue Reading
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
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
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