New & Notable
SQL Server Database Modeling and Design News
June 05, 2014
Microsoft's flagship database is advancing into the largely undiscovered country of in-memory OLTP platforms -- and it's hoping to conquer.
September 13, 2011
In this Q&A, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.
May 20, 2011
Cloud was the word at Microsoft TechEd, but attendees’ interest was rooted in SQL Server Denali, the upcoming version of the database that will be released in a CTP this summer.
January 13, 2011
Higher SQL Server cloud adoption with more competition and SQL Server virtualization will get top billing in the SQL Server market in 2011, experts predict. Plus, self-service BI is on the up and up, along with solid-state devices.
SQL Server Database Modeling and Design Get Started
Bring yourself up to speed with our introductory content
A data mart is a repository of data gathered from operational data and other sources that is designed to serve a particular community of knowledge workers. Continue Reading
AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together. Continue Reading
AdventureWorks Database is a sample OLTP database that Microsoft ships with all of its SQL Server database products. Continue Reading
Evaluate SQL Server Database Modeling and Design Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Schema comparison tools let you compare object definitions in two databases. Read why they're important, and learn about five popular ones out there. Continue Reading
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features. Continue Reading
Visual Studio 2010 is the latest version of Microsoft’s application development platform, equipped with a slew of add-ons and new features. Learn more about what’s new here. Continue Reading
Manage SQL Server Database Modeling and Design
Learn to apply best practices and optimize your operations.
Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design. Continue Reading
Learn about the SQL Server database and how to make the most of SQL Server training in this essential guide. Continue Reading
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
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.
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
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Continue Reading
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more. Continue Reading