New & Notable
Microsoft SQL Server Database Development News
September 25, 2018
A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure Cosmos DB also gets an update.
June 11, 2018
The looming Microsoft-GitHub pairing confirms the company's rebirth as an open source friend. Data tools on the Azure cloud are part of the motivation.
May 16, 2018
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.
March 21, 2018
Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.
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
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
Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems. Continue Reading
Evaluate Microsoft SQL Server Database Development Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
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
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 Microsoft SQL Server Database Development
Learn to apply best practices and optimize your operations.
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
A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Continue Reading
Microsoft is at work on a delicate technology refresh affecting database tuning and architecture, as well as data integration and business intelligence. 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.
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
Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design. 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