SQL Server Database Modeling and Design News
May 07, 2015
Microsoft's recent acquisition of Revolution Analytics could go a long way in solidifying the R language's hold on analytical solutions.
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.
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.
Microsoft is working on yet another computing transformation, and its SQL Server and Azure SQL products are central thereto. But the company faces stiff competition in the cloud from Amazon. Continue Reading
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
Product ReviewsPowered by IT Central Station
Powered by IT Central Station
Valuable Features: Horizontal layout for each connected database connection Easy way to generate statements for select,insert and update Easily...Continue Reading
Performance tuning and segment and memory advisor are features that are very valuable in the solutionPowered by IT Central Station
Valuable Features: Performance tuning, segment and memory advisor • Improvements to My Organization: All our production systems are...Continue Reading
We checked various Monitoring softwares but OEM provided us with the greatest ability for productivityPowered by IT Central Station
Valuable Features: Database performance monitoring, dashboards, databases management and Dataguard setup and monitoring are the features that I...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