Microsoft SQL Server Database Development News
November 18, 2016
Microsoft looks to broaden the horizons of SQL Server, as it moves some Enterprise features to Standard Edition and issues the first public preview of a release supporting SQL Server on Linux.
November 14, 2016
A link between Cask Data's CDAP application and integration environment and Azure HDInsight, Microsoft's Hadoop cloud service, is meant to cut development time on big data applications.
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.
Microsoft SQL Server Database Development Get Started
Bring yourself up to speed with our introductory content
A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Continue Reading
Database normalization is intrinsic to most relational database schemes. It is a process that organizes data into tables so that results are always unambiguous. Continue Reading
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
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Evaluate Microsoft SQL Server Database Development Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
DBCC CHECKDB, a long-awaited feature for SQL Server Analysis Services, provides the ability to perform database consistency checks against tabular and multidimensional databases. Continue Reading
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
Manage Microsoft SQL Server Database Development
Learn to apply best practices and optimize your operations.
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
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
Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design. Continue Reading
Problem Solve Microsoft SQL Server Database Development 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 values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading
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